HOUR | NEW_TOKENS | TOTAL_TOKENS | |
|---|---|---|---|
1 | 2025-01-07 22:00:00.000 | 1 | 600 |
2 | 2025-01-07 20:00:00.000 | 2 | 599 |
3 | 2025-01-07 19:00:00.000 | 2 | 597 |
4 | 2025-01-07 18:00:00.000 | 1 | 595 |
5 | 2025-01-07 13:00:00.000 | 1 | 594 |
6 | 2025-01-07 12:00:00.000 | 1 | 593 |
7 | 2025-01-07 11:00:00.000 | 1 | 592 |
8 | 2025-01-07 07:00:00.000 | 1 | 591 |
9 | 2025-01-07 06:00:00.000 | 1 | 590 |
10 | 2025-01-07 03:00:00.000 | 1 | 589 |
11 | 2025-01-06 23:00:00.000 | 1 | 588 |
12 | 2025-01-06 22:00:00.000 | 1 | 587 |
13 | 2025-01-06 20:00:00.000 | 1 | 586 |
14 | 2025-01-06 14:00:00.000 | 1 | 585 |
15 | 2025-01-06 13:00:00.000 | 1 | 584 |
16 | 2025-01-06 12:00:00.000 | 1 | 583 |
17 | 2025-01-06 08:00:00.000 | 1 | 582 |
18 | 2025-01-06 00:00:00.000 | 1 | 581 |
19 | 2025-01-05 22:00:00.000 | 1 | 580 |
20 | 2025-01-05 21:00:00.000 | 3 | 579 |
Pine Analyticsmoonlaunch.fun - 1
Updated 2025-03-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
date_trunc('hour', block_timestamp) as hour,
count(*) as new_tokens,
sum(new_tokens) over (order by hour) as total_tokens
FROM (
SELECT
tx_id,
block_timestamp
FROM eclipse.defi.fact_token_mint_actions
where tx_id in (
SELECT DISTINCT tx_id
FROM eclipse.core.fact_events
where program_id like 'F3MQq5eugYvhUJqnRruvyv3tu7nsVBgXxJrsaKfLhRDL'
)
GROUP BY 1,2
)
GROUP BY 1
order by 1 desc
Last run: about 2 months ago
...
339
11KB
4s