zakkisyedGalactic Punk: Daily stats since its launch
Updated 2021-12-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
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