winnie-fsAptos NFTs || Sales Query copy
9999
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
›
⌄
-- forked from Aptos NFTs || Sales Query @ https://flipsidecrypto.xyz/edit/queries/1e3d8672-438d-4a1a-a36d-324474100cda
with topaz_sale AS (
SELECT
'Topaz' AS market
,block_timestamp
,tx_hash
,sender AS buyer_address
,payload:arguments[0] AS seller_address
,payload:arguments[4] AS collection_name
,payload:arguments[1]/pow(10,8)AS amount
,'Sale' AS function
,payload:arguments[5] AS item
--,split_part(payload:type_arguments[0] ,'::' , 3) AS token_symbol
--,split_part(payload_function ,'::' , 1)AS Market_address
--,REGEXP_SUBSTR(payload:function, '0x[0-9a-fA-F]+', 1, 1) AS Market_address
--,split_part(payload_function , '::' , 3) AS Type
--,REGEXP_SUBSTR(payload:function, '::marketplace_v2::([^:]+)::', 1, 1) AS type
FROM aptos.core.fact_transactions
WHERE split_part(payload_function ,'::' , 1) = '0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2'
AND split_part(payload_function , '::' , 3) IN ( 'buy' , 'buy_v2' )
AND success
--and tx_hash = '0xaf015d782640be60ac52932618988af149fe250c40d27e2da07bed3eb3e76d36'
),
topaz_sweeps AS (
SELECT
'Topaz' AS market
,block_timestamp
,tx_hash
,sender AS buyer_address
,f.value AS seller_address
,fi.value AS collection_name
,s.value/pow(10,8) AS amount
,'Sweep Sale' AS function
Run a query to Download Data