PREVIEW / futures_1hour / 2014-12-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-09.parquet
  size:    52 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
2014-12-09 00:00:00	ES	Futures	2152.06	2154.42	2152.06	2153.37	3866.0
2014-12-09 01:00:00	ES	Futures	2153.63	2153.9	2151.8	2152.59	3093.0
2014-12-09 02:00:00	ES	Futures	2152.32	2152.85	2149.7	2150.75	20545.0
2014-12-09 03:00:00	ES	Futures	2150.75	2152.59	2147.61	2149.97	31003.0
2014-12-09 04:00:00	ES	Futures	2149.97	2153.63	2149.44	2151.28	18542.0
2014-12-09 05:00:00	ES	Futures	2151.28	2153.37	2150.23	2151.28	14967.0
2014-12-09 06:00:00	ES	Futures	2151.28	2152.06	2149.44	2151.01	14047.0
2014-12-09 07:00:00	ES	Futures	2151.01	2151.28	2140.27	2142.63	63860.0
2014-12-09 08:00:00	ES	Futures	2142.63	2143.16	2135.82	2140.01	75039.0
2014-12-09 09:00:00	ES	Futures	2139.75	2142.63	2132.68	2142.63	263598.0
2014-12-09 10:00:00	ES	Futures	2142.37	2144.2	2130.58	2138.7	326988.0
2014-12-09 11:00:00	ES	Futures	2138.7	2143.68	2136.34	2140.8	196520.0
2014-12-09 12:00:00	ES	Futures	2140.8	2148.92	2138.44	2148.92	151806.0
2014-12-09 13:00:00	ES	Futures	2148.66	2156.25	2146.82	2152.85	169733.0
2014-12-09 14:00:00	ES	Futures	2152.59	2155.47	2149.18	2152.85	130729.0
2014-12-09 15:00:00	ES	Futures	2152.59	2159.4	2152.32	2157.83	193728.0
2014-12-09 16:00:00	ES	Futures	2157.83	2158.35	2155.21	2156.78	73915.0
2014-12-09 17:00:00	ES	Futures	2156.52	2156.78	2155.99	2156.25	1364.0
2014-12-09 18:00:00	ES	Futures	2156.25	2157.04	2155.99	2156.78	4867.0
2014-12-09 19:00:00	ES	Futures	2156.78	2157.3	2155.73	2156.52	5085.0
2014-12-09 20:00:00	ES	Futures	2156.78	2157.04	2156.25	2156.52	2744.0
2014-12-09 21:00:00	ES	Futures	2156.78	2156.78	2154.94	2155.47	4843.0
2014-12-09 22:00:00	ES	Futures	2155.47	2155.47	2153.9	2154.42	5702.0
2014-12-09 23:00:00	ES	Futures	2154.68	2154.68	2153.63	2154.16	5759.0
2014-12-09 00:00:00	NQ	Futures	5006.0	5010.4	5004.83	5007.17	1053.0
2014-12-09 01:00:00	NQ	Futures	5007.47	5008.64	5002.49	5003.37	618.0
2014-12-09 02:00:00	NQ	Futures	5003.37	5004.54	4995.45	4999.26	4476.0
2014-12-09 03:00:00	NQ	Futures	4998.97	5002.78	4993.4	4997.51	4575.0
2014-12-09 04:00:00	NQ	Futures	4997.21	5003.37	4994.87	4996.92	3665.0
2014-12-09 05:00:00	NQ	Futures	4996.92	5002.19	4994.28	4996.33	2597.0
2014-12-09 06:00:00	NQ	Futures	4996.33	4998.38	4993.11	4996.63	2796.0
2014-12-09 07:00:00	NQ	Futures	4996.33	4996.63	4971.72	4977.87	10953.0
2014-12-09 08:00:00	NQ	Futures	4977.87	4978.46	4960.59	4970.26	14285.0
2014-12-09 09:00:00	NQ	Futures	4969.96	4973.19	4946.82	4971.14	63550.0
2014-12-09 10:00:00	NQ	Futures	4971.14	4975.53	4942.13	4968.2	65972.0
2014-12-09 11:00:00	NQ	Futures	4968.2	4989.59	4962.05	4984.32	33590.0
2014-12-09 12:00:00	NQ	Futures	4984.32	5011.57	4979.05	5010.69	25738.0
2014-12-09 13:00:00	NQ	Futures	5010.69	5032.08	5008.35	5025.93	33628.0
2014-12-09 14:00:00	NQ	Futures	5026.22	5030.32	5012.74	5020.07	20333.0
2014-12-09 15:00:00	NQ	Futures	5019.77	5037.94	5019.77	5035.3	31503.0
2014-12-09 16:00:00	NQ	Futures	5035.6	5035.89	5027.69	5031.2	9097.0
2014-12-09 17:00:00	NQ	Futures	5031.49	5031.79	5027.98	5027.98	323.0
2014-12-09 18:00:00	NQ	Futures	5028.86	5031.49	5028.27	5030.91	707.0
2014-12-09 19:00:00	NQ	Futures	5031.2	5032.67	5029.44	5031.2	703.0
2014-12-09 20:00:00	NQ	Futures	5031.2	5032.96	5030.32	5031.49	742.0
2014-12-09 21:00:00	NQ	Futures	5031.49	5031.49	5023.88	5025.05	1384.0
2014-12-09 22:00:00	NQ	Futures	5024.76	5025.05	5020.36	5022.12	1191.0
2014-12-09 23:00:00	NQ	Futures	5022.12	5022.7	5020.07	5020.65	842.0
2014-12-09 00:00:00	YM	Futures	18515.1	18532.7	18514.0	18523.4	968.0
2014-12-09 01:00:00	YM	Futures	18523.4	18526.5	18509.9	18511.9	579.0

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

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