PREVIEW / futures_1hour / 2014-07-10

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-10.parquet
  size:    49 KB
  rows:    1,547

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-07-10 00:00:00	ES	Futures	2047.9	2048.43	2047.64	2048.43	1039.0
2014-07-10 01:00:00	ES	Futures	2048.43	2049.21	2047.9	2049.21	1809.0
2014-07-10 02:00:00	ES	Futures	2048.95	2049.73	2047.9	2048.43	5475.0
2014-07-10 03:00:00	ES	Futures	2048.17	2048.69	2044.78	2045.82	27457.0
2014-07-10 04:00:00	ES	Futures	2045.82	2045.82	2038.78	2039.04	43593.0
2014-07-10 05:00:00	ES	Futures	2039.04	2040.35	2033.05	2034.61	61881.0
2014-07-10 06:00:00	ES	Futures	2034.87	2035.4	2030.96	2032.01	52646.0
2014-07-10 07:00:00	ES	Futures	2032.01	2034.09	2030.18	2032.27	50194.0
2014-07-10 08:00:00	ES	Futures	2032.53	2034.09	2028.88	2029.14	69412.0
2014-07-10 09:00:00	ES	Futures	2028.88	2034.35	2027.84	2032.01	339257.0
2014-07-10 10:00:00	ES	Futures	2032.01	2040.09	2031.75	2039.83	367782.0
2014-07-10 11:00:00	ES	Futures	2039.83	2041.13	2037.74	2040.09	186565.0
2014-07-10 12:00:00	ES	Futures	2039.83	2043.47	2038.52	2041.65	152676.0
2014-07-10 13:00:00	ES	Futures	2041.39	2047.38	2041.13	2044.0	155848.0
2014-07-10 14:00:00	ES	Futures	2044.26	2045.56	2040.35	2040.35	146105.0
2014-07-10 15:00:00	ES	Futures	2040.61	2044.0	2038.52	2041.65	215139.0
2014-07-10 16:00:00	ES	Futures	2041.91	2041.91	2039.83	2040.09	75826.0
2014-07-10 17:00:00	ES	Futures	2039.83	2040.87	2039.83	2040.61	1916.0
2014-07-10 18:00:00	ES	Futures	2040.35	2040.61	2039.57	2040.35	2234.0
2014-07-10 19:00:00	ES	Futures	2040.35	2041.13	2039.57	2040.87	2671.0
2014-07-10 20:00:00	ES	Futures	2040.61	2042.17	2040.35	2040.61	5896.0
2014-07-10 21:00:00	ES	Futures	2040.61	2041.13	2040.09	2040.87	3336.0
2014-07-10 22:00:00	ES	Futures	2040.87	2042.95	2040.87	2042.69	4081.0
2014-07-10 23:00:00	ES	Futures	2042.69	2042.95	2041.13	2041.39	1597.0
2014-07-10 00:00:00	NQ	Futures	4534.99	4535.57	4534.11	4535.28	161.0
2014-07-10 01:00:00	NQ	Futures	4535.57	4537.91	4534.99	4537.91	553.0
2014-07-10 02:00:00	NQ	Futures	4537.91	4539.08	4535.28	4535.57	560.0
2014-07-10 03:00:00	NQ	Futures	4535.57	4535.86	4526.23	4530.32	3758.0
2014-07-10 04:00:00	NQ	Futures	4530.02	4530.32	4512.5	4514.26	6677.0
2014-07-10 05:00:00	NQ	Futures	4513.96	4518.64	4501.99	4506.08	10798.0
2014-07-10 06:00:00	NQ	Futures	4506.37	4506.95	4494.98	4496.15	9709.0
2014-07-10 07:00:00	NQ	Futures	4496.15	4501.99	4492.94	4497.9	6201.0
2014-07-10 08:00:00	NQ	Futures	4497.9	4500.24	4483.3	4484.18	11281.0
2014-07-10 09:00:00	NQ	Futures	4483.89	4494.4	4475.42	4484.76	59440.0
2014-07-10 10:00:00	NQ	Futures	4484.76	4517.47	4484.18	4516.59	55133.0
2014-07-10 11:00:00	NQ	Futures	4516.59	4523.31	4513.67	4519.51	34386.0
2014-07-10 12:00:00	NQ	Futures	4519.22	4534.7	4516.59	4529.15	25264.0
2014-07-10 13:00:00	NQ	Futures	4529.15	4543.16	4527.98	4534.7	24181.0
2014-07-10 14:00:00	NQ	Futures	4534.4	4537.32	4522.14	4522.14	22963.0
2014-07-10 15:00:00	NQ	Futures	4522.14	4530.9	4516.01	4525.35	36703.0
2014-07-10 16:00:00	NQ	Futures	4525.35	4525.94	4521.26	4523.89	6264.0
2014-07-10 17:00:00	NQ	Futures	4524.18	4526.23	4523.89	4525.94	397.0
2014-07-10 18:00:00	NQ	Futures	4525.35	4526.52	4523.02	4524.77	393.0
2014-07-10 19:00:00	NQ	Futures	4524.77	4526.23	4523.31	4525.94	257.0
2014-07-10 20:00:00	NQ	Futures	4525.94	4529.15	4525.06	4526.23	878.0
2014-07-10 21:00:00	NQ	Futures	4525.94	4527.98	4524.77	4526.81	399.0
2014-07-10 22:00:00	NQ	Futures	4527.1	4532.07	4527.1	4530.9	985.0
2014-07-10 23:00:00	NQ	Futures	4531.48	4531.78	4526.81	4527.1	519.0
2014-07-10 00:00:00	YM	Futures	17478.0	17478.0	17473.8	17478.0	160.0
2014-07-10 01:00:00	YM	Futures	17475.9	17483.2	17473.8	17482.1	296.0

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

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