PREVIEW / futures_1hour / 2014-11-26

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-26.parquet
  size:    47 KB
  rows:    1,487

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-11-26 00:00:00	ES	Futures	2169.88	2170.14	2168.57	2168.57	1715.0
2014-11-26 01:00:00	ES	Futures	2168.83	2170.66	2168.57	2169.88	1549.0
2014-11-26 02:00:00	ES	Futures	2169.88	2170.4	2168.3	2168.3	7967.0
2014-11-26 03:00:00	ES	Futures	2168.57	2171.97	2168.04	2170.4	21029.0
2014-11-26 04:00:00	ES	Futures	2170.14	2170.66	2167.78	2170.14	15284.0
2014-11-26 05:00:00	ES	Futures	2170.14	2170.4	2168.3	2168.57	7594.0
2014-11-26 06:00:00	ES	Futures	2168.57	2169.61	2168.3	2168.57	4428.0
2014-11-26 07:00:00	ES	Futures	2168.83	2169.09	2165.42	2165.42	14428.0
2014-11-26 08:00:00	ES	Futures	2165.42	2167.52	2164.11	2165.42	30531.0
2014-11-26 09:00:00	ES	Futures	2165.42	2168.04	2164.11	2166.47	96068.0
2014-11-26 10:00:00	ES	Futures	2165.95	2167.78	2164.11	2166.73	129965.0
2014-11-26 11:00:00	ES	Futures	2166.47	2167.52	2165.16	2166.47	77639.0
2014-11-26 12:00:00	ES	Futures	2166.47	2168.04	2165.95	2167.26	41548.0
2014-11-26 13:00:00	ES	Futures	2166.99	2168.83	2166.99	2168.04	35999.0
2014-11-26 14:00:00	ES	Futures	2168.3	2168.57	2166.99	2167.78	32028.0
2014-11-26 15:00:00	ES	Futures	2167.78	2171.45	2167.26	2169.88	121131.0
2014-11-26 16:00:00	ES	Futures	2169.88	2174.59	2168.04	2173.54	81932.0
2014-11-26 17:00:00	ES	Futures	2173.54	2173.81	2173.02	2173.02	1462.0
2014-11-26 18:00:00	ES	Futures	2173.28	2173.54	2171.71	2171.97	2302.0
2014-11-26 19:00:00	ES	Futures	2171.71	2172.23	2171.19	2171.45	2382.0
2014-11-26 20:00:00	ES	Futures	2171.45	2172.76	2170.92	2172.76	2229.0
2014-11-26 21:00:00	ES	Futures	2172.76	2173.28	2172.5	2173.02	1257.0
2014-11-26 22:00:00	ES	Futures	2173.28	2174.07	2171.19	2171.45	2898.0
2014-11-26 23:00:00	ES	Futures	2171.45	2172.5	2171.45	2171.71	999.0
2014-11-26 00:00:00	NQ	Futures	5039.41	5039.41	5036.77	5037.35	556.0
2014-11-26 01:00:00	NQ	Futures	5037.06	5041.16	5036.48	5040.87	317.0
2014-11-26 02:00:00	NQ	Futures	5040.87	5041.46	5035.89	5035.89	854.0
2014-11-26 03:00:00	NQ	Futures	5036.18	5044.68	5035.3	5040.58	2100.0
2014-11-26 04:00:00	NQ	Futures	5040.87	5042.63	5035.6	5041.16	1916.0
2014-11-26 05:00:00	NQ	Futures	5040.87	5041.75	5037.65	5038.23	1169.0
2014-11-26 06:00:00	NQ	Futures	5037.94	5040.58	5037.94	5039.41	796.0
2014-11-26 07:00:00	NQ	Futures	5039.11	5040.87	5031.49	5032.08	2082.0
2014-11-26 08:00:00	NQ	Futures	5032.08	5037.35	5028.86	5032.96	5092.0
2014-11-26 09:00:00	NQ	Futures	5032.96	5042.04	5028.56	5037.06	24226.0
2014-11-26 10:00:00	NQ	Futures	5037.06	5047.61	5032.67	5044.39	23809.0
2014-11-26 11:00:00	NQ	Futures	5044.68	5051.13	5044.39	5047.02	15765.0
2014-11-26 12:00:00	NQ	Futures	5046.73	5051.42	5044.68	5048.78	9069.0
2014-11-26 13:00:00	NQ	Futures	5048.78	5055.23	5048.49	5054.64	7803.0
2014-11-26 14:00:00	NQ	Futures	5054.93	5055.81	5051.71	5052.88	7906.0
2014-11-26 15:00:00	NQ	Futures	5052.59	5064.6	5051.13	5061.09	20228.0
2014-11-26 16:00:00	NQ	Futures	5061.38	5067.53	5056.11	5066.95	8632.0
2014-11-26 17:00:00	NQ	Futures	5066.95	5066.95	5064.6	5064.9	408.0
2014-11-26 18:00:00	NQ	Futures	5067.24	5067.83	5062.85	5062.85	393.0
2014-11-26 19:00:00	NQ	Futures	5062.85	5064.9	5062.26	5063.14	299.0
2014-11-26 20:00:00	NQ	Futures	5062.85	5064.9	5061.97	5064.9	274.0
2014-11-26 21:00:00	NQ	Futures	5065.19	5065.78	5064.6	5065.19	147.0
2014-11-26 22:00:00	NQ	Futures	5064.9	5066.36	5060.79	5062.26	431.0
2014-11-26 23:00:00	NQ	Futures	5062.26	5063.72	5062.26	5063.14	209.0
2014-11-26 00:00:00	YM	Futures	18542.1	18544.2	18529.6	18529.6	434.0
2014-11-26 01:00:00	YM	Futures	18530.7	18545.2	18529.6	18543.1	286.0

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

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