kasadeghUntitled Query
    Updated 2022-11-15
    with algopricet as (
    select block_hour::date as day,
    avg (price_usd) as usdprice
    from algorand.core.ez_price_pool_balances
    where asset_id = '0'
    group by 1)

    select 'wallet: '|| tx_sender,
    coalesce(address_name,tx_sender) as Wallet_Label,
    sum (fee) as Gas,
    sum (fee*usdprice) as USD_Gas,
    avg (fee*usdprice) as Average_USD_Gas
    from algorand.core.fact_transaction t1 join algopricet t2 on t1.block_timestamp::Date = t2.DAY
    full outer join algorand.core.dim_label t3 on t1.tx_sender = t3.address
    where block_timestamp >= CURRENT_DATE - 30
    group by 1,2
    order by Gas DESC
    limit 10


    Run a query to Download Data