DATE | NET_SUPPLY | TOTAL_SUPPLY | MARKET_CAP | |
|---|---|---|---|---|
1 | 2025-03-18 00:00:00.000 | -0.413510698 | 411.774864237 | 61276.217547108 |
2 | 2025-03-17 00:00:00.000 | 1.2739 | 412.188374935 | 62671.181466992 |
3 | 2025-03-16 00:00:00.000 | -99.6878 | 410.914474935 | 64852.577006616 |
4 | 2025-03-15 00:00:00.000 | -0.10038 | 510.602274935 | 81096.406316551 |
5 | 2025-03-14 00:00:00.000 | 2.0979 | 510.702654935 | 76102.356125139 |
6 | 2025-03-13 00:00:00.000 | -1.1746 | 508.604754935 | 75179.411850717 |
7 | 2025-03-12 00:00:00.000 | 1.46575 | 509.779354935 | 75136.37912387 |
8 | 2025-03-11 00:00:00.000 | 0.4955 | 508.313604935 | 74046.042830881 |
9 | 2025-03-10 00:00:00.000 | 0.06641 | 507.818104935 | 76271.740270712 |
10 | 2025-03-09 00:00:00.000 | -5.756235083 | 507.751694935 | 81887.654600642 |
11 | 2025-03-08 00:00:00.000 | -85.72119 | 513.507930018 | 83991.924573394 |
12 | 2025-03-07 00:00:00.000 | 1.5787 | 599.229120018 | 101638.247191853 |
13 | 2025-03-06 00:00:00.000 | 19.4787 | 597.650420018 | 104292.986545241 |
14 | 2025-03-05 00:00:00.000 | 0.77791 | 578.171720018 | 98532.024525468 |
15 | 2025-03-04 00:00:00.000 | 123.283000001 | 577.393810018 | 94002.599239981 |
16 | 2025-03-03 00:00:00.000 | 6.1772 | 454.110810017 | 86896.374050803 |
17 | 2025-03-02 00:00:00.000 | 0.21044 | 447.933610017 | 76030.011296236 |
18 | 2025-03-01 00:00:00.000 | 0.1889 | 447.723170017 | 75000.346825398 |
19 | 2025-02-28 00:00:00.000 | -2.4676 | 447.534270017 | 71442.133194164 |
20 | 2025-02-27 00:00:00.000 | -104.3657 | 450.001870017 | 73339.054766021 |
Pine Analyticskyros.fi copy
Updated 2025-03-18
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
›
⌄
-- forked from kyros.fi @ https://flipsidecrypto.xyz/studio/queries/fcbf5ebd-c51e-4b2c-917a-f8d67896dce4
with tab1 as (
SELECT
date,
sum(
case when type like 'mint' then amt else -amt end
) as net_supply,
sum(net_supply) over (order by date) as total_supply
FROM (
SELECT
date(block_timestamp) as date,
'mint' as type,
mint_amount / power(10, 9) as amt
FROM eclipse.defi.fact_token_mint_actions
where mint like '8jN7xMDqJucigQphWHvqAPQPAmk7VJKKsqLmgCkE7XzP'
and SUCCEEDED
UNION all
SELECT
date(block_timestamp) as date,
'burn' as type,
burn_amount / power(10, 9) as amt
FROM eclipse.defi.fact_token_burn_actions
where mint like '8jN7xMDqJucigQphWHvqAPQPAmk7VJKKsqLmgCkE7XzP'
and SUCCEEDED
)
GROUP by 1
order by date DESC
)
SELECT
Last run: about 1 month ago
92
6KB
6s