PREVIEW / futures_1hour / 2014-03-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-03.parquet
  size:    51 KB
  rows:    1,560

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-03 00:00:00	ES	Futures	1906.79	1909.64	1906.79	1907.31	7389.0
2014-03-03 01:00:00	ES	Futures	1907.57	1908.6	1905.5	1905.76	6422.0
2014-03-03 02:00:00	ES	Futures	1905.5	1906.27	1902.65	1904.46	23511.0
2014-03-03 03:00:00	ES	Futures	1904.72	1909.12	1902.91	1908.34	61917.0
2014-03-03 04:00:00	ES	Futures	1908.34	1908.6	1904.46	1905.5	23048.0
2014-03-03 05:00:00	ES	Futures	1905.76	1907.57	1902.91	1903.43	24575.0
2014-03-03 06:00:00	ES	Futures	1903.69	1904.21	1899.55	1900.07	42838.0
2014-03-03 07:00:00	ES	Futures	1900.07	1906.53	1899.29	1906.27	62965.0
2014-03-03 08:00:00	ES	Futures	1906.27	1908.34	1901.88	1905.5	70501.0
2014-03-03 09:00:00	ES	Futures	1905.5	1913.0	1902.65	1909.9	290288.0
2014-03-03 10:00:00	ES	Futures	1909.9	1913.52	1903.17	1909.12	357387.0
2014-03-03 11:00:00	ES	Futures	1909.38	1909.64	1898.77	1898.77	289296.0
2014-03-03 12:00:00	ES	Futures	1898.77	1903.95	1895.67	1902.91	302169.0
2014-03-03 13:00:00	ES	Futures	1902.91	1908.86	1902.65	1907.31	115274.0
2014-03-03 14:00:00	ES	Futures	1907.57	1910.93	1903.95	1907.83	167955.0
2014-03-03 15:00:00	ES	Futures	1908.09	1908.34	1901.62	1907.83	299624.0
2014-03-03 16:00:00	ES	Futures	1907.83	1908.6	1906.53	1907.57	82236.0
2014-03-03 17:00:00	ES	Futures	1907.83	1907.83	1907.31	1907.57	1965.0
2014-03-03 18:00:00	ES	Futures	1907.57	1908.86	1907.31	1908.34	6090.0
2014-03-03 19:00:00	ES	Futures	1908.34	1910.41	1908.09	1909.64	9200.0
2014-03-03 20:00:00	ES	Futures	1909.38	1911.19	1908.86	1910.41	7756.0
2014-03-03 21:00:00	ES	Futures	1910.67	1910.67	1908.09	1908.34	3584.0
2014-03-03 22:00:00	ES	Futures	1908.34	1909.64	1907.83	1909.64	4595.0
2014-03-03 23:00:00	ES	Futures	1909.38	1911.71	1909.38	1910.15	5126.0
2014-03-03 00:00:00	NQ	Futures	4264.35	4270.16	4264.05	4265.51	1045.0
2014-03-03 01:00:00	NQ	Futures	4266.09	4268.41	4260.57	4260.86	848.0
2014-03-03 02:00:00	NQ	Futures	4261.15	4262.89	4254.17	4258.82	2390.0
2014-03-03 03:00:00	NQ	Futures	4259.11	4268.41	4255.92	4266.96	6046.0
2014-03-03 04:00:00	NQ	Futures	4267.25	4267.54	4257.37	4259.69	2315.0
2014-03-03 05:00:00	NQ	Futures	4259.4	4264.05	4252.72	4254.17	2504.0
2014-03-03 06:00:00	NQ	Futures	4254.17	4255.33	4247.49	4248.36	5011.0
2014-03-03 07:00:00	NQ	Futures	4248.36	4262.31	4247.49	4261.44	5437.0
2014-03-03 08:00:00	NQ	Futures	4261.44	4265.22	4253.01	4259.4	9029.0
2014-03-03 09:00:00	NQ	Futures	4259.11	4276.26	4248.07	4272.19	49886.0
2014-03-03 10:00:00	NQ	Futures	4272.77	4278.59	4248.65	4269.0	60979.0
2014-03-03 11:00:00	NQ	Futures	4269.0	4269.58	4239.06	4239.35	47426.0
2014-03-03 12:00:00	NQ	Futures	4239.35	4249.81	4228.88	4248.65	54509.0
2014-03-03 13:00:00	NQ	Futures	4248.36	4259.4	4248.36	4256.79	24102.0
2014-03-03 14:00:00	NQ	Futures	4256.79	4271.61	4253.3	4263.76	33282.0
2014-03-03 15:00:00	NQ	Futures	4263.76	4266.09	4248.65	4266.09	45525.0
2014-03-03 16:00:00	NQ	Futures	4266.38	4269.87	4264.93	4268.12	6819.0
2014-03-03 17:00:00	NQ	Futures	4267.83	4268.41	4266.96	4267.83	156.0
2014-03-03 18:00:00	NQ	Futures	4268.41	4270.74	4266.96	4270.16	433.0
2014-03-03 19:00:00	NQ	Futures	4269.87	4273.65	4269.0	4271.9	761.0
2014-03-03 20:00:00	NQ	Futures	4271.32	4275.39	4270.74	4275.1	937.0
2014-03-03 21:00:00	NQ	Futures	4275.1	4275.39	4270.16	4270.16	673.0
2014-03-03 22:00:00	NQ	Futures	4270.45	4273.65	4268.71	4272.77	454.0
2014-03-03 23:00:00	NQ	Futures	4273.36	4277.43	4272.77	4275.1	526.0
2014-03-03 00:00:00	YM	Futures	16614.6	16634.1	16613.6	16615.6	656.0
2014-03-03 01:00:00	YM	Futures	16617.7	16624.9	16598.2	16599.2	752.0

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

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