binhachonCopy of 97. [Galactic Punks] New User Onboarding - Base query - Detailed table
Updated 2021-10-23
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 execute_order as(
---------------DEPOSIT MONEY AND EXECUTE THE TRADE------------------------------------------------------------------------------------------------------------------------------
select distinct tx_id, block_timestamp,
msg_value:execute_msg:execute_order:"order":"order":nonce::float as nonce,
msg_value:execute_msg:execute_order:"order":"order":maker as maker,
msg_value:execute_msg:execute_order:"order":"order":maker_asset:info:nft:token_id::string as ID,
msg_value:sender::string as address
from terra.msgs
where msg_value:contract::string = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
and msg_value:execute_msg:execute_order:"order":"order":maker_asset:info:nft:contract_addr::string = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'
and tx_status = 'SUCCEEDED'
),
----------------DEPOSIT GP AND POST ORDER-------------------------------------------------------------------------------------------------------------------------------------
post_order as(
select distinct tx_id, block_timestamp,
msg_value:execute_msg:post_order:"order":"order":nonce::float as nonce,
msg_value:execute_msg:post_order:"order":"order":maker as maker,
msg_value:execute_msg:post_order:"order":"order":maker_asset:info:nft:token_id::string as ID,
msg_value:sender::string as address
from terra.msgs
where msg_value:contract::string = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
and msg_value:execute_msg:post_order:"order":"order":maker_asset:info:nft:contract_addr::string = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'
and tx_status = 'SUCCEEDED'
),
---------------LIST--------------------------
list_1_0 as(
select execute_order.tx_id,execute_order.block_timestamp, execute_order.nonce, execute_order.maker, execute_order.ID, execute_order.address as buyer, post_order.address as seller
from execute_order left join post_order
on execute_order.nonce = post_order.nonce
and execute_order.maker = post_order.maker
and execute_order.ID = post_order.ID
order by execute_order.ID, execute_order.block_timestamp
),
list_1 as(
select tx_id, block_timestamp, nonce, maker, ID, buyer,
CASE
Run a query to Download Data