PREVIEW / futures_1hour / 2014-11-05

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-05.parquet
  size:    52 KB
  rows:    1,572

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-05 00:00:00	ES	Futures	2106.48	2111.72	2105.43	2111.46	9697.0
2014-11-05 01:00:00	ES	Futures	2111.46	2111.72	2109.1	2109.62	6920.0
2014-11-05 02:00:00	ES	Futures	2109.89	2111.2	2107.53	2108.31	10899.0
2014-11-05 03:00:00	ES	Futures	2108.31	2109.62	2104.65	2108.58	33356.0
2014-11-05 04:00:00	ES	Futures	2108.58	2110.15	2105.96	2109.89	19679.0
2014-11-05 05:00:00	ES	Futures	2109.62	2111.2	2109.1	2110.15	14295.0
2014-11-05 06:00:00	ES	Futures	2110.15	2110.67	2108.05	2109.62	15251.0
2014-11-05 07:00:00	ES	Futures	2109.62	2114.6	2109.62	2114.08	33905.0
2014-11-05 08:00:00	ES	Futures	2114.34	2116.17	2113.03	2114.86	38962.0
2014-11-05 09:00:00	ES	Futures	2114.6	2117.22	2108.31	2109.62	237423.0
2014-11-05 10:00:00	ES	Futures	2109.62	2112.24	2104.91	2110.41	309961.0
2014-11-05 11:00:00	ES	Futures	2110.41	2113.03	2109.1	2112.77	204698.0
2014-11-05 12:00:00	ES	Futures	2112.77	2114.34	2111.2	2113.29	118132.0
2014-11-05 13:00:00	ES	Futures	2113.29	2114.6	2107.0	2108.84	121258.0
2014-11-05 14:00:00	ES	Futures	2108.58	2113.81	2107.79	2113.81	115211.0
2014-11-05 15:00:00	ES	Futures	2113.81	2115.65	2110.67	2114.6	175089.0
2014-11-05 16:00:00	ES	Futures	2114.86	2116.43	2114.34	2114.86	63189.0
2014-11-05 17:00:00	ES	Futures	2115.12	2115.91	2114.86	2115.39	1416.0
2014-11-05 18:00:00	ES	Futures	2115.12	2115.39	2113.29	2114.08	4331.0
2014-11-05 19:00:00	ES	Futures	2114.08	2114.6	2112.24	2112.77	3354.0
2014-11-05 20:00:00	ES	Futures	2112.77	2113.81	2112.5	2113.55	2493.0
2014-11-05 21:00:00	ES	Futures	2113.55	2113.81	2112.5	2113.81	1506.0
2014-11-05 22:00:00	ES	Futures	2113.55	2114.6	2112.5	2112.77	2488.0
2014-11-05 23:00:00	ES	Futures	2112.77	2112.77	2109.89	2110.15	9912.0
2014-11-05 00:00:00	NQ	Futures	4869.76	4883.53	4867.7	4882.06	1644.0
2014-11-05 01:00:00	NQ	Futures	4881.48	4883.23	4876.79	4879.42	811.0
2014-11-05 02:00:00	NQ	Futures	4880.01	4883.23	4875.03	4875.32	1512.0
2014-11-05 03:00:00	NQ	Futures	4875.32	4881.77	4866.82	4880.01	6034.0
2014-11-05 04:00:00	NQ	Futures	4880.01	4882.65	4872.69	4882.06	2882.0
2014-11-05 05:00:00	NQ	Futures	4881.77	4884.99	4880.3	4881.18	2517.0
2014-11-05 06:00:00	NQ	Futures	4881.18	4882.65	4876.2	4880.01	2053.0
2014-11-05 07:00:00	NQ	Futures	4880.01	4889.97	4879.42	4889.09	4877.0
2014-11-05 08:00:00	NQ	Futures	4888.8	4892.32	4886.16	4889.68	5178.0
2014-11-05 09:00:00	NQ	Futures	4889.68	4894.66	4858.91	4862.72	45249.0
2014-11-05 10:00:00	NQ	Futures	4862.72	4872.98	4848.07	4863.02	53548.0
2014-11-05 11:00:00	NQ	Futures	4863.02	4872.69	4860.09	4871.22	32306.0
2014-11-05 12:00:00	NQ	Futures	4871.22	4875.62	4865.65	4868.58	15876.0
2014-11-05 13:00:00	NQ	Futures	4868.58	4872.1	4844.85	4851.0	26940.0
2014-11-05 14:00:00	NQ	Futures	4850.71	4859.79	4848.37	4857.45	23306.0
2014-11-05 15:00:00	NQ	Futures	4857.74	4863.6	4848.95	4862.14	27614.0
2014-11-05 16:00:00	NQ	Futures	4861.84	4863.89	4853.35	4855.1	9919.0
2014-11-05 17:00:00	NQ	Futures	4855.4	4860.09	4854.52	4858.62	932.0
2014-11-05 18:00:00	NQ	Futures	4857.16	4858.33	4853.64	4855.4	650.0
2014-11-05 19:00:00	NQ	Futures	4855.69	4856.86	4851.0	4851.0	605.0
2014-11-05 20:00:00	NQ	Futures	4851.59	4855.1	4851.59	4855.1	597.0
2014-11-05 21:00:00	NQ	Futures	4855.1	4855.98	4852.47	4855.98	455.0
2014-11-05 22:00:00	NQ	Futures	4855.4	4858.33	4852.76	4853.64	584.0
2014-11-05 23:00:00	NQ	Futures	4853.64	4853.64	4845.73	4845.73	1692.0
2014-11-05 00:00:00	YM	Futures	18034.7	18083.6	18025.3	18080.4	2246.0
2014-11-05 01:00:00	YM	Futures	18081.5	18082.5	18062.8	18069.0	1465.0

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

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