CREATE MATERIALIZED VIEW limit_per_minuts
            ENGINE = AggregatingMergeTree()
                PARTITION BY toYYYYMM(timestamp)
                TTL timestamp + INTERVAL 1 MONTH
                PRIMARY KEY (skin_id, timestamp)
                ORDER BY (skin_id, timestamp)
AS
SELECT skin_id
     , timestamp
     , quantileExactWeightedState(0.8)(price, offers) AS max
     , quantileExactWeightedState(0.2)(price, offers) AS min
FROM states
GROUP BY skin_id, timestamp;

CREATE MATERIALIZED VIEW limit_per_hours
            ENGINE = AggregatingMergeTree()
                PARTITION BY toYYYYMM(timestamp)
                TTL timestamp + INTERVAL 1 MONTH
                PRIMARY KEY (skin_id, timestamp)
                ORDER BY (skin_id, timestamp)
AS
SELECT skin_id,
       timestamp,
       quantileExactWeightedMergeState(0.8)(max) AS max,
       quantileExactWeightedMergeState(0.2)(min) AS min
FROM (
      SELECT skin_id,
             toDateTime(formatDateTime(timestamp, '%Y-%m-%d %H:00:00')) AS timestamp,
             min,
             max
      FROM default.limit_per_minuts
         )
GROUP BY skin_id,
         timestamp;