PREVIEW / futures_1hour / 2014-04-21

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-21.parquet
  size:    38 KB
  rows:    1,205

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-04-21 00:00:00	ES	Futures	1932.21	1932.73	1931.69	1932.73	892.0
2014-04-21 01:00:00	ES	Futures	1932.47	1933.25	1932.21	1932.99	939.0
2014-04-21 02:00:00	ES	Futures	1932.99	1932.99	1932.21	1932.47	597.0
2014-04-21 03:00:00	ES	Futures	1932.47	1932.99	1931.69	1931.95	875.0
2014-04-21 04:00:00	ES	Futures	1931.95	1932.73	1931.69	1932.21	619.0
2014-04-21 05:00:00	ES	Futures	1932.21	1932.47	1931.17	1931.69	856.0
2014-04-21 06:00:00	ES	Futures	1931.69	1932.73	1931.17	1932.47	1422.0
2014-04-21 07:00:00	ES	Futures	1932.47	1933.51	1932.21	1932.47	4772.0
2014-04-21 08:00:00	ES	Futures	1932.21	1932.73	1929.1	1930.66	16525.0
2014-04-21 09:00:00	ES	Futures	1930.91	1935.07	1929.88	1934.29	89794.0
2014-04-21 10:00:00	ES	Futures	1934.29	1936.63	1928.32	1930.91	107214.0
2014-04-21 11:00:00	ES	Futures	1930.91	1935.07	1930.14	1934.81	53947.0
2014-04-21 12:00:00	ES	Futures	1934.81	1935.59	1932.99	1934.55	33273.0
2014-04-21 13:00:00	ES	Futures	1934.55	1936.37	1933.51	1936.37	29609.0
2014-04-21 14:00:00	ES	Futures	1936.37	1937.67	1935.33	1937.15	53618.0
2014-04-21 15:00:00	ES	Futures	1937.41	1937.41	1934.55	1937.15	76363.0
2014-04-21 16:00:00	ES	Futures	1937.41	1937.67	1935.85	1936.63	39252.0
2014-04-21 17:00:00	ES	Futures	1936.63	1937.15	1935.85	1936.63	2753.0
2014-04-21 18:00:00	ES	Futures	1936.37	1937.93	1936.11	1937.15	4127.0
2014-04-21 19:00:00	ES	Futures	1937.15	1937.15	1936.89	1937.15	574.0
2014-04-21 20:00:00	ES	Futures	1936.89	1937.15	1934.81	1935.07	5406.0
2014-04-21 21:00:00	ES	Futures	1935.33	1937.15	1935.07	1936.11	3714.0
2014-04-21 22:00:00	ES	Futures	1936.37	1936.63	1935.85	1936.37	1505.0
2014-04-21 23:00:00	ES	Futures	1936.37	1937.41	1936.11	1936.63	1988.0
2014-04-21 00:00:00	NQ	Futures	4115.84	4117.01	4113.51	4115.84	263.0
2014-04-21 01:00:00	NQ	Futures	4115.26	4117.3	4114.97	4116.43	221.0
2014-04-21 02:00:00	NQ	Futures	4115.84	4116.14	4114.68	4114.97	163.0
2014-04-21 03:00:00	NQ	Futures	4115.55	4115.84	4114.39	4114.97	183.0
2014-04-21 04:00:00	NQ	Futures	4114.39	4116.14	4114.39	4115.26	118.0
2014-04-21 05:00:00	NQ	Futures	4115.26	4115.26	4111.77	4112.35	246.0
2014-04-21 06:00:00	NQ	Futures	4112.35	4114.97	4111.77	4114.1	197.0
2014-04-21 07:00:00	NQ	Futures	4114.39	4117.3	4113.81	4114.97	804.0
2014-04-21 08:00:00	NQ	Futures	4115.26	4118.76	4111.77	4114.1	2660.0
2014-04-21 09:00:00	NQ	Futures	4114.1	4125.75	4107.4	4116.72	23598.0
2014-04-21 10:00:00	NQ	Futures	4117.3	4131.28	4096.62	4109.73	39638.0
2014-04-21 11:00:00	NQ	Futures	4109.44	4126.62	4106.82	4124.0	18505.0
2014-04-21 12:00:00	NQ	Futures	4124.29	4127.2	4117.59	4125.45	11340.0
2014-04-21 13:00:00	NQ	Futures	4125.16	4132.44	4121.67	4132.44	9180.0
2014-04-21 14:00:00	NQ	Futures	4132.44	4136.81	4129.53	4135.65	11910.0
2014-04-21 15:00:00	NQ	Futures	4135.65	4137.1	4126.33	4136.23	20947.0
2014-04-21 16:00:00	NQ	Futures	4136.23	4140.31	4135.07	4138.56	8617.0
2014-04-21 17:00:00	NQ	Futures	4138.56	4139.72	4137.1	4139.14	256.0
2014-04-21 18:00:00	NQ	Futures	4139.72	4141.18	4138.85	4139.72	1041.0
2014-04-21 19:00:00	NQ	Futures	4139.72	4140.6	4139.72	4140.02	252.0
2014-04-21 20:00:00	NQ	Futures	4140.02	4140.31	4135.94	4136.23	1117.0
2014-04-21 21:00:00	NQ	Futures	4136.23	4140.89	4135.65	4139.14	546.0
2014-04-21 22:00:00	NQ	Futures	4138.85	4140.02	4137.69	4139.72	458.0
2014-04-21 23:00:00	NQ	Futures	4139.43	4140.89	4139.14	4139.72	431.0
2014-04-21 00:00:00	YM	Futures	16852.6	16854.7	16844.4	16854.7	220.0
2014-04-21 01:00:00	YM	Futures	16852.6	16857.8	16850.6	16855.7	171.0

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

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