--Token Symbol 填入Token Symbol(大写)
select
    *
from 
(
    select
       substr(cast("minute"  as varchar),1,10) as stat_date 
    --   ,"minute" 
    --   ,"symbol" as symbol
      ,ROW_NUMBER() OVER( partition BY substr(cast("minute"  as varchar),1,10) order by "minute" DESC )  as rank_num 
       ,"price" as price
    from prices.usd
    where "minute" > '2021-01-01'
    and "symbol"  in ('{{Token Symbol}}')
    --填入BNB ETH LINK 或者也可以通过"contract_address" 来直接指定Token的合约地址
) a 
where rank_num =1 --取每天的最后1条价格数据
order by
        stat_date