mlhswaps
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc('day', block_timestamp) as days,
count(distinct tx_id) as swaps,
count(distinct swapper) as swappers,
swap_program,
case when block_timestamp::date <'2022-10-12' then 'before hack'
else 'after hack'
end as period
from solana.core.fact_swaps
where SUCCEEDED='TRUE'
and block_timestamp::date >='2022-10-08'
group by 1, 4, 5
Run a query to Download Data