flipside

    swap by time
    boomer77swap by time
    Updated 2021-10-25
    SELECT
    hour(block_timestamp) as block_hour, pool_name, sum(from_amount_usd) as volume_swapped_usd
    FROM thorchain.swaps
    where block_timestamp >= CURRENT_DATE - 30
    group by 1,2
    Run a query to Download Data