monad | chainrunner_

Updated 2024-03-26

-- price

-- transfers: big number

-- dex swaps: bar chart

-- dex volume: bar chart

-- liquidity

-- BASE WETH: 0x4200000000000000000000000000000000000006

-- ARB ARB: 0x912CE59144191C1204E64559FE8253a0e49E6548

-- AVA WAVAX: 0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7

-- BSC WBNB: 0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c

-- ETH WETH: 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2

-- GNOS GNOSIS: 0x9C58BAcC331c9aa871AFD802DB6379a98e80CEdb

-- OP OP: 0x4200000000000000000000000000000000000042

-- POLY MATIC: 0x0000000000000000000000000000000000001010

-- SOL WSOL: So11111111111111111111111111111111111111112

-- %% 6-month DAILY SWAP VOLUME & VOLUME MA %%

--SELECT

-- DATE_TRUNC('day', block_timestamp) AS date,

-- SUM(amount_in_usd) AS daily_vol,

-- SUM(swap_volume_USD) OVER (ORDER BY date) AS alltime_swap_volume_USD,

-- AVG(daily_vol) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS "7D MA",

-- AVG(daily_vol) OVER (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW) AS "14D MA",

-- AVG(daily_vol) OVER (ORDER BY date ROWS BETWEEN 30 PRECEDING AND CURRENT ROW) AS "1M MA"

--FROM base.defi.ez_dex_swaps

--WHERE 1=1

-- AND block_timestamp >= ADD_MONTHS(CURRENT_DATE(), -6)

-- AND (token_in = '0xf6e932ca12afa26665dc4dde7e27be02a7c02e50'

-- OR token_out = '0xf6e932ca12afa26665dc4dde7e27be02a7c02e50'

-- )

--GROUP BY 1

--ORDER BY 1 DESC

-- %% 6-month biggest BUY and SELL %%

QueryRunArchived: QueryRun has been archived

flipside