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
  • Ethereum
  • Crosschain (Studio Only)
  • Kaia
  • M1
  • Solana

Was this helpful?

  1. Support
  2. Release Notes
  3. 2024

2024-06-27 | Release Notes

New and updated tables for Ethereum, Kaia, M1, and Solana. New Olas Network schemas added to Crosschain database (studio only).

Previous2024-07-11 | Release NotesNext2024-06-14 | Release Notes

Last updated 10 months ago

Was this helpful?

Highlights

A ton of new updates and improvements to Ethereum, Kaia (New Chain), and Solana. Plus new devnet data for M1 chain from and Olas Network schemas added to our Crosschain (studio only) database.

As a reminder on July 15th we’re making an update to the solana.core.fact_transfers table to include both native and wrapped solana addresses in the mint column. You can learn more about this change on our docs .

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

Updated Table

Added a new refinancing contract from NFTfi v2. This new contract allows users to refinance a loan by closing the existing loan and opening another in the same transaction.

  • ethereum.nft.ez_lending_loans

Crosschain (Studio Only)

New Tables

These new tables include schemas for olas.network. Learn more about Olas .

  • crosschain.olas.dim_registry_metadata

  • crosschain.olas.ez_mech_activity

  • crosschain.olas.ez_olas_bonding

  • crosschain.olas.ez_olas_locking

  • crosschain.olas.ez_olas_staking

  • crosschain.olas.ez_service_checkpoints

  • crosschain.olas.ez_service_donations

  • crosschain.olas.ez_service_evictions

  • crosschain.olas.ez_service_registrations

  • crosschain.olas.ez_service_staking

  • crosschain.olas.ez_unit_registrations

  • crosschain.olas.fact_mech_activity

  • crosschain.olas.fact_pol_transfers

  • crosschain.olas.fact_service_events

New Tables

These new tables add decoded event logs.

  • kaia.core.fact_decoded_event_logs

  • kaia.core.ez_decoded_event_logs

M1

New Tables

New core tables for the M1 blockchain devnet. These tables match the format of Aptos and are from the M1 devnet. There is no mainnet at this time.

  • m1.core.fact_blocks

  • m1.core.fact_changes

  • m1.core.fact_events

  • m1.core.fact_transactions

  • m1.core.fact_transactions_block_metadata

  • m1.core.fact_transactions_state_checkpoint

New Tables

These new tables provide the beginning and ending balances for each account involved in a transaction. Fact_sol_balances contains native SOL accounts, and fact_token_balances contains information for all token accounts. This table allows for easier analysis into balance changes that occur in transactions, including verifying the balance changes for an account and tracking changes over time.

  • solana.core.fact_token_balances

  • solana.core.fact_sol_balances

Updated Tables

  • solana.defi.fact_swaps - This table now contains a more complete record of every individual swap performed on the Raydium dex.

  • solana.defi.ez_swaps - Analysts no longer have to perform additional joins to get info such as USD amounts or token symbols.

Reminder Updated Column Data

  • solana.core.fact_transfers

Useful Resources

The address of native SOL will now be reflected in the 'mint' column. Native SOL is the native token of the Solana blockchain and is used for paying tx fees, staking and participating in governance. .

Request a smart contract ABI to be decoded:

Request a Solana IDL to be decoded:

Add labels:

🗒️
Movement Labs
here
Ethereum
here
Kaia
Solana
Learn more about this change here
https://science.flipsidecrypto.xyz/abi-requestor/
https://science.flipsidecrypto.xyz/idl-requestor
https://science.flipsidecrypto.xyz/add-a-label