peteer24 light
Updated 2023-01-21
9
1
2
3
4
5
6
7
8
9
›
⌄
select count(*), count(distinct TRADER),block_timestamp::date , 'Before Week' from terra.core.ez_swaps where year(block_timestamp)=2023 and block_timestamp::date >='2023-01-07' and block_timestamp::date <='2023-01-13'
and TO_CURRENCY='uluna'
group by 3
UNION
select count(*), count(distinct TRADER),block_timestamp::date , 'After Week' from terra.core.ez_swaps where year(block_timestamp)=2023 and block_timestamp::date >='2023-01-15' and block_timestamp::date <='2023-01-21'
and TO_CURRENCY='uluna'
group by 3
Run a query to Download Data