MINTER | |
|---|---|
1 | 0xf05251c3e60c6d7efb7171bc56f1996172006fc6 |
2 | 0x3113558ea6918c3ae1d9247d1d7a3f9eff5888d8 |
3 | 0x989497f7a002313f43f2c74abd4a60766ddacc67 |
4 | 0x41a85716fa02ab850dfa5374797f809655f440a9 |
5 | 0x04a5c503a26c9bec8096a4c1152c0fba9061743f |
6 | 0x83c9440dc34da00c47a0d4dc2b598d7bdb1b53f7 |
7 | 0xa0b6792dd308f89ba6b3e7c6d103f2df9acacbff |
8 | 0x52e14e8dfc87e8875ce5e9a94019f497b82b3e01 |
9 | 0x03c4cb5a2d8ad62aa33d4aa128725610a01b962d |
10 | 0x886478d3cf9581b624cb35b5446693fc8a58b787 |
11 | 0x0c235dceba4e07d3ae3b82166dc1930855ade13a |
12 | 0x88690c01f0a9205503599931f267188ce55e19de |
13 | 0xe3bca6755abda45f3f1ba4815103235400eeaf63 |
14 | 0x36ab3c6d200c068076a56252b2b3f731112da862 |
15 | 0x5cc8f23ef02a0e5f55aef7ddc8acdf391c1fd418 |
16 | 0x313d3ea1027895e8efa5c084c87ce63605db7d2f |
17 | 0xea1b50d3b19aa218a39ba746da24b2f1064a879a |
18 | 0x8f2cf6a29daeccd027201806f26a76c590177594 |
19 | 0x0bf618b139d4928f2ad432fe865465a1398d81ef |
20 | 0x2e8f6f8662593134dc8311e312885921855332bc |
freemartianMinters who not seller
Updated 4 minutes 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: 5 minutes agoAuto-refreshes every 1 hour
...
460
21KB
82s