Abbas_ra21nova part 1
Updated 2022-08-28
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date(BLOCK_TIMESTAMP) AS DAY,
count(distinct ORIGIN_FROM_ADDRESS) AS "unique users",
count(TX_HASH) AS "number of Bridges",
sum(AMOUNT) AS "ETH amount Bridged",
sum(sum(AMOUNT)) over (order by DAY) AS "cumulative ETH Amount",
sum(AMOUNT_USD) AS "ETH amount Bridged (USD VALUE)"
from ethereum.core.ez_eth_transfers
where ETH_TO_ADDRESS='0xc1ebd02f738644983b6c4b2d440b8e77dde276bd'
group by 1
Run a query to Download Data