KeyrockEth Swap Volume
Updated 2024-06-05
999
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH CTE_1 as (
SELECT
TRUNCATE(block_timestamp, 'day') AS day,
SUM(amount_in_usd) AS stable_stable_amount
FROM
ethereum.defi.ez_dex_swaps
WHERE
(
TOKEN_IN IN (
'0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3', -- MIM
'0x03ab458634910aad20ef5f1c8ee96f1d6ac54919', -- RAI
'0x956f47f50a910163d8bf957cf5846d573e7f87ca', -- FEUI
'0x5f98805a4e8be255a32880fdec7f6728c6568ba0', -- LUSD
'0x0000000000085d4780b73119b644ae5ecd22b376', -- TUSD
'0x4fabb145d64652a948d72533023f6e7a623c7c53', -- BUSD
'0x4c9edd5852cd905f086c759e8383e09bff1e68b3', -- USDe
'0x6b175474e89094c44da98b954eedeac495271d0f', -- DAI
'0x853d955acef822db058eb8505911ed77f175b99e', -- FRAX
'0xdac17f958d2ee523a2206206994597c13d831ec7', -- USDT
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- USDC
'0x83f20f44975d03b1b09e64809b757c47f942beea' -- sDAI
,'0x6c3ea9036406852006290770bedfcaba0e23a0e8'--PYUSD
)
AND TOKEN_OUT IN (
'0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3', -- MIM
'0x03ab458634910aad20ef5f1c8ee96f1d6ac54919', -- RAI
'0x956f47f50a910163d8bf957cf5846d573e7f87ca', -- FEUI
'0x5f98805a4e8be255a32880fdec7f6728c6568ba0', -- LUSD
'0x0000000000085d4780b73119b644ae5ecd22b376', -- TUSD
'0x4fabb145d64652a948d72533023f6e7a623c7c53', -- BUSD
'0x4c9edd5852cd905f086c759e8383e09bff1e68b3', -- USDe
'0x6b175474e89094c44da98b954eedeac495271d0f', -- DAI
'0x853d955acef822db058eb8505911ed77f175b99e', -- FRAX
'0xdac17f958d2ee523a2206206994597c13d831ec7', -- USDT
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- USDC
'0x83f20f44975d03b1b09e64809b757c47f942beea' -- sDAI
QueryRunArchived: QueryRun has been archived