permaryDaily leading stable coin transactions and volume on Solana
    Updated 10 days ago
    with transfers as (
    select
    date_trunc('day', block_timestamp) as date,
    case
    when mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'
    when mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
    when mint = '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo' then 'PYUSD'
    when mint = 'A1KLoBrKBde8Ty9qtNQUtq3C2ortoC3u7twggz7sEto6' then 'USDY'
    when mint = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'
    when mint = 'DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT' then 'USDe'
    when mint = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' then 'DAI'
    end as stablecoin,
    tx_id,
    amount
    from solana.core.fact_transfers
    where block_timestamp >= current_date - interval '60 days'
    and ( mint in (
    'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',
    'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',
    '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo',
    'A1KLoBrKBde8Ty9qtNQUtq3C2ortoC3u7twggz7sEto6',
    'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS',
    'DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT',
    'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o'
    )
    )
    )
    select
    date,
    stablecoin,
    count(distinct tx_id) as tx_count,
    sum(AMOUNT) AS volume
    from transfers
    group by date,stablecoin
    order by date desc;
    Last run: 10 days ago
    DATE
    STABLECOIN
    TX_COUNT
    VOLUME
    1
    2024-12-31 00:00:00.000USDe490361563.583724164
    2
    2024-12-31 00:00:00.000PYUSD1572670863420.58251
    3
    2024-12-31 00:00:00.000PAI1735853.840869
    4
    2024-12-31 00:00:00.000USDT3546401100790038.90538
    5
    2024-12-31 00:00:00.000DAI19821.07983819
    6
    2024-12-31 00:00:00.000USDY428188317.361116
    7
    2024-12-31 00:00:00.000USDC15899039084316270.26909
    8
    2024-12-30 00:00:00.000USDe639475510.297151609
    9
    2024-12-30 00:00:00.000DAI515582.98401892
    10
    2024-12-30 00:00:00.000USDT7495462301467869.00555
    11
    2024-12-30 00:00:00.000USDY1111444406.503387
    12
    2024-12-30 00:00:00.000PAI3186172.007583
    13
    2024-12-30 00:00:00.000PYUSD2896048299848.101007
    14
    2024-12-30 00:00:00.000USDC356490128231294196.6375
    15
    2024-12-29 00:00:00.000PYUSD2245330890197.029324
    16
    2024-12-29 00:00:00.000DAI243240.6236722
    17
    2024-12-29 00:00:00.000USDC2735516923376505587.127
    18
    2024-12-29 00:00:00.000PAI1191975.237055
    19
    2024-12-29 00:00:00.000USDY12082053617.966502
    20
    2024-12-29 00:00:00.000USDT5411911996856757.41007
    ...
    427
    23KB
    203s