PRICE AVAX | yasmin-n-d-r-h

Updated 2024-11-12

--------------VOLUME BY AVAX----------------------

-- SELECT

-- DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

-- SUM(CASE WHEN DECODED_LOG:amount1In IS NOT NULL THEN DECODED_LOG:amount1In / 1e18

-- ELSE 0 END) AS daily_buy_volume,

-- SUM(CASE WHEN DECODED_LOG:amount1Out IS NOT NULL THEN DECODED_LOG:amount1Out / 1e18

-- ELSE 0 END) AS daily_sell_volume

-- FROM avalanche.core.ez_decoded_event_logs

-- WHERE

-- EVENT_NAME = 'BellumSwap'

-- AND LOWER(CONTRACT_ADDRESS) IN (

-- LOWER('0x4274f80635183e9bE3c16E1313a16f929B61E00e'),

-- LOWER('0x0a063c664e0cd6a6ae5741f15ea74c80d6155f9b'),

-- LOWER('0x9f383e31aa37b6a4f0f57033558c54c37b5de45f'),

-- LOWER('0xe0c0cb05b6dfe6c7d196493963bf083e726fc517'),

-- LOWER('0xde11a16d6e04551168dfd54e936829b024a236c4')

-- )

-- -- AND DECODED_LOG:token = '0x663efdd64ea4dea9132ea969ec5943813ef229dc'

-- AND TX_STATUS = 'SUCCESS'

-- GROUP BY

-- DATE_TRUNC('day', BLOCK_TIMESTAMP)

-- ORDER BY

-- date;

-- SELECT

-- DATE_TRUNC('day', HOUR) AS DATE,

-- AVG(PRICE) AS PRICE

-- FROM

-- avalanche.price.ez_prices_hourly

-- WHERE

-- SYMBOL = 'WAVAX'

-- AND HOUR >= '2024-08-01'

-- GROUP BY

-- 1

QueryRunArchived: QueryRun has been archived

flipside