Example queries
Explore the capabilities of our dataset with the help of the example queries found below.
1. Calculate the number of distinct ETH depositors on Lido on a daily granularity.
-- This query retrieves the number of distinct depositors for each date
-- based on the stETH_Submitted_event table in the lido_v1_ethereum dataset.
SELECT
DATE(block_timestamp) as date, -- Extracts the date from the block_timestamp column
COUNT(DISTINCT in_sender) as depositors -- Counts the distinct depositors for each date
FROM
`tt-contracts.lido_v1_ethereum.stETH_Submitted_event` -- Specifies the dataset and table
GROUP BY
date -- Groups the results by date
ORDER BY
date DESC; -- Orders the results by date in descending order
2. Calculate the daily active sender addresses on Manta Pacific.
-- This query retrieves the number of distinct transaction senders for each date
-- on Manta Pacific.
SELECT
DATE(block_timestamp) AS date, -- Extracts the date from the block_timestamp column
COUNT(DISTINCT from_address) AS depositors -- Counts the distinct transaction senders for each date
FROM
`tt-blockchain.manta.transactions` -- Specifies the dataset and table
GROUP BY
date -- Groups the results by date
ORDER BY
date DESC; -- Orders the results by date in descending order
Updated 12 months ago