flipside

    Number of exploit transactions executed by hour
    RayyykNumber of exploit transactions executed by hour
    Updated 2022-08-03
    select date_trunc('hour', block_timestamp) as hour,
    count(distinct(tx_id)) as hack_tx_count,
    sum(hack_tx_count) over (order by hour) as cumulative_hack_tx_count
    from solana.core.fact_transfers
    where tx_to in ('Htp9MGP8Tig923ZFY7Qf2zzbMUmYneFRAhSp7vSg4wxV','CEzN7mqP9xoxn2HdyW6fjEJ73t7qaX9Rp2zyS6hb3iEu','5WwBYgQG6BdErM2nNNyUmQXfcUnB68b6kesxBywh1J3n','GeEccGJ9BEzVbVor1njkBCCiqXJbXVeDHaXDCrBDbmuy')
    and block_timestamp >= '2022-08-02'
    and amount > 0
    group by 1
    order by 1
    Run a query to Download Data