theericstoneBSC Exploration
    Updated 2021-02-25
    /*with senders as (
    SELECT
    from_address
    --sum(amount) as amount,
    --symbol,
    --from_address,
    --from_address_name,
    --from_label
    from gold.ethereum_events
    where to_address = LOWER('0x131A99859a8bfa3251D899F0675607766736FFaE')
    and amount > 10
    and block_timestamp > getdate() - interval '30 days'
    group by 2,3,4,5
    order by 1 desc
    ),

    receivers as (
    SELECT
    sum(amount) as amount,
    symbol,
    to_address,
    from_address_name,
    from_label
    from gold.ethereum_events
    where from_address = LOWER('0x131A99859a8bfa3251D899F0675607766736FFaE')
    and amount > 10
    and block_timestamp > getdate() - interval '30 days'
    group by 2,3,4,5
    order by 1 desc
    )
    */

    select * from gold.ethereum_events where contract_address = LOWER('0x131A99859a8bfa3251D899F0675607766736FFaE') and
    origin_label IS NOT NULL AND
    block_timestamp > getdate() - interval '100 days' order by 1 desc limit 100;

    Run a query to Download Data