721 rows yesterday at 1:12 PM
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SELECT
date_trunc('day', timestamp) as chart_x,
1 / (
pow (1.0001, avg(input_6_value_int32)) / pow (10, 18 - 6)
) as chart_y
FROM
evm_events_ethereum_mainnet
WHERE
address = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'
and signature = 'Swap(address,address,int256,int256,uint160,uint128,int24)'
and chart_x >= '2023-01-01'
GROUP BY
chart_x
ORDER BY
chart_x ASC