LittlerDataCopy of Copy of Copy of Copy of Gnosis - new users
Updated 2022-07-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
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