PREVIEW / futures_1hour / 2014-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-23.parquet
  size:    48 KB
  rows:    1,509

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
2014-12-23 00:00:00	ES	Futures	2183.37	2183.63	2182.84	2183.63	712.0
2014-12-23 01:00:00	ES	Futures	2183.63	2184.69	2183.37	2184.42	1491.0
2014-12-23 02:00:00	ES	Futures	2184.69	2184.69	2181.27	2181.27	4802.0
2014-12-23 03:00:00	ES	Futures	2181.27	2183.37	2180.48	2181.79	9879.0
2014-12-23 04:00:00	ES	Futures	2181.53	2182.84	2180.48	2181.79	6482.0
2014-12-23 05:00:00	ES	Futures	2181.53	2183.37	2181.27	2182.84	5035.0
2014-12-23 06:00:00	ES	Futures	2182.84	2184.42	2182.58	2184.16	4761.0
2014-12-23 07:00:00	ES	Futures	2184.16	2186.27	2183.37	2186.0	8855.0
2014-12-23 08:00:00	ES	Futures	2185.74	2191.79	2184.42	2191.79	41422.0
2014-12-23 09:00:00	ES	Futures	2191.79	2194.16	2187.58	2188.9	120367.0
2014-12-23 10:00:00	ES	Futures	2189.16	2191.53	2184.69	2188.37	157120.0
2014-12-23 11:00:00	ES	Futures	2188.37	2189.95	2187.32	2188.11	91294.0
2014-12-23 12:00:00	ES	Futures	2188.11	2190.21	2187.32	2189.69	51411.0
2014-12-23 13:00:00	ES	Futures	2189.69	2191.0	2188.9	2189.95	42221.0
2014-12-23 14:00:00	ES	Futures	2189.95	2192.05	2188.63	2190.48	56432.0
2014-12-23 15:00:00	ES	Futures	2190.48	2191.27	2186.0	2186.79	114927.0
2014-12-23 16:00:00	ES	Futures	2187.06	2189.42	2185.74	2188.9	43148.0
2014-12-23 17:00:00	ES	Futures	2188.9	2188.9	2187.32	2187.84	2128.0
2014-12-23 18:00:00	ES	Futures	2188.11	2188.63	2186.79	2188.37	1728.0
2014-12-23 19:00:00	ES	Futures	2188.11	2189.42	2187.84	2188.11	1519.0
2014-12-23 20:00:00	ES	Futures	2188.11	2189.42	2188.11	2188.9	1276.0
2014-12-23 21:00:00	ES	Futures	2189.16	2190.21	2188.9	2190.21	1631.0
2014-12-23 22:00:00	ES	Futures	2190.48	2190.48	2189.16	2189.95	1328.0
2014-12-23 23:00:00	ES	Futures	2190.21	2191.27	2189.95	2191.27	1203.0
2014-12-23 00:00:00	NQ	Futures	5047.62	5048.5	5047.33	5048.21	159.0
2014-12-23 01:00:00	NQ	Futures	5048.5	5049.97	5048.21	5049.09	240.0
2014-12-23 02:00:00	NQ	Futures	5048.8	5048.8	5039.11	5039.4	706.0
2014-12-23 03:00:00	NQ	Futures	5039.69	5047.33	5036.46	5042.92	1197.0
2014-12-23 04:00:00	NQ	Futures	5043.22	5044.98	5039.69	5042.34	777.0
2014-12-23 05:00:00	NQ	Futures	5042.04	5044.98	5041.16	5043.51	536.0
2014-12-23 06:00:00	NQ	Futures	5043.8	5049.97	5043.22	5049.38	1025.0
2014-12-23 07:00:00	NQ	Futures	5049.38	5054.38	5048.5	5053.5	1389.0
2014-12-23 08:00:00	NQ	Futures	5053.2	5061.72	5049.09	5059.66	4846.0
2014-12-23 09:00:00	NQ	Futures	5059.96	5065.54	5034.11	5040.57	29290.0
2014-12-23 10:00:00	NQ	Futures	5040.57	5046.15	5021.78	5031.76	33695.0
2014-12-23 11:00:00	NQ	Futures	5031.76	5042.04	5030.0	5036.76	15800.0
2014-12-23 12:00:00	NQ	Futures	5037.05	5038.22	5026.18	5029.71	11556.0
2014-12-23 13:00:00	NQ	Futures	5029.71	5040.57	5026.77	5037.93	9579.0
2014-12-23 14:00:00	NQ	Futures	5037.93	5040.57	5034.7	5035.29	8655.0
2014-12-23 15:00:00	NQ	Futures	5035.58	5039.99	5025.01	5026.77	19044.0
2014-12-23 16:00:00	NQ	Futures	5026.18	5029.41	5022.66	5027.36	8355.0
2014-12-23 17:00:00	NQ	Futures	5027.65	5027.65	5025.01	5025.01	322.0
2014-12-23 18:00:00	NQ	Futures	5025.6	5027.65	5023.83	5027.06	311.0
2014-12-23 19:00:00	NQ	Futures	5027.36	5030.0	5026.48	5027.95	292.0
2014-12-23 20:00:00	NQ	Futures	5028.24	5030.29	5027.36	5029.12	470.0
2014-12-23 21:00:00	NQ	Futures	5029.12	5030.0	5027.65	5030.0	197.0
2014-12-23 22:00:00	NQ	Futures	5030.0	5030.29	5028.24	5029.71	311.0
2014-12-23 23:00:00	NQ	Futures	5029.71	5032.35	5029.71	5032.35	171.0
2014-12-23 00:00:00	YM	Futures	18703.1	18710.5	18701.1	18709.4	298.0
2014-12-23 01:00:00	YM	Futures	18711.5	18714.6	18707.3	18711.5	275.0

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

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