🗞️Change Log

Change log for enriched batch data on Snowflake Warehouse.

June 2024

• Week of 14th July

  • New Schemas

    • Add DEX Trades for Blast, Celo

    • Update EVM-compatible blockchain DEX trades to include transaction fees and gas details.

  • New Blockchains

    • Stacks (Beta)

• Week of 7th July

  • New Schemas

    • Add Beacon Attestation Rewards from genesis

  • New Blockchains Supported

    • Linea (Beta)

    • Hedera (Beta)

• Week of 1st July

  • New Blockchains Supported

    • Sui (Beta)

  • Schema

    • Add Solana Balances

• Week of 24th June

  • New Blockchains Supported

    • Fantom (Beta)

    • Cosmos (Beta)
• Week of 17th June

  • New Blockchains Supported

    • Scroll Sepolia (Backfilled from Genesis)

    • Provenance (Beta)

    • ZkSync (Beta)

    • Aptos (Backfilled from Genesis)

  • DEX Schemas

    • bsc.dex.uniswap_v3_events, avalanche.dex.uniswap_v3_events

• Week of 10th June

  • New Blockchains Supported

    • Add NEAR (Backfill in progress)

  • Schema Coverage

    • Add ethereum.dex.sandwich_trades

    • Add ethereum.dex.jit_liquidity_events

    • Add Odos V2, Magpie V2, Firebird Finance to ethereum.dex.aggregator_trades

      • Add Airswap v4 protocol to ethereum.dex.trades

• Week of 3rd June 2024

  • New Blockchains Supported

    • Add Aptos (Beta)

  • Schema Coverage

    • BSC DEX Trades

      • Add Dodo v2, Thena v1/Fusion, PancakeSwap Stable, Maverick, TraderJoe trades

    • Optimism DEX Trades

      • Add Dodo, Curve, Balancer (BeethovenX) trades

May 2024

• Week of 27th May 2024

  • Schema Coverage

    • Avalanche DEX Trades

      • Add Dodo, Curve, Balancer, Hashflow, Dexalot Trades

    • Polygon DEX Trades

      • Add Hashflow, Quickswap V3

    • Add Base base.dex.uniswap_v3_events

  • ⚠️ Deprecate protocol_liquidity_pool_events to the following tables:

    • uniswap_v3_protocol_liquidity_pool_events -> uniswap_v3_events

    • uniswap_v2_protocol_liquidity_pool_events -> uniswap_v2_events

  • Users are advised to migrate their existing queries to the new and improved UniswapV2 and UniswapV3 events table:

• Week of 20th May 2024

  • Schema Coverage

    • Arbitrum DEX Trades

      • Add Dodo, Curve, Balancer, Camelot V3

    • Base DEX Trades

      • Add Dodo, Curve, Maverick DEX Projects

• Week of 13th May 2024

  • New Blockchains Supported

    • Add Holesky (Beta)

  • Schema Coverage

    • Add Native and ERC20 Balances for Avalanche, Arbitrum, Optimism

    • Backfill ethereum.raw.block_rewards From Genesis, adding block and uncle rewards

    • Backfill beacon.validator.balances and beacon.validator.income from genesis

    • Add Tron schema tron.dex.trades

    • Add Tron to Crosschain dex trades

• Week of 6th May 2024

  • New Blockchains Supported

    • Immutable IMX zkEVM chain (beta)

    • Upgrade Zora from beta to production

  • • Add Magisat support to bitcoin.nfts.trades

    • Add Support for Runes on Bitcoin

    • Add Payment Processor v2 protocol and Magic Eden on base.nfts.trades

    • Add Uniswap platform UniswapV2 trades to blockchains with DEX trades

    • Update chain metrics to include native token prices for all chains, blob fee metrics for Ethereum, and historical token supply for Bitcoin

April 2024

• Week of 29th April

  • Add platform and protocol mints support on base.nfts.mints

• Week of 15th April

  • Add 1inch v2-5 toethereum.dex.aggregator_trades

• Week of 8th April

  • Add Sudoswap v2 to base.nfts.trades

• Week of 1st April

  • UniswapX trades (Beta) on Ethereum.

  • Add support for Element, Zonic, and Alienswap to base.nfts.trades

  • Add BTC chain metrics

March 2024

• Week of 25th March

  • New Blockchains Supported

    • WeMix Chain (beta)

    • Fraxtal Chain (beta)

  • Schemas

    • Add Crosschain DEX Trades

• Week of 11th March

  • New Blockchains Supported

    • Zora Chain (beta)

    • Celo Chain (beta)

• Week of 4th March

  • New Blockchains Supported

    • Blast chain (beta)

    • Osmosis chain (beta)

  • Schemas

    • Add crosschain.metrics.overview

    • Solana defi vertical: solana.defi.rewards_claimed, solana.defi.farms

February 2024

• 2024-02-22: Add ethereum.dex.aggregator_trades_beta

  • DEX aggregator trades with additional fields

• 2024-02-21: Addchain.metrics.overview for multiple chains

• 2024-02-20: Add token transfers and balances on Oasys

  • oasys.assets.ercX_token_transfer (erc20, erc721, erc1155)

  • oasys.assets.ercX_balances (erc721, erc1155)

  • oasys.assets.ercX_balances_latest (erc721, erc1155)

• 2024-02-16: Improve arbitrum.dex.trades add project coverage with Trader Joe, Uniswap v2/v3 DEXes

• 2024-02-02: Add Avalanche avalanche.dex.trades and avalanche.dex.pools for Uniswap v2/v3 DEXes and Trader Joe

January 2024

• 2024-01-29: Add BSC bsc.dex.trades and bsc.dex.pools for Uniswap v2/v3 protocols and forks

• 2024-01-26: Add Tron tron.staking.events and tron.assets.trx_token_transfers coverage from genesis.

• 2024-01-22: Solana complete backfill from genesis with voting and rewards transactions.

• 2024-01-18: Avalanche decoded logs and traces coverage.

• 2024-01-08: Improved contracts schemas: raw.contract_events for EVM chains.

  • This new table includes runtime and creation bytecode for both failed and successful contract deployments, as well as contract destruction.

• 2024-01-04: Bitcoin: support Jubilee upgrade to the ordinals protocol for Ordinals transfers.

December 2023

• 2023-12-18: Add okx marketplace coverage for solana.nfts.trades

• 2023-12-03: Blockchain Coverage: Starknet (beta)

• 2023-12-01: Add mooar marketplace coverage for polygon.nfts.trades

• 2023-12-01: Blockchain Coverage: Scroll