PREVIEW / futures_1hour / 2016-11-03

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-03.parquet
  size:    55 KB
  rows:    1,655

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-11-03 00:00:00	ES	Futures	2270.77	2274.85	2270.23	2272.13	9156.0
2016-11-03 01:00:00	ES	Futures	2272.13	2274.04	2271.32	2272.95	3896.0
2016-11-03 02:00:00	ES	Futures	2272.95	2274.04	2272.68	2272.95	2667.0
2016-11-03 03:00:00	ES	Futures	2273.22	2273.22	2270.5	2272.13	10384.0
2016-11-03 04:00:00	ES	Futures	2271.86	2276.48	2270.5	2274.85	25294.0
2016-11-03 05:00:00	ES	Futures	2275.12	2277.85	2273.49	2277.57	13999.0
2016-11-03 06:00:00	ES	Futures	2277.57	2281.11	2275.4	2277.3	32336.0
2016-11-03 07:00:00	ES	Futures	2277.3	2284.1	2276.76	2281.38	37029.0
2016-11-03 08:00:00	ES	Futures	2281.65	2284.1	2280.02	2283.01	43301.0
2016-11-03 09:00:00	ES	Futures	2283.01	2283.01	2278.12	2278.66	176666.0
2016-11-03 10:00:00	ES	Futures	2278.66	2282.47	2276.21	2279.21	249466.0
2016-11-03 11:00:00	ES	Futures	2279.21	2281.65	2277.57	2278.12	134759.0
2016-11-03 12:00:00	ES	Futures	2278.12	2278.93	2269.68	2272.4	209895.0
2016-11-03 13:00:00	ES	Futures	2272.4	2274.85	2270.23	2271.04	170228.0
2016-11-03 14:00:00	ES	Futures	2271.32	2274.58	2269.41	2272.4	176321.0
2016-11-03 15:00:00	ES	Futures	2272.68	2272.68	2263.43	2267.51	340183.0
2016-11-03 16:00:00	ES	Futures	2267.51	2269.14	2265.6	2267.23	93550.0
2016-11-03 18:00:00	ES	Futures	2268.05	2269.41	2267.78	2268.87	4661.0
2016-11-03 19:00:00	ES	Futures	2268.59	2270.5	2268.32	2269.14	4343.0
2016-11-03 20:00:00	ES	Futures	2269.14	2270.5	2268.05	2268.32	6602.0
2016-11-03 21:00:00	ES	Futures	2268.32	2269.68	2266.96	2269.41	7335.0
2016-11-03 22:00:00	ES	Futures	2269.41	2270.77	2268.59	2268.87	4304.0
2016-11-03 23:00:00	ES	Futures	2268.87	2269.96	2268.32	2268.87	3533.0
2016-11-03 00:00:00	NQ	Futures	5603.33	5612.87	5601.83	5606.31	1524.0
2016-11-03 01:00:00	NQ	Futures	5607.5	5610.19	5603.92	5606.61	928.0
2016-11-03 02:00:00	NQ	Futures	5606.91	5610.78	5606.01	5606.01	690.0
2016-11-03 03:00:00	NQ	Futures	5606.61	5607.5	5600.94	5605.12	1811.0
2016-11-03 04:00:00	NQ	Futures	5604.82	5614.36	5600.94	5608.99	4654.0
2016-11-03 05:00:00	NQ	Futures	5609.29	5615.56	5605.41	5615.56	2508.0
2016-11-03 06:00:00	NQ	Futures	5615.26	5624.81	5611.38	5616.75	4146.0
2016-11-03 07:00:00	NQ	Futures	5616.75	5633.46	5614.96	5629.28	5972.0
2016-11-03 08:00:00	NQ	Futures	5629.58	5636.14	5626.3	5633.76	5228.0
2016-11-03 09:00:00	NQ	Futures	5633.76	5643.9	5619.14	5619.73	31332.0
2016-11-03 10:00:00	NQ	Futures	5619.44	5634.65	5614.66	5620.33	39542.0
2016-11-03 11:00:00	NQ	Futures	5620.03	5628.68	5614.66	5618.84	27110.0
2016-11-03 12:00:00	NQ	Futures	5618.54	5620.03	5593.48	5601.54	28761.0
2016-11-03 13:00:00	NQ	Futures	5601.24	5605.41	5590.8	5592.88	22196.0
2016-11-03 14:00:00	NQ	Futures	5592.88	5599.75	5583.64	5593.18	24028.0
2016-11-03 15:00:00	NQ	Futures	5592.88	5592.88	5573.49	5579.76	38775.0
2016-11-03 16:00:00	NQ	Futures	5580.06	5580.95	5570.81	5573.19	9406.0
2016-11-03 18:00:00	NQ	Futures	5574.39	5580.06	5574.39	5577.07	870.0
2016-11-03 19:00:00	NQ	Futures	5576.48	5584.53	5575.58	5580.06	1315.0
2016-11-03 20:00:00	NQ	Futures	5579.76	5583.04	5577.67	5578.56	803.0
2016-11-03 21:00:00	NQ	Futures	5578.27	5583.04	5576.18	5582.44	1089.0
2016-11-03 22:00:00	NQ	Futures	5582.44	5585.72	5578.86	5579.16	973.0
2016-11-03 23:00:00	NQ	Futures	5579.16	5582.14	5578.86	5579.76	361.0
2016-11-03 00:00:00	YM	Futures	19308.9	19335.9	19304.6	19315.4	1580.0
2016-11-03 01:00:00	YM	Futures	19318.6	19327.3	19308.9	19320.8	1017.0
2016-11-03 02:00:00	YM	Futures	19321.9	19329.4	19317.6	19319.7	649.0
2016-11-03 03:00:00	YM	Futures	19320.8	19321.9	19294.9	19306.7	2611.0

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

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