pratyaksh2013DAI - 1. Volume
Updated 2022-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH DAI AS
(SELECT
date_trunc('day', block_timestamp) as DATE,
event_name,
COUNT(tx_hash)
FROM
ETHEREUM_CORE.FACT_EVENT_LOGS
WHERE
contract_address = LOWER( '0x6B175474E89094C44Da98b954EedeAC495271d0F' )
AND block_timestamp BETWEEN '2021-05-01' AND '2022-05-13'
group by 1,2
order by DATE DESC),
USDT AS
(SELECT
date_trunc('day', block_timestamp) as DATE,
event_name,
COUNT(tx_hash)
FROM
ETHEREUM_CORE.FACT_EVENT_LOGS
WHERE
contract_address = LOWER( '0xdAC17F958D2ee523a2206206994597C13D831ec7' )
AND block_timestamp::date BETWEEN '2021-05-01' AND '2022-05-13'
group by 1,2
order by DATE DESC),
USDC AS
(SELECT
date_trunc('day', block_timestamp) as DATE,
event_name,
COUNT(tx_hash)
FROM
ETHEREUM_CORE.FACT_EVENT_LOGS
Run a query to Download Data