flipside

    $RUNE Price vs Swapping Volume
    boomer77$RUNE Price vs Swapping Volume
    Updated 2022-01-23
    with raw as (select distinct tx_id, block_timestamp, to_amount_usd
    from thorchain.swaps)

    select date_trunc('day', block_timestamp) as dt, count(tx_id) as tx_count, sum(to_amount_usd) as swap_volume
    from raw
    group by 1
    Run a query to Download Data