adambala00
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select date(BLOCK_TIMESTAMP) as date,count(distinct TX_ID)as tx ,count(distinct ORIGIN_ADDRESS)as users ,'deposit'as title
FROM flipside_prod_db.ethereum.udm_events
where (to_address) in('0xa6a688F107851131F0E1dce493EbBebFAf99203e' --usdc
,'0x15ec4512516d980090050fe101de21832c8edfee' --usdt
,'0x305933e09871D4043b5036e09af794FACB3f6170' --dai
,'0x710bDa329b2a6224E4B44833DE30F38E7f81d564'--eth
,'0x2A6303e6b99d451Df3566068EBb110708335658f' --wbtc
) group by 1,4
union
select date(BLOCK_TIMESTAMP) as date,count(distinct TX_ID)as tx ,count(distinct ORIGIN_ADDRESS)as users ,'withraw'as title
FROM flipside_prod_db.ethereum.udm_events
where (from_address) in('0xa6a688F107851131F0E1dce493EbBebFAf99203e' --usdc
,'0x15ec4512516d980090050fe101de21832c8edfee' --usdt
,'0x305933e09871D4043b5036e09af794FACB3f6170' --dai
,'0x710bDa329b2a6224E4B44833DE30F38E7f81d564'--eth
,'0x2A6303e6b99d451Df3566068EBb110708335658f' --wbtc
) group by 1,4
Run a query to Download Data