ValiMohammadiDaily volume and the number of wallets for goETH and goBTC (selling)
    Updated 2022-05-22
    SELECT algorand.swaps.block_timestamp::DATE AS Days, algorand.asset.asset_name AS AssetName, sum(algorand.swaps.swap_from_amount) AS VolumeofSell, COUNT(DISTINCT algorand.swaps.swapper) AS NumberOfWallets
    FROM algorand.swaps
    LEFT JOIN algorand.asset ON algorand.swaps.swap_from_asset_id = algorand.asset.asset_id
    WHERE algorand.swaps.block_timestamp::date >= '2022-04-01' AND algorand.swaps.swap_from_asset_id in (386195940, 386192725)
    GROUP BY AssetName, Days
    Run a query to Download Data