PREVIEW / futures_1hour / 2014-03-25

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-25.parquet
  size:    48 KB
  rows:    1,521

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-25 00:00:00	ES	Futures	1924.68	1925.46	1923.64	1924.16	2840.0
2014-03-25 01:00:00	ES	Futures	1924.16	1924.68	1922.35	1922.87	2001.0
2014-03-25 02:00:00	ES	Futures	1922.61	1922.87	1920.01	1921.83	7164.0
2014-03-25 03:00:00	ES	Futures	1921.57	1922.87	1919.49	1919.75	7863.0
2014-03-25 04:00:00	ES	Futures	1919.75	1924.68	1919.75	1920.79	36581.0
2014-03-25 05:00:00	ES	Futures	1921.05	1925.2	1920.79	1924.16	27726.0
2014-03-25 06:00:00	ES	Futures	1924.16	1925.2	1923.12	1924.16	13476.0
2014-03-25 07:00:00	ES	Futures	1924.16	1928.06	1923.38	1927.02	37318.0
2014-03-25 08:00:00	ES	Futures	1927.02	1930.66	1926.76	1929.88	34168.0
2014-03-25 09:00:00	ES	Futures	1929.88	1934.81	1928.84	1932.99	189251.0
2014-03-25 10:00:00	ES	Futures	1933.25	1936.63	1923.38	1924.42	353805.0
2014-03-25 11:00:00	ES	Futures	1924.42	1928.58	1920.01	1923.12	242136.0
2014-03-25 12:00:00	ES	Futures	1923.12	1927.8	1919.49	1926.76	186972.0
2014-03-25 13:00:00	ES	Futures	1927.02	1932.73	1925.72	1930.66	154753.0
2014-03-25 14:00:00	ES	Futures	1930.66	1932.99	1928.06	1929.1	126003.0
2014-03-25 15:00:00	ES	Futures	1929.1	1932.73	1928.58	1930.66	144978.0
2014-03-25 16:00:00	ES	Futures	1930.66	1931.43	1930.14	1930.66	63515.0
2014-03-25 17:00:00	ES	Futures	1930.91	1931.17	1930.66	1930.66	1398.0
2014-03-25 18:00:00	ES	Futures	1930.91	1933.25	1930.4	1932.99	4266.0
2014-03-25 19:00:00	ES	Futures	1932.99	1934.29	1932.73	1934.29	4691.0
2014-03-25 20:00:00	ES	Futures	1934.29	1935.07	1932.73	1933.25	4325.0
2014-03-25 21:00:00	ES	Futures	1933.51	1934.55	1932.73	1934.29	3252.0
2014-03-25 22:00:00	ES	Futures	1934.29	1934.55	1932.73	1933.25	2997.0
2014-03-25 23:00:00	ES	Futures	1933.25	1933.77	1932.73	1933.25	1859.0
2014-03-25 00:00:00	NQ	Futures	4213.4	4214.28	4211.07	4211.66	363.0
2014-03-25 01:00:00	NQ	Futures	4211.37	4212.53	4208.16	4208.74	406.0
2014-03-25 02:00:00	NQ	Futures	4208.45	4209.33	4203.5	4206.41	799.0
2014-03-25 03:00:00	NQ	Futures	4207.0	4209.04	4201.17	4201.46	889.0
2014-03-25 04:00:00	NQ	Futures	4201.75	4214.57	4201.75	4204.96	4471.0
2014-03-25 05:00:00	NQ	Futures	4205.25	4215.15	4204.67	4212.82	3476.0
2014-03-25 06:00:00	NQ	Futures	4213.11	4215.44	4210.78	4213.4	1828.0
2014-03-25 07:00:00	NQ	Futures	4213.4	4220.1	4210.78	4218.65	6414.0
2014-03-25 08:00:00	NQ	Futures	4218.65	4225.93	4218.35	4223.89	6606.0
2014-03-25 09:00:00	NQ	Futures	4224.18	4243.69	4221.56	4241.36	53023.0
2014-03-25 10:00:00	NQ	Futures	4241.36	4254.17	4200.3	4204.38	89070.0
2014-03-25 11:00:00	NQ	Futures	4204.08	4219.23	4184.28	4192.44	57024.0
2014-03-25 12:00:00	NQ	Futures	4192.14	4212.53	4183.12	4209.04	40543.0
2014-03-25 13:00:00	NQ	Futures	4209.04	4225.34	4203.79	4217.77	33108.0
2014-03-25 14:00:00	NQ	Futures	4217.77	4225.93	4209.91	4214.86	23650.0
2014-03-25 15:00:00	NQ	Futures	4214.57	4225.05	4211.07	4218.06	31679.0
2014-03-25 16:00:00	NQ	Futures	4218.06	4222.43	4217.48	4221.85	5882.0
2014-03-25 17:00:00	NQ	Futures	4221.85	4222.43	4221.56	4221.85	184.0
2014-03-25 18:00:00	NQ	Futures	4219.81	4225.05	4219.52	4225.05	568.0
2014-03-25 19:00:00	NQ	Futures	4224.76	4229.13	4224.76	4229.13	526.0
2014-03-25 20:00:00	NQ	Futures	4228.55	4231.17	4225.64	4227.09	998.0
2014-03-25 21:00:00	NQ	Futures	4227.09	4229.13	4225.64	4228.84	370.0
2014-03-25 22:00:00	NQ	Futures	4228.84	4229.13	4225.05	4225.64	455.0
2014-03-25 23:00:00	NQ	Futures	4225.64	4226.8	4224.76	4226.22	215.0
2014-03-25 00:00:00	YM	Futures	16712.6	16717.7	16702.3	16705.4	420.0
2014-03-25 01:00:00	YM	Futures	16704.3	16711.5	16695.1	16695.1	332.0

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

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