PREVIEW / futures_1hour / 2014-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-27.parquet
  size:    50 KB
  rows:    1,552

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-27 00:00:00	ES	Futures	1909.12	1910.41	1908.6	1909.9	4520.0
2014-02-27 01:00:00	ES	Futures	1910.15	1910.41	1908.86	1910.15	2753.0
2014-02-27 02:00:00	ES	Futures	1909.9	1910.67	1909.38	1910.15	5354.0
2014-02-27 03:00:00	ES	Futures	1910.15	1910.67	1907.83	1909.38	26189.0
2014-02-27 04:00:00	ES	Futures	1909.64	1909.9	1899.81	1900.33	65017.0
2014-02-27 05:00:00	ES	Futures	1900.33	1902.39	1896.19	1897.74	54259.0
2014-02-27 06:00:00	ES	Futures	1897.74	1900.84	1896.7	1899.81	41401.0
2014-02-27 07:00:00	ES	Futures	1900.07	1902.65	1899.03	1902.39	33015.0
2014-02-27 08:00:00	ES	Futures	1902.39	1906.27	1900.58	1904.46	55176.0
2014-02-27 09:00:00	ES	Futures	1904.46	1909.12	1902.14	1905.5	189234.0
2014-02-27 10:00:00	ES	Futures	1905.5	1909.64	1902.65	1908.6	257272.0
2014-02-27 11:00:00	ES	Futures	1908.6	1913.52	1907.31	1911.19	193453.0
2014-02-27 12:00:00	ES	Futures	1910.93	1912.48	1908.86	1911.45	84528.0
2014-02-27 13:00:00	ES	Futures	1911.45	1917.14	1910.93	1915.59	125687.0
2014-02-27 14:00:00	ES	Futures	1915.59	1916.62	1911.71	1913.52	105492.0
2014-02-27 15:00:00	ES	Futures	1913.52	1917.66	1911.96	1917.4	216538.0
2014-02-27 16:00:00	ES	Futures	1917.66	1919.72	1916.1	1919.47	108605.0
2014-02-27 17:00:00	ES	Futures	1919.21	1919.98	1918.95	1918.95	3644.0
2014-02-27 18:00:00	ES	Futures	1918.69	1918.69	1916.88	1917.14	5339.0
2014-02-27 19:00:00	ES	Futures	1917.14	1918.43	1916.88	1917.14	3452.0
2014-02-27 20:00:00	ES	Futures	1917.4	1919.47	1917.14	1919.21	4794.0
2014-02-27 21:00:00	ES	Futures	1919.47	1919.98	1918.43	1919.21	3630.0
2014-02-27 22:00:00	ES	Futures	1918.95	1918.95	1916.1	1917.14	8694.0
2014-02-27 23:00:00	ES	Futures	1917.14	1917.66	1914.81	1914.81	4803.0
2014-02-27 00:00:00	NQ	Futures	4284.69	4287.6	4283.53	4287.02	426.0
2014-02-27 01:00:00	NQ	Futures	4286.73	4288.18	4284.98	4286.73	308.0
2014-02-27 02:00:00	NQ	Futures	4286.44	4287.89	4284.4	4286.44	570.0
2014-02-27 03:00:00	NQ	Futures	4286.44	4287.6	4281.2	4284.11	3203.0
2014-02-27 04:00:00	NQ	Futures	4284.11	4284.98	4267.25	4267.83	8958.0
2014-02-27 05:00:00	NQ	Futures	4267.83	4272.19	4257.08	4260.28	6303.0
2014-02-27 06:00:00	NQ	Futures	4259.98	4266.67	4257.66	4264.93	4856.0
2014-02-27 07:00:00	NQ	Futures	4265.22	4271.61	4263.76	4270.74	4000.0
2014-02-27 08:00:00	NQ	Futures	4270.74	4278.88	4266.96	4275.1	7952.0
2014-02-27 09:00:00	NQ	Futures	4274.81	4284.69	4269.29	4276.84	37056.0
2014-02-27 10:00:00	NQ	Futures	4277.14	4289.63	4269.58	4284.98	50857.0
2014-02-27 11:00:00	NQ	Futures	4284.98	4294.29	4283.24	4286.44	29810.0
2014-02-27 12:00:00	NQ	Futures	4286.44	4294.58	4282.37	4292.25	21239.0
2014-02-27 13:00:00	NQ	Futures	4292.54	4307.08	4289.93	4305.62	22892.0
2014-02-27 14:00:00	NQ	Futures	4305.62	4307.37	4292.83	4297.48	17890.0
2014-02-27 15:00:00	NQ	Futures	4297.48	4302.72	4290.8	4302.72	36126.0
2014-02-27 16:00:00	NQ	Futures	4302.72	4307.95	4300.39	4307.37	6642.0
2014-02-27 17:00:00	NQ	Futures	4307.37	4309.98	4307.08	4308.53	484.0
2014-02-27 18:00:00	NQ	Futures	4306.49	4306.79	4300.97	4301.84	804.0
2014-02-27 19:00:00	NQ	Futures	4301.55	4304.75	4301.26	4303.3	366.0
2014-02-27 20:00:00	NQ	Futures	4303.3	4307.37	4302.72	4306.79	387.0
2014-02-27 21:00:00	NQ	Futures	4307.37	4308.53	4305.62	4306.2	508.0
2014-02-27 22:00:00	NQ	Futures	4306.2	4306.2	4301.55	4302.72	584.0
2014-02-27 23:00:00	NQ	Futures	4302.72	4303.59	4299.23	4299.52	573.0
2014-02-27 00:00:00	YM	Futures	16619.7	16630.0	16612.6	16624.9	555.0
2014-02-27 01:00:00	YM	Futures	16623.8	16626.9	16617.7	16624.9	299.0

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

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