binhachonTamAnh-1
    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
    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