headitmanagerall quary
Updated 2022-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select month(block_timestamp) as tdate, (msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:maker_asset:amount/1e6 +
msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:taker_asset:amount/1e6) as amount,
msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:maker_asset:info:nft:contract_addr as maker_contract,
msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:taker_asset:info:nft:contract_addr as taker_contract,
msg_value
from terra.msgs where msg_value:contract='terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
and block_timestamp::date > '2022-01-01' and tx_status='SUCCEEDED'
and msg_value:execute_msg:ledger_proxy:msg:post_order is not null
group by tdate
--sender : msg_value:sender
--amount : msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:maker_asset:amount/1e6
--contract_addr contract_address : msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:taker_asset:info:nft:contract_addr
--msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:taker_asset:info:nft
Run a query to Download Data