PREVIEW / futures_1hour / 2015-06-18

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-18.parquet
  size:    52 KB
  rows:    1,561

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-18 00:00:00	ES	Futures	2220.24	2220.78	2218.91	2219.98	3054.0
2015-06-18 01:00:00	ES	Futures	2219.98	2219.98	2217.32	2217.85	3567.0
2015-06-18 02:00:00	ES	Futures	2218.11	2225.04	2218.11	2225.04	15723.0
2015-06-18 03:00:00	ES	Futures	2224.77	2229.3	2223.17	2228.76	26637.0
2015-06-18 04:00:00	ES	Futures	2228.5	2228.76	2222.11	2226.63	21068.0
2015-06-18 05:00:00	ES	Futures	2226.63	2228.5	2221.04	2227.7	28389.0
2015-06-18 06:00:00	ES	Futures	2227.7	2232.76	2226.63	2231.16	33835.0
2015-06-18 07:00:00	ES	Futures	2231.16	2231.69	2228.76	2230.89	22039.0
2015-06-18 08:00:00	ES	Futures	2230.89	2233.82	2230.1	2231.16	34728.0
2015-06-18 09:00:00	ES	Futures	2231.43	2242.61	2230.1	2241.01	220752.0
2015-06-18 10:00:00	ES	Futures	2241.01	2248.73	2240.75	2248.2	264231.0
2015-06-18 11:00:00	ES	Futures	2248.47	2252.46	2248.2	2250.6	205179.0
2015-06-18 12:00:00	ES	Futures	2250.33	2256.99	2249.8	2251.13	258826.0
2015-06-18 13:00:00	ES	Futures	2251.13	2252.73	2247.14	2248.47	133497.0
2015-06-18 14:00:00	ES	Futures	2248.73	2253.26	2247.93	2252.99	85202.0
2015-06-18 15:00:00	ES	Futures	2252.99	2254.32	2249.53	2250.86	193611.0
2015-06-18 16:00:00	ES	Futures	2250.6	2252.46	2250.6	2251.66	85320.0
2015-06-18 17:00:00	ES	Futures	2251.66	2252.73	2251.66	2252.19	2501.0
2015-06-18 18:00:00	ES	Futures	2252.19	2252.46	2248.2	2248.73	6825.0
2015-06-18 19:00:00	ES	Futures	2248.73	2251.13	2248.73	2250.33	1751.0
2015-06-18 20:00:00	ES	Futures	2250.33	2251.13	2249.0	2249.8	3353.0
2015-06-18 21:00:00	ES	Futures	2249.8	2250.33	2249.27	2250.33	1916.0
2015-06-18 22:00:00	ES	Futures	2250.06	2250.33	2249.53	2250.33	1198.0
2015-06-18 23:00:00	ES	Futures	2250.06	2250.33	2249.53	2249.8	1687.0
2015-06-18 00:00:00	NQ	Futures	5257.95	5260.02	5256.47	5258.25	404.0
2015-06-18 01:00:00	NQ	Futures	5258.25	5258.25	5253.22	5254.11	368.0
2015-06-18 02:00:00	NQ	Futures	5254.4	5269.19	5254.11	5268.6	952.0
2015-06-18 03:00:00	NQ	Futures	5268.9	5282.8	5264.76	5279.25	2818.0
2015-06-18 04:00:00	NQ	Futures	5279.84	5280.14	5260.91	5271.26	3426.0
2015-06-18 05:00:00	NQ	Futures	5270.08	5279.84	5258.25	5278.07	5422.0
2015-06-18 06:00:00	NQ	Futures	5278.07	5289.6	5275.4	5286.64	3827.0
2015-06-18 07:00:00	NQ	Futures	5286.64	5288.12	5281.02	5284.57	2440.0
2015-06-18 08:00:00	NQ	Futures	5284.28	5295.52	5283.39	5287.83	5378.0
2015-06-18 09:00:00	NQ	Futures	5288.12	5328.94	5285.46	5326.28	40937.0
2015-06-18 10:00:00	NQ	Futures	5325.98	5350.83	5324.51	5349.06	43258.0
2015-06-18 11:00:00	NQ	Futures	5348.76	5360.3	5348.76	5354.68	23407.0
2015-06-18 12:00:00	NQ	Futures	5354.97	5365.62	5352.31	5353.2	34400.0
2015-06-18 13:00:00	NQ	Futures	5353.79	5357.93	5343.73	5345.8	18828.0
2015-06-18 14:00:00	NQ	Futures	5345.8	5362.37	5344.62	5360.3	16780.0
2015-06-18 15:00:00	NQ	Futures	5360.3	5363.25	5350.53	5353.2	29107.0
2015-06-18 16:00:00	NQ	Futures	5353.2	5361.77	5351.72	5360.0	10741.0
2015-06-18 17:00:00	NQ	Futures	5360.0	5362.66	5359.7	5361.48	268.0
2015-06-18 18:00:00	NQ	Futures	5359.7	5360.59	5352.01	5353.2	852.0
2015-06-18 19:00:00	NQ	Futures	5353.2	5358.23	5353.2	5356.75	214.0
2015-06-18 20:00:00	NQ	Futures	5356.45	5357.93	5354.38	5356.45	309.0
2015-06-18 21:00:00	NQ	Futures	5355.86	5358.52	5355.56	5358.23	376.0
2015-06-18 22:00:00	NQ	Futures	5357.93	5359.11	5357.04	5358.23	278.0
2015-06-18 23:00:00	NQ	Futures	5357.93	5358.52	5355.86	5357.34	217.0
2015-06-18 00:00:00	YM	Futures	18749.5	18752.6	18738.9	18745.3	404.0
2015-06-18 01:00:00	YM	Futures	18746.3	18746.3	18727.4	18730.5	557.0

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

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