zakkisyedUnique wallets purchasing NFT's
Updated 2021-12-13
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
›
⌄
WITH RE_orders AS (
SELECT
block_timestamp,
tx_id,
msg_value : execute_msg : ledger_proxy : msg : execute_order : order : order : maker_asset : info : nft : contract_addr :: string AS collection_address,
msg_value : execute_msg : ledger_proxy : msg : execute_order : order : order : maker_asset : info : nft : token_id :: string AS tokenid,
msg_value : execute_msg : ledger_proxy : msg : execute_order : order : order : taker_asset : amount :: integer / 1000000 AS price,
msg_value : sender :: string AS owner,
'RandomEarth' AS market
FROM
terra.msgs
WHERE
msg_value : contract :: string = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t' -- RE Sale Contract
AND msg_value : execute_msg : ledger_proxy : msg : execute_order : order : order : maker_asset : info : nft : contract_addr :: string IS NOT NULL -- 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' -- GP
AND tx_status = 'SUCCEEDED'
),
RE_withdraw AS (
SELECT
block_timestamp,
tx_id,
msg_value : execute_msg : withdraw : asset : info : nft : contract_addr :: string AS collection_address,
msg_value : execute_msg : withdraw : asset : info : nft : token_id :: string AS tokenid,
NULL AS price,
msg_value : sender :: string AS owner,
'RandomEarth' AS market
FROM
terra.msgs
WHERE
msg_value : contract :: string = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
AND msg_value : execute_msg : withdraw : asset : info : nft : contract_addr :: string IS NOT NULL -- 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' -- GP
-- and msg_value : execute_msg : withdraw is not null
AND tx_status = 'SUCCEEDED'
),
KW_settle AS (
SELECT
block_timestamp,
Run a query to Download Data