PREVIEW / futures_1hour / 2019-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-26.parquet
  size:    57 KB
  rows:    1,753

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-26 00:00:00	ES	Futures	3075.75	3076.56	3066.82	3067.9	12098.0
2019-08-26 01:00:00	ES	Futures	3067.9	3068.71	3063.03	3066.55	15136.0
2019-08-26 02:00:00	ES	Futures	3066.55	3091.99	3066.28	3089.29	55497.0
2019-08-26 03:00:00	ES	Futures	3089.56	3114.73	3088.74	3104.18	117583.0
2019-08-26 04:00:00	ES	Futures	3104.18	3119.33	3099.84	3118.25	44482.0
2019-08-26 05:00:00	ES	Futures	3117.98	3127.73	3100.66	3106.88	82729.0
2019-08-26 06:00:00	ES	Futures	3106.61	3113.65	3102.82	3106.34	44716.0
2019-08-26 07:00:00	ES	Futures	3106.07	3116.63	3105.26	3108.78	39725.0
2019-08-26 08:00:00	ES	Futures	3108.78	3119.33	3102.82	3115.54	56961.0
2019-08-26 09:00:00	ES	Futures	3115.27	3116.09	3098.49	3105.53	254370.0
2019-08-26 10:00:00	ES	Futures	3105.8	3106.88	3091.72	3101.2	232603.0
2019-08-26 11:00:00	ES	Futures	3100.93	3112.57	3099.3	3106.34	156960.0
2019-08-26 12:00:00	ES	Futures	3106.61	3117.44	3104.72	3112.57	91402.0
2019-08-26 13:00:00	ES	Futures	3112.57	3116.63	3106.88	3108.78	64296.0
2019-08-26 14:00:00	ES	Futures	3108.78	3109.32	3101.47	3106.61	73220.0
2019-08-26 15:00:00	ES	Futures	3106.61	3118.52	3104.18	3117.98	188943.0
2019-08-26 16:00:00	ES	Futures	3117.98	3122.85	3117.17	3120.69	77772.0
2019-08-26 18:00:00	ES	Futures	3121.5	3123.67	3118.79	3119.33	5916.0
2019-08-26 19:00:00	ES	Futures	3119.33	3119.88	3113.11	3114.46	8913.0
2019-08-26 20:00:00	ES	Futures	3114.46	3118.25	3113.38	3116.63	17350.0
2019-08-26 21:00:00	ES	Futures	3116.9	3125.56	3116.36	3121.77	20420.0
2019-08-26 22:00:00	ES	Futures	3121.77	3126.37	3119.06	3125.56	10601.0
2019-08-26 23:00:00	ES	Futures	3125.29	3125.83	3120.69	3121.5	5706.0
2019-08-26 00:00:00	NQ	Futures	8665.1	8668.01	8634.06	8637.25	5650.0
2019-08-26 01:00:00	NQ	Futures	8637.83	8641.31	8621.58	8632.32	7339.0
2019-08-26 02:00:00	NQ	Futures	8631.74	8735.03	8629.71	8721.97	19081.0
2019-08-26 03:00:00	NQ	Futures	8722.55	8814.53	8720.52	8766.94	37684.0
2019-08-26 04:00:00	NQ	Futures	8765.78	8824.39	8749.25	8817.72	22294.0
2019-08-26 05:00:00	NQ	Futures	8817.43	8850.5	8753.6	8779.71	26299.0
2019-08-26 06:00:00	NQ	Futures	8778.55	8811.34	8764.62	8777.1	17585.0
2019-08-26 07:00:00	NQ	Futures	8776.52	8799.15	8765.78	8771.3	16285.0
2019-08-26 08:00:00	NQ	Futures	8771.01	8799.73	8744.89	8786.38	25133.0
2019-08-26 09:00:00	NQ	Futures	8785.8	8786.67	8733.58	8758.82	81713.0
2019-08-26 10:00:00	NQ	Futures	8759.11	8771.3	8716.46	8749.83	82916.0
2019-08-26 11:00:00	NQ	Futures	8749.54	8784.06	8744.02	8762.88	56338.0
2019-08-26 12:00:00	NQ	Futures	8762.59	8799.73	8757.37	8783.19	35314.0
2019-08-26 13:00:00	NQ	Futures	8783.48	8792.77	8765.49	8772.75	23896.0
2019-08-26 14:00:00	NQ	Futures	8773.04	8774.2	8751.28	8768.39	27165.0
2019-08-26 15:00:00	NQ	Futures	8768.39	8801.47	8757.95	8800.02	44851.0
2019-08-26 16:00:00	NQ	Futures	8800.02	8820.04	8797.7	8806.4	14255.0
2019-08-26 18:00:00	NQ	Futures	8810.47	8816.85	8799.44	8801.76	2685.0
2019-08-26 19:00:00	NQ	Futures	8802.05	8803.21	8786.96	8788.99	4312.0
2019-08-26 20:00:00	NQ	Futures	8788.99	8800.6	8782.9	8796.83	7128.0
2019-08-26 21:00:00	NQ	Futures	8796.54	8827.87	8794.8	8810.18	9196.0
2019-08-26 22:00:00	NQ	Futures	8810.76	8830.49	8802.92	8827.58	6056.0
2019-08-26 23:00:00	NQ	Futures	8827.87	8829.9	8808.72	8812.5	2883.0
2019-08-26 00:00:00	YM	Futures	27800.9	27805.2	27721.5	27729.1	2532.0
2019-08-26 01:00:00	YM	Futures	27730.2	27735.6	27682.3	27720.4	3267.0
2019-08-26 02:00:00	YM	Futures	27718.2	27935.7	27713.9	27907.4	7593.0
2019-08-26 03:00:00	YM	Futures	27909.6	28119.5	27900.9	28045.5	22863.0

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

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