Azinsol9. open volume
Updated 2022-11-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with t1 as
(select TX_ID from
solana.core.fact_events
where
PROGRAM_ID='srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX')
select sum(AMOUNT) as amount, date_trunc('day', BLOCK_TIMESTAMP) as date, LABEL from
solana.core.fact_transfers a left join solana.core.dim_labels b
on a.MINT=b.address
where
TX_ID in (select TX_ID from t1)
group by 2,3
Run a query to Download Data