CryptoLiontop airdrops and MIR
Updated 2021-08-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
block_timestamp,
date_trunc('day', block_timestamp) as date,
block_id,
msg_value:execute_msg:claim:amount/1e6,
msg_value:execute_msg:claim:stage,
msg_value:sender::string
FROM terra.msgs
WHERE
msg_value:contract::string = 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' -- MIR airdrop contract address
AND msg_value:execute_msg:claim:stage = 34
-- and msg_value:sender::string = 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'
-- tx_id = '5902E5EA9324DD96735C354091A4F6EB0F4619D616496314A523464FF4E930B3' -- airdrop transaction
ORDER BY block_timestamp DESC
Run a query to Download Data