PREVIEW / futures_1hour / 2015-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-09.parquet
  size:    49 KB
  rows:    1,536

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-03-09 00:00:00	ES	Futures	2176.27	2177.32	2176.0	2176.27	1637.0
2015-03-09 01:00:00	ES	Futures	2176.53	2177.84	2176.0	2177.58	1714.0
2015-03-09 02:00:00	ES	Futures	2177.58	2178.63	2177.32	2178.63	1937.0
2015-03-09 03:00:00	ES	Futures	2178.37	2178.63	2177.32	2177.58	8141.0
2015-03-09 04:00:00	ES	Futures	2177.58	2177.58	2174.69	2175.48	24148.0
2015-03-09 05:00:00	ES	Futures	2175.74	2177.58	2175.21	2175.74	13527.0
2015-03-09 06:00:00	ES	Futures	2175.48	2177.06	2174.95	2176.0	10451.0
2015-03-09 07:00:00	ES	Futures	2176.0	2181.0	2175.21	2180.74	22901.0
2015-03-09 08:00:00	ES	Futures	2180.48	2183.11	2179.95	2182.32	22708.0
2015-03-09 09:00:00	ES	Futures	2182.32	2184.16	2179.16	2183.37	197338.0
2015-03-09 10:00:00	ES	Futures	2183.11	2186.53	2181.53	2184.42	169880.0
2015-03-09 11:00:00	ES	Futures	2184.42	2187.32	2182.32	2184.42	123352.0
2015-03-09 12:00:00	ES	Futures	2184.16	2187.06	2182.06	2186.79	97156.0
2015-03-09 13:00:00	ES	Futures	2186.53	2192.05	2185.48	2190.48	97952.0
2015-03-09 14:00:00	ES	Futures	2190.48	2190.74	2185.74	2189.95	104888.0
2015-03-09 15:00:00	ES	Futures	2189.95	2191.27	2187.06	2187.84	145334.0
2015-03-09 16:00:00	ES	Futures	2187.84	2188.63	2186.79	2187.06	54000.0
2015-03-09 17:00:00	ES	Futures	2187.06	2187.32	2186.79	2187.32	1597.0
2015-03-09 18:00:00	ES	Futures	2186.79	2187.32	2185.74	2185.74	3730.0
2015-03-09 19:00:00	ES	Futures	2186.0	2186.27	2185.21	2185.74	2107.0
2015-03-09 20:00:00	ES	Futures	2185.74	2186.79	2184.42	2184.42	2960.0
2015-03-09 21:00:00	ES	Futures	2184.69	2186.27	2184.69	2184.69	2728.0
2015-03-09 22:00:00	ES	Futures	2184.95	2186.0	2184.69	2185.48	2092.0
2015-03-09 23:00:00	ES	Futures	2185.48	2186.0	2184.69	2185.21	3008.0
2015-03-09 00:00:00	NQ	Futures	5168.62	5171.56	5168.62	5170.09	270.0
2015-03-09 01:00:00	NQ	Futures	5170.09	5172.73	5169.5	5171.85	272.0
2015-03-09 02:00:00	NQ	Futures	5172.44	5174.5	5171.56	5173.32	525.0
2015-03-09 03:00:00	NQ	Futures	5173.32	5173.61	5169.8	5170.68	1275.0
2015-03-09 04:00:00	NQ	Futures	5170.38	5170.97	5164.51	5167.45	4480.0
2015-03-09 05:00:00	NQ	Futures	5167.74	5171.56	5166.86	5167.15	2348.0
2015-03-09 06:00:00	NQ	Futures	5167.15	5170.09	5164.8	5166.86	2794.0
2015-03-09 07:00:00	NQ	Futures	5167.15	5180.08	5164.8	5179.49	4070.0
2015-03-09 08:00:00	NQ	Futures	5179.78	5185.07	5176.85	5183.89	3718.0
2015-03-09 09:00:00	NQ	Futures	5184.19	5184.77	5159.22	5176.26	38723.0
2015-03-09 10:00:00	NQ	Futures	5176.26	5180.37	5164.22	5169.21	30221.0
2015-03-09 11:00:00	NQ	Futures	5168.92	5181.84	5162.75	5171.27	23196.0
2015-03-09 12:00:00	NQ	Futures	5171.56	5176.55	5163.63	5173.91	13950.0
2015-03-09 13:00:00	NQ	Futures	5173.91	5197.99	5173.32	5190.65	22079.0
2015-03-09 14:00:00	NQ	Futures	5190.36	5193.59	5164.51	5179.49	28831.0
2015-03-09 15:00:00	NQ	Futures	5179.49	5194.17	5178.61	5183.89	27076.0
2015-03-09 16:00:00	NQ	Futures	5183.89	5188.59	5183.6	5185.07	4813.0
2015-03-09 17:00:00	NQ	Futures	5185.36	5187.12	5185.07	5186.24	152.0
2015-03-09 18:00:00	NQ	Futures	5186.83	5187.42	5184.19	5184.48	326.0
2015-03-09 19:00:00	NQ	Futures	5184.48	5184.48	5183.31	5183.89	130.0
2015-03-09 20:00:00	NQ	Futures	5183.89	5186.24	5181.54	5181.54	244.0
2015-03-09 21:00:00	NQ	Futures	5181.84	5185.66	5181.84	5182.72	234.0
2015-03-09 22:00:00	NQ	Futures	5182.72	5185.07	5182.72	5183.89	356.0
2015-03-09 23:00:00	NQ	Futures	5184.48	5184.77	5181.25	5181.84	388.0
2015-03-09 00:00:00	YM	Futures	18615.5	18621.7	18613.4	18616.5	290.0
2015-03-09 01:00:00	YM	Futures	18614.4	18629.0	18611.3	18628.0	426.0

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

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