plume.event_logs

Description of the plume.event_logs table on Dune

The plume.event_logs table contains detailed information about contract events.

Table Schema

Column Name	Data Type	Description
log_index	decimal(38,0)	Log index in transaction
transaction_hash	string	Transaction hash
transaction_index	decimal(38,0)	Transaction index in block
block_hash	string	Block hash
block_number	decimal(38,0)	Block number
address	string	Contract address
data	string	Log data
topics	array	Log topics
block_timestamp	timestamp	Block timestamp
event_name	string	Event name
event_signature	string	Event signature
event_params	json	Event parameters
contract_name	string	Contract name
contract_address	string	Contract address
contract_type	string	Contract type

Sample Query

-- Get the most active contracts by event count
SELECT 
    contract_name,
    COUNT(*) as event_count
FROM plume.event_logs
WHERE block_timestamp >= NOW() - INTERVAL '24' HOUR
GROUP BY contract_name
ORDER BY event_count DESC
LIMIT 10;