PREVIEW / futures_1hour / 2016-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-30.parquet
  size:    47 KB
  rows:    1,350

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-30 00:00:00	ES	Futures	2332.53	2332.81	2331.17	2331.44	2115.0
2016-09-30 01:00:00	ES	Futures	2331.44	2332.26	2329.81	2330.08	3003.0
2016-09-30 02:00:00	ES	Futures	2330.08	2331.72	2328.72	2331.17	16426.0
2016-09-30 03:00:00	ES	Futures	2331.17	2331.99	2324.37	2329.0	61232.0
2016-09-30 04:00:00	ES	Futures	2329.0	2334.98	2327.09	2333.62	34330.0
2016-09-30 05:00:00	ES	Futures	2333.62	2337.7	2332.53	2335.25	20343.0
2016-09-30 06:00:00	ES	Futures	2335.25	2339.34	2332.26	2337.97	19270.0
2016-09-30 07:00:00	ES	Futures	2338.25	2339.06	2335.25	2337.16	23551.0
2016-09-30 08:00:00	ES	Futures	2337.16	2342.33	2336.07	2340.97	47398.0
2016-09-30 09:00:00	ES	Futures	2340.97	2349.13	2339.06	2342.33	274784.0
2016-09-30 10:00:00	ES	Futures	2342.06	2348.04	2341.24	2347.77	264007.0
2016-09-30 11:00:00	ES	Futures	2347.5	2355.66	2347.5	2352.12	275777.0
2016-09-30 12:00:00	ES	Futures	2352.4	2355.93	2351.58	2352.94	96226.0
2016-09-30 13:00:00	ES	Futures	2352.94	2355.39	2351.03	2354.84	91407.0
2016-09-30 14:00:00	ES	Futures	2355.12	2357.84	2354.3	2357.02	112008.0
2016-09-30 15:00:00	ES	Futures	2357.29	2359.74	2350.22	2351.31	423462.0
2016-09-30 16:00:00	ES	Futures	2351.31	2353.48	2347.23	2347.23	153975.0
2016-09-30 00:00:00	NQ	Futures	5762.04	5762.64	5760.25	5760.55	387.0
2016-09-30 01:00:00	NQ	Futures	5760.85	5761.74	5755.78	5755.78	574.0
2016-09-30 02:00:00	NQ	Futures	5756.07	5759.95	5752.2	5758.76	1592.0
2016-09-30 03:00:00	NQ	Futures	5759.36	5760.85	5742.05	5754.88	8220.0
2016-09-30 04:00:00	NQ	Futures	5754.58	5768.01	5749.21	5764.43	4989.0
2016-09-30 05:00:00	NQ	Futures	5764.73	5774.57	5762.64	5768.9	3320.0
2016-09-30 06:00:00	NQ	Futures	5768.6	5777.26	5761.15	5775.17	3802.0
2016-09-30 07:00:00	NQ	Futures	5775.47	5778.15	5769.8	5776.96	3228.0
2016-09-30 08:00:00	NQ	Futures	5776.96	5785.91	5775.47	5782.63	6170.0
2016-09-30 09:00:00	NQ	Futures	5782.92	5797.84	5779.05	5786.5	32532.0
2016-09-30 10:00:00	NQ	Futures	5786.8	5803.21	5777.85	5802.32	36622.0
2016-09-30 11:00:00	NQ	Futures	5802.02	5818.43	5801.42	5810.67	36298.0
2016-09-30 12:00:00	NQ	Futures	5810.97	5823.8	5810.37	5817.23	20749.0
2016-09-30 13:00:00	NQ	Futures	5817.23	5823.5	5812.46	5821.71	14983.0
2016-09-30 14:00:00	NQ	Futures	5822.01	5827.38	5819.92	5824.99	15880.0
2016-09-30 15:00:00	NQ	Futures	5825.29	5830.06	5809.77	5810.67	36242.0
2016-09-30 16:00:00	NQ	Futures	5810.67	5815.44	5803.21	5803.51	10904.0
2016-09-30 00:00:00	YM	Futures	19513.2	19514.3	19504.5	19505.6	334.0
2016-09-30 01:00:00	YM	Futures	19506.7	19509.9	19492.6	19493.7	663.0
2016-09-30 02:00:00	YM	Futures	19493.7	19499.1	19473.2	19493.7	2637.0
2016-09-30 03:00:00	YM	Futures	19494.8	19504.5	19441.8	19482.9	8809.0
2016-09-30 04:00:00	YM	Futures	19481.8	19528.3	19468.9	19517.5	4940.0
2016-09-30 05:00:00	YM	Futures	19517.5	19548.8	19508.8	19529.4	3407.0
2016-09-30 06:00:00	YM	Futures	19529.4	19555.3	19501.3	19546.7	2932.0
2016-09-30 07:00:00	YM	Futures	19548.8	19555.3	19525.1	19542.4	2603.0
2016-09-30 08:00:00	YM	Futures	19542.4	19585.6	19534.8	19571.5	5087.0
2016-09-30 09:00:00	YM	Futures	19572.6	19666.6	19562.9	19612.6	26437.0
2016-09-30 10:00:00	YM	Futures	19613.7	19661.2	19611.5	19651.5	20502.0
2016-09-30 11:00:00	YM	Futures	19650.4	19733.6	19648.3	19698.0	29273.0
2016-09-30 12:00:00	YM	Futures	19696.9	19727.2	19688.3	19703.4	8326.0
2016-09-30 13:00:00	YM	Futures	19703.4	19723.9	19692.6	19722.8	6901.0
2016-09-30 14:00:00	YM	Futures	19722.8	19733.6	19715.3	19728.2	8354.0
2016-09-30 15:00:00	YM	Futures	19729.3	19759.6	19681.8	19688.3	21422.0

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

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