fanta11opsolana
Updated 2023-03-16
9
1
2
3
4
5
6
7
›
⌄
with orca_and_saros_address as (select label,address from solana.core.dim_labels where label_type='dex' and label in ('orca' ,'saros'))
select label ,count(distinct tx_id) ,sum(amount/1e6) , count(distinct tx_from) , avg(amount/1e6) , count(distinct tx_id)/count(distinct tx_from) as avg_users
from solana.core.fact_transfers inner join orca_and_saros_address
on tx_to= address and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
where block_timestamp::date >= '2023-01-01'
group by 1
Run a query to Download Data