CryptoLionTotal value brought over
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with a as (
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')
select
shuttle,
sum(event_amount_usd) as total,
count(distinct event_to) as wallets
from a
group by 1