Skip to main content
Schema: hyperevm.core Table: ez_decoded_event_logs Type: Table

​
What

This table provides human-readable decoded event data for smart contracts where ABIs are available. It transforms raw hex-encoded logs into structured JSON with named parameters and values, making blockchain data immediately queryable without manual decoding.

​
Key Use Cases

  • Analyzing token transfers and approvals without manual decoding
  • Tracking DEX swaps and liquidity events with named parameters
  • Monitoring NFT transfers and marketplace activity
  • Querying DeFi protocol interactions (lending, staking, governance)
  • Building analytics on any smart contract with available ABIs

​
Important Relationships

  • Join with fact_event_logs: Use tx_hash and event_index for raw event data
  • Join with dim_contracts: Use contract_address for contract metadata
  • Join with fact_transactions: Use tx_hash for transaction context
  • Cross-reference ez_token_transfers: For simplified token movement data

​
Commonly-used Fields

  • contract_address: The smart contract that emitted the event
  • event_name: The event name from the contract ABI (e.g., Transfer, Swap)
  • decoded_log: JSON object with decoded parameter names and values
  • contract_name: Human-readable name of the contract
  • block_timestamp: When the event occurred
  • tx_hash: Transaction hash containing this event

​
Sample queries

ERC-20 Transfer Events with Proper Types 
SELECT
    block_timestamp,
    tx_hash,
    contract_address,
    contract_name,
    event_name,
    decoded_log:from::string AS from_address,
    decoded_log:to::string AS to_address,
    decoded_log:value::numeric AS amount,
    -- Convert to decimal (assuming 18 decimals)
    decoded_log:value::numeric / POW(10, 18) AS amount_decimal
FROM hyperevm.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48') -- USDC
    AND event_name = 'Transfer'
    AND block_timestamp >= CURRENT_DATE - 7
    AND decoded_log:value::numeric > 1000000000 -- Over 1000 USDC
ORDER BY block_timestamp DESC;
Uniswap V3 Swap Events 
SELECT
    block_timestamp,
    tx_hash,
    contract_address AS pool_address,
    event_name,
    decoded_log:sender::string AS sender,
    decoded_log:recipient::string AS recipient,
    decoded_log:amount0::numeric AS amount0,
    decoded_log:amount1::numeric AS amount1,
    decoded_log:sqrtPriceX96::numeric AS sqrt_price,
    decoded_log:liquidity::numeric AS liquidity,
    decoded_log:tick::integer AS tick
FROM hyperevm.core.ez_decoded_event_logs
WHERE event_name = 'Swap'
    AND contract_address IN (
        SELECT address FROM dim_contracts
        WHERE contract_name ILIKE '%Uniswap V3%'
    )
    AND block_timestamp >= CURRENT_DATE - 1
LIMIT 100;
NFT Transfer Events (ERC-721) 
SELECT
    block_timestamp,
    tx_hash,
    contract_address,
    contract_name AS collection_name,
    decoded_log:from::string AS from_address,
    decoded_log:to::string AS to_address,
    decoded_log:tokenId::string AS token_id
FROM hyperevm.core.ez_decoded_event_logs
WHERE event_name = 'Transfer'
    AND decoded_log:tokenId IS NOT NULL  -- Indicates ERC-721
    AND block_timestamp >= CURRENT_DATE - 1
ORDER BY block_timestamp DESC;
DeFi Protocol Events - Compound Finance 
SELECT
    DATE_TRUNC('day', block_timestamp) AS day,
    event_name,
    COUNT(*) AS event_count,
    COUNT(DISTINCT decoded_log:minter::string) AS unique_users
FROM hyperevm.core.ez_decoded_event_logs
WHERE contract_name ILIKE '%compound%'
    AND event_name IN ('Mint', 'Redeem', 'Borrow', 'RepayBorrow')
    AND block_timestamp >= CURRENT_DATE - 30
GROUP BY 1, 2
ORDER BY 1 DESC, 3 DESC;
Complex Event Analysis - DEX Aggregator Routes 
SELECT
    block_timestamp,
    tx_hash,
    event_name,
    decoded_log,
    ARRAY_SIZE(decoded_log:path) AS swap_hops,
    decoded_log:amountIn::numeric AS amount_in,
    decoded_log:amountOutMin::numeric AS min_amount_out
FROM hyperevm.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0x1111111254fb6c44bAC0beD2854e76F90643097d') -- 1inch
    AND event_name ILIKE '%swap%'
    AND block_timestamp >= CURRENT_DATE - 1;

​
Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERSequential counter representing the position of a block in the blockchain since genesis (block 0).
BLOCK_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the block was produced by validators/miners.
TX_HASHTEXTUnique 66-character identifier for the transaction.
TX_POSITIONNUMBERZero-indexed position of transaction within its block.
EVENT_INDEXNUMBERZero-based sequential position of the event within a transaction’s execution.
CONTRACT_ADDRESSTEXTSmart contract address that emitted this event or received the transaction.
TOPICSVARIANTArray containing all indexed parameters of the event.
TOPIC_0TEXTEvent signature hash - keccak256 of the event declaration.
TOPIC_1TEXTFirst indexed parameter of the event (if exists).
TOPIC_2TEXTSecond indexed parameter of the event (if exists).
TOPIC_3TEXTThird indexed parameter of the event (if exists).
DATATEXTHex-encoded non-indexed event parameters.
EVENT_REMOVEDBOOLEANBoolean flag indicating if the event was removed due to chain reorganization.
ORIGIN_FROM_ADDRESSTEXTThe externally-owned account (EOA) or contract address that initiated the transaction.
ORIGIN_TO_ADDRESSTEXTThe destination address for the transaction - either an EOA or contract address.
ORIGIN_FUNCTION_SIGNATURETEXTFunction signature (first 4 bytes) of the called method.
TX_SUCCEEDEDBOOLEANBoolean indicator of transaction success.
EVENT_NAMETEXTThe event name as defined in the contract’s ABI.
FULL_DECODED_LOGVARIANTComplete decoded event data including parameter names, values, types, and metadata.
DECODED_LOGOBJECTFlattened JSON object containing decoded event parameters with their values.
CONTRACT_NAMETEXTHuman-readable name of the smart contract emitting the event, joined from dim_contracts.
EZ_DECODED_EVENT_LOGS_IDTEXTPrimary key - unique identifier for each row ensuring data integrity.
INSERTED_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the record was first added to the Flipside database.
MODIFIED_TIMESTAMPTIMESTAMP_NTZUTC timestamp of the most recent update to this record.