PREVIEW / futures_1hour / 2014-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-22.parquet
  size:    48 KB
  rows:    1,543

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-07-22 00:00:00	ES	Futures	2051.81	2051.81	2051.29	2051.29	1561.0
2014-07-22 01:00:00	ES	Futures	2051.29	2052.6	2051.29	2052.6	4190.0
2014-07-22 02:00:00	ES	Futures	2052.34	2052.86	2051.03	2052.6	7820.0
2014-07-22 03:00:00	ES	Futures	2052.34	2053.12	2051.29	2051.81	19934.0
2014-07-22 04:00:00	ES	Futures	2051.81	2054.16	2050.77	2053.38	18894.0
2014-07-22 05:00:00	ES	Futures	2053.64	2056.77	2053.12	2055.46	22608.0
2014-07-22 06:00:00	ES	Futures	2055.72	2056.24	2054.68	2055.46	11116.0
2014-07-22 07:00:00	ES	Futures	2055.72	2058.59	2054.42	2056.5	30151.0
2014-07-22 08:00:00	ES	Futures	2056.24	2059.89	2055.2	2057.81	47461.0
2014-07-22 09:00:00	ES	Futures	2057.81	2061.2	2057.03	2059.63	212497.0
2014-07-22 10:00:00	ES	Futures	2059.89	2063.54	2059.63	2062.5	206796.0
2014-07-22 11:00:00	ES	Futures	2062.5	2064.58	2061.72	2062.76	122417.0
2014-07-22 12:00:00	ES	Futures	2062.76	2064.58	2062.24	2062.5	58421.0
2014-07-22 13:00:00	ES	Futures	2062.5	2063.8	2061.72	2062.5	44587.0
2014-07-22 14:00:00	ES	Futures	2062.76	2063.8	2058.85	2060.94	161372.0
2014-07-22 15:00:00	ES	Futures	2060.94	2063.28	2059.89	2060.67	163349.0
2014-07-22 16:00:00	ES	Futures	2060.67	2061.2	2055.98	2056.5	116535.0
2014-07-22 17:00:00	ES	Futures	2055.98	2058.33	2055.98	2058.07	2409.0
2014-07-22 18:00:00	ES	Futures	2056.77	2059.11	2056.5	2057.81	4217.0
2014-07-22 19:00:00	ES	Futures	2057.55	2058.07	2057.29	2057.55	1093.0
2014-07-22 20:00:00	ES	Futures	2057.81	2058.07	2057.29	2057.81	2294.0
2014-07-22 21:00:00	ES	Futures	2057.55	2058.59	2057.55	2058.07	2405.0
2014-07-22 22:00:00	ES	Futures	2058.33	2058.59	2057.81	2058.59	2127.0
2014-07-22 23:00:00	ES	Futures	2058.59	2059.63	2058.07	2058.59	3146.0
2014-07-22 00:00:00	NQ	Futures	4591.05	4592.22	4590.18	4590.76	559.0
2014-07-22 01:00:00	NQ	Futures	4590.47	4593.1	4590.18	4593.1	506.0
2014-07-22 02:00:00	NQ	Futures	4593.1	4594.85	4591.05	4594.85	1037.0
2014-07-22 03:00:00	NQ	Futures	4594.85	4595.44	4591.35	4592.81	2678.0
2014-07-22 04:00:00	NQ	Futures	4592.81	4598.06	4589.59	4596.9	2878.0
2014-07-22 05:00:00	NQ	Futures	4596.9	4604.78	4596.02	4601.57	3345.0
2014-07-22 06:00:00	NQ	Futures	4601.57	4602.15	4598.94	4600.4	1687.0
2014-07-22 07:00:00	NQ	Futures	4600.69	4610.33	4599.23	4604.78	5398.0
2014-07-22 08:00:00	NQ	Futures	4604.78	4611.79	4602.15	4607.12	6394.0
2014-07-22 09:00:00	NQ	Futures	4607.12	4617.04	4604.78	4612.08	36268.0
2014-07-22 10:00:00	NQ	Futures	4611.5	4624.93	4611.5	4620.84	32779.0
2014-07-22 11:00:00	NQ	Futures	4620.84	4624.34	4616.46	4618.21	15402.0
2014-07-22 12:00:00	NQ	Futures	4617.92	4623.47	4617.63	4618.21	8738.0
2014-07-22 13:00:00	NQ	Futures	4618.21	4622.59	4616.75	4619.38	8093.0
2014-07-22 14:00:00	NQ	Futures	4619.09	4621.72	4607.7	4613.54	22842.0
2014-07-22 15:00:00	NQ	Futures	4613.25	4621.42	4610.91	4618.21	26153.0
2014-07-22 16:00:00	NQ	Futures	4617.92	4619.38	4603.03	4606.24	20127.0
2014-07-22 17:00:00	NQ	Futures	4606.53	4612.37	4605.95	4611.79	1013.0
2014-07-22 18:00:00	NQ	Futures	4607.7	4616.17	4607.12	4609.74	1218.0
2014-07-22 19:00:00	NQ	Futures	4609.45	4610.62	4608.58	4609.45	303.0
2014-07-22 20:00:00	NQ	Futures	4609.16	4609.45	4607.7	4608.58	531.0
2014-07-22 21:00:00	NQ	Futures	4608.87	4611.5	4607.99	4610.04	638.0
2014-07-22 22:00:00	NQ	Futures	4610.04	4611.2	4608.58	4611.2	518.0
2014-07-22 23:00:00	NQ	Futures	4610.91	4613.25	4609.74	4611.5	551.0
2014-07-22 00:00:00	YM	Futures	17589.7	17589.7	17582.5	17584.5	512.0
2014-07-22 01:00:00	YM	Futures	17582.5	17592.8	17581.4	17590.7	680.0

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

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