hosein778Untitled Query
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date_trunc('day', block_timestamp) as day,
case
when day = '2022-10-11' then 'hacked day'
when day > '2022-10-11' then 'after the hack'
when day < '2022-10-11' then 'before the hack'
else 'the hack'
end t1,
program_id as Raydium,
count(distinct tx_id) as transactions
from solana.fact_events where
program_id in ('675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8')
and block_timestamp >= '2022-10-01'
group by 1,2,3
order by 1 asc
Run a query to Download Data