PREVIEW / futures_1hour / 2016-09-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-29.parquet
  size:    54 KB
  rows:    1,631

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-09-29 00:00:00	ES	Futures	2357.84	2358.11	2356.75	2357.02	2012.0
2016-09-29 01:00:00	ES	Futures	2357.02	2358.38	2357.02	2357.29	3390.0
2016-09-29 02:00:00	ES	Futures	2357.56	2358.38	2355.12	2355.93	9183.0
2016-09-29 03:00:00	ES	Futures	2355.66	2357.29	2353.21	2355.66	28126.0
2016-09-29 04:00:00	ES	Futures	2355.66	2357.56	2353.48	2355.12	15576.0
2016-09-29 05:00:00	ES	Futures	2355.12	2356.2	2353.76	2354.3	10682.0
2016-09-29 06:00:00	ES	Futures	2354.3	2355.12	2351.58	2352.67	10542.0
2016-09-29 07:00:00	ES	Futures	2352.67	2354.57	2352.12	2352.67	13643.0
2016-09-29 08:00:00	ES	Futures	2352.67	2353.21	2348.04	2351.03	37342.0
2016-09-29 09:00:00	ES	Futures	2350.76	2354.03	2349.13	2353.76	169593.0
2016-09-29 10:00:00	ES	Futures	2353.76	2357.02	2350.49	2351.03	287510.0
2016-09-29 11:00:00	ES	Futures	2351.03	2351.85	2345.87	2350.49	205622.0
2016-09-29 12:00:00	ES	Futures	2350.22	2354.3	2333.08	2336.07	316793.0
2016-09-29 13:00:00	ES	Futures	2336.34	2339.06	2326.0	2328.72	385265.0
2016-09-29 14:00:00	ES	Futures	2328.45	2343.96	2326.82	2338.25	344043.0
2016-09-29 15:00:00	ES	Futures	2337.97	2341.51	2332.26	2333.08	338891.0
2016-09-29 16:00:00	ES	Futures	2333.08	2338.79	2332.81	2337.43	96183.0
2016-09-29 18:00:00	ES	Futures	2335.25	2335.53	2333.08	2334.98	7967.0
2016-09-29 19:00:00	ES	Futures	2334.98	2335.25	2331.99	2334.44	6850.0
2016-09-29 20:00:00	ES	Futures	2334.44	2334.71	2330.08	2330.9	11033.0
2016-09-29 21:00:00	ES	Futures	2330.9	2332.26	2329.54	2331.99	10173.0
2016-09-29 22:00:00	ES	Futures	2332.26	2334.44	2330.9	2333.08	8153.0
2016-09-29 23:00:00	ES	Futures	2332.81	2334.17	2331.72	2332.53	6202.0
2016-09-29 00:00:00	NQ	Futures	5817.53	5818.13	5816.34	5816.93	327.0
2016-09-29 01:00:00	NQ	Futures	5817.23	5819.02	5815.74	5816.04	347.0
2016-09-29 02:00:00	NQ	Futures	5816.93	5819.02	5811.86	5813.35	1008.0
2016-09-29 03:00:00	NQ	Futures	5813.65	5818.43	5808.58	5814.25	3279.0
2016-09-29 04:00:00	NQ	Futures	5814.25	5818.13	5809.77	5813.06	1915.0
2016-09-29 05:00:00	NQ	Futures	5812.76	5814.55	5808.88	5811.27	1272.0
2016-09-29 06:00:00	NQ	Futures	5810.97	5812.16	5801.42	5804.11	2463.0
2016-09-29 07:00:00	NQ	Futures	5804.11	5806.19	5801.42	5801.42	2202.0
2016-09-29 08:00:00	NQ	Futures	5802.02	5803.21	5793.66	5800.23	4901.0
2016-09-29 09:00:00	NQ	Futures	5800.53	5807.98	5797.24	5807.09	22992.0
2016-09-29 10:00:00	NQ	Futures	5807.39	5812.46	5783.22	5788.0	51032.0
2016-09-29 11:00:00	NQ	Futures	5788.0	5792.17	5776.96	5788.59	28519.0
2016-09-29 12:00:00	NQ	Futures	5788.59	5799.03	5751.3	5757.27	36406.0
2016-09-29 13:00:00	NQ	Futures	5756.97	5776.36	5742.95	5755.78	54673.0
2016-09-29 14:00:00	NQ	Futures	5755.78	5791.58	5751.0	5776.06	42904.0
2016-09-29 15:00:00	NQ	Futures	5776.06	5783.82	5763.83	5768.31	38010.0
2016-09-29 16:00:00	NQ	Futures	5768.01	5782.63	5767.41	5778.15	6667.0
2016-09-29 18:00:00	NQ	Futures	5774.87	5776.06	5769.5	5773.08	931.0
2016-09-29 19:00:00	NQ	Futures	5773.68	5774.27	5768.01	5772.78	794.0
2016-09-29 20:00:00	NQ	Futures	5772.18	5772.18	5758.76	5759.36	2178.0
2016-09-29 21:00:00	NQ	Futures	5759.06	5762.04	5754.58	5761.44	2405.0
2016-09-29 22:00:00	NQ	Futures	5761.74	5766.52	5757.57	5762.94	1507.0
2016-09-29 23:00:00	NQ	Futures	5762.94	5766.81	5759.65	5762.04	861.0
2016-09-29 00:00:00	YM	Futures	19749.9	19753.1	19740.1	19742.3	357.0
2016-09-29 01:00:00	YM	Futures	19742.3	19750.9	19742.3	19742.3	663.0
2016-09-29 02:00:00	YM	Futures	19743.4	19752.0	19725.0	19729.3	1393.0
2016-09-29 03:00:00	YM	Futures	19729.3	19747.7	19713.1	19731.5	3288.0

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

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