flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Untitled Query
vendetta
Untitled Query
Updated 2022-09-02
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
*
FROM
solana
.
core
.
fact_swaps
WHERE
BLOCK_TIMESTAMP
>=
CURRENT_DATE
-
2
AND
contract_address
=
LOWER
(
'0x397FF1542f962076d0BFE58eA045FfA2d347ACa0'
)
-- this is the USDC-WETH SushiSwap Pool Address
AND
SWAPPER
IN
(
'Swap'
)
Results
Run a query to Download Data