borrowing nft DAILY tx user copy

yasmin-n-d-r-hborrowing nft DAILY tx user copy

Updated 2024-11-12

-- 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 CONTRACT_ADDRESS = '0x4274f80635183e9be3c16e1313a16f929b61e00e'

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

-- AND TX_STATUS = 'SUCCESS'

-- GROUP BY

-- DATE_TRUNC('day', BLOCK_TIMESTAMP)

-- ORDER BY

-- date;

-- 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'),

QueryRunArchived: QueryRun has been archived

flipside