chispasDaily Active Users (Liquity) ez tables
Updated 2024-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from 0xCHAINPARSER / Daily Active Users @ https://flipsidecrypto.xyz/0xCHAINPARSER/q/T5Fx830UCRDK/daily-active-users
with daily as (
select
block_timestamp::date as date,
symbol,
count(distinct from_address) as active_users
from ethereum.core.ez_token_transfers
where contract_address = '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' -- lusd
or contract_address = '0x6dea81c8171d0ba574754ef6f8b412f2ed88c54d' -- lusd
group by date , symbol
)
select
date,
symbol,
active_users
from daily
where date >= current_date - 90
QueryRunArchived: QueryRun has been archived