wyeeehselect_by_venues_join_block_position
Updated 2023-05-05
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
›
⌄
SELECT
ethereum.core.ez_dex_swaps.TX_HASH,
ethereum.core.ez_dex_swaps.CONTRACT_ADDRESS,
ethereum.core.fact_transactions.TO_ADDRESS,
ethereum.core.fact_transactions.TX_FEE,
ethereum.core.fact_transactions.POSITION,
ethereum.core.fact_transactions.block_number,
ethereum.core.fact_transactions.block_timestamp,
ethereum.core.fact_transactions.block_hash,
ethereum.core.fact_transactions.cumulative_gas_used,
ethereum.core.fact_transactions.eth_value,
ethereum.core.fact_transactions.from_address,
ethereum.core.fact_transactions.gas_used,
ethereum.core.fact_transactions.status
FROM
ethereum.core.ez_dex_swaps
LEFT JOIN ethereum.core.fact_transactions
ON ethereum.core.ez_dex_swaps.TX_HASH = ethereum.core.fact_transactions.TX_HASH
WHERE
ethereum.core.ez_dex_swaps.CONTRACT_ADDRESS IN (
'0x084b5191bd08412952337b1108b6e5942418928f',
'0x0574215b0a39119c84ca17f1ec83418eeb5ada8e',
'0xe34947aaaff202e2f08bd8b05f550b868c7383d4',
'0x1aec8f11a7e78dc22477e91ed924fab46e3a88fd',
'0xf1045c0bd261a1e3159cfa587b72d8a47f8f7c50',
'0x69d91b94f0aaf8e8a2586909fa77a5c2c89818d5',
'0x2f3e9588e8a6e857c7d36918b2fa2cbaef4dd779',
'0xaf0b0000f0210d0f421f0009c72406703b50506b',
'0xdc6ad288d435944330362a5637eec6ffc9251463',
'0x7f808fd904ffa3eb6a6f259e6965fb1466a05372',
'0x41bfba56b9ba48d0a83775d89c247180617266bc',
'0x576cea6d4461fcb3a9d43e922c9b54c0f791599a',
'0x14424eeecbff345b38187d0b8b749e56faa68539',
'0xbed8674cf009214a1209e61133215e5f81487fd9',
'0xae76c84c9262cdb9abc0c2c8888e62db8e22a0bf',
'0x88395224c3709be9a700624bd9246459585c56b0',
Run a query to Download Data