PREVIEW / futures_1hour / 2014-02-24

all futures 1-hour files

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

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-02-24 00:00:00	ES	Futures	1893.6	1896.96	1893.6	1896.7	3728.0
2014-02-24 01:00:00	ES	Futures	1896.7	1897.74	1895.93	1897.74	2224.0
2014-02-24 02:00:00	ES	Futures	1897.48	1898.0	1896.96	1897.74	6828.0
2014-02-24 03:00:00	ES	Futures	1897.74	1900.84	1896.96	1900.07	26148.0
2014-02-24 04:00:00	ES	Futures	1900.07	1903.17	1899.03	1900.33	25089.0
2014-02-24 05:00:00	ES	Futures	1900.07	1900.33	1897.74	1898.52	12497.0
2014-02-24 06:00:00	ES	Futures	1898.26	1901.88	1898.26	1901.62	11685.0
2014-02-24 07:00:00	ES	Futures	1901.62	1903.17	1901.36	1902.14	15794.0
2014-02-24 08:00:00	ES	Futures	1902.39	1904.72	1901.62	1901.88	26821.0
2014-02-24 09:00:00	ES	Futures	1901.88	1913.52	1900.33	1912.74	275283.0
2014-02-24 10:00:00	ES	Futures	1912.48	1915.84	1910.41	1914.81	224618.0
2014-02-24 11:00:00	ES	Futures	1914.81	1920.5	1913.52	1919.98	204339.0
2014-02-24 12:00:00	ES	Futures	1919.98	1921.02	1918.43	1918.95	97147.0
2014-02-24 13:00:00	ES	Futures	1918.69	1919.47	1916.62	1916.62	80675.0
2014-02-24 14:00:00	ES	Futures	1916.62	1918.95	1916.36	1916.36	69680.0
2014-02-24 15:00:00	ES	Futures	1916.62	1916.62	1908.6	1908.86	319684.0
2014-02-24 16:00:00	ES	Futures	1908.6	1910.15	1905.76	1908.86	156230.0
2014-02-24 17:00:00	ES	Futures	1908.6	1909.12	1908.34	1908.34	3386.0
2014-02-24 18:00:00	ES	Futures	1908.6	1909.12	1907.05	1908.86	5715.0
2014-02-24 19:00:00	ES	Futures	1909.12	1909.9	1908.86	1909.64	4090.0
2014-02-24 20:00:00	ES	Futures	1909.9	1910.67	1908.09	1908.09	6375.0
2014-02-24 21:00:00	ES	Futures	1908.34	1908.86	1908.09	1908.34	2214.0
2014-02-24 22:00:00	ES	Futures	1908.34	1909.38	1908.34	1909.12	2753.0
2014-02-24 23:00:00	ES	Futures	1909.38	1909.38	1908.6	1909.12	1987.0
2014-02-24 00:00:00	NQ	Futures	4252.14	4259.69	4251.85	4259.11	496.0
2014-02-24 01:00:00	NQ	Futures	4259.11	4261.15	4257.95	4260.57	221.0
2014-02-24 02:00:00	NQ	Futures	4260.57	4262.31	4260.28	4262.02	686.0
2014-02-24 03:00:00	NQ	Futures	4261.73	4268.12	4260.57	4266.09	2645.0
2014-02-24 04:00:00	NQ	Futures	4266.38	4274.81	4264.05	4267.54	2871.0
2014-02-24 05:00:00	NQ	Futures	4267.54	4267.54	4261.15	4263.47	1254.0
2014-02-24 06:00:00	NQ	Futures	4263.76	4269.29	4263.47	4269.29	833.0
2014-02-24 07:00:00	NQ	Futures	4269.29	4272.48	4269.0	4270.74	1599.0
2014-02-24 08:00:00	NQ	Futures	4270.74	4276.26	4270.74	4271.61	3941.0
2014-02-24 09:00:00	NQ	Futures	4271.61	4292.83	4266.67	4291.09	44102.0
2014-02-24 10:00:00	NQ	Futures	4291.38	4298.94	4287.02	4296.9	34649.0
2014-02-24 11:00:00	NQ	Futures	4296.9	4302.72	4293.41	4300.68	22015.0
2014-02-24 12:00:00	NQ	Futures	4300.68	4302.72	4295.74	4296.61	12918.0
2014-02-24 13:00:00	NQ	Futures	4296.32	4303.59	4294.87	4296.03	12653.0
2014-02-24 14:00:00	NQ	Futures	4296.03	4303.88	4295.74	4297.19	14293.0
2014-02-24 15:00:00	NQ	Futures	4297.19	4298.36	4286.44	4286.73	33478.0
2014-02-24 16:00:00	NQ	Futures	4286.73	4289.63	4282.66	4287.89	10131.0
2014-02-24 17:00:00	NQ	Futures	4287.6	4288.76	4287.02	4287.89	1134.0
2014-02-24 18:00:00	NQ	Futures	4285.57	4287.02	4282.08	4287.02	1254.0
2014-02-24 19:00:00	NQ	Futures	4287.6	4289.93	4287.31	4289.63	301.0
2014-02-24 20:00:00	NQ	Futures	4289.34	4291.38	4285.27	4285.57	694.0
2014-02-24 21:00:00	NQ	Futures	4285.57	4287.02	4285.27	4286.73	253.0
2014-02-24 22:00:00	NQ	Futures	4286.73	4289.05	4286.73	4287.89	311.0
2014-02-24 23:00:00	NQ	Futures	4288.18	4288.47	4286.73	4287.89	223.0
2014-02-24 00:00:00	YM	Futures	16458.7	16486.4	16457.7	16484.4	444.0
2014-02-24 01:00:00	YM	Futures	16484.4	16491.6	16478.2	16488.5	339.0

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

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