op-analytics

(★ 154)

Onchain Data, Utilities, References, and other Analytics on Optimism

파일 탐색기

최종 버전 다운로드 (.zip)

- config.yml
- devcontainer.json
- - test-revshare.yml
- CODEOWNERS
- .gitignore
- extensions.json
- launch.json
- settings.json
- - config.py
  - op_incentive_program_summary.ipynb
  - op_incentives_program_attribution.ipynb
  - optimism_incentives_app_net_flows.ipynb
  - pull_dune_data.ipynb
  - pull_notion_data.ipynb
  - readme.md
  - simplified_op_reward_tracking_workflow.jpg
  - utils.py
- - main.py
  - queries.py
  - utils.py
- - gcs_ingestion.superchain_blocks.sql
  - gcs_ingestion.superchain_logs.sql
  - gcs_ingestion.superchain_traces.sql
  - gcs_ingestion.superchain_transactions.sql
- - default.across_bridge_metadata.sql
- - etl_monitor.blockbatch_daily.sql
  - etl_monitor.blockbatch_markers.sql
  - etl_monitor.blockbatch_markers_datawarehouse.sql
  - etl_monitor.daily_data_markers.sql
  - etl_monitor.superchain_4337_bigquery_markers.sql
  - etl_monitor.superchain_raw_bigquery_markers.sql
  - etl_monitor.transform_dt_markers.sql
- - etl_monitor.blockbatch_markers.sql
  - etl_monitor.daily_data_markers.sql
  - etl_monitor.superchain_4337_bigquery_markers.sql
  - etl_monitor.superchain_raw_bigquery_markers.sql
- - api_defillama.py
  - api_growthe.py
  - api_l2beat.py
  - api_utilities.py
  - download_data.ipynb
  - process_data.ipynb
  - readme.md
- .gitignore
- index.html
- - ingressroute.yaml
  - INSTRUCTIONS.md
  - secret-provider.yaml
  - service-account.yaml
  - values.yaml
- airtable_utils.py
- cancel_dune_query.ipynb
- clickhouse_utils.py
- coingecko_utils.py
- csv_utils.py
- defillama_utils.py
- defillama_utils_legacy.py
- duneapi_utils.py
- ethereumetl_utils.py
- evm_utils.py
- flipside_utils.py
- get_coingecko_data.ipynb
- get_eth_balance_by_block.ipynb
- get_op_chain_addresses_from_repo.ipynb
- get_op_chain_addresses_from_repo.py
- github_utils.py
- goldsky_db_utils.py
- google_bq_utils.py
- growthepieapi_test.ipynb
- growthepieapi_utils.py
- l2beat_utils.py
- metabaseapi_utils.py
- notionapi_utils.py
- opstack_metadata_utils.py
- os_utils.py
- pandas_utils.py
- readme.md
- requests_utils.py
- sql_format_exports.py
- subgraph_utils.ipynb
- subgraph_utils.py
- test_l2beat.ipynb
- test_l2bmetadata.ipynb
- tokenlist_utils.py
- web3py_utils.py
- models-4337-backfill-pt2.yaml
- models-fees-backfill.yaml
- newchain-backfill.yaml
- secret-provider.yaml
- service-account.yaml
- - competitor_tvl_comparison.ipynb
  - defillama_lending_growth_case_studies.ipynb
  - defillama_lending_yield.ipynb
  - defillama_schemas_and_clickhouse_insert.ipynb
  - defillama_tvl_api_pull_analysis.ipynb
  - defillama_tvl_charts.ipynb
  - dev_velodrome.ipynb
  - example_defillama_reader.ipynb
  - source_token_mapping_20241201.csv
  - tvl_networks_eda.ipynb
- - cg_get_token_vwap.ipynb
  - check_blob_fullness.ipynb
  - check_tx.ipynb
  - defi_launch_time.ipynb
  - eth_balance_analysis.ipynb
  - fake_exponential.ipynb
  - get_aoc_by_token_type.ipynb
  - get_chain_id.ipynb
  - get_dfl_volume.ipynb
  - get_op_txs_ethereumetl.ipynb
  - get_oracle_addresses.ipynb
  - goerli_top_contracts.sql
  - l1_nft_users.ipynb
  - last_synced_block.txt
  - output.csv
  - pull_raw_txs_oso_bq.ipynb
  - tx_inclusion_time.ipynb
  - unclaimed_withdrawals.ipynb
  - withdrawals_unclaimed.csv
  - write_data_to_dune.ipynb
- - gcs_uploads_from_bq.ipynb
  - l2_transaction_volume_tracking.ipynb
  - mb_gs_active_devs_to_dune.ipynb
  - mb_gs_active_devs_to_dune.py
  - mb_gs_all_uploads_from_api.ipynb
  - mb_gs_all_uploads_from_api.py
  - mb_gs_feegen_contracts_to_dune.ipynb
  - mb_gs_feegen_contracts_to_dune.py
  - mb_gs_op_chain_daily_usage_to_dune.ipynb
  - mb_gs_op_chain_daily_usage_to_dune.py
  - mb_gs_used_contracts_to_dune.ipynb
  - mb_gs_used_contracts_to_dune.py
  - read_l2_transaction_qualification.ipynb
  - read_l2_transaction_qualification.py
  - read_op_chain_metadata_airtable.ipynb
  - read_op_chain_metadata_airtable.py
- - create_matviews.ipynb
  - create_matviews.py
  - create_projections.ipynb
  - create_projections.py
  - create_superchain_data_view.ipynb
  - create_superchain_data_view.py
  - upload_table_to_clickhouse.ipynb
- - generate_yml.ipynb
  - new_pipeline.ipynb
  - readme.md
  - template_default_inputs.yml
- - chain_metadata_raw.csv
  - clean_chain_metadata_and_upload.ipynb
  - clean_chain_metadata_and_upload.py
  - non_app_methods.csv
  - readme.md
- - lightweight_op_stack_aggregate_data.ipynb
  - readme.md
- - chain_metadata.csv
  - op_stack_chain_metadata.csv
  - superchain_registry.csv
- ch_gs_uploads.ipynb
- ch_gs_uploads.py
- dune_op_stack_chains_l1_data.ipynb
- dune_op_stack_chains_l1_data.py
- dune_opchain_uploads.ipynb
- dune_opchain_uploads.py
- dune_ovm1_daily_data.ipynb
- get_superchain_token_list.ipynb
- get_superchain_token_list.py
- l2_revenue_tracking.ipynb
- l2_revenue_tracking.py
- superchain_registry_metadata.ipynb
- unify_daily_chain_data.ipynb
- unify_daily_chain_data.py
- - address_list.csv
- - op_collective_revenue.ipynb
  - readme.md
- get_op_collective_net_revenue_balances.ipynb
- - dune_daily_op_votable_supply.csv
- op_circulating_supply.ipynb
- op_votable_supply.ipynb
- - fixed_response.json
  - test_l2beat_metadata_extract.ipynb
- - remove_bq_dupes.ipynb
- chain_tvl_trends.ipynb
- fix_dfl_tvl.ipynb
- get_all_txs.ipynb
- get_app_fees.ipynb
- get_contract_labels.ipynb
- get_desybil_wallets.ipynb
- get_dune_evms_info.ipynb
- get_ethereum_chain_list.ipynb
- get_filtered_deployers.ipynb
- get_qualified_txs.ipynb
- pull_l2_activity.ipynb
- total_chain_data_to_uploads.ipynb
- total_chain_data_to_uploads.py
- - op_airdrop1_addresses_detailed_list.csv
  - op_airdrop2_addresses_detailed_list.csv
  - op_airdrop2_simple_list.csv
  - op_airdrop_3_addresses_detailed_list.csv
  - op_airdrop_3_simple_list.csv
  - op_airdrop_4_addresses_detailed_list.csv
  - op_airdrop_4_simple_list.csv
  - op_airdrop_5_addresses_detailed_list.csv
  - op_airdrop_5_simple_list.csv
  - op_superstacks_addresses_detailed_list.csv
  - op_unclaimed_airdrop_1_distribution_simple_list.csv
  - readme.md
- - backfill_market_data.ipynb
  - l1_base_fees_thru_2024_01_18.zip
- - key_events.csv
  - readme.md
- - backfill_market_data.ipynb
  - get_market_data.ipynb
  - get_market_data.py
- - ovm1_created_contracts.csv
  - uniswap_v3_pool_mappings.json
- - README.md
- - README.md
  - rpgf4_voting_calculator.ipynb
- - README.md
  - rpgf5_ballot_details.csv
  - rpgf5_voting_calculator_final.ipynb
- - README.md
  - rpgf6_ballot_details.csv
  - rpgf6_voting_calculator_final.ipynb
- __init__.py
- fix_blockbatch_ingestion.sh
- markdown_link_checker.py
- python_deps.sh
- - 1-architecture.md
  - index.md
- - index.md
- conf.py
- index.md
- Makefile
- - __init__.py
  - py.typed
  - readme.md
- pull_todays_tvl.ipynb
- pull_todays_tvl.py
- pull_todays_tvl_by_app.ipynb
- readme.md
- total_app_net_flows_async.ipynb
- total_app_net_flows_async.py
.dockerignore
.gitattributes
.gitignore
.nojekyll
.pre-commit-config.yaml
.python-version
.sqlfluff
CLAUDE.md
Dockerfile
Dockerfile.dagster
Makefile
Pipfile
pyproject.toml
README.md
uv.lock

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

op-analytics

파일 탐색기

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

op-analytics

파일 탐색기

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README