PREVIEW / futures_1hour / 2018-09-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-21.parquet
  size:    46 KB
  rows:    1,396

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2018-09-21 00:00:00	ES	Futures	3200.33	3200.6	3198.43	3200.06	3003.0
2018-09-21 01:00:00	ES	Futures	3200.33	3201.69	3199.79	3200.6	7255.0
2018-09-21 02:00:00	ES	Futures	3200.6	3203.32	3199.52	3202.51	7558.0
2018-09-21 03:00:00	ES	Futures	3202.78	3204.41	3201.96	3204.14	16207.0
2018-09-21 04:00:00	ES	Futures	3204.14	3204.68	3201.69	3201.96	12870.0
2018-09-21 05:00:00	ES	Futures	3202.23	3202.78	3199.52	3200.6	12412.0
2018-09-21 06:00:00	ES	Futures	3200.6	3201.15	3198.43	3198.43	10885.0
2018-09-21 07:00:00	ES	Futures	3198.7	3198.7	3195.98	3198.43	17202.0
2018-09-21 08:00:00	ES	Futures	3198.16	3202.78	3196.52	3201.42	39012.0
2018-09-21 09:00:00	ES	Futures	3201.69	3206.31	3199.52	3201.96	265847.0
2018-09-21 10:00:00	ES	Futures	3202.23	3203.87	3197.07	3198.43	192069.0
2018-09-21 11:00:00	ES	Futures	3198.7	3202.51	3196.8	3201.96	111151.0
2018-09-21 12:00:00	ES	Futures	3201.69	3203.05	3197.61	3199.24	88917.0
2018-09-21 13:00:00	ES	Futures	3199.24	3199.79	3195.98	3198.7	70371.0
2018-09-21 14:00:00	ES	Futures	3198.7	3198.97	3194.08	3194.62	78797.0
2018-09-21 15:00:00	ES	Futures	3194.62	3196.8	3190.54	3192.72	318306.0
2018-09-21 16:00:00	ES	Futures	3192.72	3196.25	3190.0	3190.27	119806.0
2018-09-21 00:00:00	NQ	Futures	8936.7	8939.04	8932.88	8937.87	1577.0
2018-09-21 01:00:00	NQ	Futures	8938.16	8947.25	8936.99	8943.44	3381.0
2018-09-21 02:00:00	NQ	Futures	8943.44	8955.17	8940.51	8953.71	3183.0
2018-09-21 03:00:00	NQ	Futures	8953.41	8960.75	8951.07	8958.99	5508.0
2018-09-21 04:00:00	NQ	Futures	8959.28	8959.57	8945.2	8946.08	5033.0
2018-09-21 05:00:00	NQ	Futures	8946.37	8946.96	8935.52	8939.92	5316.0
2018-09-21 06:00:00	NQ	Futures	8940.22	8941.1	8928.78	8929.95	4095.0
2018-09-21 07:00:00	NQ	Futures	8930.24	8931.42	8919.39	8929.66	5844.0
2018-09-21 08:00:00	NQ	Futures	8929.36	8945.2	8924.96	8941.98	8922.0
2018-09-21 09:00:00	NQ	Futures	8941.98	8957.81	8926.14	8930.83	71063.0
2018-09-21 10:00:00	NQ	Futures	8930.54	8938.16	8894.16	8901.2	64369.0
2018-09-21 11:00:00	NQ	Futures	8900.91	8923.5	8887.71	8918.22	40828.0
2018-09-21 12:00:00	NQ	Futures	8918.22	8929.07	8903.26	8910.0	26029.0
2018-09-21 13:00:00	NQ	Futures	8909.71	8912.35	8894.75	8903.55	16558.0
2018-09-21 14:00:00	NQ	Futures	8903.84	8903.84	8876.57	8878.62	24205.0
2018-09-21 15:00:00	NQ	Futures	8878.91	8880.97	8858.38	8869.23	53380.0
2018-09-21 16:00:00	NQ	Futures	8868.65	8874.51	8855.15	8855.15	14061.0
2018-09-21 00:00:00	YM	Futures	29081.6	29083.8	29067.5	29080.5	930.0
2018-09-21 01:00:00	YM	Futures	29081.6	29097.9	29058.8	29085.9	3436.0
2018-09-21 02:00:00	YM	Futures	29085.9	29104.4	29078.3	29103.3	2552.0
2018-09-21 03:00:00	YM	Futures	29103.3	29130.5	29095.7	29128.3	5203.0
2018-09-21 04:00:00	YM	Futures	29128.3	29134.8	29103.3	29108.8	3079.0
2018-09-21 05:00:00	YM	Futures	29108.8	29115.3	29078.3	29085.9	3025.0
2018-09-21 06:00:00	YM	Futures	29087.0	29091.4	29072.9	29074.0	1944.0
2018-09-21 07:00:00	YM	Futures	29074.0	29074.0	29041.4	29068.6	3578.0
2018-09-21 08:00:00	YM	Futures	29068.6	29102.2	29049.0	29094.6	4392.0
2018-09-21 09:00:00	YM	Futures	29094.6	29140.3	29054.4	29058.8	26886.0
2018-09-21 10:00:00	YM	Futures	29059.9	29067.5	29022.9	29058.8	20528.0
2018-09-21 11:00:00	YM	Futures	29057.7	29110.9	29039.2	29109.8	13606.0
2018-09-21 12:00:00	YM	Futures	29109.8	29124.0	29067.5	29083.8	10452.0
2018-09-21 13:00:00	YM	Futures	29083.8	29094.6	29071.8	29089.2	6080.0
2018-09-21 14:00:00	YM	Futures	29089.2	29091.4	29054.4	29064.2	6819.0
2018-09-21 15:00:00	YM	Futures	29064.2	29094.6	29051.2	29076.2	16497.0

> showing 50 of 1,396 rows — these rows as CSV

> unlock the full archive -- $79 one-time