PREVIEW / futures_1hour / 2016-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-26.parquet
  size:    51 KB
  rows:    1,596

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-05-26 00:00:00	ES	Futures	2250.28	2251.36	2249.74	2251.36	1851.0
2016-05-26 01:00:00	ES	Futures	2251.09	2252.17	2250.28	2252.17	5512.0
2016-05-26 02:00:00	ES	Futures	2252.17	2254.06	2251.63	2252.98	7927.0
2016-05-26 03:00:00	ES	Futures	2252.98	2257.84	2252.44	2255.95	24848.0
2016-05-26 04:00:00	ES	Futures	2255.95	2256.49	2251.9	2252.17	15441.0
2016-05-26 05:00:00	ES	Futures	2252.44	2255.41	2251.9	2254.87	8615.0
2016-05-26 06:00:00	ES	Futures	2255.14	2258.11	2254.33	2257.03	13539.0
2016-05-26 07:00:00	ES	Futures	2257.03	2258.38	2255.41	2257.57	13754.0
2016-05-26 08:00:00	ES	Futures	2257.84	2258.65	2255.14	2256.22	30495.0
2016-05-26 09:00:00	ES	Futures	2256.22	2258.92	2251.36	2251.9	180502.0
2016-05-26 10:00:00	ES	Futures	2251.9	2257.03	2251.36	2251.63	187411.0
2016-05-26 11:00:00	ES	Futures	2251.36	2255.14	2250.82	2253.79	102780.0
2016-05-26 12:00:00	ES	Futures	2254.06	2255.41	2251.9	2252.71	61107.0
2016-05-26 13:00:00	ES	Futures	2252.71	2255.41	2251.63	2254.6	57050.0
2016-05-26 14:00:00	ES	Futures	2254.6	2256.76	2254.06	2255.41	67366.0
2016-05-26 15:00:00	ES	Futures	2255.14	2257.57	2253.79	2254.6	96775.0
2016-05-26 16:00:00	ES	Futures	2254.33	2258.11	2254.33	2257.84	54259.0
2016-05-26 18:00:00	ES	Futures	2257.57	2258.11	2256.76	2257.84	2377.0
2016-05-26 19:00:00	ES	Futures	2257.84	2258.92	2257.57	2258.65	2310.0
2016-05-26 20:00:00	ES	Futures	2258.38	2259.73	2257.84	2259.46	5180.0
2016-05-26 21:00:00	ES	Futures	2259.73	2259.73	2255.41	2256.49	7986.0
2016-05-26 22:00:00	ES	Futures	2256.76	2257.03	2255.95	2255.95	2007.0
2016-05-26 23:00:00	ES	Futures	2255.95	2258.38	2255.95	2257.57	3099.0
2016-05-26 00:00:00	NQ	Futures	5317.15	5320.43	5316.56	5319.24	317.0
2016-05-26 01:00:00	NQ	Futures	5319.83	5323.7	5317.15	5323.1	1439.0
2016-05-26 02:00:00	NQ	Futures	5323.1	5327.57	5320.72	5325.19	1156.0
2016-05-26 03:00:00	NQ	Futures	5325.19	5337.39	5324.29	5333.82	2816.0
2016-05-26 04:00:00	NQ	Futures	5333.82	5335.3	5324.0	5324.89	2098.0
2016-05-26 05:00:00	NQ	Futures	5324.89	5332.62	5324.59	5330.84	876.0
2016-05-26 06:00:00	NQ	Futures	5330.84	5337.98	5329.95	5334.71	1511.0
2016-05-26 07:00:00	NQ	Futures	5335.3	5337.68	5330.84	5335.9	1551.0
2016-05-26 08:00:00	NQ	Futures	5336.2	5340.96	5329.35	5332.92	4528.0
2016-05-26 09:00:00	NQ	Futures	5332.62	5338.87	5319.83	5320.72	31620.0
2016-05-26 10:00:00	NQ	Futures	5321.02	5341.55	5318.34	5329.05	33000.0
2016-05-26 11:00:00	NQ	Futures	5329.05	5338.87	5326.38	5332.03	20098.0
2016-05-26 12:00:00	NQ	Futures	5332.03	5335.9	5327.27	5329.65	10277.0
2016-05-26 13:00:00	NQ	Futures	5329.95	5339.47	5327.86	5337.68	9660.0
2016-05-26 14:00:00	NQ	Futures	5337.68	5344.53	5336.79	5341.25	11373.0
2016-05-26 15:00:00	NQ	Futures	5341.25	5348.39	5337.98	5340.96	19170.0
2016-05-26 16:00:00	NQ	Futures	5341.25	5350.18	5340.66	5348.99	4680.0
2016-05-26 18:00:00	NQ	Futures	5348.39	5348.69	5346.01	5347.8	496.0
2016-05-26 19:00:00	NQ	Futures	5347.8	5350.77	5347.5	5349.58	373.0
2016-05-26 20:00:00	NQ	Futures	5349.29	5355.83	5347.5	5355.83	1075.0
2016-05-26 21:00:00	NQ	Futures	5356.13	5356.43	5344.82	5347.2	1271.0
2016-05-26 22:00:00	NQ	Futures	5347.2	5348.39	5345.42	5346.61	409.0
2016-05-26 23:00:00	NQ	Futures	5346.31	5350.48	5346.31	5349.58	471.0
2016-05-26 00:00:00	YM	Futures	19052.9	19063.6	19048.7	19060.4	389.0
2016-05-26 01:00:00	YM	Futures	19061.5	19066.9	19050.8	19065.8	761.0
2016-05-26 02:00:00	YM	Futures	19065.8	19079.7	19061.5	19076.5	1491.0
2016-05-26 03:00:00	YM	Futures	19076.5	19112.9	19074.3	19101.1	3360.0

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

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