PREVIEW / futures_1hour / 2018-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-12.parquet
  size:    49 KB
  rows:    1,543

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-12 00:00:00	ES	Futures	3146.99	3147.8	3146.71	3147.53	2376.0
2018-09-12 01:00:00	ES	Futures	3147.8	3150.26	3147.53	3149.98	5400.0
2018-09-12 02:00:00	ES	Futures	3149.71	3151.35	3148.89	3148.89	6007.0
2018-09-12 03:00:00	ES	Futures	3148.62	3155.16	3148.08	3154.07	18385.0
2018-09-12 04:00:00	ES	Futures	3154.07	3155.43	3153.25	3154.34	14556.0
2018-09-12 05:00:00	ES	Futures	3154.34	3154.61	3150.53	3150.8	10446.0
2018-09-12 06:00:00	ES	Futures	3150.8	3152.44	3149.98	3151.89	7333.0
2018-09-12 07:00:00	ES	Futures	3152.16	3152.71	3146.71	3147.8	22843.0
2018-09-12 08:00:00	ES	Futures	3147.8	3149.44	3145.9	3146.44	25206.0
2018-09-12 09:00:00	ES	Futures	3146.44	3151.07	3144.53	3145.62	184599.0
2018-09-12 10:00:00	ES	Futures	3145.9	3149.98	3138.27	3141.26	242715.0
2018-09-12 11:00:00	ES	Futures	3141.26	3155.43	3140.17	3142.63	338997.0
2018-09-12 12:00:00	ES	Futures	3142.63	3148.89	3142.08	3146.99	135969.0
2018-09-12 13:00:00	ES	Futures	3146.71	3150.26	3143.44	3144.81	83823.0
2018-09-12 14:00:00	ES	Futures	3145.08	3146.17	3141.81	3144.53	103693.0
2018-09-12 15:00:00	ES	Futures	3144.81	3152.44	3144.53	3148.35	141986.0
2018-09-12 16:00:00	ES	Futures	3148.35	3148.89	3146.44	3146.44	41346.0
2018-09-12 18:00:00	ES	Futures	3146.44	3146.99	3145.08	3146.99	3967.0
2018-09-12 19:00:00	ES	Futures	3146.71	3147.53	3146.44	3146.99	1670.0
2018-09-12 20:00:00	ES	Futures	3146.71	3149.71	3146.17	3149.71	7760.0
2018-09-12 21:00:00	ES	Futures	3149.44	3149.71	3147.26	3147.8	7007.0
2018-09-12 22:00:00	ES	Futures	3147.8	3147.8	3145.35	3146.99	5751.0
2018-09-12 23:00:00	ES	Futures	3146.99	3147.26	3145.9	3146.71	2521.0
2018-09-12 00:00:00	NQ	Futures	8843.44	8846.68	8839.9	8844.32	2144.0
2018-09-12 01:00:00	NQ	Futures	8844.62	8856.1	8840.79	8853.74	2995.0
2018-09-12 02:00:00	NQ	Futures	8853.74	8859.34	8851.09	8851.39	2847.0
2018-09-12 03:00:00	NQ	Futures	8851.09	8876.41	8849.62	8874.35	7924.0
2018-09-12 04:00:00	NQ	Futures	8874.06	8880.83	8872.29	8877.59	5768.0
2018-09-12 05:00:00	NQ	Futures	8877.59	8878.47	8861.99	8862.58	4388.0
2018-09-12 06:00:00	NQ	Futures	8862.58	8868.17	8861.4	8867.29	2888.0
2018-09-12 07:00:00	NQ	Futures	8867.58	8869.05	8844.03	8850.21	8219.0
2018-09-12 08:00:00	NQ	Futures	8849.92	8850.8	8831.96	8835.49	8314.0
2018-09-12 09:00:00	NQ	Futures	8835.19	8839.9	8792.21	8792.5	91719.0
2018-09-12 10:00:00	NQ	Futures	8792.5	8813.11	8744.22	8757.17	113520.0
2018-09-12 11:00:00	NQ	Futures	8757.17	8829.6	8753.35	8770.42	117323.0
2018-09-12 12:00:00	NQ	Futures	8770.72	8815.17	8769.24	8801.34	53504.0
2018-09-12 13:00:00	NQ	Futures	8801.34	8825.48	8794.27	8801.93	44054.0
2018-09-12 14:00:00	NQ	Futures	8801.93	8806.34	8783.67	8795.15	40866.0
2018-09-12 15:00:00	NQ	Futures	8795.15	8826.95	8794.56	8821.65	41328.0
2018-09-12 16:00:00	NQ	Futures	8821.36	8823.42	8810.17	8811.35	9030.0
2018-09-12 18:00:00	NQ	Futures	8812.82	8812.82	8804.87	8810.46	1302.0
2018-09-12 19:00:00	NQ	Futures	8810.46	8814.59	8809.29	8812.23	773.0
2018-09-12 20:00:00	NQ	Futures	8811.94	8827.25	8810.17	8824.89	3175.0
2018-09-12 21:00:00	NQ	Futures	8824.89	8824.89	8816.35	8817.53	2852.0
2018-09-12 22:00:00	NQ	Futures	8817.53	8818.71	8802.51	8811.94	3863.0
2018-09-12 23:00:00	NQ	Futures	8811.64	8813.7	8806.93	8809.29	1644.0
2018-09-12 00:00:00	YM	Futures	28256.9	28262.4	28253.7	28262.4	15.0
2018-09-12 01:00:00	YM	Futures	28271.1	28286.3	28260.2	28285.2	42.0
2018-09-12 02:00:00	YM	Futures	28284.1	28297.1	28272.1	28273.2	69.0
2018-09-12 03:00:00	YM	Futures	28276.5	28339.5	28267.8	28328.6	104.0

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

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