rezarwzِDaily New Buyers
Updated 2024-08-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with all_r as (
SELECT
ORIGIN_FROM_ADDRESS as ua,
BLOCK_TIMESTAMP::date as date,
rank() over(partition by ORIGIN_FROM_ADDRESS ORDER by BLOCK_TIMESTAMP asc ) as rank
from
ethereum.defi.ez_dex_swaps
where
TOKEN_OUT = lower ('{{contract_address}}'))
SELECT
date,
count(DISTINCT ua ) as "New Buyers Count"
from all_r
where rank=1 and date >= current_date - {{last_x_days}}
GROUP by 1
ORDER by 1 desc
QueryRunArchived: QueryRun has been archived