rustygee2024-06-04 10:03 PM
Updated 2024-06-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT COUNT(DISTINCT USER_ADDRESS) AS distinct_user_count
FROM ethereum.core.ez_current_balances
WHERE CONTRACT_ADDRESS = lower('0xcf0C122c6b73ff809C693DB761e7BaeBe62b6a2E')
-- and LAST_ACTIVITY_BLOCK_TIMESTAMP
-- and LAST_ACTIVITY_BLOCK > 20021100
and LAST_ACTIVITY_BLOCK_TIMESTAMP > '2024-06-04 00:00:00.000'
-- AND USD_VALUE_NOW > 100
-- AND CURRENT_BAL > 0;
-- AND CURRENT_BAL > 30000;
-- limit 100
-- floki 0xcf0C122c6b73ff809C693DB761e7BaeBe62b6a2E
-- pepe 0x6982508145454ce325ddbe47a25d4ec3d2311933
-- shib 0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce
QueryRunArchived: QueryRun has been archived