flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Swap Profiles In May & June - 2
Crazy_Kid
Swap Profiles In May & June - 2
Updated 2022-07-07
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
WITH
users
AS
(
SELECT
DISTINCT
swapper
FROM
algorand
.
swaps
WHERE
date
(
block_timestamp
)
BETWEEN
'2022-05-01'
AND
'2022-06-30'
)
SELECT
address
,
balance
as
algo_balance
FROM
algorand
.
account
WHERE
address
IN
(
SELECT
*
FROM
users
)
Results
Run a query to Download Data