Flipside Docs
Search…
Ethereum UDM Events Table
Ethereum events exist within the ethereum schema, as ethereum.udm_events
Within the event table, native ETH transfers, internal transactions, and contract calls are all modeled as "events".
Notable Features that make querying simple:
  • "Origin" metadata is carried down to every event. This is particularly useful if you want to query an event in the context of a specific origin contract call, i.e. all "burn" events that occur in the context of a token "transfer".
  • All function names, log methods, and log events have been decoded into their human-readable format.
  • All amounts have been decimal adjusted.
  • All amounts, where applicable, contain their USD Equivalent.

Table Schema

ethereum.udm_events
Field
Type
Description
amount
number
Native amount of transfer (decimal adjusted)
amount_usd
number
In the case of a transfer event, the equivalent amount in USD. Note this is computed by taking the average hourly price around the time of the tx event.
block_number
number
The block height this event was recorded at.
block_timestamp
timestamp
UTC block timestamp for parent block
contract_address
address
The parent contract that is responsible for kicking off this event.
event_id
string
The index/order of the event in the transaction
event_name
string
English decoded name for the event name. This could be a transfer, or any decoded log method or log event name
event_type
string
The english name for the type of event. This could be a native eth event, erc20 transfer, or contract methods calls/events.
from_address
address
The sender of the event
from_address_name
string
from_label
string
from_label_subtype
string
from_label_type
string
origin_address
address
The initiator of the transaction
origin_address_name
string
origin_function_name
string
Input function signature decoded to English name for the parent tx that kicked off this event, if applicable
origin_function_signature
string
The function signature of contract call, if applicable
origin_label
string
origin_label_subtype
string
Copy link
Contents
Table Schema