barbodTransferred USDC transacion count
Updated 2022-12-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
date_trunc(day, BLOCK_TIMESTAMP)::date as date,
LABEL_TYPE,
sum(amount) as toal_amount,
sum(toal_amount) over (partition by LABEL_TYPE order by date rows between unbounded preceding and current row ) as cum_toal_amount,
count(tx_id) as transaction_count,
sum(transaction_count) over (partition by LABEL_TYPE order by date rows between unbounded preceding and
current row ) as cum_transaction_count
from solana.core.fact_transfers t,solana.core.dim_labels l
where t.TX_TO = l.address
and mint in (--'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt,
'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc
)
-- and LABEL_TYPE = 'cex'
AND BLOCK_TIMESTAMP::date >= '2022-10-01'
group by 1,2
order by 1
Run a query to Download Data