Optimism Premium Onchain Data

Optimism is an Ethereum Layer 2 scaling solution that uses optimistic rollups to provide faster and cheaper transactions while maintaining Ethereum security. It is a key player in the OP Stack ecosystem powering multiple L2 chains.

<p><br/></p>

Flipside Crypto provides access to the most comprehensive blockchain data in crypto — covering dozens of chains, DEX exchanges, and thousands of protocols. Our data sets empower analysts, data scientists, developers, and AI agents without the hassle of managing nodes, decoding transactions, or building complex pipelines.

<p><br/></p>

Premium listings deliver curated, labeled, and priced data — structured for both human analysts and AI agents. Core listings are also available for raw and decoded data without labels, prices, or curation.

<p><br/></p>

HOW TO GET ACCESS

1. Click Request on this listing page
2. Our team will reach out with pricing and terms
3. Once agreed, data access is provisioned directly to your Snowflake account
4. Start querying immediately using the schema and table references below

<p><br/></p>

Sample Tables:

- balances.ez_balances_erc20_daily
- balances.ez_balances_native_daily
- core.dim_contracts
- core.dim_contract_abis
- core.dim_labels
- core.ez_decoded_event_logs
- core.ez_native_transfers
- core.ez_token_transfers
- core.fact_blocks
- core.fact_event_logs
- core.fact_traces
- core.fact_transactions
- defi.dim_dex_liquidity_pools
- defi.dim_stablecoins
- defi.ez_bridge_activity
- defi.ez_dex_liquidity_pool_actions
- defi.ez_dex_swaps
- defi.ez_lending_borrows
- defi.ez_lending_deposits
- defi.ez_lending_flashloans
- defi.ez_lending_liquidations
- defi.ez_lending_ohlc_rates
- defi.ez_lending_repayments
- defi.ez_lending_withdraws
- defi.ez_protocol_tvl
- defi.ez_stablecoins_supply
- gov.fact_delegations
- nft.ez_nft_sales
- nft.ez_nft_transfers
- price.dim_asset_metadata
- price.ez_asset_metadata
- price.ez_prices_hourly
- price.fact_prices_ohlc_hourly
- stats.ez_core_metrics_hourly

<p><br/></p>

Fields Include:

block_number, block_date, address, contract_address, decimals, symbol, balance_hex, balance_raw, balance_precise, balance, balance_usd, name, created_block_number, created_block_timestamp, created_tx_hash, creator_address, abi, abi_source, bytecode, blockchain, creator, address_name, label_type, label_subtype, label, block_timestamp, tx_hash, tx_position, event_index, topics, topic_0, topic_1, topic_2, topic_3, data, event_removed, origin_from_address, origin_to_address, origin_function_signature, tx_succeeded, event_name, full_decoded_log, decoded_log, contract_name, trace_index, trace_address, type, from_address, to_address, amount, amount_precise_raw, amount_precise, amount_usd, token_standard, token_is_verified, raw_amount_precise, raw_amount, block_hash, network, tx_count, size, miner, mix_hash, extra_data, parent_hash, gas_used, gas_limit, base_fee_per_gas, blob_gas_used, excess_blob_gas, difficulty, total_difficulty, sha3_uncles, uncle_blocks, nonce, receipts_root, state_root, transactions_root, logs_bloom, parent_beacon_block_root, withdrawals, withdrawals_root, input, output, sub_traces, value, value_precise_raw, value_precise, value_hex, gas, trace_succeeded, error_reason, revert_reason, tx_fee, tx_fee_precise, tx_type, input_data, gas_price, effective_gas_price, cumulative_gas_used, max_fee_per_gas, max_priority_fee_per_gas, l1_fee, l1_fee_precise_raw, l1_fee_precise, l1_fee_scalar, l1_gas_used, l1_gas_price, l1_base_fee_scalar, l1_blob_base_fee, l1_blob_base_fee_scalar, mint, mint_precise_raw, mint_precise, y_parity, access_list, r, s, v, source_hash, creation_block, creation_time, creation_tx, platform, protocol, protocol_version, factory_address, pool_address, pool_name, tokens, symbols, is_verified, is_verified_modified_timestamp, bridge_address, sender, receiver, destination_chain_receiver, destination_chain, token_address, token_symbol, amount_unadj, liquidity_provider, amount_in_unadj, amount_in, amount_in_usd, amount_out_unadj, amount_out, amount_out_usd, tx_to, token_in, token_in_is_verified, token_out, token_out_is_verified, symbol_in, symbol_out, protocol_market, borrower, depositor, initiator, target, flashloan_token, flashloan_token_symbol, flashloan_amount_unadj, flashloan_amount, flashloan_amount_usd, premium_amount_unadj, premium_amount, premium_amount_usd, liquidator, collateral_token, collateral_token_symbol, liquidated_amount_unadj, liquidated_amount, liquidated_amount_usd, debt_token, debt_token_symbol, repaid_amount_unadj, repaid_amount, repaid_amount_usd, day, version, supply_rate_open, supply_rate_high, supply_rate_low, supply_rate_close, stable_borrow_rate_open, stable_borrow_rate_high, stable_borrow_rate_low, stable_borrow_rate_close, variable_borrow_rate_open, variable_borrow_rate_high, variable_borrow_rate_low, variable_borrow_rate_close, rate_updates_count, payer, tvl_usd, total_supply, total_holders, amount_minted, amount_burned, amount_transferred, amount_blacklisted, amount_in_cex, amount_in_bridges, amount_in_dex_liquidity_pools, amount_in_lending_pools, amount_in_contracts, market_cap, fully_diluted_valuation, status, delegator, delegate, delegation_type, new_balance, previous_balance, raw_new_balance, raw_previous_balance, to_delegate, from_delegate, event_type, platform_address, platform_name, platform_exchange_version, aggregator_name, seller_address, buyer_address, quantity, currency_symbol, currency_address, price, price_usd, total_fees, platform_fee, creator_fee, total_fees_usd, platform_fee_usd, creator_fee_usd, tx_fee_usd, intra_event_index, token_transfer_type, is_mint, provider, is_native, is_deprecated, hour, is_imputed, open, high, low, close, block_timestamp_hour, block_number_min, block_number_max, block_count, transaction_count, transaction_count_success, transaction_count_failed, unique_from_count, unique_to_count, total_fees_native