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