MasiDaily New Addresses
Updated 10 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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)