MasiDaily New Vs. Active
    Updated 10 days ago
    with tb1 as (select a.BLOCK_TIMESTAMP,
    POST_TOKEN_BALANCES[0]:owner as receiver,
    a.tx_id,
    a.event_type,
    case when mint_authority = 'CGchU6apMNYBDujP8w7hShR6er4ESDGvB2TvVM7bjnpc' then 'USDT'
    when mint_authority = '6AjQBsySS1FtQmA7a4oYc6GYpHBTDqtSswptsVSTz3Tv' then 'apxETH'
    when mint_authority = 'V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM' then 'stTIA'
    when mint_authority = '2tGbYEm4nuPFyS6zjDTELzEhvVKizgKewi6xT7AaSKzn' then 'ORCA'
    when mint_authority = 'JAh5pFYn1Kbh7kCuqZab8viVFdNgTmpS6hzFstSGNBvG' then 'JitoSOL'
    when mint_authority = 'F72PqK74jc28zjC7kWDk6ykJ2ZAbjNzn2jaAY9v9M6om' then 'weETHs'
    when mint_authority = 'Hm7FzFMQYxRay1AJxJN4ScBrpMakj8xxXaFcWiU7KLGK' then 'tETH'
    when mint_authority = 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL' then 'SOL'
    when mint_authority = '8jN7xMDqJucigQphWHvqAPQPAmk7VJKKsqLmgCkE7XzP' then 'kySOL'
    when mint_authority = 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm' then 'USDT'
    when mint_authority = 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn' then 'tETH'
    when mint_authority = 'AvieFG3iLSaETVWyd1Urov5fZHy888aATC2QtGTAEhf8' then 'USDC'
    when mint_authority = '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH' then 'WIF'
    when mint_authority = 'Fu5P5ikrnQ8BKZECJ1XeeDAaTgWJUrcjw8JmFrNA8TJk' then 'ezSOL'
    when mint_authority = '9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8' then 'TIA'
    when mint_authority = '7UTjr1VC6Z9DPsWD6mh5wPzNtufN17VnzpKS3ASpfAji' then 'WBTC'
    when mint_authority = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' then 'USDC'
    when mint_authority = '7S8wswnCyQi2YsvnKz2Cja5t5B5jZa2UNExcG6Yr9MTN' then 'SOL'
    when mint_authority = '8SuhHnSEogAN2udZsoychjTafnaGgM9MCidYZEP8vuVY' then 'SOL' end as token_name,
    mint_authority as token_address,
    mint_amount/pow(10,decimal) as amount
    from eclipse.defi.fact_token_mint_actions a join eclipse.core.fact_events b on a.tx_id = b.tx_id
    join eclipse.core.fact_transactions c on a.tx_id = c.tx_id
    where 1 = 1
    and PROGRAM_ID = 'EitxJuv2iBjsg2d7jVy2LDC1e2zBrx4GB5Y9h2Ko3A9Y'
    and a.succeeded = 'TRUE'
    )
    ,
    tb2 as ( select min(block_timestamp) as date,
    receiver
    from tb1
    group by 2
    Last run: 10 days ago
    DAY
    TYPE
    TRANSACTIONS
    ADDRESSES
    Volume (USD)
    Avg Volume Per Address
    Avg Volume (USD)
    Median Volume (USD)
    Max Volume (USD)
    1
    2025-01-03 00:00:00.000New Address231517302156676.099153671246.633583326931.609546071163.06739166736491.834021741
    2
    2024-12-29 00:00:00.000Active Address781609511328.157874303839.619306854654.709549135100.90556666740002.825
    3
    2024-12-27 00:00:00.000Active Address845664436389.090143136657.212485155516.43679306983.27645369824071.464469848
    4
    2024-12-22 00:00:00.000Active Address795624342990.845831908549.664817038431.43502620488.067311539910.90968
    5
    2024-12-19 00:00:00.000New Address1040770964321.0172313291252.364957443927.231747338192.94830134642770.916317506
    6
    2024-12-19 00:00:00.000Active Address415362210963.102573956582.771001586508.344825479108.7599759954.88190125
    7
    2025-01-02 00:00:00.000Active Address605504342550.981582009679.664645996566.199969557142.8023333337650.8306625
    8
    2024-12-28 00:00:00.000New Address304023981811992.32838302755.626492236596.05010802152.43074644217432.698452404
    9
    2024-12-26 00:00:00.000Active Address827682451033.118391637661.338883272545.38466552857.53537524093.473529846
    10
    2024-12-18 00:00:00.000Active Address778614476626.83469024776.265203079612.630892918130.176599968.154166667
    11
    2024-12-15 00:00:00.000New Address12719941186191.443617231193.351552935933.274149187112.0342538683.096759088
    12
    2024-12-24 00:00:00.000New Address392827643779708.030777131367.477579876962.2474620157.80351425168.35616667
    13
    2025-01-10 00:00:00.000Active Address633519282924.982023222545.134840122446.95889735194.52083333311720.583333333
    14
    2024-12-27 00:00:00.000New Address304623562333836.27906881990.592648162766.19707126466.62116194978538.656108244
    15
    2025-01-07 00:00:00.000Active Address948768332006.265146756432.29982441350.21757926935.21514822410669.785
    16
    2024-12-23 00:00:00.000New Address245917631204612.1135154683.27402922489.87885868999.98289583319996.579166667
    17
    2025-01-06 00:00:00.000New Address300823912554496.747884611068.380070215849.23429118571.4829550038.388795542
    18
    2025-01-01 00:00:00.000New Address155712191658416.152454951360.4726435231065.13561493676.29316666744566.452162948
    19
    2025-01-14 00:00:00.000New Address1156989918036.08168503928.246796446794.14885958990.34772589134320.460779826
    20
    2024-12-21 00:00:00.000Active Address618482330745.445136434686.193869578535.186804428106.39936100325819.382122292
    62
    8KB
    50s