peteer1 light
Updated 2023-01-21
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select count(*), count(distinct tx_sender),block_timestamp::date , 'Before Week' from terra.core.fact_transactions
where year(block_timestamp)=2023 and block_timestamp::date >='2023-01-07' and block_timestamp::date <='2023-01-13'
group by 3
UNION
select count(*), count(distinct tx_sender),block_timestamp::date , 'After Week' from terra.core.fact_transactions
where 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