ArkanAlgorand 1
    Updated 2022-11-15


    SELECT
    date_trunc('hour', block_timestamp) as day,
    'algorand' as chain,
    sum(algo_price * FEE) as fee_volume,
    avg(algo_price * FEE) as avg_fee,
    sum(algo_price * AMOUNT) as trasfer_volume,
    avg(algo_price * AMOUNT) as avg_trasfer,
    (sum(algo_price * FEE) / sum(algo_price * AMOUNT) ) * 1000000 as gas_per_million_transfered,
    avg(algo_price) as ALGO_price
    FROM
    algorand.core.ez_transaction_payment
    left outer JOIN (
    SELECT
    date_trunc('hour', RECORDED_HOUR) as day1,
    avg(CLOSE) as algo_price
    FROM crosschain.core.fact_hourly_prices
    WHERE id LIKE 'wrapped-algo'
    GROUP BY 1
    )
    ON date_trunc('day', block_timestamp) = day1
    WHERE block_timestamp > CURRENT_DATE - 30
    AND asset_id = 0
    GROUP BY 1
    Run a query to Download Data