tcsForefront Holdings over Time
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT e.balance_date
, CASE WHEN balance < 100 THEN '1) No Signal Access (FF Balance<100)'
WHEN balance < 1000 THEN '2) Signal Access (100 < FF Balance < 1000)'
ELSE '3) Discord and Signal Access (FF Balance >= 1000)' END AS token_tier
, COUNT(DISTINCT user_address) AS number_users
FROM ethereum.erc20_balances e
WHERE contract_address = '0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'
AND balance_date > '2022-01-01'
GROUP BY 1, 2
Run a query to Download Data