CryptoLionterra bridge base
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
block_timestamp,
event_to,
event_amount,
event_amount_usd,
case
when event_from = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc' then 'eth shuttle'
when event_from = 'terra1g6llg3zed35nd3mh9zx6n64tfw3z67w2c48tn2' then 'bsc shuttle'
end as shuttle
FROM terra.transfers
WHERE
(event_from = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc' -- eth
or event_from = 'terra1g6llg3zed35nd3mh9zx6n64tfw3z67w2c48tn2') -- bsc
AND block_timestamp >= getdate() - interval '30 days'
Run a query to Download Data