PREVIEW / futures_1hour / 2015-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-20.parquet
  size:    50 KB
  rows:    1,548

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-10-20 00:00:00	ES	Futures	2168.71	2168.98	2168.17	2168.44	1206.0
2015-10-20 01:00:00	ES	Futures	2168.71	2168.98	2166.57	2166.84	2825.0
2015-10-20 02:00:00	ES	Futures	2167.1	2168.71	2165.23	2167.37	7885.0
2015-10-20 03:00:00	ES	Futures	2167.1	2169.78	2167.1	2168.98	14663.0
2015-10-20 04:00:00	ES	Futures	2168.98	2169.24	2161.48	2162.02	19776.0
2015-10-20 05:00:00	ES	Futures	2162.02	2163.62	2161.22	2162.29	12553.0
2015-10-20 06:00:00	ES	Futures	2162.55	2163.62	2161.22	2162.82	9202.0
2015-10-20 07:00:00	ES	Futures	2163.09	2166.03	2162.55	2165.77	13530.0
2015-10-20 08:00:00	ES	Futures	2165.5	2167.64	2164.96	2165.23	23887.0
2015-10-20 09:00:00	ES	Futures	2165.5	2168.44	2161.48	2167.91	154010.0
2015-10-20 10:00:00	ES	Futures	2168.17	2174.33	2166.57	2172.72	211524.0
2015-10-20 11:00:00	ES	Futures	2172.99	2172.99	2164.43	2166.3	178246.0
2015-10-20 12:00:00	ES	Futures	2166.57	2168.17	2162.55	2166.03	117895.0
2015-10-20 13:00:00	ES	Futures	2165.77	2167.37	2160.41	2162.82	114711.0
2015-10-20 14:00:00	ES	Futures	2162.82	2168.17	2161.22	2167.64	121555.0
2015-10-20 15:00:00	ES	Futures	2167.91	2169.51	2163.89	2166.57	183911.0
2015-10-20 16:00:00	ES	Futures	2166.3	2166.84	2161.22	2161.75	51924.0
2015-10-20 18:00:00	ES	Futures	2161.75	2161.75	2157.47	2161.48	6336.0
2015-10-20 19:00:00	ES	Futures	2161.48	2162.55	2160.41	2160.68	2677.0
2015-10-20 20:00:00	ES	Futures	2160.68	2166.03	2160.41	2165.23	7972.0
2015-10-20 21:00:00	ES	Futures	2165.23	2165.77	2163.36	2164.43	2992.0
2015-10-20 22:00:00	ES	Futures	2164.43	2165.77	2164.43	2165.23	1769.0
2015-10-20 23:00:00	ES	Futures	2165.23	2167.37	2165.23	2167.37	3555.0
2015-10-20 00:00:00	NQ	Futures	5279.32	5279.91	5277.54	5278.43	287.0
2015-10-20 01:00:00	NQ	Futures	5278.43	5279.62	5273.69	5275.46	737.0
2015-10-20 02:00:00	NQ	Futures	5275.46	5281.1	5271.02	5276.95	1292.0
2015-10-20 03:00:00	NQ	Futures	5276.95	5284.66	5276.65	5282.58	2027.0
2015-10-20 04:00:00	NQ	Futures	5282.88	5283.17	5263.61	5265.09	2718.0
2015-10-20 05:00:00	NQ	Futures	5265.09	5269.83	5263.61	5266.57	1770.0
2015-10-20 06:00:00	NQ	Futures	5266.87	5269.83	5264.79	5267.76	1345.0
2015-10-20 07:00:00	NQ	Futures	5267.46	5275.46	5266.87	5273.69	1907.0
2015-10-20 08:00:00	NQ	Futures	5273.39	5280.21	5273.09	5275.17	4240.0
2015-10-20 09:00:00	NQ	Futures	5275.76	5279.32	5257.38	5271.61	29003.0
2015-10-20 10:00:00	NQ	Futures	5271.61	5281.69	5268.35	5275.17	31266.0
2015-10-20 11:00:00	NQ	Futures	5275.17	5275.46	5254.41	5260.05	29802.0
2015-10-20 12:00:00	NQ	Futures	5260.64	5266.27	5245.82	5261.53	21638.0
2015-10-20 13:00:00	NQ	Futures	5261.23	5261.23	5234.85	5242.55	20091.0
2015-10-20 14:00:00	NQ	Futures	5242.85	5255.3	5236.33	5255.3	16922.0
2015-10-20 15:00:00	NQ	Futures	5255.3	5259.16	5244.93	5253.82	24435.0
2015-10-20 16:00:00	NQ	Futures	5254.12	5255.01	5244.93	5245.22	5499.0
2015-10-20 18:00:00	NQ	Futures	5245.22	5245.82	5236.03	5244.63	1319.0
2015-10-20 19:00:00	NQ	Futures	5244.93	5248.19	5242.26	5243.74	399.0
2015-10-20 20:00:00	NQ	Futures	5244.33	5258.56	5243.44	5255.01	1392.0
2015-10-20 21:00:00	NQ	Futures	5255.6	5257.38	5250.26	5253.23	643.0
2015-10-20 22:00:00	NQ	Futures	5252.93	5256.79	5252.93	5255.9	443.0
2015-10-20 23:00:00	NQ	Futures	5256.19	5262.72	5256.19	5261.53	745.0
2015-10-20 00:00:00	YM	Futures	18114.3	18115.4	18107.9	18111.1	110.0
2015-10-20 01:00:00	YM	Futures	18112.2	18114.3	18096.3	18099.5	449.0
2015-10-20 02:00:00	YM	Futures	18100.5	18115.4	18092.0	18106.9	979.0
2015-10-20 03:00:00	YM	Futures	18105.8	18124.9	18105.8	18114.3	1817.0

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

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