ErsvanNumber of transactions per day for swap programs
Updated 2022-07-07
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
›
⌄
SELECT DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY, SWAP_PROGRAM, COUNT(*) AS TRANSACTIONS FROM(
SELECT BLOCK_TIMESTAMP, TX_GROUP_ID, SWAPPER, SWAP_PROGRAM, split_part(L.ADDRESS_NAME,': ',2) AS DEX_NAME, SWAP_FROM_ASSET_ID, SWAP_FROM_AMOUNT
FROM flipside_prod_db.algorand.swaps AS S
JOIN flipside_prod_db.algorand.labels AS L ON S.POOL_ADDRESS = L.ADDRESS
WHERE
L.LABEL_TYPE = 'dex'
AND BLOCK_TIMESTAMP BETWEEN '2022-05-01' AND '2022-06-30'
AND SWAP_PROGRAM IN(
SELECT SWAP_PROGRAM FROM(
SELECT SWAP_PROGRAM, COUNT(*) AS TRANSACTIONS FROM (
SELECT BLOCK_TIMESTAMP, TX_GROUP_ID, SWAPPER, SWAP_PROGRAM, split_part(L.ADDRESS_NAME,': ',2) AS DEX_NAME, SWAP_FROM_ASSET_ID, SWAP_FROM_AMOUNT
FROM flipside_prod_db.algorand.swaps AS S
JOIN flipside_prod_db.algorand.labels AS L ON S.POOL_ADDRESS = L.ADDRESS
WHERE
L.LABEL_TYPE = 'dex'
AND BLOCK_TIMESTAMP BETWEEN '2022-05-01' AND '2022-06-30'
)
GROUP BY SWAP_PROGRAM
ORDER BY 2 DESC
LIMIT 5
)
)
)
GROUP BY DAY,SWAP_PROGRAM
Run a query to Download Data