binhachonTamAnh-3
Updated 2022-05-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with stablecoin_mint as (
select
address,
address_name
from flipside_prod_db.solana.dim_labels
where blockchain = 'solana'
and address in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',
'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',
'CXLBjMMcwkc17GfJtBos6rQCo1ypeH6eDbB82Kby4MRm',
'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX',
'7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT',
'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'
)
or address_name ilike 'ust %'
-- or address_name ilike '%usdh%'
union all
select '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' as address,
'uxd' as address_name
union all
select 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' as address,
'usdh' as address_name
),
transfer_transaction as (
select
distinct mint,
tx_id
from flipside_prod_db.solana.fact_transfers
where block_timestamp::date >= '2022-04-01'
and mint in (select address from stablecoin_mint)
),
program_interaction as (
select
program_id,
mint,
count(distinct transfer_transaction.tx_id) as number_of_txs
from flipside_prod_db.solana.fact_events
Run a query to Download Data