zakkisyedUnique wallets purchasing NFT's
    Updated 2021-12-13
    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