alleriaSwaps to $THOR
    Updated 2022-05-29
    WITH thor_price as (
    SELECT
    date(block_timestamp) as dates2,
    AVG(price_asset_rune) as avg_price_1,
    AVG(price_rune_asset),
    AVG(asset_usd) as average_thor_price_usd
    FROM thorchain.prices
    WHERE pool_name like '%ETH.THOR%'
    AND dates2 >= '2022-04-27'
    GROUP BY dates2
    ),

    final as (
    SELECT
    date(block_timestamp) as dates,
    SUM(to_amount) as THOR_amount,
    SUM(to_amount_usd) as THOR_USD_amount,
    COUNT(tx_id) as no_tx,
    COUNT(from_address) as distinct_swappers
    FROM thorchain.swaps
    WHERE to_asset like '%ETH.THOR%'
    AND dates >= '2022-04-27'
    GROUP BY dates
    ORDER BY dates ASC
    )

    SELECT
    dates,
    THOR_amount,
    THOR_USD_amount,
    no_tx as "No. of Transactions",
    distinct_swappers as "Distinct Swappers",
    average_thor_price_usd
    FROM final
    INNER JOIN thor_price ON dates2 = dates
    ORDER BY dates ASC
    Run a query to Download Data