CryptoLionMIR airdrops
Updated 2021-08-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
block_timestamp,
date_trunc('day', block_timestamp) as date,
msg_value,
msg_value:execute_msg:claim:amount/POW(10,6) as amount,
msg_value:execute_msg:claim:stage,
msg_value:sender::string as recipient
FROM terra.msgs
WHERE
msg_value:contract::string = 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' -- MIR airdrop contract address
-- tx_id = '5902E5EA9324DD96735C354091A4F6EB0F4619D616496314A523464FF4E930B3' -- airdrop transaction
ORDER BY block_timestamp DESC
LIMIT 100