bachiGalact punks - Traders, Collectors
Updated 2021-10-27
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
›
⌄
⌄
/*SELECT
block_timestamp,
sender,
token_id
FROM (
SELECT
block_timestamp,
MAX(block_timestamp) OVER (PARTITION BY token_id) AS max_block_timestamp,
sender,
token_id
FROM (
SELECT
block_timestamp,
msg_value:sender::string AS sender,
COALESCE(msg_value:execute_msg:approve:token_id::string,
msg_value:execute_msg:revoke:token_id::string,
msg_value:execute_msg:send_nft:token_id::string,
msg_value:execute_msg:transfer_nft:token_id::string) AS token_id
FROM terra.msgs
WHERE msg_value:contract = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'
)
)
WHERE block_timestamp = max_block_timestamp*/
select * from terra.msgs
WHERE msg_value:contract = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'
Run a query to Download Data