MIN(AMOUNT_OUT/AMOUNT_IN) | MAX(AMOUNT_OUT/AMOUNT_IN) | |
|---|---|---|
1 | 4.240781576e-25 | 3406976153846150000 |
toming2024-02-15 09:27 AM
Updated 2024-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- SELECT *
-- FROM
-- ethereum.core.ez_token_transfers
-- WHERE
-- contract_address = '0xd7db52daa32b738ed55b23a487afd4daa0ad7e72'
-- ORDER BY
-- block_number
-- AND
-- to_address = '0xe33893d543e1c0c0c6af4f82bdd4f0682174f590'
SELECT
min(amount_out/amount_in),
max(amount_out/amount_in)
FROM
ethereum.defi.ez_dex_swaps
WHERE
token_out = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
AND
block_timestamp ::date >= current_date() - 30
AND
amount_out <> 0
AND
amount_in <> 0
Last run: over 1 year ago
1
39B
4s