CryptoLionbridge
Updated 2021-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
tx_id,
event_currency,
event_amount_usd,
CASE
WHEN event_from_address_name LIKE 'ETH shuttle' THEN 'in'
WHEN event_to_address_name LIKE 'ETH shuttle' THEN 'out'
ELSE NULL
END as direction
FROM terra.transfers
WHERE (event_from_address_name LIKE 'ETH shuttle'
OR event_to_address_name LIKE 'ETH shuttle')
AND block_timestamp >= getdate() - interval '90 days'
AND (event_currency LIKE 'LUNA'
OR event_currency LIKE 'UST')