ShapeShiftCount of Fox Holders over Time
Updated 2024-10-09
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 ethereum.core.ez_token_transfers
where contract_address = '0xc770eefad204b5180df6a14ee197d99d808ee52d'
),
dates as ( -- my favourite table ; gets a list of dates
select
date_day
from ethereum.core.dim_dates
where date_day between (select min_timestamp from min_date) and current_date()
),
fox_total_holders as ( -- all possible addresses that have held fox
select
distinct to_address
from ethereum.core.ez_token_transfers
where contract_address = '0xc770eefad204b5180df6a14ee197d99d808ee52d' -- fox token
),
dates_x_fox_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 fox_total_holders
),
end_of_day_balance as (
select
date_trunc('day', block_timestamp) as day,
user_address,
balance
QueryRunArchived: QueryRun has been archived