peteer12 light
Updated 2023-01-21
9
1
2
3
4
5
6
7
8
9
›
⌄
select count(*), sum(AMOUNT/1e6) , block_timestamp::date , 'Before Week' 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 3
UNION
select count(*), sum(AMOUNT/1e6) , block_timestamp::date , 'after Week' 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 3
Run a query to Download Data