PREVIEW / futures_1hour / 2015-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-20.parquet
  size:    53 KB
  rows:    1,570

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-08-20 00:00:00	ES	Futures	2211.19	2212.79	2210.13	2210.93	4114.0
2015-08-20 01:00:00	ES	Futures	2210.93	2211.19	2207.46	2207.73	6343.0
2015-08-20 02:00:00	ES	Futures	2207.46	2208.26	2201.34	2203.47	18156.0
2015-08-20 03:00:00	ES	Futures	2203.47	2207.2	2200.01	2200.81	32020.0
2015-08-20 04:00:00	ES	Futures	2201.07	2202.67	2193.35	2195.48	39926.0
2015-08-20 05:00:00	ES	Futures	2195.48	2196.55	2186.96	2193.89	52808.0
2015-08-20 06:00:00	ES	Futures	2194.15	2195.48	2190.16	2191.22	30567.0
2015-08-20 07:00:00	ES	Futures	2190.96	2194.68	2188.83	2193.89	41136.0
2015-08-20 08:00:00	ES	Futures	2193.89	2198.68	2190.69	2196.28	56832.0
2015-08-20 09:00:00	ES	Futures	2196.28	2199.21	2188.83	2190.16	367338.0
2015-08-20 10:00:00	ES	Futures	2189.89	2191.76	2180.84	2187.76	410623.0
2015-08-20 11:00:00	ES	Futures	2187.76	2189.36	2181.9	2188.29	245751.0
2015-08-20 12:00:00	ES	Futures	2188.29	2188.56	2175.51	2177.38	230759.0
2015-08-20 13:00:00	ES	Futures	2177.38	2184.57	2175.78	2183.5	211816.0
2015-08-20 14:00:00	ES	Futures	2183.5	2183.77	2170.99	2171.79	200702.0
2015-08-20 15:00:00	ES	Futures	2171.79	2178.18	2164.33	2164.33	388513.0
2015-08-20 16:00:00	ES	Futures	2164.6	2165.13	2156.08	2157.68	205725.0
2015-08-20 17:00:00	ES	Futures	2157.68	2157.94	2156.61	2156.88	3351.0
2015-08-20 18:00:00	ES	Futures	2157.94	2159.54	2157.14	2158.74	8692.0
2015-08-20 19:00:00	ES	Futures	2158.74	2160.07	2157.41	2159.54	7122.0
2015-08-20 20:00:00	ES	Futures	2159.81	2160.87	2158.74	2160.34	8322.0
2015-08-20 21:00:00	ES	Futures	2160.07	2160.6	2146.23	2146.76	40277.0
2015-08-20 22:00:00	ES	Futures	2147.03	2150.49	2139.3	2141.7	43686.0
2015-08-20 23:00:00	ES	Futures	2141.43	2150.75	2140.9	2148.62	28217.0
2015-08-20 00:00:00	NQ	Futures	5338.7	5339.59	5334.56	5336.34	709.0
2015-08-20 01:00:00	NQ	Futures	5336.34	5336.93	5327.46	5327.76	1338.0
2015-08-20 02:00:00	NQ	Futures	5328.35	5329.53	5313.27	5319.77	2878.0
2015-08-20 03:00:00	NQ	Futures	5320.07	5329.53	5309.42	5312.67	4032.0
2015-08-20 04:00:00	NQ	Futures	5312.67	5317.41	5292.56	5298.48	6017.0
2015-08-20 05:00:00	NQ	Futures	5298.77	5301.73	5278.66	5294.63	7493.0
2015-08-20 06:00:00	NQ	Futures	5295.52	5298.48	5285.46	5289.01	6027.0
2015-08-20 07:00:00	NQ	Futures	5289.31	5297.0	5284.57	5294.33	6875.0
2015-08-20 08:00:00	NQ	Futures	5294.63	5307.35	5288.42	5299.07	7025.0
2015-08-20 09:00:00	NQ	Futures	5299.36	5303.21	5273.63	5276.88	63960.0
2015-08-20 10:00:00	NQ	Futures	5276.88	5281.62	5227.78	5247.01	104570.0
2015-08-20 11:00:00	NQ	Futures	5247.3	5253.22	5227.19	5244.64	37027.0
2015-08-20 12:00:00	NQ	Futures	5244.64	5244.94	5207.37	5210.92	35295.0
2015-08-20 13:00:00	NQ	Futures	5210.92	5230.74	5205.89	5226.6	33113.0
2015-08-20 14:00:00	NQ	Futures	5226.6	5227.19	5200.27	5204.71	31977.0
2015-08-20 15:00:00	NQ	Futures	5204.71	5225.12	5186.96	5187.55	59450.0
2015-08-20 16:00:00	NQ	Futures	5187.55	5189.33	5158.57	5163.0	28246.0
2015-08-20 17:00:00	NQ	Futures	5163.0	5163.6	5159.45	5160.93	504.0
2015-08-20 18:00:00	NQ	Futures	5167.74	5167.74	5160.93	5164.78	1352.0
2015-08-20 19:00:00	NQ	Futures	5165.07	5167.74	5161.82	5165.96	630.0
2015-08-20 20:00:00	NQ	Futures	5166.55	5168.33	5163.6	5166.85	1033.0
2015-08-20 21:00:00	NQ	Futures	5166.85	5167.44	5135.2	5136.97	5963.0
2015-08-20 22:00:00	NQ	Futures	5136.09	5148.21	5121.59	5127.81	8413.0
2015-08-20 23:00:00	NQ	Futures	5127.21	5144.07	5125.44	5139.93	3984.0
2015-08-20 00:00:00	YM	Futures	18239.6	18245.9	18231.2	18235.4	519.0
2015-08-20 01:00:00	YM	Futures	18236.4	18236.4	18208.0	18210.1	1218.0

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

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