MasiTotal By Tokens
    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'
    and a.block_timestamp::Date >= '2024-09-01'
    )
    ,
    tb2 as ( select trunc(hour,'day') as daily,
    'CGchU6apMNYBDujP8w7hShR6er4ESDGvB2TvVM7bjnpc' as token_address,
    avg(price) as avg_price
    Last run: 10 days ago
    TOKEN_NAME
    TRANSACTIONS
    ADDRESSES
    Volume (USD)
    Avg Volume Per Address
    Avg Volume (USD)
    Median Volume (USD)
    Max Volume (USD)
    1
    weETHs393490213824.79696672653347.788146082313174.99479402110.2999689853208.75
    2
    USDC483312442361401821.36384942514.0982419791270.443842748240.9345687511999666.41666667
    3
    SOL987145542741025092.1023485740.16439826415.59547888250.519583333248787.48125
    4
    TIA182911211420075149.26953021657.1858403111097.54246730851.847519633.47448725
    5
    tETH18619173988462080.2818675486.382358999454.48629259754.3964103091660198.06577994
    6
    USDT426531935369184.448259811681.5485274851258.894360671234.877584583250117.2151625
    7
    WIF35492531588162.892544381232.383600373165.7263715268.360112917102350
    8
    ORCA15141006340318.411423965338.288679348224.78098508824.73397133348833.93103875
    9
    WBTC2118283390.26670390415743.90370577213494.7746049487.961729708147609.6325
    10
    kySOL1134958233449.970236589243.684728848205.86417128425.2814865429970.0443125
    11
    stTIA1256838222769.877663182265.835176209177.3645522824.31909264626963.38494975
    12
    ezSOL322288120145.275170741417.171094343373.1219725865.38219522912163.0913225
    13
    apxETH28239301.706147408404.422006409332.203790979171.9027654171408.30753
    14
    JitoSOL211.3047520831.3047520830.65237604170.65237604171.043801667
    14
    1KB
    458s