PREVIEW / futures_1hour / 2014-03-27

all futures 1-hour files

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

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-27 00:00:00	ES	Futures	1917.15	1917.93	1916.11	1917.15	4341.0
2014-03-27 01:00:00	ES	Futures	1916.89	1917.93	1915.85	1917.67	4327.0
2014-03-27 02:00:00	ES	Futures	1917.67	1917.93	1916.11	1917.41	5173.0
2014-03-27 03:00:00	ES	Futures	1917.41	1918.97	1917.15	1917.41	14606.0
2014-03-27 04:00:00	ES	Futures	1917.67	1918.45	1915.33	1916.63	27731.0
2014-03-27 05:00:00	ES	Futures	1916.37	1920.01	1916.37	1919.23	21604.0
2014-03-27 06:00:00	ES	Futures	1919.49	1919.75	1916.89	1918.71	22057.0
2014-03-27 07:00:00	ES	Futures	1918.71	1919.49	1915.85	1916.37	22192.0
2014-03-27 08:00:00	ES	Futures	1916.37	1917.15	1910.4	1912.74	61166.0
2014-03-27 09:00:00	ES	Futures	1913.0	1915.59	1904.95	1910.92	354971.0
2014-03-27 10:00:00	ES	Futures	1910.66	1919.75	1909.1	1917.15	389489.0
2014-03-27 11:00:00	ES	Futures	1916.89	1917.93	1906.25	1909.88	287744.0
2014-03-27 12:00:00	ES	Futures	1909.88	1913.78	1906.25	1911.96	192632.0
2014-03-27 13:00:00	ES	Futures	1911.96	1915.59	1909.62	1911.18	142361.0
2014-03-27 14:00:00	ES	Futures	1911.44	1913.52	1908.32	1910.66	138566.0
2014-03-27 15:00:00	ES	Futures	1910.66	1915.07	1908.58	1912.22	232222.0
2014-03-27 16:00:00	ES	Futures	1912.48	1914.04	1910.4	1913.52	75126.0
2014-03-27 17:00:00	ES	Futures	1913.78	1914.56	1913.52	1914.3	2449.0
2014-03-27 18:00:00	ES	Futures	1914.82	1915.59	1914.04	1915.07	3909.0
2014-03-27 19:00:00	ES	Futures	1915.07	1915.07	1913.52	1914.3	1853.0
2014-03-27 20:00:00	ES	Futures	1914.3	1914.82	1913.26	1913.52	2909.0
2014-03-27 21:00:00	ES	Futures	1913.26	1915.33	1912.74	1914.56	4461.0
2014-03-27 22:00:00	ES	Futures	1914.56	1914.82	1913.78	1913.78	1658.0
2014-03-27 23:00:00	ES	Futures	1913.78	1916.89	1913.78	1915.33	5021.0
2014-03-27 00:00:00	NQ	Futures	4167.68	4169.14	4165.64	4167.1	607.0
2014-03-27 01:00:00	NQ	Futures	4167.39	4170.01	4165.35	4168.85	829.0
2014-03-27 02:00:00	NQ	Futures	4168.56	4169.72	4165.93	4169.14	482.0
2014-03-27 03:00:00	NQ	Futures	4168.85	4172.05	4167.68	4167.97	1413.0
2014-03-27 04:00:00	NQ	Futures	4167.97	4169.43	4163.9	4168.56	5339.0
2014-03-27 05:00:00	NQ	Futures	4168.56	4175.84	4168.26	4174.67	3776.0
2014-03-27 06:00:00	NQ	Futures	4174.96	4175.54	4167.39	4171.76	3170.0
2014-03-27 07:00:00	NQ	Futures	4172.05	4174.09	4164.48	4166.23	3557.0
2014-03-27 08:00:00	NQ	Futures	4165.93	4167.97	4151.96	4158.07	11449.0
2014-03-27 09:00:00	NQ	Futures	4158.36	4163.02	4118.17	4146.71	85236.0
2014-03-27 10:00:00	NQ	Futures	4146.42	4176.42	4140.31	4161.28	93508.0
2014-03-27 11:00:00	NQ	Futures	4160.98	4163.6	4124.87	4137.98	66600.0
2014-03-27 12:00:00	NQ	Futures	4137.98	4150.21	4123.71	4144.68	46502.0
2014-03-27 13:00:00	NQ	Futures	4144.38	4157.2	4137.69	4142.05	31098.0
2014-03-27 14:00:00	NQ	Futures	4142.05	4151.66	4131.57	4137.39	33479.0
2014-03-27 15:00:00	NQ	Futures	4137.69	4149.33	4129.24	4140.02	44078.0
2014-03-27 16:00:00	NQ	Futures	4140.31	4145.26	4137.98	4144.38	7242.0
2014-03-27 17:00:00	NQ	Futures	4144.68	4147.3	4144.68	4147.3	368.0
2014-03-27 18:00:00	NQ	Futures	4147.01	4149.92	4146.13	4148.17	522.0
2014-03-27 19:00:00	NQ	Futures	4148.17	4148.75	4143.51	4144.68	687.0
2014-03-27 20:00:00	NQ	Futures	4144.68	4145.84	4140.6	4141.76	905.0
2014-03-27 21:00:00	NQ	Futures	4141.47	4146.42	4140.6	4144.68	361.0
2014-03-27 22:00:00	NQ	Futures	4144.38	4145.55	4142.64	4142.64	266.0
2014-03-27 23:00:00	NQ	Futures	4143.51	4149.63	4142.93	4147.01	989.0
2014-03-27 00:00:00	YM	Futures	16690.9	16698.1	16680.6	16685.8	541.0
2014-03-27 01:00:00	YM	Futures	16686.8	16698.1	16679.6	16696.1	446.0

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

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