DistributedDoge

-- Google Big Query... query(?) to catch all Events emitted by successful donations to old Gitcoin grant round. No matter what contract/round is emitting them. 
-- In post-processing might be prudent to check that only official Gitcoin grant rounds are emitting such events. 

-- Event ABI corresponds to `Voted` event emitted by QuadraticFundingVotingStrategyImplementation
-- https://etherscan.io/tx/0x02d062a8605c518b07343230b35d9aa23c3781a65e58d45a71ffb607a8b00ced#eventlog

-- NOTE: Won't work for recent Gicoin rounds as ABI has changed. 

-- Voted (address token, uint256 amount, index_topic_1 address voter, address grantAddress, index_topic_2 bytes32 projectId, uint256 applicationIndex, index_topic_3 address roundAddress)

DistributedDoge

import bs4
import markdown
import pandas 
import requests
import lxml

chains = requests.get('https://raw.githubusercontent.com/allo-protocol/allo-contracts/main/docs/CHAINS.md').text
html = markdown.markdown(text=chains, extensions=['tables'])

soup = bs4.BeautifulSoup(html, 'html.parser')

DistributedDoge

import pandas as pd
import plotly.offline as pyo

data = pd.read_parquet('http://grant-data.xyz/rounds.parquet')
data = data[data['amount_usd'] > 100]
dat = data
dat['donations'] = 'Community'

sankey_fig = make_sankey_graph(
    df=dat, 

DistributedDoge

DistributedDoge