SajjadiiiBlast \\ Market - Sales Metrics ( 17 Visualization With Time Parameter ) copy
Updated 2024-06-28
999
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
›
⌄
-- 0x6a761202 3 tx || execTransaction 0x55c2a8565db63cf625b572027beed3eafb3f225cefd7d0f5218bae360a597530 -
-- 0x627cdcb9 22 tx || incrementNonce 0x502c68861a5163c61a658b8ee7b2b305a8a897ff8ddd9e9ba4dbf51852c119ca -
-- 0xf2fde38b 1 tx || transferOwnership 0x77d424bb6155e789b14a891d298438cdbd971e93049f4ff1f510cadedf79ea86 -
-- 0x60806040 3 tx || unknown 0xf5ba2a8ea7594a2187a0b80f6170bcbe97225087fef851bb00958184ec5a3234 -
-- 0x3f8fc233 245372 tx || cancelTrades 0xfe4ace07457dc5001442fa354350cde59056ba011433ae2406c37dcf6c9a1975 -
-- 0x3925c3c3 601531 tx || takeAsk 0xfd7cc2610b32e7c08d8ffc3391a2fd779c907b0955fa82380741e873572ad274 +
-- 0x7034d120 194397 tx || takeBid 0x9bec41c4ef3d31b0b52e549f45c3bcb905f479f7f7be46d581a65e946aeb35ef -
-- 0xda815cb5 22182 tx || takeBidSingle 0x1bebc53a982bb365f4b2b60c5dfa00479212297ccf7fc8dc44f7f93d0c96ef74 +
-- 0x70bce2d6 174682 tx || takeAskSingle 0x103d7d25b464b82ceeb41ed1fb87950aa0607f3cfef2d813a36a25bb92d45095 -
with tab AS (
SELECT
block_timestamp,
tx_hash,
concat('0x', substr(topics [1], 24 + 3, 32 + 8)) as Seller_address,
concat('0x', substr(topics [2], 24 + 3, 32 + 8)) as Buyer_address,
-- ethereum.public.udf_hex_to_int(substr(data, (64 * 13) + 24 + 3, 32 + 8)) as Raw_amount,
-- Raw_amount / pow(10, 18) AS Unit_Price,
contract_address as NFT_contract,
ethereum.public.udf_hex_to_int(substr(topics [3], + 24 + 3, 32 + 8)) as Token_id,
row_number() over (
partition BY tx_hash,
Seller_address :: string
ORDER BY
block_timestamp
) AS rn
FROM
blast.core.fact_event_logs
WHERE
topics [0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND origin_function_signature = '0x3925c3c3' -- takeAsk
AND topics [0] <> '0x1d5e12b51dee5e4d34434576c3fb99714a85f57b0fd546ada4b0bddd736d12b2'
AND origin_to_address = '0x0f41639352b190f352baddd32856038f1c230ced' -- blur ERC1967Proxy
--AND tx_hash IN ( '0x55749c7bf3100ff41077ff184eeafdbbdd54cb5e368efa902e42d0a4ecd0ce04','0xfd7cc2610b32e7c08d8ffc3391a2fd779c907b0955fa82380741e873572ad274')
--AND tx_hash = '0xd4234c03a302677c97791495aee13d0b2ae58ff2c5f351b489c6e9e201570e54'
--GROUP BY 1,2,3,4,5,6,7
),
QueryRunArchived: QueryRun has been archived