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

    SELECT
    date_trunc('day',block_timestamp) as block_day,
    swap_to_asset_id as ASA,
    asset_name as ASA_name,
    count(swap_to_asset_id) as swaps
    FROM algorand.swaps
    LEFT JOIN whales ON swapper = whales.address
    left join algorand.asset b on b.asset_id = swap_to_asset_id
    WHERE block_day >= '2022-01-01' AND
    whales.balance > '100000'
    GROUP BY block_day, swap_to_asset_id,asset_name
    ORDER BY block_day

    Run a query to Download Data