wallet_fees_cq.sql

CREATE CONTINUOUS QUERY "wallet_fee" ON "trade_logs"
RESAMPLE EVERY 1h FOR 1d
BEGIN
    SELECT SUM("amount") as "sum_amount"
    INTO "hourly_wallet_fees"
    FROM "wallet_fees"
    GROUP BY "reserve_addr", "wallet_addr", time(1h)
END

CREATE CONTINUOUS QUERY "wallet_fee_1d" ON "trade_logs"
RESAMPLE EVERY 1d FOR 3d
BEGIN
    SELECT SUM("amount") as "sum_amount"
    INTO "daily_wallet_fees"
    FROM "wallet_fees"
    GROUP BY "reserve_addr", "wallet_addr", time(1d)
END