pavlyshyn2023-05-30 09:19 AM
    with
    logs_data as (
    SELECT
    DECODED_LOG:"to" AS "pubkey"
    from
    ethereum.core.fact_decoded_event_logs
    WHERE
    CONTRACT_ADDRESS = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') -- Lido CONTRACT_ADDRESS
    AND EVENT_NAME = 'Transfer'
    )
    SELECT DISTINCT
    "pubkey"
    from
    logs_data
    Run a query to Download Data