mohamadreza221166Daily BendDAO transactios by event type
    Updated 2022-09-08
    WITH event_logs AS(
    SELECT BLOCK_TIMESTAMP, EVENT_NAME, event_inputs:value AS eth_value_raw, round(eth_value_raw / pow(10, 18), 10) as eth_value
    FROM ethereum.core.fact_event_logs
    WHERE ORIGIN_TO_ADDRESS = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88'
    AND TX_STATUS = 'SUCCESS'
    )

    SELECT date_trunc('day', BLOCK_TIMESTAMP) AS date, EVENT_NAME, COUNT(*) AS tx_num
    FROM event_logs
    GROUP BY 1, 2
    ORDER BY 1

    Run a query to Download Data