Papasotarbinu_swaps copy
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
pool_details AS (
SELECT
lower('0xa271826737f32c317b62e306b2e11a876324ce8a') AS pool_address,
lower('0xdd8e557c8804d326c72074e987de02a23ae6ef84') AS token0_address,
(
SELECT
symbol
FROM
arbitrum.core.dim_contracts
WHERE
address = lower('0xdd8e557c8804d326c72074e987de02a23ae6ef84')
) AS token0_symbol,
(
SELECT
decimals
FROM
arbitrum.core.dim_contracts
WHERE
address = lower('0xdd8e557c8804d326c72074e987de02a23ae6ef84')
) AS token0_decimals,
'0x82af49447d8a07e3bd95bd0d56f35241523fbab1' AS token1_address,
(
SELECT
symbol
FROM
arbitrum.core.dim_contracts
WHERE
address = lower('0x82af49447d8a07e3bd95bd0d56f35241523fbab1')
) AS token1_symbol,
(
SELECT
decimals
FROM
arbitrum.core.dim_contracts
WHERE
Run a query to Download Data