CryptoLionUntitled Query
Updated 2022-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select *
-- msg_value:sender as sender,
from terra.msgs
where msg_index = 0
and msg_value:contract = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
limit 100
-- where tx_id = '24D4051A349BFAD4E680BB6E9E320C28B118A6C4D240ADBA1DC0345371035BC2'
-- where (event_to = 'terra1dq03ugtd40zu9hcgdzrsq6z2z4hwhc9tqk2uy5' or event_from = 'terra1dq03ugtd40zu9hcgdzrsq6z2z4hwhc9tqk2uy5'--wormhole core addy
-- or event_to = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf' or event_from = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf') --wormhole token addy
-- and block_timestamp >= getdate() - interval '2 weeks'
-- order by block_timestamp
Run a query to Download Data