test dash

Updated 2024-05-14

-- forked from new name - cache register test copy @ https://flipsidecrypto.xyz/edit/queries/9e2224ae-07ee-4b63-8be3-7ac31af81560

-- forked from new name - cache register test @ https://flipsidecrypto.xyz/edit/queries/0320d69c-1764-48bb-b8bf-2ae36fbad7af

-- forked from 2024-03-07 05:53 PM copy copy copy @ https://flipsidecrypto.xyz/edit/queries/3835c714-61fa-4973-8fbd-750e97abb3f9

-- forked from 2024-03-07 05:53 PM copy copy @ https://flipsidecrypto.xyz/edit/queries/7ec803c7-ac58-4854-b964-7e97c8adc737

-- forked from 2024-03-07 05:53 PM copy @ https://flipsidecrypto.xyz/edit/queries/eeb339f5-7743-4622-85c9-d8ff5beee524

-- forked from 2024-03-07 05:53 PM @ https://flipsidecrypto.xyz/edit/queries/bac6db15-f9c8-443b-8b68-87b5b9bca51d

SELECT

Date_trunc(day , block_timestamp) AS date,

COUNT(DISTINCT tx_id) AS no_of_transactions

FROM solana.defi.fact_swaps

WHERE swap_program = 'jupiter swap v6'

AND succeeded = 'true'

AND swap_to_amount IS NOT NULL

AND Date >= '2023-01-01'

GROUP BY 1

ORDER BY 2 DESC

limit {{num_row}}

QueryRunArchived: QueryRun has been archived