andreafiandroAverage Buy Price
Updated 2023-12-12
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT ORIGIN_FROM_ADDRESS as BUYER_ADDRESS, AVG(PRICE) AS AVG_BUY_PRICE, SUM(AMOUNT_IN) as TOT_BUY_USD
FROM
(SELECT ORIGIN_FROM_ADDRESS, (AMOUNT_IN / AMOUNT_OUT) AS price, AMOUNT_IN
FROM ethereum.defi.ez_dex_swaps
WHERE CONTRACT_ADDRESS = lower({{pool_address}}) AND TOKEN_IN = lower({{quote_address}}))
-- AND ORIGIN_FROM_ADDRESS = lower({{wallet_address}})
GROUP BY ORIGIN_FROM_ADDRESS
ORDER BY TOT_BUY_USD DESC
Run a query to Download Data