PREVIEW / futures_1hour / 2017-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-29.parquet
  size:    36 KB
  rows:    1,116

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
2017-05-29 00:00:00	ES	Futures	2639.93	2639.93	2638.83	2639.38	1098.0
2017-05-29 01:00:00	ES	Futures	2639.38	2639.93	2638.83	2638.83	869.0
2017-05-29 02:00:00	ES	Futures	2638.83	2639.11	2638.29	2638.56	2768.0
2017-05-29 03:00:00	ES	Futures	2638.56	2639.11	2637.2	2638.83	6404.0
2017-05-29 04:00:00	ES	Futures	2638.83	2639.65	2637.74	2638.29	3796.0
2017-05-29 05:00:00	ES	Futures	2638.29	2639.38	2637.47	2638.56	3421.0
2017-05-29 06:00:00	ES	Futures	2638.56	2639.38	2638.01	2639.38	3172.0
2017-05-29 07:00:00	ES	Futures	2639.11	2639.93	2638.56	2639.65	2483.0
2017-05-29 08:00:00	ES	Futures	2639.38	2640.47	2639.38	2640.47	2748.0
2017-05-29 09:00:00	ES	Futures	2640.2	2640.75	2639.93	2640.2	5666.0
2017-05-29 10:00:00	ES	Futures	2639.93	2640.47	2638.29	2638.29	6840.0
2017-05-29 11:00:00	ES	Futures	2638.29	2639.38	2637.74	2638.83	4840.0
2017-05-29 12:00:00	ES	Futures	2638.83	2639.11	2637.74	2637.74	2355.0
2017-05-29 18:00:00	ES	Futures	2638.01	2638.29	2637.47	2638.01	2948.0
2017-05-29 19:00:00	ES	Futures	2638.01	2638.01	2637.2	2637.74	1365.0
2017-05-29 20:00:00	ES	Futures	2637.74	2638.29	2637.2	2637.2	4086.0
2017-05-29 21:00:00	ES	Futures	2637.47	2637.74	2633.37	2634.19	10842.0
2017-05-29 22:00:00	ES	Futures	2633.92	2635.01	2633.92	2634.74	2075.0
2017-05-29 23:00:00	ES	Futures	2634.46	2636.65	2634.46	2636.38	2634.0
2017-05-29 00:00:00	NQ	Futures	6916.55	6917.45	6915.06	6915.36	323.0
2017-05-29 01:00:00	NQ	Futures	6915.36	6916.26	6914.77	6915.36	279.0
2017-05-29 02:00:00	NQ	Futures	6915.36	6915.96	6913.57	6913.87	589.0
2017-05-29 03:00:00	NQ	Futures	6913.87	6915.06	6911.19	6915.06	938.0
2017-05-29 04:00:00	NQ	Futures	6915.06	6916.26	6912.08	6912.68	547.0
2017-05-29 05:00:00	NQ	Futures	6912.98	6915.96	6911.78	6915.06	432.0
2017-05-29 06:00:00	NQ	Futures	6914.47	6916.55	6913.27	6916.26	391.0
2017-05-29 07:00:00	NQ	Futures	6916.26	6918.34	6914.77	6918.05	524.0
2017-05-29 08:00:00	NQ	Futures	6918.05	6918.64	6916.55	6918.34	721.0
2017-05-29 09:00:00	NQ	Futures	6918.05	6919.24	6914.77	6915.66	1734.0
2017-05-29 10:00:00	NQ	Futures	6915.36	6915.96	6910.0	6910.89	1749.0
2017-05-29 11:00:00	NQ	Futures	6910.59	6912.38	6907.31	6911.49	1886.0
2017-05-29 12:00:00	NQ	Futures	6911.49	6913.57	6909.7	6912.08	873.0
2017-05-29 18:00:00	NQ	Futures	6911.49	6912.08	6907.61	6909.1	814.0
2017-05-29 19:00:00	NQ	Futures	6909.4	6910.59	6908.5	6909.1	295.0
2017-05-29 20:00:00	NQ	Futures	6909.4	6911.19	6908.5	6908.8	769.0
2017-05-29 21:00:00	NQ	Futures	6909.1	6909.4	6897.18	6898.67	2801.0
2017-05-29 22:00:00	NQ	Futures	6898.67	6902.54	6898.37	6901.95	1536.0
2017-05-29 23:00:00	NQ	Futures	6901.95	6907.01	6901.95	6906.42	786.0
2017-05-29 00:00:00	YM	Futures	22909.6	22911.7	22904.1	22906.3	192.0
2017-05-29 01:00:00	YM	Futures	22906.3	22911.7	22905.2	22907.4	349.0
2017-05-29 02:00:00	YM	Futures	22907.4	22908.5	22899.8	22903.0	664.0
2017-05-29 03:00:00	YM	Futures	22903.0	22909.6	22896.5	22905.2	1221.0
2017-05-29 04:00:00	YM	Futures	22906.3	22908.5	22895.4	22897.6	694.0
2017-05-29 05:00:00	YM	Futures	22898.7	22907.4	22894.3	22904.1	536.0
2017-05-29 06:00:00	YM	Futures	22905.2	22908.5	22898.7	22906.3	788.0
2017-05-29 07:00:00	YM	Futures	22906.3	22911.7	22900.9	22908.5	533.0
2017-05-29 08:00:00	YM	Futures	22906.3	22912.8	22906.3	22912.8	517.0
2017-05-29 09:00:00	YM	Futures	22912.8	22921.5	22912.8	22915.0	1380.0
2017-05-29 10:00:00	YM	Futures	22915.0	22917.2	22903.0	22904.1	1456.0
2017-05-29 11:00:00	YM	Futures	22904.1	22908.5	22899.8	22905.2	882.0

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

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