PromotedPawnQuery 3. Average swap price
    Updated 2022-05-08
    --Show us the volume of ALGOs swapped for goMint by day on each DEX since the token release
    --Show us the number of swaps and the number of wallets by day by DEX for goMINT/algo swaps in the first week of the token release.
    --In the first 24 hours of the token release- chart the average swap price in ALGOs for goMint across each DEX(AlgoFi Tinyman Pact). Do we see a higher average price for goMint on any of the DEXes?
    --Note any other interesting findings between the DEXes related to the release of the goMint and the goMint/algopools, such as volume, number of swaps, or number of wallets swapping.

    --Launch Details: https://www.algomint.io/token-launch goMint Token Asset ID: 441139422 swap_from_asset_id = 0 swap_to_asset_id = 441139422

    select
    trunc(block_timestamp,'hour') as date,
    swap_program,
    sum(swap_from_amount) as volume_Algo,
    sum(swap_to_amount) as volume_goMINT,
    volume_Algo / volume_goMINT as avg_price
    from algorand.swaps
    where swap_from_asset_id = '0'
    and swap_to_asset_id = '441139422'
    and date > '2022-03-28'
    and date < '2022-03-30'
    Group by 1, 2
    order by 1

    Run a query to Download Data