boomer77top synths swap by asset
    Updated 2022-05-12
    select date_trunc('day', block_timestamp) as dt, from_asset, to_asset, sum(from_amount_usd) as swap_from_volume_usd, count(distinct tx_id) as tx_count, count(distinct from_address) as address_count
    from thorchain.swaps
    WHERE CONTAINS(from_ASSET, '/')
    group by 1,2,3
    Run a query to Download Data