hess7. Daily Per source
    Updated 2025-03-06
    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 1 month ago
    DATE
    SOURCE
    ADDRESSES
    TRANSACTION
    Volume (USD)
    Cumulative Transactions
    Avg Transactions per Address
    Avg Volume Per Address (USD)
    Cum Volume (USD)
    Avg Volume (USD)
    Max Volume (USD)
    Median Volume (USD)
    AVG_7_DAY_MOVING_VOLUME
    AVG_30_DAY_MOVING_TXNS
    1
    2025-02-06 00:00:00.000Arbitrum3430504614886937.7082033160931.4711374340.21507527845703756.24088221349.799411388500000314886937.70820335046
    2
    2025-02-06 00:00:00.000INK99591.3516093165.70555555645703756.240882232.852777778410.410.037443764.529101642527.5
    3
    2025-02-06 00:00:00.000Avalanche4568778437.28282466160931.51111117298.60628499245703756.24088225520.831793083149992.7220037446.89966885221988.780342651707.666
    4
    2025-02-06 00:00:00.000MATLE212157217.471609312724.64142857145703756.24088221300.39704545549850.640.4153930795.952756991286
    5
    2025-02-06 00:00:00.000Linea31283656.3041845160930.903226117.94529627445703756.2408822117.9452962742095.5597039913.890153145368.023042491034.4
    6
    2025-02-06 00:00:00.000BNB163287816491.632301736160931.7607365009.15111841645703756.24088221656.169639557219787.2618.782757221.95791903909.833
    7
    2025-02-06 00:00:00.000Scroll44313.5794916093178.394872545703756.240882278.3948725141.6795384.450052363377.90385774780.428
    8
    2025-02-06 00:00:00.000Optimism513716351926.417934485160931.395712686.01640922945703756.2408822249.06328233254011.560.292111946.46811733772.375
    9
    2025-02-06 00:00:00.000Ethereum3411642523792149.5814879160931.8836126975.12447419845703756.24088222241.5818335683300207.150377270.023225097.95227791944.75
    10
    2025-02-06 00:00:00.000Polygon5665196107.152170203160931.1607143501.91343161145703756.24088221400.765372644169981.4129505893.4008652953249537.42754918951.75
    11
    2025-02-06 00:00:00.000Base252534244819927.76228547160931.356041908.88228209345703756.2408822692.51835665376462.664.1953754723.737481781371.25
    12
    2025-02-07 00:00:00.000MATLE18182404.56236801133.586666667101750866.91608966.7933333331951.750.133747872.123731781370.875
    13
    2025-02-07 00:00:00.000Ethereum1014153741923591.7922474236801.51577941344.765081112101750866.91608915766.6761159265249691.2499410.028987864.059739651559.5
    14
    2025-02-07 00:00:00.000INK20202168.046721286236801108.402336064101750866.91608951.6201600311749.150.028886073.611542091526.125
    15
    2025-02-07 00:00:00.000Polygon485314772.885508008236801.104167307.768448084101750866.916089135.5310597069989.960040.038887881.024794341532.25
    16
    2025-02-07 00:00:00.000Arbitrum236833386715647.65326558236801.4096282835.999853575101750866.916089894.227383924361607.360040982.969683346.179210721860
    17
    2025-02-07 00:00:00.000Avalanche1961752266.915031416236803.21052639592.995527969101750866.9160894615.13444804549999.9519.656803360.845903671064.5
    18
    2025-02-07 00:00:00.000Scroll1010124.31832388723680112.431832389101750866.91608912.43183238967.7218333334.8759726778862.991672881057.625
    19
    2025-02-07 00:00:00.000Sei3767493.13466122236802.33333322497.71155374101750866.9160899641.87638017464663.489213365626.3698332656184808.66321984630.5
    20
    2025-02-07 00:00:00.000Base130516194904733.04795093236801.2406133758.416128698101750866.9160891631.105104074268144.620.9999716797599.72421371830.625
    ...
    343
    53KB
    457s