blockchain-etl / ethereum-etl-airflow

Airflow DAGs for exporting, loading, and parsing the Ethereum blockchain data. How to get any Ethereum smart contract into BigQuery https://towardsdatascience.com/how-to-get-any-ethereum-smart-contract-into-bigquery-in-8-mins-bab5db1fdeee
MIT License
401 stars 189 forks source link

Add contract parsers for SushiSwap #134

Open askeluv opened 4 years ago

askeluv commented 4 years ago

Context

We add "table definition" for contract events so that we can regularly parse these events from Ethereum logs. One benefit of this is that the events become available in public BigQuery tables, under the blockchain-etl project.

For more details on this, please read How to get any Ethereum smart contract into BigQuery.

In this ticket we are looking to add datasets for SushiSwap.

Proposed solution

Add table definition files for SushiSwap by following the checklist below.

Checklist

  1. [ ] 1. Identify all smart contracts for the 13 farms listed on https://app.sushiswap.org/farms
  2. [ ] 2. Generate table definition files for all the contracts in your list using this Contract Parser
  3. [ ] 3. Create Pull Request containing all the table definition files

Please note

Before applying for this bounty, please list the contracts identified in step 1, and confirm you've understood the process.

It may be helpful to look at past PRs that are labeled contract parsing.

sebastiantf commented 4 years ago

@askeluv It seems staking to all the 13 pools are facilitated by the single MasterChef contract at 0xc2edad668740f1aa35e4d8f227fb8e17dca888cd. I got the info from their discord.

I shall create a PR with the table definition files for that contract. Is that good?

askeluv commented 4 years ago

@sebastiantf thanks for checking! yeah that sounds good, as long as it has the basic events like Withdrawn and Staked.

sebastiantf commented 4 years ago

These are the events found from using the Contract Parser:

Screenshot 2020-08-28 at 2 55 27 PM
askeluv commented 4 years ago

Perfect, let's do it :)

sebastiantf commented 4 years ago

@askeluv I have a PR up at #135

sebastiantf commented 4 years ago

@askeluv I have submitted work on Gitcoin