CryptoLioncomp tx
Updated 2021-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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