BlazeEthereum swaps count
Updated 2024-12-19
99
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 t1 AS (
SELECT
date_trunc('week', BLOCK_TIMESTAMP) AS week,
TOKEN_IN AS token,
CASE
WHEN LOWER(TOKEN_IN) = LOWER('0xdac17f958d2ee523a2206206994597c13d831ec7') THEN 'USDT'
WHEN LOWER(TOKEN_IN) = LOWER('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48') THEN 'USDC'
WHEN LOWER(TOKEN_IN) = LOWER('0x6b175474e89094c44da98b954eedeac495271d0f') THEN 'DAI'
WHEN LOWER(TOKEN_IN) = LOWER('0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409') THEN 'FDUSD'
WHEN LOWER(TOKEN_IN) = LOWER('0x0000000000085d4780B73119b644AE5ecd22b376') THEN 'TUSD'
END AS symbol,
tx_hash
FROM
ethereum.defi.ez_dex_swaps
WHERE
LOWER(TOKEN_IN) IN (
LOWER('0xdac17f958d2ee523a2206206994597c13d831ec7'), -- USDT
LOWER('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'), -- USDC
LOWER('0x6b175474e89094c44da98b954eedeac495271d0f'), -- DAI
LOWER('0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409'), -- FDUSD
LOWER('0x0000000000085d4780B73119b644AE5ecd22b376') -- TUSD
)
),
t2 AS (
SELECT
date_trunc('week', BLOCK_TIMESTAMP) AS week,
TOKEN_out AS token,
CASE
WHEN LOWER(TOKEN_OUT) = LOWER('0xdac17f958d2ee523a2206206994597c13d831ec7') THEN 'USDT'
WHEN LOWER(TOKEN_OUT) = LOWER('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48') THEN 'USDC'
WHEN LOWER(TOKEN_OUT) = LOWER('0x6b175474e89094c44da98b954eedeac495271d0f') THEN 'DAI'
WHEN LOWER(TOKEN_OUT) = LOWER('0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409') THEN 'FDUSD'
WHEN LOWER(TOKEN_OUT) = LOWER('0x0000000000085d4780B73119b644AE5ecd22b376') THEN 'TUSD'
END AS symbol,
tx_hash
FROM
QueryRunArchived: QueryRun has been archived