ghostcrabUnique buyers over time
Updated 2024-10-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH
shib_swaps AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(DISTINCT(origin_from_address)) AS unique_senders,
--COUNT(origin_from_address) AS total
FROM
ethereum.defi.ez_dex_swaps
WHERE
token_out = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'
GROUP BY
day, origin_from_address
)
SELECT
day,
unique_senders
FROM
shib_swaps
GROUP BY
day, unique_senders
ORDER BY
day DESC
QueryRunArchived: QueryRun has been archived