PREVIEW / futures_1hour / 2017-05-30

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-30.parquet
  size:    52 KB
  rows:    1,641

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-30 00:00:00	ES	Futures	2636.1	2636.65	2636.1	2636.65	1126.0
2017-05-30 01:00:00	ES	Futures	2636.65	2636.92	2635.28	2635.83	3155.0
2017-05-30 02:00:00	ES	Futures	2636.1	2636.38	2634.19	2634.46	6440.0
2017-05-30 03:00:00	ES	Futures	2634.46	2636.65	2632.83	2636.1	21918.0
2017-05-30 04:00:00	ES	Futures	2635.83	2636.65	2633.92	2636.1	16910.0
2017-05-30 05:00:00	ES	Futures	2635.83	2636.38	2633.92	2634.46	15540.0
2017-05-30 06:00:00	ES	Futures	2634.46	2635.01	2633.1	2633.64	9740.0
2017-05-30 07:00:00	ES	Futures	2633.64	2633.64	2630.64	2630.64	22988.0
2017-05-30 08:00:00	ES	Futures	2630.91	2634.19	2630.64	2633.37	28188.0
2017-05-30 09:00:00	ES	Futures	2633.64	2636.92	2631.46	2634.46	139874.0
2017-05-30 10:00:00	ES	Futures	2634.46	2636.1	2630.91	2634.74	192292.0
2017-05-30 11:00:00	ES	Futures	2634.74	2636.1	2634.19	2635.01	110129.0
2017-05-30 12:00:00	ES	Futures	2635.01	2638.01	2634.74	2637.2	80359.0
2017-05-30 13:00:00	ES	Futures	2637.2	2637.47	2635.56	2636.1	45644.0
2017-05-30 14:00:00	ES	Futures	2636.1	2636.92	2635.01	2636.38	57367.0
2017-05-30 15:00:00	ES	Futures	2636.38	2637.74	2634.74	2635.01	121471.0
2017-05-30 16:00:00	ES	Futures	2635.01	2635.56	2633.37	2634.74	64127.0
2017-05-30 18:00:00	ES	Futures	2633.64	2635.28	2633.1	2635.01	3050.0
2017-05-30 19:00:00	ES	Futures	2634.74	2635.01	2634.19	2634.46	962.0
2017-05-30 20:00:00	ES	Futures	2634.46	2635.01	2633.1	2634.74	4622.0
2017-05-30 21:00:00	ES	Futures	2634.46	2636.1	2634.46	2635.28	3432.0
2017-05-30 22:00:00	ES	Futures	2635.28	2635.56	2634.46	2635.56	3160.0
2017-05-30 23:00:00	ES	Futures	2635.28	2635.28	2634.74	2635.01	1476.0
2017-05-30 00:00:00	NQ	Futures	6906.12	6907.61	6905.52	6907.01	591.0
2017-05-30 01:00:00	NQ	Futures	6907.01	6909.7	6905.52	6906.72	671.0
2017-05-30 02:00:00	NQ	Futures	6907.01	6907.61	6902.24	6903.44	1167.0
2017-05-30 03:00:00	NQ	Futures	6903.14	6910.0	6898.96	6907.31	4378.0
2017-05-30 04:00:00	NQ	Futures	6907.31	6910.59	6902.54	6908.21	2864.0
2017-05-30 05:00:00	NQ	Futures	6908.21	6909.4	6904.03	6906.12	1546.0
2017-05-30 06:00:00	NQ	Futures	6906.12	6907.01	6903.14	6903.73	1559.0
2017-05-30 07:00:00	NQ	Futures	6904.03	6904.33	6890.91	6891.51	5012.0
2017-05-30 08:00:00	NQ	Futures	6891.51	6904.33	6891.21	6903.44	5384.0
2017-05-30 09:00:00	NQ	Futures	6903.14	6919.54	6897.77	6915.36	35067.0
2017-05-30 10:00:00	NQ	Futures	6915.36	6918.94	6906.72	6912.98	35738.0
2017-05-30 11:00:00	NQ	Futures	6913.27	6918.05	6910.59	6912.98	19452.0
2017-05-30 12:00:00	NQ	Futures	6912.98	6920.13	6911.49	6917.45	12352.0
2017-05-30 13:00:00	NQ	Futures	6917.45	6919.54	6910.89	6912.38	11047.0
2017-05-30 14:00:00	NQ	Futures	6912.38	6914.17	6908.5	6911.78	9164.0
2017-05-30 15:00:00	NQ	Futures	6911.49	6918.34	6911.19	6912.08	21070.0
2017-05-30 16:00:00	NQ	Futures	6912.08	6912.98	6906.42	6909.7	4980.0
2017-05-30 18:00:00	NQ	Futures	6907.91	6913.27	6906.42	6912.08	960.0
2017-05-30 19:00:00	NQ	Futures	6912.08	6913.27	6910.0	6911.19	435.0
2017-05-30 20:00:00	NQ	Futures	6911.19	6912.98	6907.61	6912.38	1161.0
2017-05-30 21:00:00	NQ	Futures	6912.08	6918.05	6911.49	6916.55	1214.0
2017-05-30 22:00:00	NQ	Futures	6916.55	6916.55	6911.78	6915.36	1404.0
2017-05-30 23:00:00	NQ	Futures	6914.77	6915.06	6911.78	6912.98	418.0
2017-05-30 00:00:00	YM	Futures	22885.6	22891.1	22884.6	22888.9	406.0
2017-05-30 01:00:00	YM	Futures	22888.9	22894.3	22882.4	22886.7	724.0
2017-05-30 02:00:00	YM	Futures	22885.6	22890.0	22873.7	22875.9	1131.0
2017-05-30 03:00:00	YM	Futures	22875.9	22898.7	22860.7	22893.3	3960.0

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

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