This release includes gas specific queries and dashboards

Flashbots is a new section

1inch is its own section now, more dex's to be separated this way

Release Notes

v1.8.3

• feat(release): updates to dex.trades, balancer, curve, 1inch, clipper, and LBPs 5dd8115
• v1.8.1 #12
• v1.8.0 #10

• abstractions update
• balancer overhaul
• numerari added

Changelog

All notable changes to this project will be documented in this file. See standard-version for commit guidelines.

1.8.0 (2021-04-10)

Features

• add: uniswap V2 (#9) (ac9ab26)
• cli: python3 scripts pkg (364b651)

1.7.3 (2021-04-10)

Bug Fixes

• bug: malformed artifact pollution (fcb4f66), closes #8
• defect: artifact (b187b05)

1.7.1

list of changes

rewrite dune/abstractions/async_art_v2/async_art_v2_token_mapping.sql (98%)
rewrite dune/abstractions/balancer/view_add_liquidity.sql (100%)
rewrite dune/abstractions/balancer/view_balances.sql (87%)
create mode 100644 dune/abstractions/balancer/view_lbps.sql
create mode 100644 dune/abstractions/balancer/view_pools_liquidity.sql
rewrite dune/abstractions/balancer/view_pools_tokens_weights.sql (98%)
rewrite dune/abstractions/balancer/view_remove_liquidity.sql (100%)
rewrite dune/abstractions/balancer/view_swaps.sql (100%)
rewrite dune/abstractions/bancornetwork/view_add_convertible_token.sql (100%)
rewrite dune/abstractions/bancornetwork/view_add_liquidity_pool.sql (95%)
rewrite dune/abstractions/bancornetwork/view_add_smart_token.sql (95%)
rewrite dune/abstractions/bancornetwork/view_convert.sql (100%)
rewrite dune/abstractions/bancornetwork/view_remove_convertible_token.sql (93%)
rewrite dune/abstractions/bancornetwork/view_remove_liquidity_pool.sql (95%)
rewrite dune/abstractions/bancornetwork/view_remove_smart_token.sql (95%)
rewrite dune/abstractions/bancornetwork/view_smart_tokens.sql (99%)
rewrite dune/abstractions/bancornetwork/view_update_conversion_fee.sql (95%)
rewrite dune/abstractions/bancornetwork/view_update_price_data.sql (99%)
rewrite dune/abstractions/bancornetwork/view_update_token_rate.sql (100%)
rewrite dune/abstractions/chainlink/view_aggregator_mappings.sql (99%)
rewrite dune/abstractions/compound/view_accrue_interest.sql (99%)
rewrite dune/abstractions/compound/view_borrow.sql (98%)
rewrite dune/abstractions/compound/view_ctokens.sql (96%)
rewrite dune/abstractions/compound/view_liquidate_borrow.sql (99%)
rewrite dune/abstractions/compound/view_mint.sql (98%)
rewrite dune/abstractions/compound/view_redeem.sql (98%)
rewrite dune/abstractions/compound/view_repay_borrow.sql (98%)
rewrite dune/abstractions/compound/view_transfer_ctoken.sql (100%)
rewrite dune/abstractions/curvefi/view_trades.sql (90%)
delete mode 100644 dune/abstractions/dex/trades.sql
create mode 100644 dune/abstractions/dex/trades/insert_1inch.sql
create mode 100644 dune/abstractions/dex/trades/insert_balancer.sql
create mode 100644 dune/abstractions/dex/trades/insert_bancor.sql
create mode 100644 dune/abstractions/dex/trades/insert_curve.sql
create mode 100644 dune/abstractions/dex/trades/insert_ddex.sql
create mode 100644 dune/abstractions/dex/trades/insert_dydx.sql
create mode 100644 dune/abstractions/dex/trades/insert_futureswap.sql
create mode 100644 dune/abstractions/dex/trades/insert_gnosis_protocol.sql
create mode 100644 dune/abstractions/dex/trades/insert_idex.sql
create mode 100644 dune/abstractions/dex/trades/insert_kyber.sql
create mode 100644 dune/abstractions/dex/trades/insert_linkswap.sql
create mode 100644 dune/abstractions/dex/trades/insert_loopring.sql
create mode 100644 dune/abstractions/dex/trades/insert_mooniswap.sql
create mode 100644 dune/abstractions/dex/trades/insert_oasis.sql
create mode 100644 dune/abstractions/dex/trades/insert_sushi.sql
create mode 100644 dune/abstractions/dex/trades/insert_synthetix.sql
create mode 100644 dune/abstractions/dex/trades/insert_uniswap.sql
create mode 100644 dune/abstractions/dex/trades/insert_zeroex.sql
create mode 100644 dune/abstractions/dex/trades/trades.sql
rewrite dune/abstractions/dex/view_token_prices.sql (95%)
rewrite dune/abstractions/erasure_bay/view_burn.sql (100%)
rewrite dune/abstractions/erasure_bay/view_deposit_reward.sql (99%)
rewrite dune/abstractions/erasure_bay/view_deposit_stake.sql (99%)
rewrite dune/abstractions/erasure_bay/view_request_data.sql (100%)
rewrite dune/abstractions/erasure_bay/view_submit_data.sql (100%)
rewrite dune/abstractions/erasure_numerai/view_burn.sql (98%)
rewrite dune/abstractions/erasure_numerai/view_reward.sql (100%)
rewrite dune/abstractions/erasure_numerai/view_stake.sql (98%)
rewrite dune/abstractions/erasure_quant/view_burn.sql (98%)
rewrite dune/abstractions/erasure_quant/view_reward.sql (92%)
rewrite dune/abstractions/erasure_quant/view_stake.sql (98%)
rewrite dune/abstractions/erc20/stablecoins.sql (93%)
rewrite dune/abstractions/erc20/tokens.sql (98%)
rewrite dune/abstractions/ethereumnameservice/view_expirations.sql (100%)
rewrite dune/abstractions/ethereumnameservice/view_registries.sql (100%)
rewrite dune/abstractions/gnosis_protocol/known_address.sql (98%)
rewrite dune/abstractions/gnosis_protocol/view_balances.sql (81%)
rewrite dune/abstractions/gnosis_protocol/view_daily_average_prices.sql (84%)
rewrite dune/abstractions/gnosis_protocol/view_tokens.sql (83%)
rewrite dune/abstractions/gnosis_protocol/view_trade_stats.sql (94%)
rewrite dune/abstractions/gnosis_protocol/view_trades.sql (89%)
rewrite dune/abstractions/iearn_v2/view_ytokens.sql (93%)
rewrite dune/abstractions/index/view_indices.sql (97%)
rewrite dune/abstractions/index/view_indices_assets.sql (99%)
rewrite dune/abstractions/lending/borrow.sql (97%)
rewrite dune/abstractions/lending/collateral_change.sql (96%)
rewrite dune/abstractions/lending/repay.sql (96%)
rewrite dune/abstractions/loopring/fn_decode_float_16.sql (87%)
rewrite dune/abstractions/loopring/fn_decode_float_24.sql (88%)
rewrite dune/abstractions/loopring/fn_process_block_v2.sql (87%)
rewrite dune/abstractions/loopring/fn_process_trade_block_v1.sql (94%)
rewrite dune/abstractions/makermcd/collateral_addresses.sql (97%)
rewrite dune/abstractions/oneinch/swaps.sql (98%)
rewrite dune/abstractions/oneproto/swaps.sql (98%)
rewrite dune/abstractions/onesplit/swaps.sql (99%)
rewrite dune/abstractions/public/numeric2bytea.sql (100%)
rewrite dune/abstractions/stablecoin/burn.sql (93%)
rewrite dune/abstractions/stablecoin/mint.sql (93%)
rewrite dune/abstractions/stablecoin/transfer.sql (94%)
rewrite dune/abstractions/synthetix/rates.sql (92%)
rewrite dune/abstractions/synthetix/symbols.sql (99%)
rewrite dune/abstractions/synthetix/synths.sql (99%)
rewrite dune/abstractions/synthetix/trades.sql (93%)
rewrite dune/abstractions/token_balances/project_addresses.sql (92%)
rewrite dune/abstractions/zeroex/view_affiliate_data.sql (73%)
delete mode 100644 dune/chain/block_rewards_daily_by_miner.sql
delete mode 100644 dune/chain/block_rewards_gini.sql
delete mode 100644 dune/chain/daily_top_miners.sql
delete mode 100644 dune/chain/gini.sql
delete mode 100644 dune/chain/gini_daily.sql
delete mode 100644 dune/chain/gini_sma.sql
delete mode 100644 dune/chain/hashrate.sql
delete mode 100644 dune/chain/hashrate_by_day.sql
delete mode 100644 dune/chain/hashrate_by_hour.sql
delete mode 100644 dune/chain/hashrate_daily_average.sql
delete mode 100644 dune/chain/hashrate_sma.sql
delete mode 100644 dune/chain/miners_by_reward_monthly.sql
delete mode 100644 dune/chain/onchain_transactions_all.sql
delete mode 100644 dune/chain/rich_list.sql
delete mode 100644 dune/chain/top_miners.sql
rename dune/{chain => homestead}/RoutedUniswapSwaps.sql (97%)
create mode 100644 dune/homestead/block_rewards_daily_by_miner.sql
create mode 100644 dune/homestead/block_rewards_gini.sql
create mode 100644 dune/homestead/daily_top_miners.sql
create mode 100644 dune/homestead/gini.sql
create mode 100644 dune/homestead/gini_daily.sql
create mode 100644 dune/homestead/gini_sma.sql
create mode 100644 dune/homestead/hashrate.sql
create mode 100644 dune/homestead/hashrate_by_day.sql
create mode 100644 dune/homestead/hashrate_by_hour.sql
create mode 100644 dune/homestead/hashrate_daily_average.sql
create mode 100644 dune/homestead/hashrate_sma.sql
create mode 100644 dune/homestead/miners_by_reward_monthly.sql
create mode 100644 dune/homestead/onchain_transactions_all.sql
create mode 100644 dune/homestead/rich_list.sql
create mode 100644 dune/homestead/top_miners.sql
create mode 100644 dune/xdai/README.md
create mode 100644 dune/xdai/dex/trades.sql
copy dune/{abstractions => xdai}/gnosis_protocol/view_balances.sql (83%)
copy dune/{abstractions => xdai}/gnosis_protocol/view_daily_average_prices.sql (85%)
create mode 100644 dune/xdai/gnosis_protocol/view_movement.sql
create mode 100644 dune/xdai/gnosis_protocol/view_price_batch.sql
create mode 100644 dune/xdai/gnosis_protocol/view_tokens.sql
copy dune/{abstractions => xdai}/gnosis_protocol/view_trade_stats.sql (74%)
copy dune/{abstractions => xdai}/gnosis_protocol/view_trades.sql (97%)
create mode 100644 dune/xdai/perp/view_amm.sql
create mode 100644 dune/xdai/public/bytea2numeric.sql
copy dune/{abstractions => xdai}/public/numeric2bytea.sql (100%)
delete mode 100644 labels/ethereum/account_type.sql
create mode 100644 prices/prices.ini
create mode 100644 prices/prices.toml

1.6.0 (2021-03-07)

Features

• abstractions: dune-abstractions update (467b3d7)

v1.4.2

22 February 2021

• docs(chore): fix markup e72ee8d
• feat(base): start base sql layers fc6aae4
• Release 1.4.2 f1eadb8

v1.4.1

22 February 2021

• Release 1.4.1 0fe5c06

v1.4.0

22 February 2021

• feat(sushiswap): sushiswap analytics package ba65246
• docs(chore): changelog ed28437
• feat(release): v1.3.1 33f1398

v1.3.1

10 February 2021

• Yearn Fiannce #4
• Auto-format queries 92bbeb5

CI Actions Workflow