MostlyData_test_arbs
Updated 2023-01-05Copy Reference Fork
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
29
30
31
32
33
34
35
36
›
⌄
with swap_list as(
select
block_number,
block_timestamp,
tx_hash,
tx_to,
sender,
origin_from_address,
origin_to_address,
pool_name,
amount_in,
amount_in_usd,
amount_out,
amount_out_usd,
event_index,
platform,
symbol_in,
symbol_out
from ethereum.core.ez_dex_swaps
where block_timestamp < '{{end_date}}'
and block_timestamp > '{{start_date}}'
),
possible_arbs as (
select
block_number,
block_timestamp,
tx_hash,
origin_from_address,
origin_to_address,
tx_to,
sender as searcher,
symbol_out as symbol,
pool_name,
event_index,
Run a query to Download Data