theericstoneWhat's goin on with Paxos
    Updated 2021-11-11
    with prespike as (
    select
    to_address,
    to_label,
    to_address_name,
    sum(amount) as amount_received
    from
    gold.ethereum_events
    where block_timestamp < '2020-11-02'
    and block_timestamp > '2020-10-01'
    and contract_address = '0x8e870d67f660d95d5be530380d0ec0bd388289e1' --paxos stablecoin
    group by 1,2,3
    order by 4 desc
    limit 50
    ),
    postspike as (
    select
    to_address,
    to_label,
    to_address_name,
    sum(amount) as amount_received
    from
    gold.ethereum_events
    where block_timestamp > '2020-11-01'
    and block_timestamp < '2020-12-02'
    and contract_address = '0x8e870d67f660d95d5be530380d0ec0bd388289e1' --paxos stablecoin
    group by 1,2,3
    order by 4 desc
    limit 50
    )
    select
    postspike.to_address,
    postspike.to_address_name,
    postspike.to_label,
    postspike.amount_received as after_received,
    prespike.amount_received as before_received,
    Run a query to Download Data