TOTAL_MINTED_NAMES | TOTAL_MINTED_FEES | TOTAL_MINTERS | |
---|---|---|---|
1 | 686351 | 740286.043072837 | 635854 |
damidezBaseSummary
Updated 10 days ago
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
›
⌄
WITH Ethprice AS (
SELECT trunc(hour, 'day') as date,
AVG(price) AS price_usd
FROM ethereum.price.ez_prices_hourly
WHERE token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
GROUP BY date
),
MainBasename AS (
SELECT DATE_TRUNC('day', Block_timestamp) AS day,
Tx_hash,
from_address AS miner,
origin_function_signature,
value * price_usd AS amount_usd
FROM base.core.fact_transactions ft
JOIN Ethprice ep
ON ep.date = DATE_TRUNC('day', ft.Block_timestamp)
WHERE to_address = '0x4ccb0bb02fcaba27e82a56646e81d8c5bc4119a5'
AND block_timestamp >= '2024-08-20'
AND origin_function_signature IN ('0xc7c79676', '0xe0093eda')
AND STATUS = 'SUCCESS'
)
-- Step 1: Total Metrics
SELECT
COUNT(DISTINCT Tx_hash) AS total_minted_names,
SUM(amount_usd) AS total_minted_fees,
COUNT(DISTINCT miner) AS total_minters
FROM MainBasename;
Last run: 10 days ago
1
34B
67s