AndyCoolSushi Polygon Users
Updated 2022-05-15
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with source AS(
SELECT block_timestamp, tx_from_address ,TX_TO_LABEL ,TX_TO_ADDRESS , EVENT_NAME,
row_number() over (partition by tx_from_address order by block_timestamp asc) as rank
FROM flipside_prod_db.polygon.events_emitted
WHERE block_timestamp::DATE BETWEEN '2021-02-26' AND '2022-05-15'
AND TX_TO_LABEL = 'sushiswap'
AND EVENT_NAME = 'Swap'
qualify rank <=2
)
select count(distinct tx_from_address)
FROM source
Run a query to Download Data