Pine Analytics2024-07-09 09:44 AM
Updated 2025-02-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date(block_timestamp) as date,
sum(
decoded_log:numTokens
) as collectibles_minted,
sum(collectibles_minted) over (ORDER by date) as total_collectibles_minted
-- *
--FROM blast.core.fact_event_logs
FROM blast.core.ez_decoded_event_logs
--WHERE tx_hash LIKE '0x3fa813e3eb11b97a8f92257c7ef2c8e0e14906ebe6799fe1bafa47e68dfbb695'
WHERE contract_address ILIKE '0xf2bb3dd3ea243ad644f1a4026a1d2026d98552e3'
AND event_name LIKE 'Tokenized'
GROUP BY 1
ORDER BY 1 DESC
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived