PREVIEW / futures_1hour / 2014-03-05

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-05.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-03-05 00:00:00	ES	Futures	1935.76	1936.02	1934.73	1934.73	1859.0
2014-03-05 01:00:00	ES	Futures	1934.99	1935.5	1932.4	1933.69	4969.0
2014-03-05 02:00:00	ES	Futures	1933.43	1934.73	1933.17	1934.73	6499.0
2014-03-05 03:00:00	ES	Futures	1934.73	1938.09	1933.43	1937.83	28058.0
2014-03-05 04:00:00	ES	Futures	1937.57	1937.57	1935.24	1935.76	15474.0
2014-03-05 05:00:00	ES	Futures	1935.76	1936.54	1934.99	1936.02	9996.0
2014-03-05 06:00:00	ES	Futures	1936.02	1937.31	1934.73	1936.28	10660.0
2014-03-05 07:00:00	ES	Futures	1936.28	1939.64	1935.5	1939.12	36269.0
2014-03-05 08:00:00	ES	Futures	1939.12	1939.64	1936.02	1936.8	45691.0
2014-03-05 09:00:00	ES	Futures	1936.8	1938.86	1934.21	1935.5	214952.0
2014-03-05 10:00:00	ES	Futures	1935.5	1939.9	1933.95	1937.57	197238.0
2014-03-05 11:00:00	ES	Futures	1937.57	1940.42	1935.24	1937.57	152994.0
2014-03-05 12:00:00	ES	Futures	1937.31	1938.35	1935.24	1937.31	67823.0
2014-03-05 13:00:00	ES	Futures	1937.31	1939.64	1935.24	1936.28	96216.0
2014-03-05 14:00:00	ES	Futures	1936.54	1938.35	1935.5	1936.02	115169.0
2014-03-05 15:00:00	ES	Futures	1936.28	1937.83	1934.21	1937.05	148808.0
2014-03-05 16:00:00	ES	Futures	1937.05	1938.35	1935.76	1937.57	53618.0
2014-03-05 17:00:00	ES	Futures	1937.57	1938.86	1937.31	1938.86	3369.0
2014-03-05 18:00:00	ES	Futures	1938.61	1938.86	1935.76	1937.31	6196.0
2014-03-05 19:00:00	ES	Futures	1937.31	1937.31	1936.28	1937.31	2329.0
2014-03-05 20:00:00	ES	Futures	1937.05	1938.09	1936.54	1937.31	3523.0
2014-03-05 21:00:00	ES	Futures	1937.57	1938.09	1936.8	1937.31	2445.0
2014-03-05 22:00:00	ES	Futures	1937.31	1939.9	1937.05	1939.9	4947.0
2014-03-05 23:00:00	ES	Futures	1939.9	1941.19	1939.38	1940.68	5388.0
2014-03-05 00:00:00	NQ	Futures	4324.23	4324.23	4321.61	4321.9	180.0
2014-03-05 01:00:00	NQ	Futures	4321.9	4322.77	4316.67	4318.7	489.0
2014-03-05 02:00:00	NQ	Futures	4318.99	4320.74	4318.12	4320.45	415.0
2014-03-05 03:00:00	NQ	Futures	4320.74	4327.71	4318.41	4326.84	2785.0
2014-03-05 04:00:00	NQ	Futures	4326.55	4326.55	4322.19	4323.06	1067.0
2014-03-05 05:00:00	NQ	Futures	4322.48	4324.23	4320.45	4322.48	832.0
2014-03-05 06:00:00	NQ	Futures	4322.77	4324.81	4320.45	4322.77	1036.0
2014-03-05 07:00:00	NQ	Futures	4322.48	4330.33	4321.32	4328.3	4583.0
2014-03-05 08:00:00	NQ	Futures	4328.59	4329.75	4324.23	4325.39	6159.0
2014-03-05 09:00:00	NQ	Futures	4325.39	4330.91	4321.61	4323.94	40568.0
2014-03-05 10:00:00	NQ	Futures	4323.64	4335.56	4318.7	4330.91	35731.0
2014-03-05 11:00:00	NQ	Futures	4330.91	4337.02	4327.13	4331.78	24982.0
2014-03-05 12:00:00	NQ	Futures	4331.78	4337.6	4327.71	4335.27	14110.0
2014-03-05 13:00:00	NQ	Futures	4335.56	4339.92	4330.04	4331.78	17672.0
2014-03-05 14:00:00	NQ	Futures	4332.07	4336.43	4328.59	4330.91	23558.0
2014-03-05 15:00:00	NQ	Futures	4331.2	4334.69	4327.13	4333.53	21153.0
2014-03-05 16:00:00	NQ	Futures	4333.53	4337.6	4331.49	4337.02	4492.0
2014-03-05 17:00:00	NQ	Futures	4337.02	4339.92	4336.14	4339.63	1258.0
2014-03-05 18:00:00	NQ	Futures	4338.76	4339.05	4332.66	4336.14	1174.0
2014-03-05 19:00:00	NQ	Futures	4336.14	4336.73	4334.11	4336.73	436.0
2014-03-05 20:00:00	NQ	Futures	4336.43	4339.05	4334.69	4337.31	678.0
2014-03-05 21:00:00	NQ	Futures	4337.02	4338.18	4335.27	4336.43	325.0
2014-03-05 22:00:00	NQ	Futures	4336.43	4340.5	4335.85	4340.5	876.0
2014-03-05 23:00:00	NQ	Futures	4340.5	4341.67	4339.92	4340.8	1079.0
2014-03-05 00:00:00	YM	Futures	16797.1	16797.1	16786.9	16789.9	232.0
2014-03-05 01:00:00	YM	Futures	16791.0	16792.0	16773.5	16781.7	600.0

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

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