PREVIEW / futures_1hour / 2019-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-08.parquet
  size:    53 KB
  rows:    1,757

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
2019-04-08 00:00:00	ES	Futures	3135.3	3135.57	3133.94	3135.3	3455.0
2019-04-08 01:00:00	ES	Futures	3135.3	3135.57	3132.86	3134.76	5216.0
2019-04-08 02:00:00	ES	Futures	3134.48	3136.92	3133.94	3136.11	5745.0
2019-04-08 03:00:00	ES	Futures	3136.11	3137.47	3134.21	3135.3	15980.0
2019-04-08 04:00:00	ES	Futures	3135.3	3136.65	3134.48	3135.03	8332.0
2019-04-08 05:00:00	ES	Futures	3135.03	3136.65	3134.76	3135.3	6839.0
2019-04-08 06:00:00	ES	Futures	3135.3	3138.55	3135.3	3137.47	11935.0
2019-04-08 07:00:00	ES	Futures	3137.2	3138.55	3136.65	3137.74	9944.0
2019-04-08 08:00:00	ES	Futures	3137.74	3138.28	3134.21	3134.76	16720.0
2019-04-08 09:00:00	ES	Futures	3135.03	3136.38	3127.71	3130.96	179869.0
2019-04-08 10:00:00	ES	Futures	3130.69	3137.47	3128.79	3134.76	152561.0
2019-04-08 11:00:00	ES	Futures	3134.76	3138.01	3132.04	3134.76	130797.0
2019-04-08 12:00:00	ES	Futures	3134.76	3135.57	3131.5	3135.03	71173.0
2019-04-08 13:00:00	ES	Futures	3135.3	3139.36	3134.48	3138.82	49795.0
2019-04-08 14:00:00	ES	Futures	3138.82	3141.26	3137.47	3139.64	69733.0
2019-04-08 15:00:00	ES	Futures	3139.64	3144.52	3138.55	3143.43	134825.0
2019-04-08 16:00:00	ES	Futures	3143.43	3144.24	3142.35	3143.7	39756.0
2019-04-08 18:00:00	ES	Futures	3143.16	3143.97	3141.8	3142.08	4353.0
2019-04-08 19:00:00	ES	Futures	3142.35	3143.16	3141.8	3142.35	2206.0
2019-04-08 20:00:00	ES	Futures	3142.35	3144.79	3141.26	3141.26	8676.0
2019-04-08 21:00:00	ES	Futures	3141.26	3141.53	3137.2	3137.74	9626.0
2019-04-08 22:00:00	ES	Futures	3137.47	3140.72	3137.2	3140.45	4987.0
2019-04-08 23:00:00	ES	Futures	3140.45	3140.99	3139.09	3140.45	3837.0
2019-04-08 00:00:00	NQ	Futures	8840.95	8842.7	8838.04	8842.41	1858.0
2019-04-08 01:00:00	NQ	Futures	8842.12	8842.7	8834.26	8838.33	2520.0
2019-04-08 02:00:00	NQ	Futures	8838.33	8847.36	8836.29	8843.57	3328.0
2019-04-08 03:00:00	NQ	Futures	8843.57	8847.94	8837.46	8839.5	5876.0
2019-04-08 04:00:00	NQ	Futures	8839.5	8844.45	8837.46	8838.92	3929.0
2019-04-08 05:00:00	NQ	Futures	8839.21	8843.57	8837.46	8839.5	3855.0
2019-04-08 06:00:00	NQ	Futures	8839.5	8849.98	8839.21	8849.11	4686.0
2019-04-08 07:00:00	NQ	Futures	8848.81	8852.6	8845.32	8848.52	4413.0
2019-04-08 08:00:00	NQ	Futures	8848.52	8849.69	8832.51	8834.84	5731.0
2019-04-08 09:00:00	NQ	Futures	8835.13	8844.74	8806.01	8823.48	60054.0
2019-04-08 10:00:00	NQ	Futures	8823.19	8848.23	8813.88	8839.5	54425.0
2019-04-08 11:00:00	NQ	Futures	8839.5	8857.84	8836.88	8844.45	46584.0
2019-04-08 12:00:00	NQ	Futures	8844.74	8852.89	8836.29	8851.73	26441.0
2019-04-08 13:00:00	NQ	Futures	8852.31	8866.28	8850.27	8864.83	22306.0
2019-04-08 14:00:00	NQ	Futures	8864.83	8872.11	8860.46	8870.07	21348.0
2019-04-08 15:00:00	NQ	Futures	8869.78	8885.21	8868.9	8879.09	35409.0
2019-04-08 16:00:00	NQ	Futures	8879.09	8884.04	8877.64	8882.3	6970.0
2019-04-08 18:00:00	NQ	Futures	8881.13	8885.5	8878.22	8878.8	1614.0
2019-04-08 19:00:00	NQ	Futures	8879.39	8883.75	8878.51	8879.68	1155.0
2019-04-08 20:00:00	NQ	Futures	8879.68	8890.45	8877.06	8878.8	3344.0
2019-04-08 21:00:00	NQ	Futures	8878.8	8879.09	8864.54	8864.83	4628.0
2019-04-08 22:00:00	NQ	Futures	8864.83	8876.47	8862.79	8876.18	2492.0
2019-04-08 23:00:00	NQ	Futures	8876.18	8877.35	8870.65	8875.89	2042.0
2019-04-08 00:00:00	YM	Futures	28635.0	28635.0	28605.6	28628.5	1882.0
2019-04-08 01:00:00	YM	Futures	28627.4	28635.0	28608.9	28632.8	2475.0
2019-04-08 02:00:00	YM	Futures	28631.8	28648.1	28622.0	28639.4	1788.0
2019-04-08 03:00:00	YM	Futures	28640.5	28657.9	28626.3	28644.8	2645.0

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

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