feat: add chainswap #6332
feat: add chainswap #6332
Conversation
|
Workflow run id 9811148524 approved. |
|
Workflow run id 9811148648 approved. |
|
Workflow run id 9811273295 approved. |
|
Workflow run id 9811273479 approved. |
|
Workflow run id 9811405393 approved. |
|
Workflow run id 9811632666 approved. |
|
Workflow run id 9811405538 approved. |
|
Workflow run id 9811632793 approved. |
|
Workflow run id 9811790049 approved. |
|
Workflow run id 9811789963 approved. |
|
Workflow run id 9811924073 approved. |
|
Workflow run id 9811924061 approved. |
|
Workflow run id 9811981783 approved. |
Co-authored-by: Huang Geyang <[email protected]>
|
Workflow run id 9894534877 approved. |
|
Workflow run id 9894534986 approved. |
|
Workflow run id 9894537227 approved. |
|
Workflow run id 9894537614 approved. |
| {% set deployer_3 = "0xc1cc1a300Dcfe5359eBe37f2007A77d1F91533ba" %} | ||
| {% set deployer_4 = "0x3A510C5a32bCb381c53704AED9c02b0c70041F7A" %} | ||
| {% set deployer_5 = "0xb7b953e81612c57256ff0aebd62b6a2f0546f7da" %} | ||
| {% set weth_contract_address = "0x82aF49447D8a07e3bd95BD0d56f35241523fBab1" %} | ||
| {% set usdc_contract_address = "0xaf88d065e77c8cC2239327C5EDb3A432268e5831" %} | ||
| {% set fee_recipient_1 = "0x415EEc63c95e944D544b3088bc682B759edB8548" %} | ||
| {% set fee_recipient_2 = "0xe1ff5a4c489b11e094bfbb5d23c6d4597a3a79ad" %} | ||
|
|
||
| with | ||
| bot_contracts as ( | ||
| select address | ||
| from {{ source("arbitrum", "creation_traces") }} | ||
| where |
There was a problem hiding this comment.
Please use single quotes (') in the code as much as possible. Double quotes (") can sometimes break the code.
|
Workflow run id 9920578611 approved. |
|
Workflow run id 9920697985 approved. |
|
Workflow run id 9920698243 approved. |
|
Workflow run id 9920742605 approved. |
|
Workflow run id 9920742499 approved. |
|
Workflow run id 9920775014 approved. |
|
Workflow run id 9920775092 approved. |
|
Workflow run id 9920830494 approved. |
|
Workflow run id 9920830549 approved. |
|
@Hosuke the uniqueness test is failing on the incremental run only, initial run works fine. |
I think we may need to add |
|
Workflow run id 10071784899 approved. |
|
Workflow run id 10071785209 approved. |
ok will try that out and report back, thank you sir! |
|
Workflow run id 10132637251 approved. |
|
Workflow run id 10132686143 approved. |
|
Workflow run id 10132730375 approved. |
| and block_time >= timestamp '{{project_start_date}}' | ||
|
|
There was a problem hiding this comment.
Maybe we can add an incremental filter here.
| tx_to as bot, | ||
| trades.tx_hash, | ||
| evt_index | ||
| from {{ source('dex', 'trades') }} as trades |
There was a problem hiding this comment.
We can apply incremental filters to most selection from large tables/sources.
| trades.blockchain = '{{blockchain}}' | ||
| and trades.block_time >= timestamp '{{project_start_date}}' | ||
| and (tx_from != {{ fee_recipient_1 }} and tx_from != {{ fee_recipient_2 }}) | ||
| order by trades.block_time desc, trades.evt_index desc |
There was a problem hiding this comment.
Since this is not the final select, I am not sure if the order by works here.
This PR adds a dedicated spellbook for chainswap trades.
Dashboard: https://dune.com/whale_hunter/chainswap