MetaLightEclipse Mainnet Bridge Data
    Updated 2024-12-13
    SELECT
    DATE(BLOCK_TIMESTAMP) AS date,
    COUNT(DISTINCT FROM_ADDRESS) AS users,
    SUM(CAST(VALUE_PRECISE_RAW AS FLOAT)) / POWER(10, 18) AS daily_deposits,
    COUNT(TX_HASH) AS transaction_count
    FROM ethereum.core.fact_transactions
    WHERE to_address = lower('0x83cB71D80078bf670b3EfeC6AD9E5E6407cD0fd1')
    GROUP BY DATE(BLOCK_TIMESTAMP)
    ORDER BY DATE(BLOCK_TIMESTAMP) DESC;

    QueryRunArchived: QueryRun has been archived