PREVIEW / futures_1hour / 2015-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-24.parquet
  size:    50 KB
  rows:    1,515

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
2015-06-24 00:00:00	ES	Futures	2254.06	2254.06	2253.26	2253.26	851.0
2015-06-24 01:00:00	ES	Futures	2253.26	2253.79	2251.93	2251.93	2569.0
2015-06-24 02:00:00	ES	Futures	2251.93	2252.99	2250.86	2252.73	8245.0
2015-06-24 03:00:00	ES	Futures	2252.73	2255.12	2251.4	2252.73	13885.0
2015-06-24 04:00:00	ES	Futures	2252.73	2253.53	2250.86	2251.66	15719.0
2015-06-24 05:00:00	ES	Futures	2251.66	2253.79	2245.27	2245.54	50396.0
2015-06-24 06:00:00	ES	Futures	2245.8	2251.13	2245.54	2249.8	29238.0
2015-06-24 07:00:00	ES	Futures	2249.8	2251.13	2248.73	2249.27	21803.0
2015-06-24 08:00:00	ES	Futures	2249.27	2249.8	2247.14	2249.0	31243.0
2015-06-24 09:00:00	ES	Futures	2248.73	2252.46	2247.93	2250.6	132829.0
2015-06-24 10:00:00	ES	Futures	2250.6	2255.12	2249.27	2251.66	134899.0
2015-06-24 11:00:00	ES	Futures	2251.66	2251.93	2246.07	2247.14	112035.0
2015-06-24 12:00:00	ES	Futures	2247.14	2247.14	2241.81	2243.14	122881.0
2015-06-24 13:00:00	ES	Futures	2242.88	2244.47	2238.08	2240.75	110337.0
2015-06-24 14:00:00	ES	Futures	2240.48	2242.34	2237.82	2240.75	97160.0
2015-06-24 15:00:00	ES	Futures	2240.75	2241.81	2236.49	2236.49	182100.0
2015-06-24 16:00:00	ES	Futures	2236.75	2237.82	2235.42	2237.28	71349.0
2015-06-24 17:00:00	ES	Futures	2237.02	2238.08	2237.02	2237.55	1274.0
2015-06-24 18:00:00	ES	Futures	2237.82	2238.88	2237.55	2238.35	2477.0
2015-06-24 19:00:00	ES	Futures	2238.62	2238.88	2237.82	2238.62	1668.0
2015-06-24 20:00:00	ES	Futures	2238.88	2240.21	2238.62	2239.15	3326.0
2015-06-24 21:00:00	ES	Futures	2239.41	2241.28	2239.41	2239.68	3919.0
2015-06-24 22:00:00	ES	Futures	2239.95	2240.21	2238.88	2239.95	1682.0
2015-06-24 23:00:00	ES	Futures	2239.95	2241.01	2239.68	2240.75	1542.0
2015-06-24 00:00:00	NQ	Futures	5371.83	5372.72	5370.94	5371.24	112.0
2015-06-24 01:00:00	NQ	Futures	5370.94	5372.42	5368.28	5369.47	318.0
2015-06-24 02:00:00	NQ	Futures	5369.17	5371.24	5366.8	5370.94	721.0
2015-06-24 03:00:00	NQ	Futures	5370.94	5376.86	5367.99	5371.24	1456.0
2015-06-24 04:00:00	NQ	Futures	5371.54	5374.2	5367.39	5369.76	1444.0
2015-06-24 05:00:00	NQ	Futures	5369.76	5374.49	5354.97	5354.97	6629.0
2015-06-24 06:00:00	NQ	Futures	5354.97	5366.21	5354.97	5362.66	3990.0
2015-06-24 07:00:00	NQ	Futures	5362.66	5367.1	5361.48	5364.44	2575.0
2015-06-24 08:00:00	NQ	Futures	5363.85	5364.73	5358.52	5362.07	3977.0
2015-06-24 09:00:00	NQ	Futures	5362.07	5375.09	5359.7	5373.61	20847.0
2015-06-24 10:00:00	NQ	Futures	5373.31	5389.58	5371.24	5383.07	22864.0
2015-06-24 11:00:00	NQ	Futures	5383.07	5383.07	5368.28	5370.65	16890.0
2015-06-24 12:00:00	NQ	Futures	5370.65	5370.65	5357.04	5360.59	17958.0
2015-06-24 13:00:00	NQ	Futures	5360.59	5365.32	5346.1	5352.31	17349.0
2015-06-24 14:00:00	NQ	Futures	5352.31	5357.63	5344.91	5352.61	15665.0
2015-06-24 15:00:00	NQ	Futures	5352.9	5356.15	5342.84	5344.62	24339.0
2015-06-24 16:00:00	NQ	Futures	5344.62	5348.46	5341.37	5347.58	5920.0
2015-06-24 17:00:00	NQ	Futures	5347.87	5348.76	5346.99	5348.76	146.0
2015-06-24 18:00:00	NQ	Futures	5348.17	5350.53	5346.1	5349.65	307.0
2015-06-24 19:00:00	NQ	Futures	5349.65	5350.53	5348.46	5350.53	211.0
2015-06-24 20:00:00	NQ	Futures	5350.24	5353.2	5349.35	5351.42	351.0
2015-06-24 21:00:00	NQ	Futures	5351.72	5356.15	5351.42	5353.49	568.0
2015-06-24 22:00:00	NQ	Futures	5353.2	5354.38	5351.13	5353.79	301.0
2015-06-24 23:00:00	NQ	Futures	5353.79	5354.97	5352.61	5354.08	271.0
2015-06-24 00:00:00	YM	Futures	19028.7	19032.9	19024.4	19024.4	176.0
2015-06-24 01:00:00	YM	Futures	19025.5	19030.8	19017.1	19017.1	404.0

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

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