binhachonTamAnh-3
    Updated 2022-05-20
    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