Flipside Docs
  • Welcome to Flipside!
    • Welcome to Flipside
    • Growth Services
    • Data
      • Choose your Flipside plan
        • Free
        • Builder
        • Pro
          • Get Started in Snowflake
          • Incremental Table Pattern
          • Copy Data from Snowflake to AWS
          • Copy Data from Snowflake to GCP
          • Copy Data from Snowflake to Azure
        • Snowflake Data Shares
          • Mounting a Snowflake Data Share
    • Earn
    • Community
  • Data
    • Flipside Data
      • Table Docs by Chain
      • Data Modeling Approach
      • Labels
        • Centralized Exchange Label Type
        • Decentralized Exchange Label Type
        • Operator Label Type
        • Chain Admin Label Type
        • Decentralized Finance Label Type
        • NonFungible Tokens Label Type
        • Games Label Type
        • Bridge Label Type
        • Decentralized Applications Label Type
        • Token Label Type
        • Flotsam Label Type
      • Tags
      • Table Freshness Targets
      • Contribute to Our Data
        • Contract Decoding & ABIs
        • How to Add Your Own Tags
        • Community Curation
          • Getting Started
            • Contribution Workflow
          • Model Standards
            • dbt Tips
          • PR Checklist
    • Data Products
      • Data Studio (SQL Analysts)
        • Get Started
          • Write/fork your first query
        • Flipside AI
        • Studio in Depth
          • Query Editor
            • Query Referencing
            • Pro Tips for Querying
            • Keyboard Shortcuts
            • Hex-to-Integer Function
          • Create a Chart
            • Advanced Visualization
          • Build a Dashboard
            • Markdown Reference
          • Team Accounts
        • Tutorials
          • How to Analyze Web3 Data
          • Video Tutorials
            • Overview of Schemas & Tables
            • Ethereum Tutorials
              • Getting Started with Decoded Ethereum Events
              • Getting Started with Ethereum Balances
              • Block Level and Daily Balances
              • Finding Centralized Exchange Flows
            • Solana Tutorials
              • Solana Schema & Tables: Video Walkthrough
              • Solana Specialty Tables: Video Walkthrough
              • Exploring Transactions in solana.events
            • THORChain Tutorials
              • THORChain Schema & Tables
              • Calculating IL for THORChain
          • More Tools & Resources
        • Get Inspired
      • LiveQuery
        • Get Started
        • LiveQuery in Depth
          • Functions
            • 🤝Partner Functions
            • 🧙‍♂️EVM Functions
              • 💡Seaport: Real-time Orders
              • 💡WETH Pool Balances
              • 💡General EVM Node Queries
            • 🤖API Functions
              • 💡Query TheGraph
              • 💡Query Defi Llama
            • ⚙️Utility Functions
              • 💡Hex Converters
              • 💡JSON RPC Request Builder
              • 💡EVM Logs Decoder
              • 💡Keccak256 Encoder
          • QuickNode Setup Guide
        • Secrets Manager
        • Get Inspired
      • Snowflake
      • API/SDK (Developers)
        • Get Started - Your first API call in < 2 min
        • SDK in Depth
          • JSON RPC methods
          • Run A Query
          • Query Results
          • Pagination
          • Sorting
          • Filtering
          • Query Seconds
          • Caching (maxAgeMinutes)
          • Rate Limits
          • Errors
          • More Examples
          • Archive
            • [ARCHIVED] JS/TS SDK
            • ShroomDK Migration Guide
            • [LEGACY] R
        • Tutorials
          • Have Questions?
        • Get Inspired
    • Insights and Tools
  • Earn
    • Flipside Earn
    • Onchain Rewards
      • Quests
    • Analyst Rewards
      • Top Dashboards
        • Top Dashboard Guidelines
        • Skill Tree
      • Ambassador Program
      • Direct to Analyst Commissions
    • Wallet Management
    • Tax Center
  • Support
    • General Support
    • Open a Ticket
      • That email doesn't look quite right
    • 🌟Product Special Releases
      • 2025
        • 2025-02-06 | EVM Blockchain Standardization
          • Table Change Overview
      • 2024
        • 2024-06-13 | Solana native and wrapped addresses
        • 2024-05-01 | Improvements to Pricing Data
          • Actions for Data Studio Users
          • Actions for API Users
          • Action for Data Share Users
    • 🗒️Release Notes
      • 2025
        • 2025-05-01 | Release Notes
        • 2025-04-17 | Release Notes
        • 2025-04-03 | Release Notes
        • 2025-03-20 | Release Notes
        • 2025-03-06 | Release Notes
        • 2025-02-20 | Release Notes
        • 2025-02-06 | Release Notes
        • 2025-01-23 | Release Notes
      • 2024
        • 2024-12-24 | Release Notes
        • 2024-12-12 | Release Notes
        • 2024-11-27 | Release Notes
        • 2024-11-14 | Release Notes
        • 2024-10-31 | Release Notes
        • 2024-10-03 | Release Notes
        • 2024-10-17 | Release Notes
        • 2024-09-19 | Release Notes
        • 2024-09-05 | Release Notes
        • 2024-08-22 | Release Notes
        • 2024-08-08 | Release Notes
        • 2024-07-25 | Release Notes
        • 2024-07-11 | Release Notes
        • 2024-06-27 | Release Notes
        • 2024-06-14 | Release Notes
        • 2024-05-30 | Release Notes
        • 2024-05-16 | Release Notes
        • 2024-05-02 | Release Notes
        • 2024-04-18 | Release Notes
        • 2024-04-05 | Release Notes
        • 2024-03-18 | Release Notes
        • 2024-03-05 | Release Notes
        • 2024-02-20 | Release Notes
        • 2024-02-05 | Release Notes
    • 📊Studio Change log
  • Flipside Community
    • Get Started
    • Ambassador Program
    • Join Our Discord
    • Join Our Guild
Powered by GitBook
On this page
  • Highlights
  • All EVM Chains
  • Avalanche
  • Ethereum
  • External (Studio Only)
  • Lava
  • Useful Resources

Was this helpful?

  1. Support
  2. Release Notes
  3. 2024

2024-08-22 | Release Notes

This update includes EVM chain swaps USD value improvements, new Avalanche Dexalot trace data, Ethereum NFT lending support for Arcade XYZ, and new Lava staking models.

Previous2024-09-05 | Release NotesNext2024-08-08 | Release Notes

Last updated 8 months ago

Was this helpful?

Highlights

This release brings updates across multiple blockchains. EVM chain swaps tables now include USD values for native assets, even when one side of the swap is NULL, effective August 26, 2024. Avalanche gets a new table for Dexalot's internal contract trace data, and Ethereum's NFT lending tables now support Arcade XYZ. Additionally, Lava introduces two new models to enhance staking and staking rewards tracking, and we’ve added a Farcaster table for Warpcast power users.

Reminder: Flow ez_swaps and ez_bridge_transactions is deprecating on 9/1. Please update your queries to reference the .

Check out these updates and the rest of the release notes below.

All EVM Chains

Updated Tables - EVM Chain Swaps Tables

Updates amount_in_usd and amount_out_usd to have USD values for the native chain's asset, even if the other side of the swap is NULL. Previously, both amount_in_usd and amount_out_usd were set to NULL if any side of the swap had a NULL USD value. This is put in place to avoid overstating volumes on low-liquidity swaps. Going live August 26, 2024.

  • CHAIN.defi.ez_dex_swaps

Avalanche

New Table - Avalanche Subnet - Dexalot

This table contains flattened trace data for internal contract calls on the Dexalot Blockchain. Hex encoded fields can be decoded to integers by using the utils.udf_hex_to_int() function.

  • avalanche.dexalot.fact_traces

Ethereum

Updated Tables - Bridging Activity

The team updated three NFT lending tables to include Arcade XYZ DeFi protocol curation.

  • ethereum.nft.ez_lending_loans

  • ethereum.nft.ez_lending_repayments

  • ethereum.nft.ez_lending_liquidations

External (Studio Only)

New Table - Farcaster Warpcast Power Users

Represents data associated with power users, based on Warpcast power badges.

  • external.farcaster.fact_warpcast_power_users

Lava

New Tables - Staking

Two new curated models for both staking and staking rewards. Lava staking is non-standard due to the functionality of staking to providers.

  • lava.gov.fact_staking

  • lava.gov.fact_staking_rewards

Useful Resources

Request a smart contract ABI to be decoded:

Request a Solana IDL to be decoded:

Add labels:

🗒️
new swaps and bridging tables Flow
https://science.flipsidecrypto.xyz/abi-requestor/
https://science.flipsidecrypto.xyz/idl-requestor
https://science.flipsidecrypto.xyz/add-a-label