zakkisyedGalactic Punk Sales by Token ID
    Updated 2021-10-15
    WITH nft_sales AS (
    SELECT
    block_id,
    block_timestamp,
    tx_id,
    msg_value:execute_msg:execute_order:"order":"order":maker_asset:amount maker_asset_amount,
    msg_value:execute_msg:execute_order:"order":"order":maker_asset:info:nft:contract_addr maker_asset_nft_address,
    msg_value:execute_msg:execute_order:"order":"order":maker_asset:info:nft:token_id maker_asset_nft_token_id,
    msg_value:execute_msg:execute_order:"order":"order":maker_fee maker_fee,
    msg_value:execute_msg:execute_order:"order":"order":taker_fee taker_fee,
    msg_value:execute_msg:execute_order:"order":"order":taker_asset:amount taker_asset_amount,
    msg_value:execute_msg:execute_order:"order":"order":taker_asset:info:native_token:denom taker_asset_currenct
    FROM terra.msgs
    WHERE msg_value:execute_msg:execute_order is not null
    AND msg_type = 'wasm/MsgExecuteContract'
    AND tx_status = 'SUCCEEDED')

    SELECT
    taker_asset_nft_address,
    COUNT(*) num_address,
    --SUM(taker_asset_amount / 1000000) amt_sales,
    --MIN(taker_asset_amount / 1000000) min_sale_amt,
    --MAX(taker_asset_amount / 1000000) max_sale_amt,
    --AVG(taker_asset_amount / 1000000) average_sale_amt
    FROM nft_sales
    WHERE maker_asset_nft_address = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'
    GROUP BY 1
    ORDER BY 1 ASC

    Run a query to Download Data