MasiTotal Addresses (30D)
    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
    New Address
    1
    40771
    1
    9B
    70s