PREVIEW / futures_1hour / 2016-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-01.parquet
  size:    55 KB
  rows:    1,628

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
2016-12-01 00:00:00	ES	Futures	2395.11	2395.38	2393.75	2394.3	4349.0
2016-12-01 01:00:00	ES	Futures	2394.02	2394.3	2388.04	2389.13	12365.0
2016-12-01 02:00:00	ES	Futures	2389.13	2392.93	2388.85	2391.57	9696.0
2016-12-01 03:00:00	ES	Futures	2391.85	2392.93	2389.13	2391.57	21527.0
2016-12-01 04:00:00	ES	Futures	2391.85	2391.85	2389.13	2389.4	15102.0
2016-12-01 05:00:00	ES	Futures	2389.4	2391.85	2388.85	2389.67	11361.0
2016-12-01 06:00:00	ES	Futures	2389.67	2391.3	2388.85	2391.03	9921.0
2016-12-01 07:00:00	ES	Futures	2390.76	2391.57	2389.13	2390.49	12272.0
2016-12-01 08:00:00	ES	Futures	2390.49	2396.74	2390.49	2395.93	36342.0
2016-12-01 09:00:00	ES	Futures	2395.93	2397.56	2388.31	2391.85	266748.0
2016-12-01 10:00:00	ES	Futures	2392.12	2396.2	2386.13	2388.58	427288.0
2016-12-01 11:00:00	ES	Futures	2388.58	2392.93	2386.68	2390.76	300326.0
2016-12-01 12:00:00	ES	Futures	2390.49	2391.03	2383.41	2384.23	188118.0
2016-12-01 13:00:00	ES	Futures	2384.23	2384.5	2380.42	2380.69	190933.0
2016-12-01 14:00:00	ES	Futures	2380.69	2385.32	2380.69	2383.68	192946.0
2016-12-01 15:00:00	ES	Futures	2383.68	2384.5	2379.06	2383.14	317911.0
2016-12-01 16:00:00	ES	Futures	2383.14	2386.68	2382.87	2384.77	87925.0
2016-12-01 18:00:00	ES	Futures	2383.96	2384.23	2381.51	2383.14	6968.0
2016-12-01 19:00:00	ES	Futures	2383.14	2385.04	2383.14	2383.68	3941.0
2016-12-01 20:00:00	ES	Futures	2383.68	2384.23	2382.6	2382.87	4134.0
2016-12-01 21:00:00	ES	Futures	2382.6	2382.87	2381.24	2382.32	3137.0
2016-12-01 22:00:00	ES	Futures	2382.32	2383.14	2380.96	2381.24	3480.0
2016-12-01 23:00:00	ES	Futures	2380.96	2382.05	2380.69	2381.78	3878.0
2016-12-01 00:00:00	NQ	Futures	5756.37	5758.16	5753.39	5754.28	790.0
2016-12-01 01:00:00	NQ	Futures	5754.58	5755.18	5738.17	5739.96	1737.0
2016-12-01 02:00:00	NQ	Futures	5739.96	5748.32	5739.96	5745.04	1544.0
2016-12-01 03:00:00	NQ	Futures	5745.33	5748.02	5737.58	5743.84	3178.0
2016-12-01 04:00:00	NQ	Futures	5743.54	5743.84	5734.0	5735.49	2091.0
2016-12-01 05:00:00	NQ	Futures	5735.49	5742.65	5734.59	5736.98	1301.0
2016-12-01 06:00:00	NQ	Futures	5737.58	5739.96	5734.59	5738.47	1336.0
2016-12-01 07:00:00	NQ	Futures	5738.17	5739.96	5734.3	5738.47	2133.0
2016-12-01 08:00:00	NQ	Futures	5738.17	5751.0	5736.98	5747.72	4874.0
2016-12-01 09:00:00	NQ	Futures	5747.72	5752.79	5699.09	5710.13	39681.0
2016-12-01 10:00:00	NQ	Futures	5710.13	5728.93	5650.46	5666.87	69153.0
2016-12-01 11:00:00	NQ	Futures	5666.57	5683.58	5661.5	5668.96	40688.0
2016-12-01 12:00:00	NQ	Futures	5668.36	5670.45	5648.38	5651.66	27989.0
2016-12-01 13:00:00	NQ	Futures	5651.36	5654.04	5640.02	5642.41	24022.0
2016-12-01 14:00:00	NQ	Futures	5642.41	5660.01	5641.22	5654.64	21261.0
2016-12-01 15:00:00	NQ	Futures	5654.64	5657.33	5635.85	5647.78	31812.0
2016-12-01 16:00:00	NQ	Futures	5648.08	5657.92	5646.29	5650.17	8866.0
2016-12-01 18:00:00	NQ	Futures	5651.06	5652.25	5644.5	5646.88	850.0
2016-12-01 19:00:00	NQ	Futures	5646.88	5650.17	5646.59	5647.48	750.0
2016-12-01 20:00:00	NQ	Futures	5647.78	5648.67	5645.39	5646.59	1001.0
2016-12-01 21:00:00	NQ	Futures	5645.99	5646.59	5640.02	5642.41	772.0
2016-12-01 22:00:00	NQ	Futures	5642.41	5643.9	5637.34	5637.64	904.0
2016-12-01 23:00:00	NQ	Futures	5637.93	5639.72	5637.34	5638.53	579.0
2016-12-01 00:00:00	YM	Futures	20705.3	20709.6	20697.7	20700.9	813.0
2016-12-01 01:00:00	YM	Futures	20702.0	20702.0	20656.6	20662.0	2396.0
2016-12-01 02:00:00	YM	Futures	20663.1	20692.3	20663.1	20684.7	2115.0
2016-12-01 03:00:00	YM	Futures	20685.8	20695.5	20666.3	20684.7	3666.0

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

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