PREVIEW / futures_1hour / 2017-05-16

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-16.parquet
  size:    55 KB
  rows:    1,678

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-16 00:00:00	ES	Futures	2618.62	2619.44	2618.35	2619.44	1089.0
2017-05-16 01:00:00	ES	Futures	2619.44	2619.99	2618.62	2619.71	4658.0
2017-05-16 02:00:00	ES	Futures	2619.71	2620.53	2619.17	2619.99	5485.0
2017-05-16 03:00:00	ES	Futures	2619.99	2621.08	2618.89	2620.53	16446.0
2017-05-16 04:00:00	ES	Futures	2620.53	2620.81	2618.89	2619.99	9519.0
2017-05-16 05:00:00	ES	Futures	2619.99	2620.53	2618.89	2619.44	9506.0
2017-05-16 06:00:00	ES	Futures	2619.71	2621.9	2619.44	2621.9	12428.0
2017-05-16 07:00:00	ES	Futures	2622.17	2624.36	2621.35	2623.81	20056.0
2017-05-16 08:00:00	ES	Futures	2623.81	2626.54	2621.9	2624.63	33751.0
2017-05-16 09:00:00	ES	Futures	2624.9	2627.09	2622.72	2624.36	130765.0
2017-05-16 10:00:00	ES	Futures	2624.36	2624.63	2615.34	2617.8	245070.0
2017-05-16 11:00:00	ES	Futures	2617.8	2622.99	2616.16	2621.63	167971.0
2017-05-16 12:00:00	ES	Futures	2621.35	2623.27	2620.26	2621.08	73069.0
2017-05-16 13:00:00	ES	Futures	2621.35	2621.63	2618.89	2619.44	68454.0
2017-05-16 14:00:00	ES	Futures	2619.17	2620.26	2617.53	2618.35	59954.0
2017-05-16 15:00:00	ES	Futures	2618.35	2621.63	2618.08	2620.81	113739.0
2017-05-16 16:00:00	ES	Futures	2620.81	2620.81	2618.62	2619.44	63941.0
2017-05-16 18:00:00	ES	Futures	2618.35	2618.62	2610.15	2610.15	22095.0
2017-05-16 19:00:00	ES	Futures	2610.43	2612.07	2606.06	2606.88	24687.0
2017-05-16 20:00:00	ES	Futures	2606.88	2607.7	2599.5	2604.42	43994.0
2017-05-16 21:00:00	ES	Futures	2604.15	2606.33	2603.6	2604.15	15318.0
2017-05-16 22:00:00	ES	Futures	2604.15	2606.06	2602.78	2603.05	11611.0
2017-05-16 23:00:00	ES	Futures	2603.05	2604.42	2601.41	2603.6	8274.0
2017-05-16 00:00:00	NQ	Futures	6795.81	6798.79	6795.81	6798.79	340.0
2017-05-16 01:00:00	NQ	Futures	6798.79	6801.47	6797.0	6799.68	1095.0
2017-05-16 02:00:00	NQ	Futures	6799.68	6801.47	6798.49	6800.58	881.0
2017-05-16 03:00:00	NQ	Futures	6800.28	6804.16	6798.19	6802.07	2118.0
2017-05-16 04:00:00	NQ	Futures	6802.07	6803.26	6799.09	6801.77	1513.0
2017-05-16 05:00:00	NQ	Futures	6801.77	6803.26	6799.39	6802.07	1405.0
2017-05-16 06:00:00	NQ	Futures	6802.07	6805.65	6801.17	6805.65	2031.0
2017-05-16 07:00:00	NQ	Futures	6805.65	6810.71	6803.86	6809.52	3523.0
2017-05-16 08:00:00	NQ	Futures	6809.82	6814.59	6805.65	6811.01	6793.0
2017-05-16 09:00:00	NQ	Futures	6811.31	6819.96	6807.73	6817.27	28671.0
2017-05-16 10:00:00	NQ	Futures	6817.27	6820.55	6798.49	6808.33	37436.0
2017-05-16 11:00:00	NQ	Futures	6808.33	6822.64	6804.75	6818.47	27294.0
2017-05-16 12:00:00	NQ	Futures	6818.76	6824.73	6815.48	6822.34	15457.0
2017-05-16 13:00:00	NQ	Futures	6822.64	6825.62	6817.57	6818.47	13444.0
2017-05-16 14:00:00	NQ	Futures	6818.47	6821.45	6816.08	6818.47	9690.0
2017-05-16 15:00:00	NQ	Futures	6818.47	6830.09	6818.17	6829.2	18506.0
2017-05-16 16:00:00	NQ	Futures	6829.2	6829.5	6825.92	6826.81	5443.0
2017-05-16 18:00:00	NQ	Futures	6825.62	6826.22	6809.22	6809.82	4008.0
2017-05-16 19:00:00	NQ	Futures	6809.82	6811.61	6797.0	6799.39	5630.0
2017-05-16 20:00:00	NQ	Futures	6799.09	6800.88	6778.22	6792.83	11889.0
2017-05-16 21:00:00	NQ	Futures	6792.83	6798.49	6791.93	6794.02	3950.0
2017-05-16 22:00:00	NQ	Futures	6794.02	6797.89	6789.55	6790.14	2051.0
2017-05-16 23:00:00	NQ	Futures	6790.44	6794.62	6786.86	6791.04	2387.0
2017-05-16 00:00:00	YM	Futures	22735.7	22745.5	22735.7	22744.4	422.0
2017-05-16 01:00:00	YM	Futures	22744.4	22750.9	22741.1	22749.8	875.0
2017-05-16 02:00:00	YM	Futures	22748.7	22754.1	22743.3	22748.7	989.0
2017-05-16 03:00:00	YM	Futures	22748.7	22759.6	22742.2	22756.3	1774.0

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

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