rezaramshiniUntitled Query
    Updated 2022-08-01
    with a as (select distinct BLOCK_TIMESTAMP as brg_time,ORIGIN_FROM_ADDRESS,ORIGIN_TO_ADDRESS from ethereum.core.fact_event_logs
    WHERE ORIGIN_TO_ADDRESS in (Lower('0x401F6c983eA34274ec46f84D70b31C151321188b'),LOWER('0xA0c68C638235ee32657e8f720a23ceC1bFc77C77'))
    and block_timestamp::date>= CURRENT_DATE-60
    ORDER BY 1)
    select brg_time::date as block_day, count(*) "number of brigde" from A
    group by 1
    Run a query to Download Data