PREVIEW / futures_1hour / 2019-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-27.parquet
  size:    58 KB
  rows:    1,809

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-08-27 00:00:00	ES	Futures	3121.5	3122.31	3119.61	3122.04	4837.0
2019-08-27 01:00:00	ES	Futures	3122.31	3122.31	3115.0	3116.09	11955.0
2019-08-27 02:00:00	ES	Futures	3115.82	3120.69	3110.94	3115.27	21658.0
2019-08-27 03:00:00	ES	Futures	3115.0	3115.27	3106.88	3112.3	34951.0
2019-08-27 04:00:00	ES	Futures	3112.3	3117.44	3107.69	3112.3	33732.0
2019-08-27 05:00:00	ES	Futures	3112.3	3125.83	3112.03	3119.06	40095.0
2019-08-27 06:00:00	ES	Futures	3119.06	3125.29	3118.52	3121.5	24693.0
2019-08-27 07:00:00	ES	Futures	3121.5	3128.81	3121.5	3125.83	28575.0
2019-08-27 08:00:00	ES	Futures	3125.83	3136.12	3124.75	3133.95	41112.0
2019-08-27 09:00:00	ES	Futures	3133.95	3139.64	3129.08	3132.33	174370.0
2019-08-27 10:00:00	ES	Futures	3132.33	3134.76	3121.23	3122.04	170466.0
2019-08-27 11:00:00	ES	Futures	3122.04	3125.02	3110.67	3112.03	170529.0
2019-08-27 12:00:00	ES	Futures	3111.75	3115.0	3097.41	3099.3	158964.0
2019-08-27 13:00:00	ES	Futures	3099.03	3114.73	3096.87	3112.57	121363.0
2019-08-27 14:00:00	ES	Futures	3112.3	3116.09	3104.45	3114.19	91121.0
2019-08-27 15:00:00	ES	Futures	3114.46	3120.42	3104.99	3105.53	230454.0
2019-08-27 16:00:00	ES	Futures	3105.53	3106.34	3099.57	3104.18	65654.0
2019-08-27 18:00:00	ES	Futures	3103.63	3112.57	3102.82	3110.4	9803.0
2019-08-27 19:00:00	ES	Futures	3110.4	3112.84	3109.05	3112.3	6053.0
2019-08-27 20:00:00	ES	Futures	3112.03	3115.0	3105.8	3109.05	17359.0
2019-08-27 21:00:00	ES	Futures	3109.05	3116.36	3107.69	3109.86	18876.0
2019-08-27 22:00:00	ES	Futures	3109.86	3114.19	3109.59	3112.3	9949.0
2019-08-27 23:00:00	ES	Futures	3112.3	3114.19	3110.4	3113.65	9011.0
2019-08-27 00:00:00	NQ	Futures	8812.21	8815.4	8805.82	8812.79	2372.0
2019-08-27 01:00:00	NQ	Futures	8812.79	8813.37	8785.51	8791.03	5434.0
2019-08-27 02:00:00	NQ	Futures	8790.74	8808.72	8768.97	8787.54	11961.0
2019-08-27 03:00:00	NQ	Futures	8787.25	8787.54	8759.69	8779.42	13148.0
2019-08-27 04:00:00	NQ	Futures	8780.0	8797.41	8764.62	8777.68	11715.0
2019-08-27 05:00:00	NQ	Futures	8777.97	8824.68	8776.52	8803.21	13767.0
2019-08-27 06:00:00	NQ	Futures	8803.79	8824.68	8802.05	8812.79	9709.0
2019-08-27 07:00:00	NQ	Futures	8813.37	8839.48	8811.92	8829.03	9519.0
2019-08-27 08:00:00	NQ	Futures	8828.45	8865.59	8824.97	8859.21	17905.0
2019-08-27 09:00:00	NQ	Futures	8859.21	8876.62	8840.93	8854.28	63390.0
2019-08-27 10:00:00	NQ	Futures	8854.57	8865.3	8824.39	8826.71	61132.0
2019-08-27 11:00:00	NQ	Futures	8826.42	8835.42	8775.36	8795.09	65951.0
2019-08-27 12:00:00	NQ	Futures	8795.09	8804.66	8752.44	8755.05	52751.0
2019-08-27 13:00:00	NQ	Futures	8755.05	8805.82	8747.21	8797.12	45509.0
2019-08-27 14:00:00	NQ	Futures	8797.12	8812.5	8769.85	8808.14	32694.0
2019-08-27 15:00:00	NQ	Futures	8808.43	8829.03	8779.13	8786.38	53745.0
2019-08-27 16:00:00	NQ	Futures	8786.09	8786.96	8764.33	8780.87	12204.0
2019-08-27 18:00:00	NQ	Futures	8778.55	8804.37	8775.36	8801.18	4301.0
2019-08-27 19:00:00	NQ	Futures	8801.47	8810.47	8797.7	8806.4	3616.0
2019-08-27 20:00:00	NQ	Futures	8806.4	8818.01	8788.12	8800.6	10365.0
2019-08-27 21:00:00	NQ	Futures	8800.31	8820.91	8794.8	8802.34	12547.0
2019-08-27 22:00:00	NQ	Futures	8802.05	8815.4	8800.02	8806.11	6977.0
2019-08-27 23:00:00	NQ	Futures	8805.82	8813.08	8799.73	8811.05	4168.0
2019-08-27 00:00:00	YM	Futures	28193.4	28204.3	28181.5	28201.1	1322.0
2019-08-27 01:00:00	YM	Futures	28201.1	28203.2	28142.3	28148.9	2515.0
2019-08-27 02:00:00	YM	Futures	28147.8	28185.8	28105.4	28139.1	4394.0
2019-08-27 03:00:00	YM	Futures	28138.0	28138.0	28065.1	28111.9	6144.0

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

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