PREVIEW / futures_1hour / 2014-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-29.parquet
  size:    52 KB
  rows:    1,572

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-10-29 00:00:00	ES	Futures	2070.85	2071.38	2070.07	2071.11	1406.0
2014-10-29 01:00:00	ES	Futures	2071.11	2071.64	2070.85	2071.38	1441.0
2014-10-29 02:00:00	ES	Futures	2071.11	2073.47	2071.11	2072.95	2463.0
2014-10-29 03:00:00	ES	Futures	2072.69	2075.57	2072.69	2074.78	11446.0
2014-10-29 04:00:00	ES	Futures	2074.52	2075.31	2071.11	2072.42	30577.0
2014-10-29 05:00:00	ES	Futures	2072.42	2076.35	2072.42	2074.78	20433.0
2014-10-29 06:00:00	ES	Futures	2074.52	2074.78	2071.11	2071.38	21982.0
2014-10-29 07:00:00	ES	Futures	2071.38	2072.42	2069.54	2071.9	24747.0
2014-10-29 08:00:00	ES	Futures	2071.64	2073.73	2071.11	2072.95	30139.0
2014-10-29 09:00:00	ES	Futures	2073.21	2080.81	2072.69	2080.28	209175.0
2014-10-29 10:00:00	ES	Futures	2080.28	2080.54	2071.11	2072.42	279983.0
2014-10-29 11:00:00	ES	Futures	2072.69	2075.83	2071.64	2073.73	155264.0
2014-10-29 12:00:00	ES	Futures	2073.73	2073.73	2068.49	2070.07	159396.0
2014-10-29 13:00:00	ES	Futures	2069.8	2070.59	2065.87	2069.8	106203.0
2014-10-29 14:00:00	ES	Futures	2069.8	2069.8	2055.92	2065.61	442083.0
2014-10-29 15:00:00	ES	Futures	2065.87	2073.21	2058.02	2070.07	293429.0
2014-10-29 16:00:00	ES	Futures	2070.07	2070.59	2065.87	2066.4	63198.0
2014-10-29 17:00:00	ES	Futures	2066.14	2066.14	2065.35	2065.61	1684.0
2014-10-29 18:00:00	ES	Futures	2066.14	2068.23	2064.3	2067.18	4964.0
2014-10-29 19:00:00	ES	Futures	2067.18	2067.45	2064.83	2064.83	2097.0
2014-10-29 20:00:00	ES	Futures	2064.56	2067.97	2064.56	2066.66	4253.0
2014-10-29 21:00:00	ES	Futures	2066.66	2067.45	2065.35	2066.14	2546.0
2014-10-29 22:00:00	ES	Futures	2066.14	2067.71	2065.87	2067.45	2048.0
2014-10-29 23:00:00	ES	Futures	2067.71	2067.97	2066.92	2067.18	1365.0
2014-10-29 00:00:00	NQ	Futures	4778.63	4780.1	4777.46	4779.8	308.0
2014-10-29 01:00:00	NQ	Futures	4779.8	4780.68	4778.04	4779.22	399.0
2014-10-29 02:00:00	NQ	Futures	4779.51	4783.32	4779.51	4782.44	629.0
2014-10-29 03:00:00	NQ	Futures	4782.44	4788.3	4782.44	4785.66	1371.0
2014-10-29 04:00:00	NQ	Futures	4785.37	4789.18	4779.8	4784.2	4615.0
2014-10-29 05:00:00	NQ	Futures	4783.61	4794.75	4783.32	4793.57	4574.0
2014-10-29 06:00:00	NQ	Futures	4793.28	4793.57	4785.37	4785.96	3198.0
2014-10-29 07:00:00	NQ	Futures	4785.96	4788.01	4780.68	4786.25	3023.0
2014-10-29 08:00:00	NQ	Futures	4785.96	4791.82	4784.2	4788.01	4403.0
2014-10-29 09:00:00	NQ	Futures	4788.01	4800.9	4782.73	4798.26	40383.0
2014-10-29 10:00:00	NQ	Futures	4797.97	4799.14	4781.27	4785.08	45813.0
2014-10-29 11:00:00	NQ	Futures	4785.37	4794.16	4782.73	4786.54	25292.0
2014-10-29 12:00:00	NQ	Futures	4786.54	4787.13	4773.94	4776.87	30929.0
2014-10-29 13:00:00	NQ	Futures	4777.17	4781.27	4770.43	4779.22	16238.0
2014-10-29 14:00:00	NQ	Futures	4779.22	4782.44	4752.26	4777.17	87309.0
2014-10-29 15:00:00	NQ	Futures	4777.17	4790.35	4760.17	4786.54	52844.0
2014-10-29 16:00:00	NQ	Futures	4786.54	4787.13	4770.13	4772.48	9140.0
2014-10-29 17:00:00	NQ	Futures	4772.18	4773.06	4771.31	4772.77	344.0
2014-10-29 18:00:00	NQ	Futures	4772.77	4776.87	4768.67	4775.7	1103.0
2014-10-29 19:00:00	NQ	Futures	4775.41	4775.99	4768.96	4769.55	465.0
2014-10-29 20:00:00	NQ	Futures	4768.96	4776.58	4768.38	4774.53	781.0
2014-10-29 21:00:00	NQ	Futures	4774.53	4775.41	4770.43	4774.24	535.0
2014-10-29 22:00:00	NQ	Futures	4773.94	4776.58	4773.06	4776.58	389.0
2014-10-29 23:00:00	NQ	Futures	4776.87	4777.75	4775.11	4776.87	317.0
2014-10-29 00:00:00	YM	Futures	17591.8	17597.0	17589.7	17594.9	269.0
2014-10-29 01:00:00	YM	Futures	17593.8	17597.0	17592.8	17597.0	304.0

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

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