Task: Create a query using
DuneAnalytics.com or BigQuery with following specification.
1. Find Set Protocol (
setprotocol.com) rebalancing transactions in Ethereum blockchain;
2. Determine the parameters of these transactions, the most important Asset pair, price, Amount, time, block.
3. Compare with transactions on DEX's by
Asset Prices,
Volumes in corresponding blocks. If there is no same block transaction, then find the nearest deals +2-3 blocks.
4. For corresponding transactions of Set Protocol and and DEX prices, check whether there was an arbitrage opportunity for a particular platform.
The query must include the following data:
- set_price
- set_volume
- set_time
- set_block
- dex_name
- dex_price
- dex_volume
- dex_time
- dex_block
- profit (calculated as dex_price*dex_volume-set_price*set_volume)
Of the DEXes, Uniswap, Kyber, and Oasis are a main interest. Aggregators like 1split can be used as well.
@mikevolkov