zakkisyedGalactic Punk: Daily stats since its launch
    Updated 2021-12-19
    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:contract = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
    AND msg_value:execute_msg:execute_order is not null
    AND msg_type = 'wasm/MsgExecuteContract'
    AND tx_status = 'SUCCEEDED')

    SELECT
    DATE_TRUNC('day',block_timestamp) "date",
    COUNT(*) num_sales,
    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