PREVIEW / futures_1hour / 2014-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-04.parquet
  size:    51 KB
  rows:    1,571

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-03-04 00:00:00	ES	Futures	1910.15	1913.0	1910.15	1912.22	5646.0
2014-03-04 01:00:00	ES	Futures	1911.96	1924.64	1911.71	1918.43	42131.0
2014-03-04 02:00:00	ES	Futures	1918.17	1922.57	1917.91	1919.21	22512.0
2014-03-04 03:00:00	ES	Futures	1918.95	1922.83	1917.4	1919.98	48659.0
2014-03-04 04:00:00	ES	Futures	1920.24	1920.5	1918.17	1919.72	20134.0
2014-03-04 05:00:00	ES	Futures	1919.72	1928.52	1918.43	1926.97	48103.0
2014-03-04 06:00:00	ES	Futures	1926.71	1929.55	1925.16	1926.45	64126.0
2014-03-04 07:00:00	ES	Futures	1926.45	1930.33	1926.19	1926.97	51703.0
2014-03-04 08:00:00	ES	Futures	1927.23	1927.23	1924.12	1925.93	47236.0
2014-03-04 09:00:00	ES	Futures	1925.93	1932.4	1924.64	1931.62	256807.0
2014-03-04 10:00:00	ES	Futures	1931.62	1934.73	1929.04	1933.43	219562.0
2014-03-04 11:00:00	ES	Futures	1933.43	1934.73	1931.62	1933.17	113152.0
2014-03-04 12:00:00	ES	Futures	1933.17	1936.54	1932.92	1935.24	134276.0
2014-03-04 13:00:00	ES	Futures	1935.24	1936.8	1931.62	1933.17	150677.0
2014-03-04 14:00:00	ES	Futures	1933.17	1937.05	1930.85	1936.02	159852.0
2014-03-04 15:00:00	ES	Futures	1936.02	1939.64	1935.5	1936.54	228942.0
2014-03-04 16:00:00	ES	Futures	1936.54	1937.83	1934.21	1935.76	93547.0
2014-03-04 17:00:00	ES	Futures	1935.76	1936.8	1935.5	1936.28	2389.0
2014-03-04 18:00:00	ES	Futures	1935.5	1935.76	1933.95	1934.21	6854.0
2014-03-04 19:00:00	ES	Futures	1934.21	1934.73	1932.92	1934.47	5548.0
2014-03-04 20:00:00	ES	Futures	1934.21	1935.5	1933.43	1933.95	4298.0
2014-03-04 21:00:00	ES	Futures	1933.95	1934.73	1933.69	1934.21	2296.0
2014-03-04 22:00:00	ES	Futures	1934.21	1935.24	1933.69	1934.21	2508.0
2014-03-04 23:00:00	ES	Futures	1934.21	1936.28	1934.21	1935.76	3259.0
2014-03-04 00:00:00	NQ	Futures	4274.52	4281.5	4274.23	4278.88	993.0
2014-03-04 01:00:00	NQ	Futures	4278.88	4309.4	4278.88	4294.58	6312.0
2014-03-04 02:00:00	NQ	Futures	4294.29	4303.88	4293.99	4297.48	2551.0
2014-03-04 03:00:00	NQ	Futures	4297.77	4305.33	4292.54	4298.06	5597.0
2014-03-04 04:00:00	NQ	Futures	4298.06	4299.23	4292.25	4296.03	2442.0
2014-03-04 05:00:00	NQ	Futures	4296.03	4316.96	4293.99	4313.76	6540.0
2014-03-04 06:00:00	NQ	Futures	4313.76	4319.87	4309.98	4312.6	7198.0
2014-03-04 07:00:00	NQ	Futures	4312.89	4317.83	4311.44	4312.6	5198.0
2014-03-04 08:00:00	NQ	Futures	4312.6	4312.89	4305.91	4309.69	7678.0
2014-03-04 09:00:00	NQ	Futures	4309.98	4322.19	4308.53	4320.45	43590.0
2014-03-04 10:00:00	NQ	Futures	4320.45	4325.68	4314.92	4324.52	42194.0
2014-03-04 11:00:00	NQ	Futures	4324.52	4325.68	4318.12	4322.19	20319.0
2014-03-04 12:00:00	NQ	Futures	4322.19	4329.17	4321.32	4324.23	19662.0
2014-03-04 13:00:00	NQ	Futures	4324.23	4326.26	4316.09	4316.67	24888.0
2014-03-04 14:00:00	NQ	Futures	4316.67	4324.23	4311.15	4321.9	23452.0
2014-03-04 15:00:00	NQ	Futures	4321.9	4329.17	4320.74	4322.77	32613.0
2014-03-04 16:00:00	NQ	Futures	4322.48	4326.55	4319.28	4322.19	7317.0
2014-03-04 17:00:00	NQ	Futures	4321.9	4325.1	4321.9	4323.94	180.0
2014-03-04 18:00:00	NQ	Futures	4323.64	4323.64	4318.41	4321.32	847.0
2014-03-04 19:00:00	NQ	Futures	4321.32	4321.9	4317.54	4321.03	808.0
2014-03-04 20:00:00	NQ	Futures	4320.45	4323.06	4318.12	4319.87	649.0
2014-03-04 21:00:00	NQ	Futures	4320.45	4321.61	4318.99	4321.03	365.0
2014-03-04 22:00:00	NQ	Futures	4321.61	4322.77	4319.58	4320.45	275.0
2014-03-04 23:00:00	NQ	Futures	4320.74	4324.52	4320.74	4324.23	308.0
2014-03-04 00:00:00	YM	Futures	16586.9	16608.5	16585.9	16603.3	672.0
2014-03-04 01:00:00	YM	Futures	16602.3	16716.1	16602.3	16671.0	5675.0

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

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