[WIP] Cowswap trades SS

ShapeShift[WIP] Cowswap trades SS

Updated 2024-01-29

SELECT date_trunc('day', BLOCK_TIMESTAMP) AS date,

count(TX_HASH),

sum(AMOUNT_IN_USD) AS total_in_usd_value -- or AMOUNT_OUT_USD depending on your requirement

FROM ethereum.defi.ez_dex_swaps

WHERE lower(ORIGIN_TO_ADDRESS) = lower('0x9008d19f58aabd9ed0d60971565aa8510560ab41') -- or TX_TO, based on your context

AND lower(PLATFORM) = 'shapeshift'

AND BLOCK_TIMESTAMP BETWEEN '{{start_date}}' AND '{{end_date}}'

GROUP BY date

ORDER BY date;

Last run: over 1 year ago

No Data to Display

flipside