LittlerDataCopy of Copy of Copy of Copy of Gnosis - new users
    Updated 2022-07-31

    select
    gnosis.core.fact_event_logs.block_timestamp,
    gnosis.core.fact_event_logs.tx_hash,
    gnosis.core.fact_token_transfers.contract_address,
    topics,
    event_inputs,
    raw_amount
    from gnosis.core.fact_event_logs
    join gnosis.core.fact_token_transfers on gnosis.core.fact_token_transfers.tx_hash = gnosis.core.fact_event_logs.tx_hash
    where gnosis.core.fact_event_logs.origin_function_signature = '0xda75ada3'
    and tx_status = 'SUCCESS'
    and event_name ilike 'swap'
    group by 1, 2, 3, 4, 5, 6
    order by 1 desc
    limit 10

    -- where contract_address swap amount0in not 0 then swap in, when amount 0 0 then swap out
    -- if swap out then sum amount 1

    --tomar los hash de los que si son swaps y buscarlos el contract_address en las transferencias de tokens,

    -- quizas when amount in = raw-amount para ver cantidades

    --select
    --*
    --from gnosis.core.fact_token_transfers
    -- where tx_hash = '0x7e8ff6fef4328a815b37e984532baa99d97484366ce1b197625c8492491ca884'
    Run a query to Download Data