binhachonCopy of 97. [Galactic Punks] New User Onboarding - Base query - Detailed table
    Updated 2021-10-23
    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