DATE | CREATED | Cumul. Tokens | SOL | Cumul. Fee | |
---|---|---|---|---|---|
1 | 2024-11-30 00:00:00.000 | 3879 | 85164 | 0.624697658 | 21.33304746 |
2 | 2024-11-27 00:00:00.000 | 3561 | 73420 | 1.124750521 | 19.130445397 |
3 | 2024-11-22 00:00:00.000 | 4320 | 54500 | 0.996471106 | 13.36110828 |
4 | 2024-11-09 00:00:00.000 | 2251 | 12994 | 0.431607495 | 2.433493739 |
5 | 2024-12-04 00:00:00.000 | 892 | 98136 | 0.181922446 | 25.285153878 |
6 | 2024-11-14 00:00:00.000 | 2530 | 25973 | 0.73251002 | 5.638173255 |
7 | 2024-11-11 00:00:00.000 | 2850 | 18532 | 0.606935189 | 3.550704615 |
8 | 2024-11-24 00:00:00.000 | 3501 | 61772 | 0.760306175 | 14.942122752 |
9 | 2024-11-23 00:00:00.000 | 3771 | 58271 | 0.820708297 | 14.181816577 |
10 | 2024-11-17 00:00:00.000 | 3004 | 34908 | 0.736637216 | 7.818195226 |
11 | 2024-11-16 00:00:00.000 | 3007 | 31904 | 0.680386217 | 7.08155801 |
12 | 2024-11-25 00:00:00.000 | 4153 | 65925 | 1.651503812 | 16.593626564 |
13 | 2024-11-20 00:00:00.000 | 3844 | 45865 | 0.983162532 | 11.058689652 |
14 | 2024-12-03 00:00:00.000 | 4186 | 97244 | 1.253419433 | 25.103231432 |
15 | 2024-12-02 00:00:00.000 | 3862 | 93058 | 1.570415136 | 23.849811999 |
16 | 2024-11-19 00:00:00.000 | 3903 | 42021 | 1.019879121 | 10.07552712 |
17 | 2024-11-29 00:00:00.000 | 4027 | 81285 | 0.769960329 | 20.708349802 |
18 | 2024-11-12 00:00:00.000 | 2659 | 21191 | 0.522956007 | 4.073660622 |
19 | 2024-11-21 00:00:00.000 | 4315 | 50180 | 1.305947522 | 12.364637174 |
20 | 2024-12-01 00:00:00.000 | 4032 | 89196 | 0.946349403 | 22.279396863 |
marquShitcoinery - [sol] spl tokens created
Updated 2024-03-11
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
active_tokens as (
select distinct
mint,
max(mint_amount) over (partition by amounts.mint) as mint_amount,
max(decimal) over (partition by amounts.mint) as decimal
from solana.defi.fact_token_mint_actions amounts
where succeeded
and block_timestamp > current_date() - interval '{{days}} days'
qualify max(mint_amount) over (partition by amounts.mint) > 100000
),
creation_dates as (
select distinct
block_timestamp,
tx_id,
signers[0] as creator_address,
mint,
fee
from solana.core.fact_events events
inner join solana.core.fact_transactions txs
using(tx_id, block_timestamp, succeeded)
inner join active_tokens
on events.instruction :parsed :info :newAccount = active_tokens.mint
where succeeded
and program_id = '11111111111111111111111111111111'
and instruction :parsed :type = 'createAccount'
and block_timestamp ::date > current_date() - interval '{{days}} days'
),
Last run: 3 months ago
30
2KB
296s