DATE | Total users | New users | Existing users | |
|---|---|---|---|---|
1 | 2023-12-23 00:00:00.000 | 331 | 236 | 95 |
2 | 2023-12-15 00:00:00.000 | 198 | 156 | 42 |
3 | 2023-12-02 00:00:00.000 | 225 | 209 | 16 |
4 | 2023-12-05 00:00:00.000 | 122 | 114 | 8 |
5 | 2023-12-24 00:00:00.000 | 227 | 169 | 58 |
6 | 2024-01-06 00:00:00.000 | 690 | 392 | 298 |
7 | 2023-12-16 00:00:00.000 | 180 | 124 | 56 |
8 | 2024-01-10 00:00:00.000 | 460 | 196 | 264 |
9 | 2023-12-12 00:00:00.000 | 307 | 264 | 43 |
10 | 2024-01-25 00:00:00.000 | 302 | 107 | 195 |
11 | 2024-01-26 00:00:00.000 | 11 | 6 | 5 |
12 | 2024-01-20 00:00:00.000 | 751 | 430 | 321 |
13 | 2023-12-08 00:00:00.000 | 219 | 204 | 15 |
14 | 2023-11-30 00:00:00.000 | 73 | 73 | 0 |
15 | 2024-01-01 00:00:00.000 | 605 | 332 | 273 |
16 | 2023-12-01 00:00:00.000 | 373 | 367 | 6 |
17 | 2024-01-09 00:00:00.000 | 607 | 316 | 291 |
18 | 2024-01-02 00:00:00.000 | 557 | 268 | 289 |
19 | 2023-12-31 00:00:00.000 | 762 | 438 | 324 |
20 | 2023-12-09 00:00:00.000 | 565 | 512 | 53 |
Hessishdefist - dau
Updated 2024-01-26
999
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
›
⌄
-- forked from defist - daily actions @ https://flipsidecrypto.xyz/edit/queries/4f749f57-40b9-4aa5-9811-6283bdb74d93
with prices as (SELECT HOUR::date as datex,
case when symbol = 'USDT' then '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8'
when symbol = 'USDC' then '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8'
when symbol = 'DAI' then '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3'
when symbol = 'WBTC' then '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac'
when symbol = 'wstETH' then '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2'
when symbol = 'WETH' then '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7'
when symbol = 'rETH' then '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610'
when symbol = 'LORDS' then '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49'
when symbol = 'LUSD' then '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac'
when symbol = 'UNI' then '0x049210ffc442172463f3177147c1aeaa36c51d152c1b0630f2364c300d4f48ee'
end as addy,
case when symbol = 'USDT' then '0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8'
when symbol = 'USDC' then '0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8'
when symbol = 'DAI' then '0xda114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3'
when symbol = 'WBTC' then '0x3fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac'
when symbol = 'wstETH' then '0x42b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2'
when symbol = 'WETH' then '0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7'
when symbol = 'rETH' then '0x319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610'
when symbol = 'LORDS' then '0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49'
when symbol = 'LUSD' then '0x70a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac'
when symbol = 'UNI' then '0x49210ffc442172463f3177147c1aeaa36c51d152c1b0630f2364c300d4f48ee'
end as addy_b,
case when symbol = 'WETH' then 'ETH' else SYMBOL end as token,
DECIMALS , avg(PRICE) as pr
from crosschain.price.ez_hourly_token_prices
where HOUR::date >= '2023-11-30'
and TOKEN_ADDRESS in
('0x6b175474e89094c44da98b954eedeac495271d0f',
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
'0x686f2404e77ab0d9070a46cdfb0b7fecdd2318b0',
'0x5f98805a4e8be255a32880fdec7f6728c6568ba0',
'0xae78736cd615f374d3085123a210448e74fc6393',
'0x1f9840a85d5af5bf1d1762f925bdaddc4201f984',
Last run: over 1 year ago
58
2KB
106s