PREVIEW / futures_1hour / 2016-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-01.parquet
  size:    52 KB
  rows:    1,600

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-08-01 00:00:00	ES	Futures	2361.22	2361.49	2360.41	2360.68	1796.0
2016-08-01 01:00:00	ES	Futures	2360.95	2361.49	2359.86	2361.49	4442.0
2016-08-01 02:00:00	ES	Futures	2361.49	2362.3	2360.14	2360.41	7636.0
2016-08-01 03:00:00	ES	Futures	2360.41	2361.49	2358.51	2358.51	16149.0
2016-08-01 04:00:00	ES	Futures	2358.51	2359.32	2355.25	2355.53	18583.0
2016-08-01 05:00:00	ES	Futures	2355.8	2356.34	2353.36	2353.63	16537.0
2016-08-01 06:00:00	ES	Futures	2353.63	2354.44	2352.27	2353.36	13628.0
2016-08-01 07:00:00	ES	Futures	2353.36	2355.25	2353.08	2355.25	20168.0
2016-08-01 08:00:00	ES	Futures	2354.98	2355.53	2351.73	2352.27	27688.0
2016-08-01 09:00:00	ES	Futures	2352.0	2354.17	2345.49	2349.29	213721.0
2016-08-01 10:00:00	ES	Futures	2348.75	2353.63	2347.39	2353.08	228738.0
2016-08-01 11:00:00	ES	Futures	2353.08	2356.88	2350.37	2350.64	161824.0
2016-08-01 12:00:00	ES	Futures	2350.64	2350.64	2342.78	2345.76	196706.0
2016-08-01 13:00:00	ES	Futures	2345.76	2349.29	2344.14	2348.75	139753.0
2016-08-01 14:00:00	ES	Futures	2348.75	2350.37	2345.76	2348.2	168153.0
2016-08-01 15:00:00	ES	Futures	2348.47	2349.02	2343.32	2348.2	291221.0
2016-08-01 16:00:00	ES	Futures	2348.47	2349.29	2347.12	2349.02	78222.0
2016-08-01 18:00:00	ES	Futures	2349.56	2349.56	2347.93	2348.75	3215.0
2016-08-01 19:00:00	ES	Futures	2348.75	2349.56	2348.47	2349.02	1956.0
2016-08-01 20:00:00	ES	Futures	2349.02	2352.27	2348.75	2351.73	7331.0
2016-08-01 21:00:00	ES	Futures	2351.46	2353.63	2350.92	2353.63	5236.0
2016-08-01 22:00:00	ES	Futures	2353.63	2354.98	2352.27	2352.54	6294.0
2016-08-01 23:00:00	ES	Futures	2352.54	2352.54	2351.19	2351.46	2911.0
2016-08-01 00:00:00	NQ	Futures	5654.63	5654.93	5650.46	5651.65	502.0
2016-08-01 01:00:00	NQ	Futures	5651.65	5653.44	5649.87	5653.44	566.0
2016-08-01 02:00:00	NQ	Futures	5653.14	5655.83	5650.76	5650.76	1005.0
2016-08-01 03:00:00	NQ	Futures	5650.76	5654.63	5647.78	5648.38	1994.0
2016-08-01 04:00:00	NQ	Futures	5648.08	5651.06	5641.52	5641.82	1896.0
2016-08-01 05:00:00	NQ	Futures	5642.12	5644.2	5637.05	5637.94	2361.0
2016-08-01 06:00:00	NQ	Futures	5637.65	5638.84	5634.07	5637.35	1561.0
2016-08-01 07:00:00	NQ	Futures	5637.35	5642.12	5635.86	5641.82	2334.0
2016-08-01 08:00:00	NQ	Futures	5641.82	5643.31	5635.26	5636.45	2805.0
2016-08-01 09:00:00	NQ	Futures	5636.45	5644.8	5628.41	5643.9	25968.0
2016-08-01 10:00:00	NQ	Futures	5643.9	5666.85	5641.52	5665.36	34258.0
2016-08-01 11:00:00	NQ	Futures	5665.07	5675.2	5661.79	5664.17	20573.0
2016-08-01 12:00:00	NQ	Futures	5663.87	5663.87	5642.71	5650.46	26315.0
2016-08-01 13:00:00	NQ	Futures	5650.46	5662.38	5648.08	5660.6	14985.0
2016-08-01 14:00:00	NQ	Futures	5660.6	5664.47	5652.85	5662.09	18637.0
2016-08-01 15:00:00	NQ	Futures	5661.79	5662.98	5649.57	5660.89	28879.0
2016-08-01 16:00:00	NQ	Futures	5660.89	5662.38	5655.23	5660.6	6903.0
2016-08-01 18:00:00	NQ	Futures	5662.09	5662.09	5655.53	5660.0	642.0
2016-08-01 19:00:00	NQ	Futures	5660.0	5662.68	5658.81	5660.89	491.0
2016-08-01 20:00:00	NQ	Futures	5660.89	5668.34	5660.6	5666.85	964.0
2016-08-01 21:00:00	NQ	Futures	5667.15	5674.01	5665.36	5671.33	1112.0
2016-08-01 22:00:00	NQ	Futures	5671.33	5674.31	5668.64	5669.54	1139.0
2016-08-01 23:00:00	NQ	Futures	5669.83	5670.13	5666.85	5667.75	570.0
2016-08-01 00:00:00	YM	Futures	19850.6	19850.6	19838.8	19843.1	522.0
2016-08-01 01:00:00	YM	Futures	19844.1	19848.4	19835.5	19845.2	684.0
2016-08-01 02:00:00	YM	Futures	19846.3	19854.9	19838.8	19838.8	1323.0
2016-08-01 03:00:00	YM	Futures	19838.8	19850.6	19828.0	19828.0	2341.0

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

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