PREVIEW / futures_1hour / 2016-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-05.parquet
  size:    56 KB
  rows:    1,589

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-07-05 00:00:00	ES	Futures	2270.1	2270.64	2268.47	2269.02	3625.0
2016-07-05 01:00:00	ES	Futures	2268.75	2270.64	2268.75	2270.1	3563.0
2016-07-05 02:00:00	ES	Futures	2270.37	2270.64	2264.68	2264.68	15727.0
2016-07-05 03:00:00	ES	Futures	2264.95	2267.12	2260.88	2261.15	48696.0
2016-07-05 04:00:00	ES	Futures	2261.42	2262.51	2258.44	2259.53	25026.0
2016-07-05 05:00:00	ES	Futures	2259.53	2261.97	2258.71	2261.15	23227.0
2016-07-05 06:00:00	ES	Futures	2261.15	2264.95	2260.34	2264.14	19972.0
2016-07-05 07:00:00	ES	Futures	2264.14	2264.68	2257.9	2258.17	37709.0
2016-07-05 08:00:00	ES	Futures	2258.44	2262.51	2257.36	2262.24	42313.0
2016-07-05 09:00:00	ES	Futures	2261.97	2263.32	2253.56	2256.0	223510.0
2016-07-05 10:00:00	ES	Futures	2256.0	2259.8	2252.75	2255.46	300522.0
2016-07-05 11:00:00	ES	Futures	2255.46	2258.44	2250.3	2253.29	243920.0
2016-07-05 12:00:00	ES	Futures	2253.56	2256.27	2251.93	2253.56	107580.0
2016-07-05 13:00:00	ES	Futures	2253.29	2254.1	2248.14	2249.76	100735.0
2016-07-05 14:00:00	ES	Futures	2249.76	2255.19	2248.14	2251.12	150159.0
2016-07-05 15:00:00	ES	Futures	2251.12	2260.07	2250.58	2256.0	256562.0
2016-07-05 16:00:00	ES	Futures	2256.0	2261.15	2255.73	2261.15	79956.0
2016-07-05 18:00:00	ES	Futures	2260.61	2260.61	2257.08	2258.17	4292.0
2016-07-05 19:00:00	ES	Futures	2258.17	2258.98	2255.19	2256.27	6605.0
2016-07-05 20:00:00	ES	Futures	2256.0	2256.54	2251.66	2253.83	13662.0
2016-07-05 21:00:00	ES	Futures	2253.83	2253.83	2245.97	2247.59	20293.0
2016-07-05 22:00:00	ES	Futures	2247.32	2247.86	2242.71	2246.51	20841.0
2016-07-05 23:00:00	ES	Futures	2246.24	2248.68	2244.61	2248.41	8636.0
2016-07-05 00:00:00	NQ	Futures	5278.2	5278.79	5273.13	5273.72	327.0
2016-07-05 01:00:00	NQ	Futures	5273.72	5277.3	5273.72	5276.7	374.0
2016-07-05 02:00:00	NQ	Futures	5277.6	5278.2	5265.98	5265.98	1680.0
2016-07-05 03:00:00	NQ	Futures	5265.98	5270.45	5252.56	5253.46	4825.0
2016-07-05 04:00:00	NQ	Futures	5253.16	5257.33	5250.18	5252.26	3758.0
2016-07-05 05:00:00	NQ	Futures	5251.97	5257.03	5249.88	5254.05	1720.0
2016-07-05 06:00:00	NQ	Futures	5254.05	5263.29	5252.26	5261.5	1535.0
2016-07-05 07:00:00	NQ	Futures	5261.5	5262.7	5247.2	5248.99	2823.0
2016-07-05 08:00:00	NQ	Futures	5249.28	5257.63	5247.2	5256.44	3753.0
2016-07-05 09:00:00	NQ	Futures	5256.74	5260.61	5232.3	5242.43	29338.0
2016-07-05 10:00:00	NQ	Futures	5242.13	5254.05	5230.21	5239.15	29879.0
2016-07-05 11:00:00	NQ	Futures	5239.15	5248.09	5228.12	5234.08	24673.0
2016-07-05 12:00:00	NQ	Futures	5234.38	5244.52	5232.3	5236.77	12645.0
2016-07-05 13:00:00	NQ	Futures	5236.77	5239.75	5219.48	5224.55	13696.0
2016-07-05 14:00:00	NQ	Futures	5224.25	5238.26	5218.88	5229.31	15444.0
2016-07-05 15:00:00	NQ	Futures	5229.31	5254.35	5226.63	5247.79	25010.0
2016-07-05 16:00:00	NQ	Futures	5247.79	5255.84	5245.71	5254.35	7200.0
2016-07-05 18:00:00	NQ	Futures	5252.86	5254.95	5245.11	5246.9	657.0
2016-07-05 19:00:00	NQ	Futures	5247.2	5248.69	5239.75	5242.73	1049.0
2016-07-05 20:00:00	NQ	Futures	5241.83	5243.32	5231.1	5236.47	1388.0
2016-07-05 21:00:00	NQ	Futures	5236.47	5236.47	5217.39	5219.48	2470.0
2016-07-05 22:00:00	NQ	Futures	5219.48	5220.37	5207.85	5215.6	2274.0
2016-07-05 23:00:00	NQ	Futures	5215.6	5220.97	5211.73	5220.37	1269.0
2016-07-05 00:00:00	YM	Futures	19193.0	19196.3	19175.8	19180.1	603.0
2016-07-05 01:00:00	YM	Futures	19180.1	19197.3	19180.1	19196.3	751.0
2016-07-05 02:00:00	YM	Futures	19196.3	19200.6	19157.5	19158.6	1623.0
2016-07-05 03:00:00	YM	Futures	19158.6	19173.7	19120.9	19123.1	6249.0

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

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