strawbettyGST transferred per day
Updated 2022-03-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with base as (select tx_id
from solana.transactions
where (pre_mint ilike 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
or post_mint ilike 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
and succeeded = 'TRUE'
and block_timestamp >= '2022-01-01'
and block_timestamp <= '2022-02-28')
--group by 1)
select date_trunc('day', block_timestamp) as day,
sum(a.instruction:parsed:info:amount/1e9) as GST_transferred
from solana.transfers a
join base b
on a.tx_id = b.tx_id
where succeeded = 'TRUE'
and block_timestamp >= '2022-01-01'
and block_timestamp <= '2022-02-28'
and instruction:parsed:info:amount is not null
group by 1
limit 100
Run a query to Download Data