PREVIEW / futures_1hour / 2014-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-31.parquet
  size:    36 KB
  rows:    1,018

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-31 00:00:00	ES	Futures	2190.21	2190.48	2189.69	2189.69	1305.0
2014-12-31 01:00:00	ES	Futures	2189.69	2190.21	2189.69	2190.21	358.0
2014-12-31 02:00:00	ES	Futures	2189.95	2192.32	2189.95	2191.0	3415.0
2014-12-31 03:00:00	ES	Futures	2191.27	2191.79	2189.42	2190.74	2519.0
2014-12-31 04:00:00	ES	Futures	2190.74	2191.27	2189.16	2189.42	1944.0
2014-12-31 05:00:00	ES	Futures	2189.42	2190.48	2189.42	2189.42	1425.0
2014-12-31 06:00:00	ES	Futures	2189.42	2189.69	2188.37	2188.63	1994.0
2014-12-31 07:00:00	ES	Futures	2188.63	2189.42	2188.37	2189.42	2293.0
2014-12-31 08:00:00	ES	Futures	2189.42	2190.48	2188.37	2188.63	6741.0
2014-12-31 09:00:00	ES	Futures	2188.63	2189.16	2184.42	2185.21	56488.0
2014-12-31 10:00:00	ES	Futures	2185.21	2189.16	2185.21	2188.37	61704.0
2014-12-31 11:00:00	ES	Futures	2188.63	2188.63	2185.21	2186.0	49204.0
2014-12-31 12:00:00	ES	Futures	2186.27	2186.53	2176.0	2178.11	102093.0
2014-12-31 13:00:00	ES	Futures	2177.84	2181.27	2176.0	2177.84	60512.0
2014-12-31 14:00:00	ES	Futures	2177.58	2177.84	2166.53	2169.42	109783.0
2014-12-31 15:00:00	ES	Futures	2169.42	2173.11	2158.9	2160.21	247403.0
2014-12-31 16:00:00	ES	Futures	2159.95	2162.85	2158.63	2159.69	112819.0
2014-12-31 17:00:00	ES	Futures	2159.69	2162.32	2159.42	2162.06	2578.0
2014-12-31 00:00:00	NQ	Futures	5039.11	5041.16	5038.52	5039.4	317.0
2014-12-31 01:00:00	NQ	Futures	5039.4	5039.99	5037.64	5038.81	131.0
2014-12-31 02:00:00	NQ	Futures	5039.11	5044.69	5038.81	5042.63	571.0
2014-12-31 03:00:00	NQ	Futures	5043.22	5043.51	5038.52	5039.69	408.0
2014-12-31 04:00:00	NQ	Futures	5039.69	5039.99	5035.87	5036.17	376.0
2014-12-31 05:00:00	NQ	Futures	5036.17	5039.11	5035.87	5037.05	280.0
2014-12-31 06:00:00	NQ	Futures	5036.76	5036.76	5033.23	5034.7	413.0
2014-12-31 07:00:00	NQ	Futures	5034.7	5037.34	5034.7	5037.05	437.0
2014-12-31 08:00:00	NQ	Futures	5037.05	5039.11	5033.53	5036.46	1713.0
2014-12-31 09:00:00	NQ	Futures	5036.17	5043.22	5032.94	5038.22	13016.0
2014-12-31 10:00:00	NQ	Futures	5037.93	5057.31	5037.64	5054.96	14106.0
2014-12-31 11:00:00	NQ	Futures	5054.96	5055.85	5040.28	5042.34	10815.0
2014-12-31 12:00:00	NQ	Futures	5042.63	5043.51	5010.91	5017.96	20394.0
2014-12-31 13:00:00	NQ	Futures	5018.25	5025.3	5012.38	5015.61	9790.0
2014-12-31 14:00:00	NQ	Futures	5015.9	5016.2	4985.65	4988.59	25320.0
2014-12-31 15:00:00	NQ	Futures	4988.88	4996.52	4966.86	4972.73	35195.0
2014-12-31 16:00:00	NQ	Futures	4972.73	4980.66	4971.26	4973.61	12009.0
2014-12-31 17:00:00	NQ	Futures	4973.91	4979.19	4973.91	4978.61	155.0
2014-12-31 00:00:00	YM	Futures	18754.3	18755.3	18751.2	18753.3	208.0
2014-12-31 01:00:00	YM	Futures	18753.3	18756.4	18752.2	18756.4	233.0
2014-12-31 02:00:00	YM	Futures	18756.4	18773.1	18756.4	18762.7	579.0
2014-12-31 03:00:00	YM	Futures	18763.7	18767.9	18753.3	18757.4	511.0
2014-12-31 04:00:00	YM	Futures	18758.5	18759.5	18738.6	18742.8	718.0
2014-12-31 05:00:00	YM	Futures	18742.8	18749.1	18739.7	18743.9	214.0
2014-12-31 06:00:00	YM	Futures	18741.8	18743.9	18735.5	18737.6	266.0
2014-12-31 07:00:00	YM	Futures	18737.6	18743.9	18736.6	18742.8	306.0
2014-12-31 08:00:00	YM	Futures	18742.8	18753.3	18740.7	18744.9	901.0
2014-12-31 09:00:00	YM	Futures	18743.9	18752.2	18729.2	18735.5	4905.0
2014-12-31 10:00:00	YM	Futures	18735.5	18766.8	18731.3	18757.4	4279.0
2014-12-31 11:00:00	YM	Futures	18758.5	18759.5	18735.5	18742.8	3242.0
2014-12-31 12:00:00	YM	Futures	18744.9	18745.9	18645.7	18661.4	12869.0
2014-12-31 13:00:00	YM	Futures	18662.4	18697.9	18657.2	18670.8	5280.0

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

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