peteer18 light
Updated 2023-01-21
9
1
2
3
4
5
6
7
8
9
›
⌄
with top10 as (select sum(AMOUNT/1e6) , SENDER from terra.core.ez_transfers
where CURRENCY='uluna' and year(block_timestamp)=2023 and block_timestamp::date >='2023-01-15' and block_timestamp::date <='2023-01-21'
group by 2
order by 1 DESC
limit 10)
select sum(AMOUNT/1e6) , SENDER ,block_timestamp::date from terra.core.ez_transfers
where CURRENCY='uluna' and block_timestamp::date>'2023-01-01' and SENDER in (select SENDER from top10) and block_timestamp::date >='2023-01-15' and block_timestamp::date <='2023-01-21'
group by 2,3
Run a query to Download Data