PREVIEW / futures_1hour / 2018-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-06.parquet
  size:    53 KB
  rows:    1,663

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-06 00:00:00	ES	Futures	3147.26	3148.35	3146.44	3146.99	1655.0
2018-09-06 01:00:00	ES	Futures	3146.99	3147.26	3144.81	3145.62	4693.0
2018-09-06 02:00:00	ES	Futures	3145.9	3145.9	3141.26	3142.35	11215.0
2018-09-06 03:00:00	ES	Futures	3142.35	3146.44	3140.99	3144.26	20058.0
2018-09-06 04:00:00	ES	Futures	3143.99	3151.35	3143.99	3151.35	17421.0
2018-09-06 05:00:00	ES	Futures	3151.07	3152.71	3149.44	3149.71	14915.0
2018-09-06 06:00:00	ES	Futures	3149.98	3151.07	3146.71	3146.71	13070.0
2018-09-06 07:00:00	ES	Futures	3146.71	3150.8	3144.81	3150.26	19552.0
2018-09-06 08:00:00	ES	Futures	3150.26	3152.44	3148.08	3151.07	29863.0
2018-09-06 09:00:00	ES	Futures	3151.07	3152.98	3144.81	3152.71	174178.0
2018-09-06 10:00:00	ES	Futures	3152.71	3152.98	3129.55	3133.63	383162.0
2018-09-06 11:00:00	ES	Futures	3133.63	3137.18	3126.82	3135.27	253938.0
2018-09-06 12:00:00	ES	Futures	3135.0	3135.81	3128.73	3129.0	101540.0
2018-09-06 13:00:00	ES	Futures	3128.73	3135.81	3125.73	3132.55	117142.0
2018-09-06 14:00:00	ES	Futures	3132.82	3138.81	3131.73	3135.81	108215.0
2018-09-06 15:00:00	ES	Futures	3136.09	3143.72	3135.81	3138.81	211143.0
2018-09-06 16:00:00	ES	Futures	3138.81	3140.45	3136.09	3136.9	61429.0
2018-09-06 18:00:00	ES	Futures	3136.36	3137.45	3135.54	3137.45	4215.0
2018-09-06 19:00:00	ES	Futures	3137.45	3137.72	3135.54	3135.81	3058.0
2018-09-06 20:00:00	ES	Futures	3135.81	3136.36	3129.0	3131.73	16783.0
2018-09-06 21:00:00	ES	Futures	3131.46	3137.45	3129.82	3136.36	12952.0
2018-09-06 22:00:00	ES	Futures	3136.36	3137.99	3133.09	3134.72	11392.0
2018-09-06 23:00:00	ES	Futures	3134.72	3135.0	3130.64	3133.63	10420.0
2018-09-06 00:00:00	NQ	Futures	8864.64	8867.58	8861.99	8863.75	756.0
2018-09-06 01:00:00	NQ	Futures	8863.75	8863.75	8857.86	8858.45	2804.0
2018-09-06 02:00:00	NQ	Futures	8858.45	8858.45	8844.03	8850.8	5057.0
2018-09-06 03:00:00	NQ	Futures	8850.8	8864.93	8845.79	8856.98	7243.0
2018-09-06 04:00:00	NQ	Futures	8856.98	8880.53	8856.98	8879.95	6336.0
2018-09-06 05:00:00	NQ	Futures	8880.53	8884.95	8873.76	8875.53	5653.0
2018-09-06 06:00:00	NQ	Futures	8875.53	8880.83	8862.58	8862.87	5232.0
2018-09-06 07:00:00	NQ	Futures	8862.87	8879.06	8853.15	8876.12	6913.0
2018-09-06 08:00:00	NQ	Futures	8876.12	8884.66	8869.64	8879.65	9009.0
2018-09-06 09:00:00	NQ	Futures	8879.65	8882.3	8817.23	8857.57	88939.0
2018-09-06 10:00:00	NQ	Futures	8858.75	8861.99	8746.87	8767.18	147663.0
2018-09-06 11:00:00	NQ	Futures	8767.48	8780.14	8732.74	8776.02	93202.0
2018-09-06 12:00:00	NQ	Futures	8775.72	8781.32	8740.1	8740.1	67520.0
2018-09-06 13:00:00	NQ	Futures	8739.8	8774.25	8723.9	8755.41	61872.0
2018-09-06 14:00:00	NQ	Futures	8755.11	8773.07	8746.28	8766.01	47592.0
2018-09-06 15:00:00	NQ	Futures	8766.01	8797.51	8766.01	8783.38	61422.0
2018-09-06 16:00:00	NQ	Futures	8784.55	8790.74	8777.49	8780.14	11752.0
2018-09-06 18:00:00	NQ	Futures	8779.25	8781.02	8775.13	8781.02	1338.0
2018-09-06 19:00:00	NQ	Futures	8781.02	8781.9	8772.48	8774.84	1444.0
2018-09-06 20:00:00	NQ	Futures	8774.25	8775.43	8747.46	8755.41	6178.0
2018-09-06 21:00:00	NQ	Futures	8755.7	8776.61	8747.75	8774.25	5953.0
2018-09-06 22:00:00	NQ	Futures	8774.84	8777.49	8758.06	8763.06	5606.0
2018-09-06 23:00:00	NQ	Futures	8763.06	8764.24	8748.93	8758.94	3803.0
2018-09-06 00:00:00	YM	Futures	28247.1	28256.9	28241.7	28245.0	602.0
2018-09-06 01:00:00	YM	Futures	28245.0	28245.0	28213.4	28222.1	2291.0
2018-09-06 02:00:00	YM	Futures	28221.0	28221.0	28176.5	28186.3	3643.0
2018-09-06 03:00:00	YM	Futures	28186.3	28221.0	28173.2	28206.9	4404.0

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

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