New Minter | |
|---|---|
1 | 3793 |
MasiNew Minter
Updated 2025-02-19
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
›
⌄
with tb0 as ( select trunc(hour,'day') as daily,
token_address,
symbol,
avg(price) as avg_price
from solana.price.ez_prices_hourly
where symbol = 'MSOL'
and daily = current_date
group by 1,2,3)
,
tb1 as ( select trunc(block_timestamp,'day') as day,
tx_id,
provider_address,
MSOL_MINTED,
MSOL_MINTED*avg_price as msol_usd
from solana.marinade.ez_liquid_staking_actions a , tb0
where action_type in ('depositStakeAccount','deposit') )
,
tb2 as ( select min(day) as daily,
provider_address
from tb1
group by 2)
select
count(distinct provider_address) as "New Minter"
from tb2
where daily >= current_date - 60
Last run: 2 months ago
1
8B
6s