PREVIEW / futures_1hour / 2014-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-02.parquet
  size:    49 KB
  rows:    1,549

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-02 00:00:00	ES	Futures	1953.51	1954.03	1952.99	1953.51	1911.0
2014-04-02 01:00:00	ES	Futures	1953.51	1953.77	1951.95	1952.73	3272.0
2014-04-02 02:00:00	ES	Futures	1952.73	1953.51	1951.95	1952.21	5710.0
2014-04-02 03:00:00	ES	Futures	1952.21	1953.51	1951.17	1952.47	19128.0
2014-04-02 04:00:00	ES	Futures	1952.73	1954.03	1951.95	1952.99	16851.0
2014-04-02 05:00:00	ES	Futures	1952.99	1954.03	1952.47	1953.25	8666.0
2014-04-02 06:00:00	ES	Futures	1953.25	1954.03	1951.43	1951.95	17815.0
2014-04-02 07:00:00	ES	Futures	1951.95	1952.99	1949.61	1950.65	21274.0
2014-04-02 08:00:00	ES	Futures	1950.39	1952.73	1949.87	1951.17	24971.0
2014-04-02 09:00:00	ES	Futures	1951.17	1953.51	1948.83	1950.13	175825.0
2014-04-02 10:00:00	ES	Futures	1950.13	1956.1	1950.13	1955.58	193137.0
2014-04-02 11:00:00	ES	Futures	1955.32	1956.36	1953.25	1955.58	127000.0
2014-04-02 12:00:00	ES	Futures	1955.58	1956.88	1953.77	1955.32	83180.0
2014-04-02 13:00:00	ES	Futures	1955.32	1955.58	1950.91	1952.47	105948.0
2014-04-02 14:00:00	ES	Futures	1952.47	1954.54	1951.43	1954.54	84721.0
2014-04-02 15:00:00	ES	Futures	1954.54	1959.22	1954.03	1956.62	192458.0
2014-04-02 16:00:00	ES	Futures	1956.36	1957.14	1955.32	1956.1	60313.0
2014-04-02 17:00:00	ES	Futures	1956.36	1956.36	1955.58	1955.84	1864.0
2014-04-02 18:00:00	ES	Futures	1955.58	1955.84	1954.54	1955.06	3553.0
2014-04-02 19:00:00	ES	Futures	1955.06	1955.32	1954.03	1954.29	2423.0
2014-04-02 20:00:00	ES	Futures	1954.54	1955.32	1954.03	1955.06	4267.0
2014-04-02 21:00:00	ES	Futures	1954.8	1956.1	1954.29	1954.29	4618.0
2014-04-02 22:00:00	ES	Futures	1954.29	1955.84	1954.29	1955.58	2357.0
2014-04-02 23:00:00	ES	Futures	1955.32	1955.84	1954.54	1955.06	2216.0
2014-04-02 00:00:00	NQ	Futures	4260.58	4262.04	4260.29	4260.87	292.0
2014-04-02 01:00:00	NQ	Futures	4260.87	4261.75	4258.25	4259.71	530.0
2014-04-02 02:00:00	NQ	Futures	4259.42	4262.04	4258.54	4259.71	1099.0
2014-04-02 03:00:00	NQ	Futures	4260.0	4263.2	4256.8	4261.75	2610.0
2014-04-02 04:00:00	NQ	Futures	4261.16	4264.95	4260.0	4261.75	4027.0
2014-04-02 05:00:00	NQ	Futures	4261.75	4265.53	4260.87	4262.04	1523.0
2014-04-02 06:00:00	NQ	Futures	4262.33	4264.08	4256.8	4258.54	2682.0
2014-04-02 07:00:00	NQ	Futures	4258.54	4262.62	4254.47	4255.05	4574.0
2014-04-02 08:00:00	NQ	Futures	4255.05	4261.16	4254.76	4257.38	5976.0
2014-04-02 09:00:00	NQ	Futures	4257.38	4273.4	4251.85	4253.3	46565.0
2014-04-02 10:00:00	NQ	Futures	4253.01	4263.2	4246.02	4262.04	45222.0
2014-04-02 11:00:00	NQ	Futures	4262.04	4266.12	4253.01	4259.71	22923.0
2014-04-02 12:00:00	NQ	Futures	4259.42	4260.87	4252.14	4259.42	14906.0
2014-04-02 13:00:00	NQ	Futures	4259.71	4260.0	4243.11	4249.22	18963.0
2014-04-02 14:00:00	NQ	Futures	4249.22	4253.59	4244.27	4253.59	17076.0
2014-04-02 15:00:00	NQ	Futures	4253.59	4266.7	4250.68	4262.62	39045.0
2014-04-02 16:00:00	NQ	Futures	4262.62	4265.53	4260.0	4263.49	6273.0
2014-04-02 17:00:00	NQ	Futures	4264.08	4264.08	4262.33	4262.62	114.0
2014-04-02 18:00:00	NQ	Futures	4261.46	4262.04	4258.83	4260.0	670.0
2014-04-02 19:00:00	NQ	Futures	4259.71	4259.71	4257.09	4257.67	448.0
2014-04-02 20:00:00	NQ	Futures	4257.38	4260.0	4256.8	4258.83	509.0
2014-04-02 21:00:00	NQ	Futures	4258.25	4262.04	4257.09	4257.67	817.0
2014-04-02 22:00:00	NQ	Futures	4257.67	4260.87	4257.67	4260.0	216.0
2014-04-02 23:00:00	NQ	Futures	4260.0	4261.46	4258.54	4258.83	203.0
2014-04-02 00:00:00	YM	Futures	16966.9	16970.0	16963.8	16965.9	191.0
2014-04-02 01:00:00	YM	Futures	16966.9	16970.0	16954.6	16958.7	367.0

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

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