binhachonTamAnh-1
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
block_timestamp,
mint,
amount
from flipside_prod_db.solana.fact_transfers
where mint in (select address from stablecoin_mint)
and block_timestamp::date >= '2022-04-01'
)
select
date_trunc('day', block_timestamp) as date,
mint,
address_name,
count(*) as number_of_transactions,
Run a query to Download Data