CryptoLionTotal value brought over
    Updated 2022-07-07
    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