PREVIEW / futures_1hour / 2014-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-23.parquet
  size:    47 KB
  rows:    1,545

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-23 00:00:00	ES	Futures	1945.98	1946.5	1945.72	1946.5	631.0
2014-04-23 01:00:00	ES	Futures	1946.5	1947.53	1945.98	1947.01	2336.0
2014-04-23 02:00:00	ES	Futures	1947.01	1947.79	1946.75	1947.79	5477.0
2014-04-23 03:00:00	ES	Futures	1947.53	1947.79	1945.72	1947.27	19662.0
2014-04-23 04:00:00	ES	Futures	1947.53	1948.05	1945.98	1947.27	12915.0
2014-04-23 05:00:00	ES	Futures	1947.01	1947.27	1943.64	1943.9	15457.0
2014-04-23 06:00:00	ES	Futures	1943.9	1944.94	1943.64	1944.16	15840.0
2014-04-23 07:00:00	ES	Futures	1944.42	1945.2	1943.38	1943.9	21958.0
2014-04-23 08:00:00	ES	Futures	1943.9	1945.2	1942.34	1944.68	25735.0
2014-04-23 09:00:00	ES	Futures	1944.68	1946.24	1941.56	1943.38	156216.0
2014-04-23 10:00:00	ES	Futures	1943.12	1945.98	1939.74	1944.16	190640.0
2014-04-23 11:00:00	ES	Futures	1943.9	1945.2	1940.78	1944.42	110606.0
2014-04-23 12:00:00	ES	Futures	1944.68	1944.94	1941.82	1943.9	52621.0
2014-04-23 13:00:00	ES	Futures	1943.9	1944.68	1941.3	1942.34	68504.0
2014-04-23 14:00:00	ES	Futures	1942.34	1942.86	1940.52	1942.08	69227.0
2014-04-23 15:00:00	ES	Futures	1942.08	1943.64	1941.04	1941.56	98370.0
2014-04-23 16:00:00	ES	Futures	1941.3	1951.69	1941.04	1950.91	96804.0
2014-04-23 17:00:00	ES	Futures	1950.65	1953.51	1950.39	1952.99	8766.0
2014-04-23 18:00:00	ES	Futures	1951.69	1952.47	1950.39	1951.43	8373.0
2014-04-23 19:00:00	ES	Futures	1951.43	1951.95	1950.91	1951.43	2215.0
2014-04-23 20:00:00	ES	Futures	1951.43	1951.69	1950.91	1950.91	2209.0
2014-04-23 21:00:00	ES	Futures	1950.91	1951.43	1950.39	1950.39	2444.0
2014-04-23 22:00:00	ES	Futures	1950.39	1951.43	1950.39	1950.91	2560.0
2014-04-23 23:00:00	ES	Futures	1951.17	1951.17	1950.13	1950.65	2513.0
2014-04-23 00:00:00	NQ	Futures	4171.76	4173.22	4171.47	4172.34	143.0
2014-04-23 01:00:00	NQ	Futures	4172.92	4175.84	4172.05	4174.67	359.0
2014-04-23 02:00:00	NQ	Futures	4174.67	4178.17	4174.67	4177.0	949.0
2014-04-23 03:00:00	NQ	Futures	4177.0	4178.46	4172.92	4177.0	2920.0
2014-04-23 04:00:00	NQ	Futures	4177.0	4179.91	4174.09	4177.29	1849.0
2014-04-23 05:00:00	NQ	Futures	4176.42	4176.71	4167.39	4167.68	2057.0
2014-04-23 06:00:00	NQ	Futures	4167.97	4170.59	4166.52	4168.56	2055.0
2014-04-23 07:00:00	NQ	Futures	4168.26	4171.18	4165.93	4166.23	4761.0
2014-04-23 08:00:00	NQ	Futures	4166.52	4171.47	4163.9	4170.01	4950.0
2014-04-23 09:00:00	NQ	Futures	4170.3	4171.76	4146.13	4149.92	41735.0
2014-04-23 10:00:00	NQ	Futures	4150.5	4152.83	4137.1	4147.88	50135.0
2014-04-23 11:00:00	NQ	Futures	4147.88	4151.37	4139.43	4149.33	24824.0
2014-04-23 12:00:00	NQ	Futures	4149.63	4150.21	4138.56	4143.8	12193.0
2014-04-23 13:00:00	NQ	Futures	4143.8	4145.55	4133.9	4136.23	16540.0
2014-04-23 14:00:00	NQ	Futures	4135.65	4137.98	4131.28	4135.36	18822.0
2014-04-23 15:00:00	NQ	Futures	4135.07	4142.64	4130.7	4132.44	27183.0
2014-04-23 16:00:00	NQ	Futures	4132.74	4184.28	4132.15	4180.79	30731.0
2014-04-23 17:00:00	NQ	Futures	4180.79	4193.02	4180.2	4191.56	3393.0
2014-04-23 18:00:00	NQ	Futures	4188.65	4188.65	4182.24	4186.32	2304.0
2014-04-23 19:00:00	NQ	Futures	4186.32	4188.07	4185.45	4186.61	823.0
2014-04-23 20:00:00	NQ	Futures	4186.61	4187.49	4183.7	4184.57	765.0
2014-04-23 21:00:00	NQ	Futures	4184.28	4184.86	4182.24	4182.24	958.0
2014-04-23 22:00:00	NQ	Futures	4182.53	4183.99	4181.95	4183.7	927.0
2014-04-23 23:00:00	NQ	Futures	4183.99	4184.28	4182.83	4183.7	595.0
2014-04-23 00:00:00	YM	Futures	16952.5	16955.6	16950.5	16955.6	192.0
2014-04-23 01:00:00	YM	Futures	16954.6	16960.8	16951.5	16958.7	377.0

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

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