binhachonSushi's contribution to Polygon growth
Updated 2022-05-15
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
›
⌄
-- select * from flipside_prod_db.polygon.transactions
-- where to_address = '0x0319000133d3ada02600f0875d2cf03d442c3367'
-- limit 10
with sushi_address as (
select
distinct to_address as sushi_address
from polygon.udm_events
where to_label ilike 'sushiswap'
union
select
'0x0319000133d3ada02600f0875d2cf03d442c3367' as sushi_address
),
sushi_swap_txs as (
select
distinct tx_id
from polygon.udm_events
where to_address in (select sushi_address from sushi_address)
),
sushi_first_transactions as (
select
distinct from_address
from flipside_prod_db.polygon.transactions
where nonce < 2
and to_address in (select sushi_address from sushi_address)
union
select
distinct from_address
from flipside_prod_db.polygon.transactions
where nonce < 2
and tx_id in (select tx_id from sushi_swap_txs)
),
polygon_new_user as (
select
date_trunc('month', block_timestamp) as time,
'Others' as symbol,
count(distinct to_address) as number_of_users
Run a query to Download Data