fanta6opsolana
Updated 2023-03-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with orca_and_saros_address as (select label,address from solana.core.dim_labels where label_type='dex' and label in ('orca' ,'saros'))
, tops as (select tx_to,count(distinct tx_id)
from solana.core.fact_transfers inner join orca_and_saros_address
on tx_from= address and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
where block_timestamp::date >= '2023-01-01' and label='saros'
group by 1
order by 2 DESC
limit 10)
select tx_to,block_timestamp::date,count(distinct tx_id)
from solana.core.fact_transfers inner join orca_and_saros_address
on tx_from= address and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
where block_timestamp::date >= '2023-01-01' and label='saros' and tx_to in (select tx_to from tops)
group by 1 , 2
Run a query to Download Data