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.