PapasotAnirand rug pull trades
    Updated 2022-05-11
    select
    date_trunc('day',block_timestamp) as block_day,
    count(distinct(swapper)) as Investors,
    sum(swap_from_amount) as Lost_Algo


    from algorand.swaps

    where swap_to_asset_id = '604643747'
    AND
    swap_from_asset_id = 0
    group by block_day
    order by block_day
    Run a query to Download Data