FatemeTheLadySOL10
Updated 2022-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with tbl1 as (select sum(t.amount) as outflow_amount, tx_to
from solana.core.fact_transfers t,solana.core.dim_labels l
where t.TX_TO = l.address
and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
group by 2
order by 1 DESC
limit 9)
select sum(t.amount) as outflow_amount, tx_to , date_trunc(week,BLOCK_TIMESTAMP)::date as outflow_date
from solana.core.fact_transfers t,solana.core.dim_labels l
where t.TX_TO = l.address
and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' and tx_to in (select tx_to from tbl1)
group by 2 , 3
Run a query to Download Data