0xHaM-dNew Users on three platforms
Updated 2022-11-25
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
›
⌄
WITH new_user as (
SELECT
min(BLOCK_TIMESTAMP) as min_date,
'Bebop' as platform,
FROM_ADDRESS
FROM ethereum.core.fact_token_transfers
WHERE TO_ADDRESS = '0xaf0b0000f0210d0f421f0009c72406703b50506b'
AND FROM_ADDRESS != '0xaf0b0000f0210d0f421f0009c72406703b50506b'
GROUP by 2,3
UNION ALL
SELECT
min(BLOCK_TIMESTAMP) as min_date,
'Bebop' as platform,
FROM_ADDRESS
FROM polygon.core.fact_token_transfers
WHERE TO_ADDRESS = '0xaf0b0000f0210d0f421f0009c72406703b50506b'
AND FROM_ADDRESS != '0xaf0b0000f0210d0f421f0009c72406703b50506b'
GROUP by 2,3
UNION ALL
SELECT
min(BLOCK_TIMESTAMP) as min_date,
'Uniswap' as platform,
ORIGIN_FROM_ADDRESS
FROM ethereum.core.ez_dex_swaps
WHERE PLATFORM = 'uniswap-v3'
group by 2,3
UNION ALL
SELECT
min(BLOCK_TIMESTAMP) as min_date,
'Sushiswap' as platform,
Run a query to Download Data