clayopLUNC TFL to Wormhole
Updated 2023-02-13
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
31
32
33
34
35
36
›
⌄
SELECT
-- BLOCK_TIMESTAMP, TX_ID,
MSG_VALUE['sender'] AS FROM_ADDRESS,
-- MSG_VALUE['contract'] AS TO_ADDRESS,
SUM(MSG_VALUE['coins'] [0] ['amount'] / POW(10, 6)) AS AMOUNT,
MSG_VALUE['coins'] [0] ['denom'] AS TOKEN
FROM
terra.classic.fact_messages
WHERE
MSG_VALUE['contract'] = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
-- AND AMOUNT > 0
AND FROM_ADDRESS in (
'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6',
'terra10zzfuednzhkmwn4tqks2mukstr02r5jklpmh2f',
'terra12qmfcxy8kahwt44tn4aq4t6kdmtyer38xnrh7m',
'terra12vp8yq4wygfl9gssjs8k3kagrv3kx7ppexzqv2',
'terra13u3p30c2tn9m8dmru6mfyhmqs379qm43vrx7l7',
'terra13vpm23s7rw5gqp9ckhqngjesxcuzatytknqpfg',
'terra14ny376fe7hys2zqxwc87zp2achp9tju5q6jul4',
'terra14tlthgtg6ep6xnqptyg8dp3gcq4jxvgqmskwkd',
'terra17p4mqd7yl9m0r7cfv0nf9s9zae3d3gm4tmyg2a',
'terra1885dgdvn5u8sjfaefvr39arssaxgqmd29ht0aa',
'terra18kgwjqrm7mcnlzcy7l8h7awnn7fs2pvdl2tpm9',
'terra18w7z9prrjzncz3mkqh7e65q3mc6j386y0qyw9a',
'terra1anllr0tt8r2my88kp6kmdwdnewnja5246djj99',
'terra1dtzfwgzt8xa70zkm8gqzwz0n4zrqtngdpqejx5',
'terra1e028300g5kaef05vycatgz8tnrvmwmfstafk52',
'terra1fqgwjedr6wc63f5hasmurzc7kfqe6zqjz2ets7',
'terra1g2ghu8s3c4thlta9v3zlnk5sr9jq7gzaymnjqw',
'terra1g3m0gl6ku7f79y83q4fdam630sd2s0ewzpafzs',
'terra1g5dmf4qpmdrcw77d3ty6djrgujt8r2n3lgyknj',
'terra1g9p9c5hjw4m3v9l65lmxt2g89vheashp6yfukm',
'terra1kflkz6dyc84snr5rwqx3dn8dd92m6lhqauhpen',
'terra1lewnh53gt0hzgjejrtwdz8q7dennz09s6ds4k2',
'terra1mer7nd843n5g3v37xxtd3hude6t5rf4cq3mnae',
'terra1nexqdq252acp09m9eler7jhg9kd3rqfzkek9r0',
Run a query to Download Data