MINTER | |
|---|---|
1 | 0x0790f2c20b1517f9f93d85ff72f10cf8287c8d56 |
2 | 0x0790f2c20b1517f9f93d85ff72f10cf8287c8d56 |
3 | 0x42ff0190817221b7b91b9d0b91d7268d23b66c1d |
4 | 0x2424618d727e17a38cad7d531dfc90540dcdb566 |
5 | 0x6963b940c563ed9add515c9b4c800ffc69b6773d |
6 | 0x5ee9d8e5b32baa91a2bd0d4ab2e7d6a2fef73a48 |
7 | 0xe9cf3844b059f14ae7dda239a7e0202e56026496 |
8 | 0x9f35344931c5afec90aa9a4a2b92e471cdef3741 |
9 | 0x3aab3396fede536accb3a578cd96617092270536 |
10 | 0x751c3639c59ac22fa1039be7dd754eec03d4a8c5 |
11 | 0xff62e0b94a939455971f761faa240b3a2084804a |
12 | 0x814c1df10596e865b9d4fc611928f032b0161204 |
13 | 0x1300ea417b5b19d311687bc1390356382bd79b69 |
14 | 0x194a595068ae5b65811c64fc60574467a15c85f2 |
15 | 0x7c4fb9b58c6697cb30215d56f772d65f3b850b5d |
16 | 0x95f6915a3839c284bac794a85032555aa0b56226 |
17 | 0x1a567b84377e64bdab026342c177870cc7410ead |
18 | 0x0fa871f7f473f0606d496a6418490f853f76cf6d |
19 | 0xa86a2944c9fbc778d7f97407ab11cba0821e22d4 |
20 | 0xa7c8f596848722260032b78a9f3f1210bfbef456 |
freemartianMinters who not seller
Updated 8 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
31
32
33
34
35
36
›
⌄
with sapes_api as (
SELECT livequery.live.udf_api(
'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/sale.json'
) AS response
),
sales AS(
SELECT
to_timestamp(value:closing_date) AS block_timestamp,
value:transaction AS tx_hash,
value:event_type AS event,
value:protocol_address AS protocol_address,
value:nft:identifier AS identifier,
value:nft:collection AS collection,
value:chain AS chain,
value:buyer AS buyer,
value:seller AS seller,
(value:payment:quantity) / pow(10,18) AS price,
-- ROUND(((value:payment:quantity) / pow(10,18)),8) AS price,
value:quantity AS qty
FROM sapes_api, LATERAL FLATTEN (input => response:data)
GROUP BY ALL
ORDER BY 1 DESC
),
mints AS(
SELECT
block_timestamp,
tx_hash,
(CASE
WHEN decoded_log:dropStageIndex = 1 THEN 'Phase1'
WHEN decoded_log:dropStageIndex = 2 THEN 'Phase2'
END) AS phase,
decoded_log:feeRecipient AS fee_recipient,
decoded_log:minter AS minter,
decoded_log:quantityMinted AS quantity_minted,
Last run: 8 days agoAuto-refreshes every 1 hour
...
460
21KB
26s