AndyCoolSwaps on SushiSwap
Updated 2022-05-15
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH aaa 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 '2020-05-30' AND '2021-06-30'
qualify rank <=2
)
SELECT block_timestamp, tx_from_address FROM aaa
WHERE TX_TO_LABEL = 'sushiswap'
AND EVENT_NAME = 'Swap'
ORDER by block_timestamp ASC
Run a query to Download Data