PREVIEW / futures_1hour / 2014-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-03.parquet
  size:    44 KB
  rows:    1,390

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-03 00:00:00	ES	Futures	2050.25	2050.25	2049.47	2050.25	852.0
2014-07-03 01:00:00	ES	Futures	2050.25	2050.25	2049.99	2050.25	954.0
2014-07-03 02:00:00	ES	Futures	2050.25	2051.03	2049.73	2050.77	2628.0
2014-07-03 03:00:00	ES	Futures	2050.51	2052.34	2049.47	2052.07	15716.0
2014-07-03 04:00:00	ES	Futures	2051.81	2052.34	2051.03	2051.55	6125.0
2014-07-03 05:00:00	ES	Futures	2051.81	2053.64	2051.55	2053.12	9147.0
2014-07-03 06:00:00	ES	Futures	2052.86	2053.9	2052.6	2053.12	8400.0
2014-07-03 07:00:00	ES	Futures	2053.38	2053.64	2052.86	2053.38	5826.0
2014-07-03 08:00:00	ES	Futures	2053.12	2056.77	2049.73	2056.5	115353.0
2014-07-03 09:00:00	ES	Futures	2056.5	2058.85	2054.94	2056.77	203504.0
2014-07-03 10:00:00	ES	Futures	2056.77	2058.85	2055.46	2058.07	136110.0
2014-07-03 11:00:00	ES	Futures	2058.07	2060.67	2057.29	2060.15	113427.0
2014-07-03 12:00:00	ES	Futures	2060.41	2062.24	2059.63	2061.46	146544.0
2014-07-03 13:00:00	ES	Futures	2061.46	2061.98	2060.15	2061.46	61183.0
2014-07-03 18:00:00	ES	Futures	2060.94	2061.2	2060.15	2060.15	1980.0
2014-07-03 19:00:00	ES	Futures	2060.15	2061.46	2059.89	2060.94	1369.0
2014-07-03 20:00:00	ES	Futures	2060.67	2060.67	2059.63	2059.63	2302.0
2014-07-03 21:00:00	ES	Futures	2059.89	2060.67	2059.63	2060.41	1909.0
2014-07-03 22:00:00	ES	Futures	2060.41	2060.94	2060.15	2060.41	570.0
2014-07-03 23:00:00	ES	Futures	2060.67	2060.94	2060.41	2060.67	516.0
2014-07-03 00:00:00	NQ	Futures	4542.87	4543.46	4542.0	4543.46	156.0
2014-07-03 01:00:00	NQ	Futures	4543.75	4544.04	4542.87	4543.75	184.0
2014-07-03 02:00:00	NQ	Futures	4543.75	4545.5	4543.16	4545.21	343.0
2014-07-03 03:00:00	NQ	Futures	4545.21	4547.54	4542.87	4546.67	1812.0
2014-07-03 04:00:00	NQ	Futures	4546.96	4547.25	4544.62	4546.67	1369.0
2014-07-03 05:00:00	NQ	Futures	4546.96	4550.17	4546.38	4549.59	1401.0
2014-07-03 06:00:00	NQ	Futures	4549.3	4550.76	4548.42	4549.0	1415.0
2014-07-03 07:00:00	NQ	Futures	4549.0	4549.88	4548.13	4549.0	1228.0
2014-07-03 08:00:00	NQ	Futures	4549.0	4558.35	4545.21	4558.06	15251.0
2014-07-03 09:00:00	NQ	Futures	4558.35	4560.69	4546.96	4552.8	32991.0
2014-07-03 10:00:00	NQ	Futures	4553.09	4560.39	4550.76	4559.52	23709.0
2014-07-03 11:00:00	NQ	Futures	4559.52	4566.53	4557.47	4566.53	13793.0
2014-07-03 12:00:00	NQ	Futures	4566.82	4572.37	4565.65	4571.49	16900.0
2014-07-03 13:00:00	NQ	Futures	4571.2	4576.45	4569.45	4575.58	9112.0
2014-07-03 18:00:00	NQ	Futures	4573.83	4574.99	4571.78	4572.37	437.0
2014-07-03 19:00:00	NQ	Futures	4572.37	4574.7	4572.37	4573.53	177.0
2014-07-03 20:00:00	NQ	Futures	4573.83	4573.83	4571.78	4572.37	186.0
2014-07-03 21:00:00	NQ	Futures	4572.07	4573.24	4571.2	4573.24	232.0
2014-07-03 22:00:00	NQ	Futures	4572.95	4574.41	4572.95	4573.53	81.0
2014-07-03 23:00:00	NQ	Futures	4573.53	4574.12	4573.24	4574.12	57.0
2014-07-03 00:00:00	YM	Futures	17472.8	17474.9	17468.7	17472.8	114.0
2014-07-03 01:00:00	YM	Futures	17472.8	17475.9	17472.8	17474.9	171.0
2014-07-03 02:00:00	YM	Futures	17474.9	17480.0	17472.8	17480.0	494.0
2014-07-03 03:00:00	YM	Futures	17479.0	17497.6	17469.7	17494.5	2984.0
2014-07-03 04:00:00	YM	Futures	17494.5	17496.6	17487.3	17492.5	937.0
2014-07-03 05:00:00	YM	Futures	17491.4	17500.7	17491.4	17497.6	1395.0
2014-07-03 06:00:00	YM	Futures	17497.6	17501.8	17494.5	17499.7	1568.0
2014-07-03 07:00:00	YM	Futures	17498.7	17501.8	17495.6	17498.7	964.0
2014-07-03 08:00:00	YM	Futures	17498.7	17528.7	17475.9	17518.3	10103.0
2014-07-03 09:00:00	YM	Futures	17519.4	17559.7	17510.0	17545.2	19661.0

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

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