PapasotAlgo whales swaps
    Updated 2023-01-03
    With whales AS
    (select address,balance,wallet_type
    from algorand.account
    where balance > '10000000'
    order by balance DESC)

    SELECT
    date_trunc('day',block_timestamp) as block_day,
    swap_to_asset_id as ASA_id,
    count(swap_to_asset_id) as Swaps
    FROM algorand.swaps
    LEFT JOIN whales ON swapper = whales.address
    WHERE block_timestamp >= '2022-01-01'
    GROUP BY block_day,ASA_id
    ORDER BY 1
    Run a query to Download Data