DeFi Swap -> Dune Analytics

[NatalieTop]

add trades from DEX DeFi Swap to Ethereum dex.trades table on Dune Analytics

see an example: https://github.com/duneanalytics/abstractions/blob/f935c24521ae260f3ada576daf5d66fc87e5bb2f/ethereum/dex/trades/insert_1inch_lp.sql

https://docs.dune.xyz/

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

This issue now has a funding of 100.0018 1INCH (248.0 USD @ $2.48/1INCH) attached to it.

• If you would like to work on this issue you can 'start work' on the Gitcoin Issue Details page.
• Want to chip in? Add your own contribution here.
• Questions? Checkout Gitcoin Help or the Gitcoin's Discord
• $5,677,955.14 more funded OSS Work available on the Gitcoin Issue Explorer

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

Workers have applied to start work.

These users each claimed they can complete the work by 264 years, 11 months from now.
Please review their action plans below:

1) sinedvonotirah has applied to start work (Funders only: approve worker | reject worker).

I'm ready to start this task.
Dune analytics looks interesting for me as a start point at gitcoin.
I'm an experienced Senior Backend Engineer with huge SQL experience and a love for blockchain. This task is very familiar to my current project - data visualization, SQL.

Learn more on the Gitcoin Issue Details page.

[SinedVonotirah]

@NatalieTop
The task looks not feasible. Dune doesn't contain tables with any swap info, only info about lp pair creation and fees changes for defi swap protocol. As a result, I can't query swap transactions for defi swap.
If you have any ideas where I can find list of all swap transactions, I will be glad to get help

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

Workers have applied to start work.

These users each claimed they can complete the work by 264 years, 11 months from now.
Please review their action plans below:

1) echolon166 has applied to start work (Funders only: approve worker | reject worker).

Hello, already submitted PR's for 4 other bounties (3 of them got approved so far, waiting for merge) and would like to take on this one as well.

I will add trades from Crypto.com DeFi Swap to the dex.trades table on Dune Analytics.

Learn more on the Gitcoin Issue Details page.

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

Work for 100.0018 1INCH (252.00 USD @ $2.6/1INCH) has been submitted by:

---

• Learn more on the Gitcoin Issue Details page
• Want to chip in? Add your own contribution here.
• Questions? Checkout Gitcoin Help or the Gitcoin's Discord
• $5,695,825.57 more funded OSS Work available on the Gitcoin Issue Explorer

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

The funding of 100.0018 1INCH (255.0 USD @ $2.55/1INCH) attached to this issue has been approved & issued to @Echolon166.

• Learn more on the Gitcoin Issue Details page
• Questions? Checkout Gitcoin Help or the Gitcoin's Discord
• $5,185,948.85 more funded OSS Work available on the Gitcoin Issue Explorer