germanDaily deposits on StarkNet from Ethereum L1
    Updated 2022-06-27
    with deposits as (
    SELECT *
    FROM ethereum.core.ez_eth_transfers
    WHERE eth_to_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419')

    SELECT
    date_trunc('day', block_timestamp) as date,
    count(eth_from_address) as n_depositors,
    sum(round(amount,2)) as eth_deposited_StarkNet,
    sum(amount_usd) as usd_deposited_StarkNet,
    sum(n_depositors) OVER (order by date) as cumulative_users,
    sum(eth_deposited_StarkNet) OVER (order by date) as cumulative_eth_deposited,
    sum(usd_deposited_StarkNet) OVER (order by date) as cumulative_usd_deposited
    FROM deposits
    WHERE block_timestamp > current_date - 90
    GROUP BY 1 ORDER BY 1

    Run a query to Download Data