bigbuddy2024-06-13 05:45 PM
Updated 2024-06-17
9999
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
›
⌄
-- mev todo 0xdaac5c9f179d4b46a10f7f03e7b34cb0b447543d834226210879ea45923e4d68
-- buytokens todo
-- unknown todo 0xd7ae9952d2db3846fc78a0e5d75fd032ce7f73df777b261ce9d47ad50482ef4b
-- 1inch something todo 0x2c1e67270f7d01294ed071465737df95f9779f86ca33606f9db2b022159baea9
-- jared todo 0xecc7b6d94a3d6af5840df6db7beb750378033110a6180795924c418459105c78
-- something else todo 0x77426a21fce14d6ccc3005b09b7845d5e15106a06f978048539eb66339ca6c08
-- gets by with universals
-- metamask router and mev todo 0xec432029ec3a536c5c448111025a943ba39142ae40df7ca7e0127001f66813a9
-- metamask todo 0x928f0df7068d250b1d73960fe7912f8cb997565bc3e3d322610a733ea442b7a0
-- triangle metamask mev? todo 0xf162c02638368e67a8063bed211dfe9ba11a52be70630ae71aad1fe64b8750f4
-- v2 pool {{pool}}
-- neural ai addy {{token}}
with x as (
select
symbol,
row_number() over (
partition by tx_hash
order by event_index
) as tx_index,
block_timestamp,
origin_from_address,
origin_to_address,
contract_address,
from_address,
to_address,
amount_precise as tokens,
block_number,
tx_hash,
event_index,
origin_function_signature,
from ethereum.core.ez_token_transfers
WHERE
block_timestamp > '2023-01-01'
and contract_address in (
QueryRunArchived: QueryRun has been archived