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')

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