PREVIEW / futures_1hour / 2018-09-10

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-10.parquet
  size:    47 KB
  rows:    1,501

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-10 00:00:00	ES	Futures	3138.54	3138.81	3135.81	3136.36	3725.0
2018-09-10 01:00:00	ES	Futures	3136.63	3137.18	3135.54	3136.63	4277.0
2018-09-10 02:00:00	ES	Futures	3136.9	3138.54	3136.09	3137.45	5656.0
2018-09-10 03:00:00	ES	Futures	3137.18	3141.54	3134.72	3140.45	22381.0
2018-09-10 04:00:00	ES	Futures	3140.45	3145.08	3140.17	3144.53	18751.0
2018-09-10 05:00:00	ES	Futures	3144.53	3145.08	3142.63	3142.9	12499.0
2018-09-10 06:00:00	ES	Futures	3142.9	3146.17	3142.08	3145.9	12662.0
2018-09-10 07:00:00	ES	Futures	3145.9	3146.17	3143.44	3144.81	19356.0
2018-09-10 08:00:00	ES	Futures	3144.81	3145.35	3142.08	3144.81	28327.0
2018-09-10 09:00:00	ES	Futures	3145.08	3147.8	3141.54	3143.17	230305.0
2018-09-10 10:00:00	ES	Futures	3143.17	3144.81	3136.63	3139.08	237334.0
2018-09-10 11:00:00	ES	Futures	3138.81	3143.72	3136.63	3140.99	155926.0
2018-09-10 12:00:00	ES	Futures	3141.26	3141.26	3135.0	3135.81	93206.0
2018-09-10 13:00:00	ES	Futures	3136.09	3139.36	3135.0	3139.36	49177.0
2018-09-10 14:00:00	ES	Futures	3139.08	3141.26	3138.27	3140.72	60915.0
2018-09-10 15:00:00	ES	Futures	3140.72	3142.08	3136.09	3137.45	150323.0
2018-09-10 16:00:00	ES	Futures	3137.45	3139.9	3136.9	3138.54	45392.0
2018-09-10 18:00:00	ES	Futures	3138.54	3139.9	3137.45	3139.63	4160.0
2018-09-10 19:00:00	ES	Futures	3139.63	3140.17	3138.81	3139.63	2125.0
2018-09-10 20:00:00	ES	Futures	3139.9	3143.17	3139.36	3142.08	9740.0
2018-09-10 21:00:00	ES	Futures	3142.35	3143.44	3141.26	3143.17	9104.0
2018-09-10 22:00:00	ES	Futures	3142.9	3143.44	3140.99	3141.81	6693.0
2018-09-10 23:00:00	ES	Futures	3141.81	3144.26	3141.54	3143.99	4993.0
2018-09-10 00:00:00	NQ	Futures	8780.14	8780.43	8773.07	8776.02	1443.0
2018-09-10 01:00:00	NQ	Futures	8776.02	8781.9	8770.42	8780.14	2238.0
2018-09-10 02:00:00	NQ	Futures	8780.43	8787.2	8778.08	8783.08	2853.0
2018-09-10 03:00:00	NQ	Futures	8783.08	8793.39	8776.02	8791.62	7016.0
2018-09-10 04:00:00	NQ	Futures	8791.62	8808.4	8791.62	8806.64	6302.0
2018-09-10 05:00:00	NQ	Futures	8806.34	8808.11	8801.04	8802.81	3473.0
2018-09-10 06:00:00	NQ	Futures	8802.51	8813.11	8801.04	8812.23	4546.0
2018-09-10 07:00:00	NQ	Futures	8812.23	8812.23	8802.51	8806.93	4406.0
2018-09-10 08:00:00	NQ	Futures	8806.93	8809.87	8798.39	8807.81	7383.0
2018-09-10 09:00:00	NQ	Futures	8807.52	8808.11	8753.05	8765.12	87287.0
2018-09-10 10:00:00	NQ	Futures	8765.12	8773.07	8731.26	8752.46	89282.0
2018-09-10 11:00:00	NQ	Futures	8752.17	8783.97	8740.69	8779.84	54765.0
2018-09-10 12:00:00	NQ	Futures	8779.84	8779.84	8754.52	8762.18	38872.0
2018-09-10 13:00:00	NQ	Futures	8762.47	8777.49	8756.29	8775.43	25822.0
2018-09-10 14:00:00	NQ	Futures	8775.13	8781.61	8768.66	8777.49	18991.0
2018-09-10 15:00:00	NQ	Futures	8777.78	8786.91	8769.24	8779.55	34550.0
2018-09-10 16:00:00	NQ	Futures	8779.55	8787.79	8778.67	8786.03	8322.0
2018-09-10 18:00:00	NQ	Futures	8786.03	8791.62	8781.02	8791.62	1365.0
2018-09-10 19:00:00	NQ	Futures	8791.62	8794.27	8788.97	8791.03	842.0
2018-09-10 20:00:00	NQ	Futures	8790.74	8806.05	8789.56	8801.04	3207.0
2018-09-10 21:00:00	NQ	Futures	8800.75	8805.75	8796.63	8804.87	3440.0
2018-09-10 22:00:00	NQ	Futures	8803.69	8807.52	8799.28	8802.22	3296.0
2018-09-10 23:00:00	NQ	Futures	8802.22	8815.47	8801.34	8813.41	2906.0
2018-09-10 00:00:00	YM	Futures	28262.4	28262.4	28238.5	28241.7	28.0
2018-09-10 01:00:00	YM	Futures	28242.8	28249.3	28236.3	28248.2	16.0
2018-09-10 02:00:00	YM	Futures	28242.8	28260.2	28241.7	28251.5	52.0
2018-09-10 03:00:00	YM	Futures	28246.1	28292.8	28225.4	28280.8	171.0

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

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