COLLECTION_NAME | NFT_CONTRACT | NUMBER_OF_SALES | TOTAL_VOLUME | AVG_SALE_PRICE | |
|---|---|---|---|---|---|
1 | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 923455 | 26957224.8151207 | 29.191703781 | |
2 | 0xb5a30b0fdc5ea94a52fdc42e3e9760cb8449fb37 | 46101 | 12788755.4236555 | 277.407332241 | |
3 | 0xcf5a6076cfa32686c0df13abada2b40dec133f1d | 9172 | 10038609.1004739 | 1094.484201971 | |
4 | 0x132cb626be0dd6eb3b53fbeb392838c7a7b93621 | 25 | 10009688.1631398 | 400387.526525594 | |
5 | 0x76a61e9953de35ccbcb383f82f42fb1b1f256079 | 7 | 10001633 | 1428804.71428571 | |
6 | 0x2503b64954478af06674184239aea4cc99de7c04 | 11914 | 8313441.312 | 697.78758704 | |
7 | 0xf817257fed379853cde0fa4f97ab987181b1e5ea | 130044 | 7330213.52217256 | 56.36717974 | |
8 | 0xdf702217524fbdfdf5458830ab522cb9fdd94cfb | 5835 | 6193210 | 1061.389888603 | |
9 | 0x9c138479bc0423df993fc4f246fd1d7d598712de | 8743 | 5438957.29 | 622.092793092 | |
10 | 0xff72ac3b7da415f9a97e3bebf11e1d5891d211fa | 11567 | 5015226.46 | 433.580570589 | |
11 | 0xba12d525b8165943ddc529ed4127f648a3d1b47e | 2 | 3333334 | 1666667 | |
12 | 0x3bb9afb94c82752e47706a10779ea525cf95dc27 | 365326 | 3166005.24286986 | 8.666246703 | |
13 | 0xc7a47a51e830a319ec0855b82ae3945a61392085 | 11908 | 2672457.0909 | 224.42535194 | |
14 | ETH | 0x836047a99e11f376522b447bffb6e3495dd0637c | 16921 | 2387507.48734376 | 141.097304376 |
15 | 0xbdf43886b633600733932d6db54735b0ce155468 | 5636 | 2259032 | 400.821859475 | |
16 | 0x73a58b73018c1a417534232529b57b99132b13d2 | 2460 | 2001664.20192232 | 813.684634928 | |
17 | 0x672692a49c3567cc4d2f0890555291935d6674d3 | 2 | 2000000 | 1000000 | |
18 | 0xc32e6fd62910b0b39c774079019b56ecb8504e44 | 6505 | 1895908.43 | 291.454024596 | |
19 | 0x6aba96f37f1fa7c699b45d76822e7457f888f8f2 | 8990 | 1455301.83 | 161.880070078 | |
20 | 0xccec303083ad2d42346a7316cde6556e7b3e7cdb | 22784 | 1247320.27485 | 54.745447457 |
gigiokobaflying-cyan
Updated 2025-02-23
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
›
⌄
WITH nft_transfers AS (
SELECT
ft.block_timestamp,
ft.tx_hash,
ft.from_address,
ft.to_address,
ft.value as payment_amount,
el.contract_address as nft_contract,
dc.name as collection_name
FROM monad.testnet.fact_transactions ft
JOIN monad.testnet.fact_event_logs el
ON ft.tx_hash = el.tx_hash
LEFT JOIN monad.testnet.dim_contracts dc
ON el.contract_address = dc.address
WHERE el.topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- Transfer event signature
AND ft.block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())
AND ft.tx_succeeded = true
AND ft.value > 0 -- Only include transfers with payment
)
SELECT
collection_name,
nft_contract,
COUNT(*) as number_of_sales,
SUM(payment_amount) as total_volume,
AVG(payment_amount) as avg_sale_price
FROM nft_transfers
GROUP BY 1, 2
ORDER BY total_volume DESC;
Last run: 21 days ago
...
60206
4MB
9s