andreafiandroPolygon Bridge Users sum
    Updated 2023-09-21
    select
    count(distinct ORIGIN_FROM_ADDRESS) as "Unique Bridgers"
    from
    (
    select
    AMOUNT,
    AMOUNT_USD,
    date_trunc('hour', BLOCK_TIMESTAMP) as HOUR,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    ORIGIN_TO_ADDRESS,
    ORIGIN_FUNCTION_SIGNATURE,
    ETH_FROM_ADDRESS as FROM_ADDRESS,
    ETH_TO_ADDRESS as TO_ADDRESS
    from
    ethereum.core.ez_ETH_transfers
    where
    AMOUNT > 0
    AND HOUR > '{{start_date_polygon}}'
    AND HOUR < '{{end_date_polygon}}'
    AND ORIGIN_TO_ADDRESS = '0x2a3dd3eb832af982ec71669e178424b10dca2ede'
    AND ORIGIN_FUNCTION_SIGNATURE in ('0xcd586579') -- Deposit ETH
    ORDER BY
    BLOCK_TIMESTAMP
    )


    Run a query to Download Data