DATE | MINT_TXS | FEE_LAMPORTS | |
---|---|---|---|
1 | 2024-01-13 00:00:00.000 | 2785970 | 12040316778 |
2 | 2024-01-17 00:00:00.000 | 1301947 | 7384876903 |
3 | 2024-01-22 00:00:00.000 | 2839625 | 10022083955 |
4 | 2024-01-18 00:00:00.000 | 1599781 | 7567190274 |
5 | 2024-01-31 00:00:00.000 | 3788048 | 13824606773 |
6 | 2024-02-01 00:00:00.000 | 2816343 | 11096536365 |
7 | 2024-01-01 00:00:00.000 | 183080 | 1069289735 |
8 | 2024-01-20 00:00:00.000 | 828289 | 5661668935 |
9 | 2024-01-03 00:00:00.000 | 2429386 | 22129027432 |
10 | 2024-01-29 00:00:00.000 | 3788695 | 12640180657 |
11 | 2024-01-30 00:00:00.000 | 4765042 | 15651406079 |
12 | 2024-01-05 00:00:00.000 | 2417041 | 14852694728 |
13 | 2024-01-14 00:00:00.000 | 1331478 | 6763464542 |
14 | 2024-01-02 00:00:00.000 | 700251 | 5706862833 |
15 | 2024-02-04 00:00:00.000 | 4285900 | 14370517613 |
16 | 2024-01-16 00:00:00.000 | 1016394 | 5607843810 |
17 | 2024-01-10 00:00:00.000 | 2767487 | 9419212467 |
18 | 2024-01-19 00:00:00.000 | 1723727 | 8815410424 |
19 | 2024-01-24 00:00:00.000 | 2878605 | 11329063821 |
20 | 2024-01-07 00:00:00.000 | 1528644 | 58836318714 |
marqububblegum.core.fact_nft_mints
Updated 2024-02-05
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
fact_nft_mints_2024q1_call as (
select
f.value :DATE ::timestamp as date
, f.value :MINT_TXS ::int as mint_txs
, f.value :FEE_LAMPORTS ::int as fee_lamports
from ( -- bubblegum.core.fact_nft_mints_2024q1
select livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/e22508cf-ab41-46ea-91de-e4b3e76ff3b3/data/latest'
) :data as data
) response
inner join lateral flatten (input => response.data) f
),
daily_txs as (
select
block_timestamp
, tx_id
, fee / count(1) over (partition by tx_id) as fee
from solana.core.fact_transactions
inner join lateral flatten (input => log_messages) f_logs
where succeeded
and block_timestamp > '2023-11-01'
and block_timestamp >= dateadd('day', 1, (select max(date) from fact_nft_mints_2024q1_call))
and f_logs.value = 'Program log: Instruction: MintToCollectionV1'
and log_messages[f_logs.index -1] like 'Program BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY invoke %'
),
aggregated as (
Last run: about 1 year ago
...
333
15KB
145s