Example queries

-- 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

-- 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