germanDaily deposits on StarkNet from Ethereum L1
Updated 2022-06-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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