DAY | BONKMARKS_SENT | BONKMARK_WALLETS | BONKMARKS_SENT_PER_WALLET | CUML_BONKMARKS_SENT | CUML_BONKMARK_WALLETS | |
|---|---|---|---|---|---|---|
1 | 2025-04-19 00:00:00.000 | 1 | 1 | 1 | 15 | 15 |
2 | 2025-03-08 00:00:00.000 | 1 | 1 | 1 | 14 | 14 |
3 | 2025-03-03 00:00:00.000 | 1 | 1 | 1 | 13 | 13 |
4 | 2025-02-28 00:00:00.000 | 2 | 2 | 1 | 12 | 12 |
5 | 2025-02-20 00:00:00.000 | 2 | 2 | 1 | 10 | 10 |
6 | 2025-02-19 00:00:00.000 | 2 | 2 | 1 | 8 | 8 |
7 | 2025-02-15 00:00:00.000 | 2 | 2 | 1 | 6 | 6 |
8 | 2025-02-14 00:00:00.000 | 2 | 2 | 1 | 4 | 4 |
9 | 2025-02-13 00:00:00.000 | 1 | 1 | 1 | 2 | 2 |
10 | 2025-02-12 00:00:00.000 | 1 | 1 | 1 | 1 | 1 |
0xsloaneBONKMARK - Valentines 2025 Stats
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
--- forked from BONKMARK 2024-25 Monthly Stats @ https://flipsidecrypto.xyz/studio/queries/f7f39bb6-98fc-4577-952f-c94d31e08690
SELECT date_trunc(day, block_timestamp) AS day,
count(DISTINCT tx_id) as bonkmarks_sent,
count(DISTINCT signers[0]) AS bonkmark_wallets,
div0(count(DISTINCT tx_id), count(DISTINCT signers[0])) AS bonkmarks_sent_per_wallet,
sum(bonkmarks_sent) over(order by day asc) as cuml_bonkmarks_sent,
sum(bonkmark_wallets) over(order by day asc) as cuml_bonkmark_wallets
FROM solana.core.ez_events_decoded
WHERE program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
and event_type = 'mintToCollectionV1'
and block_timestamp >= '2025-01-01'
and block_timestamp <= current_date() -1
and DECODED_ARGS:metadataArgs:symbol::string = 'BONKMARK'
AND (LOWER(DECODED_ARGS:metadataArgs:name::string) like '%valentine%'
OR LOWER(DECODED_ARGS:metadataArgs:name::string) like '%heart%')
group by 1
order by 1 desc
;
Last run: 1 day ago
10
391B
10s