PapasotAnirand rug pull Liquidity pool withdrawals
    Updated 2022-05-11
    select
    block_timestamp,
    case
    when block_timestamp >= '2022-03-28' and block_timestamp < '2022-03-29' then 'Rug Pull'
    else 'Suspicious LP withdrawals' end as Liquidity_providers,
    sender,
    asset_amount


    from algorand.asset_transfer_transaction

    where asset_id = '656319282'
    AND
    asset_receiver = 'JO7VWMGSF7NSIWMIG3DIUL7DD3RVPIC7CBASGJLRFUMNTMXKGCPS2BYC7I'
    AND
    asset_amount is not null
    order by asset_amount desc
    limit 15

    Run a query to Download Data