i_danCQ - Query 1: Daily token holders for x token copy
Updated 2024-11-12
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
›
⌄
-- forked from sam / CQ - Query 1: Daily token holders for x token @ https://flipsidecrypto.xyz/sam/q/Z2d7K2q-v1pu/cq---query-1-daily-token-holders-for-x-token
with min_date as (
select
min(block_timestamp)::date as min_timestamp
from base.core.ez_token_transfers
where contract_address = '0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE'
),
dates as ( -- my favourite table ; gets a list of dates
select
date_trunc('day', block_timestamp) AS date_day
from base.core.ez_token_transfers
where date_day between (select min_timestamp from min_date) and current_date()
),
lido_total_holders as ( -- all possible addresses that have held lido
select
distinct to_address
from base.core.ez_token_transfers
where contract_address = '0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE' -- lido token
),
dates_x_lido_total_holders as (-- cross join between dates and holders so that for every date, there is an entry for each user
select
date_day as full_dates,
to_address as full_user_addresses
from dates
cross join lido_total_holders
),
end_of_day_balance as (
select
date_trunc('day', block_timestamp) as day,
user_address,
balance
QueryRunArchived: QueryRun has been archived