CryptoLioncomp tx
    Updated 2021-04-26
    SELECT
    date_trunc('day',block_timestamp) as day,
    MAX(block_id) - MIN(block_id) as blocks,
    symbol
    FROM ethereum.udm_events
    WHERE
    (
    contract_address = LOWER('0xccf4429db6322d5c611ee964527d42e5d685dd6a') --cwBTC
    OR contract_address = LOWER('0x35A18000230DA775CAc24873d00Ff85BccdeD550') --cUNI
    OR contract_address = LOWER('0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9') --cUSDT
    OR contract_address = LOWER('0x39aa39c021dfbae8fac545936693ac917d5e7563') --cUSDC
    OR contract_address = LOWER('0x5d3a536E4D6DbD6114cc1Ead35777bAB948E3643') --cDAI
    OR contract_address = LOWER('0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5') --cETH
    OR contract_address = LOWER('0xb3319f5d18bc0d84dd1b4825dcde5d5f7266d407') --cZRX
    OR contract_address = LOWER('0x70e36f6BF80a52b3B46b3aF8e106CC0ed743E8e4') --cCOMP
    OR contract_address = LOWER('0x6c8c6b02e7b2be14d4fa6022dfd6d75921d90e4e') --cBAT
    )
    AND block_timestamp >= getdate() - interval '31 days'
    GROUP BY date_trunc('day',block_timestamp), symbol
    ORDER BY 1
    Run a query to Download Data