UNIQUE_MINTERS | NUMBER_OF_MINTS | TOTAL_SEI_SPENT | TOTAL_USD_SPENT | NFT_CATEGORY | COLLECTION | |
|---|---|---|---|---|---|---|
1 | 400 | 496 | 0 | 0 | NFT 1 | Seiyans |
2 | 152 | 7157 | 0 | 0 | NFT 2 | Drill Club |
bobby_danielyodelling-salmon
Updated 2025-04-02
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 prices AS (
SELECT hour,
price as sei_price
FROM sei.price.ez_prices_hourly
WHERE symbol = 'SEI'
AND blockchain = 'sei'
AND is_native = TRUE
)
SELECT
count(distinct e.origin_from_address) as unique_minters,
count(*) as number_of_mints,
sum(t.value/1e18) as total_sei_spent, -- assuming 18 decimals for SEI
sum((t.value/1e18) * p.sei_price) as total_usd_spent,
'NFT 1' as nft_category,
case
when e.origin_to_address = lower('{{NFT_1}}') then 'Seiyans'
when e.origin_to_address = '{{NFT_2}}' then 'Drill Club'
end as Collection
FROM sei.core_evm.fact_event_logs e
JOIN sei.core_evm.fact_transactions t
ON e.tx_hash = t.tx_hash
LEFT JOIN prices p
ON date_trunc('hour', e.block_timestamp) = p.hour
WHERE e.block_timestamp >= '2025-01-01'
AND e.origin_to_address = lower('{{NFT_1}}')
AND e.tx_status = 'SUCCESS'
GROUP BY 5,6
UNION ALL
SELECT
count(distinct e.origin_from_address) as unique_minters,
count(*) as number_of_mints,
sum(t.value/1e18) as total_sei_spent,
sum((t.value/1e18) * p.sei_price) as total_usd_spent,
Last run: about 2 months ago
2
69B
7s