adambalaUntitled Query
    Updated 2022-09-05
    with
    gg as (
    select hour::date as date,
    avg (price) as usdprice
    from ethereum.core.fact_hourly_token_prices
    where symbol ='WETH'
    group by 1),


    ANKR as (select --date_trunc (week,block_timestamp) as week,
    'ANKR' as title ,
    count (distinct tx_hash) as TX_Count,
    origin_from_address,
    sum (event_inputs:value/1e18) as G,
    sum (event_inputs:value/1e18*usdprice) as S,
    avg (event_inputs:value/1e18) as Average_ETH,
    avg (event_inputs:value/1e18*usdprice) as Average_USD,
    Median (event_inputs:value/1e18) as Median_ETH,
    median (event_inputs:value/1e18*usdprice) as Median_USD,
    min (event_inputs:value/1e18) as Min_Eth,
    min (event_inputs:value/1e18*usdprice) as Min_USD,
    max (event_inputs:value/1e18) as Max_ETH,
    max (event_inputs:value/1e18*usdprice) USD_Max
    --sum (Total_ETH) over (order by week) as Cumulative_ETH,
    --sum (total_usd) over (order by week) as Cumulative_USD
    from ethereum.core.fact_event_logs t1 join gg t2 on t1.block_timestamp::date = t2.date
    where origin_to_address = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
    --and origin_function_signature = '0xd0e30db0' -- Deposit
    and event_name = 'Transfer'
    group by 1,origin_from_address
    order by 1),



    LIDO as (select date_trunc (week,block_timestamp) as week,'LIDO' as title ,
    count (distinct tx_hash) as TX_Count,