PREVIEW / futures_1hour / 2018-09-11

all futures 1-hour files

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

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-11 00:00:00	ES	Futures	3143.99	3144.26	3143.44	3143.99	1761.0
2018-09-11 01:00:00	ES	Futures	3143.72	3144.26	3142.35	3143.72	5371.0
2018-09-11 02:00:00	ES	Futures	3143.44	3143.99	3142.35	3143.72	5279.0
2018-09-11 03:00:00	ES	Futures	3143.44	3143.99	3139.08	3140.17	11576.0
2018-09-11 04:00:00	ES	Futures	3140.17	3141.26	3132.82	3135.81	23936.0
2018-09-11 05:00:00	ES	Futures	3135.54	3135.81	3129.28	3132.82	29181.0
2018-09-11 06:00:00	ES	Futures	3132.82	3134.45	3131.46	3133.63	14120.0
2018-09-11 07:00:00	ES	Futures	3133.63	3133.63	3128.73	3131.46	20518.0
2018-09-11 08:00:00	ES	Futures	3131.18	3132.27	3127.91	3129.28	34858.0
2018-09-11 09:00:00	ES	Futures	3129.0	3135.27	3124.92	3134.45	190565.0
2018-09-11 10:00:00	ES	Futures	3134.45	3140.45	3133.36	3136.63	193124.0
2018-09-11 11:00:00	ES	Futures	3136.9	3151.35	3136.63	3151.35	176980.0
2018-09-11 12:00:00	ES	Futures	3151.35	3152.98	3148.89	3152.44	98631.0
2018-09-11 13:00:00	ES	Futures	3152.44	3152.98	3147.53	3148.62	80184.0
2018-09-11 14:00:00	ES	Futures	3148.89	3152.44	3146.99	3150.53	66434.0
2018-09-11 15:00:00	ES	Futures	3150.26	3151.89	3146.71	3148.62	136268.0
2018-09-11 16:00:00	ES	Futures	3148.62	3150.8	3148.08	3149.71	48758.0
2018-09-11 18:00:00	ES	Futures	3149.71	3152.16	3149.71	3151.35	5813.0
2018-09-11 19:00:00	ES	Futures	3151.07	3151.89	3150.26	3150.53	1833.0
2018-09-11 20:00:00	ES	Futures	3150.8	3151.35	3147.53	3148.62	7878.0
2018-09-11 21:00:00	ES	Futures	3148.89	3149.71	3145.62	3146.44	8535.0
2018-09-11 22:00:00	ES	Futures	3146.44	3147.53	3145.62	3147.53	6159.0
2018-09-11 23:00:00	ES	Futures	3147.53	3147.8	3146.44	3146.71	3089.0
2018-09-11 00:00:00	NQ	Futures	8813.7	8816.94	8811.94	8813.11	1141.0
2018-09-11 01:00:00	NQ	Futures	8812.82	8814.0	8806.64	8808.99	1796.0
2018-09-11 02:00:00	NQ	Futures	8808.99	8810.17	8802.51	8809.29	2470.0
2018-09-11 03:00:00	NQ	Futures	8809.29	8810.17	8792.21	8798.69	5170.0
2018-09-11 04:00:00	NQ	Futures	8799.28	8800.16	8767.77	8778.08	7638.0
2018-09-11 05:00:00	NQ	Futures	8777.78	8778.37	8751.58	8764.53	11440.0
2018-09-11 06:00:00	NQ	Futures	8765.12	8771.6	8762.77	8771.31	4698.0
2018-09-11 07:00:00	NQ	Futures	8771.01	8771.01	8754.82	8762.77	6949.0
2018-09-11 08:00:00	NQ	Futures	8762.47	8763.36	8740.39	8745.1	12629.0
2018-09-11 09:00:00	NQ	Futures	8745.1	8792.8	8720.08	8784.85	93892.0
2018-09-11 10:00:00	NQ	Futures	8785.14	8806.93	8774.54	8783.38	79200.0
2018-09-11 11:00:00	NQ	Futures	8783.08	8852.27	8781.9	8851.98	67031.0
2018-09-11 12:00:00	NQ	Futures	8851.68	8861.69	8834.61	8847.56	41676.0
2018-09-11 13:00:00	NQ	Futures	8847.85	8850.5	8817.53	8831.96	41062.0
2018-09-11 14:00:00	NQ	Futures	8831.96	8853.15	8824.89	8843.73	27939.0
2018-09-11 15:00:00	NQ	Futures	8843.44	8850.8	8836.96	8846.38	32313.0
2018-09-11 16:00:00	NQ	Futures	8846.38	8853.45	8842.85	8849.62	8815.0
2018-09-11 18:00:00	NQ	Futures	8850.5	8858.75	8849.03	8854.33	1923.0
2018-09-11 19:00:00	NQ	Futures	8854.63	8858.16	8851.09	8853.45	1204.0
2018-09-11 20:00:00	NQ	Futures	8853.45	8854.63	8841.67	8846.09	2623.0
2018-09-11 21:00:00	NQ	Futures	8845.79	8848.44	8836.08	8838.14	3613.0
2018-09-11 22:00:00	NQ	Futures	8838.14	8846.68	8836.08	8845.2	4076.0
2018-09-11 23:00:00	NQ	Futures	8845.5	8847.56	8840.49	8843.44	1733.0
2018-09-11 00:00:00	YM	Futures	28191.7	28198.3	28191.7	28192.8	25.0
2018-09-11 01:00:00	YM	Futures	28193.9	28193.9	28188.5	28189.6	22.0
2018-09-11 02:00:00	YM	Futures	28196.1	28196.1	28183.0	28189.6	14.0
2018-09-11 03:00:00	YM	Futures	28183.0	28183.0	28148.3	28151.5	36.0

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

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