flipside

    Volume
    arabianhorses-jZtVNaVolume
    Updated 2024-02-20
    WITH
    tokenList AS (
    SELECT tokenSymbol, l1Address, starknetAddressWith0s,starknetAddress, decimals
    FROM (
    VALUES('ETH', '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7','0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7', 18)
    , ('BTC', '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac', '0x3fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac', 8)
    , ('DAI', '0x6b175474e89094c44da98b954eedeac495271d0f', '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3', '0xda114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3', 18)
    , ('USDT', '0xdac17f958d2ee523a2206206994597c13d831ec7', '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8', '0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8', 6)
    , ('USDC', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8', '0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8', 6)
    , ('wstETH', '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0', '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2', '0x42b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2', 18)
    , ('LORDS', '0x686f2404e77Ab0d9070a46cdfb0B7feCDD2318b0', '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49', '0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49', 18)
    , ('rETH', '0xae78736cd615f374d3085123a210448e74fc6393', '0x0319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610', '0x319111a5037cbec2b3e638cc34a3474e2d2608299f3e62866e9cc683208c610', 18 )
    , ('LUSD', '0x5f98805a4e8be255a32880fdec7f6728c6568ba0', '0x070a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac', '0x70a76fd48ca0ef910631754d77dd822147fe98a569b826ec85e3c33fde586ac', 18)
    ) AS t(tokenSymbol, l1Address, starknetAddressWith0s, starknetAddress, decimals)
    )

    , prices AS (
    SELECT
    DATE_TRUNC('HOUR', HOUR) AS HOUR
    , TOKEN_ADDRESS
    , AVG(price) AS price
    FROM crosschain.price.fact_hourly_token_prices
    WHERE BLOCKCHAIN = 'ethereum'
    AND HOUR > '2022-11-07'
    AND TOKEN_ADDRESS IN (
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --WETH18DECIMALS
    , '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' --USDC6DECIMALS
    , '0x6b175474e89094c44da98b954eedeac495271d0f' --DAI18DECIMALS
    , '0xdac17f958d2ee523a2206206994597c13d831ec7' --USDT6DECIMALS
    , '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' --WBTC8DECIMALS
    , '0x686f2404e77ab0d9070a46cdfb0b7fecdd2318b0' --LORDS18DECIMALS
    , '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' --wstETH18DECIMALS
    )
    GROUP BY 1,2
    )

    Last run: about 1 year ago
    Time Frame
    Pair
    Volume
    Average Volume
    Median Volume
    Cumulative Volume
    1
    		2022-11-23 00:00:00.000ETH/USDC0.11759821840.058799109190.058799109190.1175982184
    2
    		2022-11-23 00:00:00.000DAI/ETH0.11618462030.11618462030.11618462030.1161846203
    3
    		2022-11-30 00:00:00.000ETH/USDC2218.9591429498.0689423385.6359275082219.076741168
    4
    		2022-11-30 00:00:00.000DAI/ETH618.6149783024.9489198263.722701439618.731162922
    5
    		2022-11-30 00:00:00.000USDC/USDT47.7184699360.75743603070.226660109347.718469936
    6
    		2022-11-30 00:00:00.000DAI/USDC20.2022359650.80808943860.241724480620.202235965
    7
    		2022-11-30 00:00:00.000ETH/USDT2.2429780410.04232034040.012714158012.242978041
    8
    		2022-11-30 00:00:00.000BTC/USDC1.556485310.77824265490.77824265491.55648531
    9
    		2022-11-30 00:00:00.000DAI/USDT0.91994246950.091994246950.081731347850.9199424695
    10
    		2022-12-01 00:00:00.000ETH/USDC9261.49227224915.5655332317.29907089511480.569013416
    11
    		2022-12-01 00:00:00.000DAI/ETH1215.7235217144.8052313111.4261759811834.454684637
    12
    		2022-12-01 00:00:00.000USDC/USDT723.6143649284.2565550881.228447403771.332834863
    13
    		2022-12-01 00:00:00.000ETH/USDT135.3457132731.6918214160.8788679964137.588691314
    14
    		2022-12-01 00:00:00.000DAI/USDC125.6556981091.1743523191.000004437145.857934074
    15
    		2022-12-01 00:00:00.000DAI/USDT7.0679258510.17238843540.11355443677.987868321
    16
    		2022-12-01 00:00:00.000BTC/USDC1.0000169951.0000169951.0000169952.556502305
    17
    		2022-12-01 00:00:00.000DAI/BTC0.13710121230.068550606150.068550606150.1371012123
    18
    		2022-12-01 00:00:00.000BTC/ETH0.0080030133150.0026676711050.0025623793990.008003013315
    19
    		2022-12-02 00:00:00.000ETH/USDC7045.45702731616.4998993618.11753214218526.026040733
    20
    		2022-12-02 00:00:00.000DAI/ETH1844.5060747127.348629785.0001282483678.960759349
    ...
    6649
    610KB
    76s