ADDRESSES | TRANSACTION | Volume (USD) | Avg Transactions per Address | Avg Volume Per Address (USD) | Source Chain | Avg Volume (USD) | Max Volume (USD) | Median Volume (USD) | |
|---|---|---|---|---|---|---|---|---|---|
1 | 29547 | 71409 | 1520908306.05797 | 2.416794 | 51474.204015906 | 12 | 9694.538643817 | 12254121.2415297 | 1.03 |
hess0. Total Inflow
Updated 2025-03-06
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with eth_base as (select *,regexp_substr_all(SUBSTR(INPUT_DATA, 11, len(INPUT_DATA)), '.{64}') AS segmented_data,
'Ethereum' as source
from ethereum.core.fact_transactions
where block_timestamp::Date >= current_date - 30
and STATUS = 'SUCCESS')
,
eth_transfer as ( select block_timestamp,
tx_hash,
origin_from_address,
origin_to_address,
'' as contract_address,
'ETH' as symbol,
amount,
amount_usd
from ethereum.core.ez_native_transfers
where block_timestamp::Date >= current_date - 30
union
select block_timestamp,
tx_hash,
origin_from_address,
origin_to_address,
contract_address,
symbol,
amount,
amount_usd
from ethereum.core.ez_token_transfers
where block_timestamp::Date >= current_date - 30
)
,
ethereum as ( select a.block_timestamp,
source,
a.tx_hash,
origin_from_address,
origin_to_address,
contract_address,
symbol,
Last run: about 2 months ago
1
97B
432s