Papasot186. Bridge - Ethereum to Terra - Daily
    Updated 2022-11-28
    select --date_trunc('week',block_timestamp) AS DateWeek,
    date_trunc('day',block_timestamp) AS DateDay,
    CASE WHEN contract_address = '0xa47c8bf37f92abed4a126bda807a7b7498661acd' THEN 'UST' ELSE 'LUNA' END AS Currency,
    count(distinct from_address) AS AddressCount,
    count(tx_id) AS TxCount,
    sum(amount) AS totalAmount,
    sum(totalAmount) over (order by DateDay asc rows between unbounded preceding and current row) as cum_amount
    from ethereum.udm_events
    where to_address = '0x0000000000000000000000000000000000000000'
    and contract_address = '0xa47c8bf37f92abed4a126bda807a7b7498661acd'
    and DateDay > '2022-01-01'
    group by 1,2
    order by 1 desc
    Run a query to Download Data