PREVIEW / futures_1hour / 2014-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-14.parquet
  size:    43 KB
  rows:    1,255

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-14 00:00:00	ES	Futures	1913.52	1913.78	1912.74	1912.74	1882.0
2014-03-14 01:00:00	ES	Futures	1912.74	1912.74	1909.88	1910.92	3979.0
2014-03-14 02:00:00	ES	Futures	1910.92	1911.7	1909.36	1910.4	3473.0
2014-03-14 03:00:00	ES	Futures	1910.4	1911.7	1908.84	1911.44	10365.0
2014-03-14 04:00:00	ES	Futures	1911.44	1914.82	1910.66	1912.22	27639.0
2014-03-14 05:00:00	ES	Futures	1912.22	1914.56	1911.7	1914.56	15966.0
2014-03-14 06:00:00	ES	Futures	1914.3	1915.33	1912.74	1914.04	12908.0
2014-03-14 07:00:00	ES	Futures	1914.04	1914.3	1909.62	1909.88	26016.0
2014-03-14 08:00:00	ES	Futures	1910.14	1910.4	1903.13	1909.1	77906.0
2014-03-14 09:00:00	ES	Futures	1909.1	1916.63	1905.73	1909.88	211828.0
2014-03-14 10:00:00	ES	Futures	1909.88	1917.67	1908.84	1909.62	228917.0
2014-03-14 11:00:00	ES	Futures	1909.36	1916.89	1904.17	1915.07	336402.0
2014-03-14 12:00:00	ES	Futures	1914.82	1915.59	1908.32	1913.26	173407.0
2014-03-14 13:00:00	ES	Futures	1913.52	1914.3	1907.8	1910.4	97631.0
2014-03-14 14:00:00	ES	Futures	1910.14	1911.18	1904.43	1904.69	90022.0
2014-03-14 15:00:00	ES	Futures	1904.69	1908.84	1902.87	1904.69	196226.0
2014-03-14 16:00:00	ES	Futures	1904.95	1905.47	1902.87	1903.39	57596.0
2014-03-14 17:00:00	ES	Futures	1903.65	1904.17	1903.39	1903.39	1194.0
2014-03-14 00:00:00	NQ	Futures	4252.14	4252.72	4248.93	4249.22	335.0
2014-03-14 01:00:00	NQ	Futures	4249.22	4249.22	4243.11	4246.02	817.0
2014-03-14 02:00:00	NQ	Futures	4245.73	4248.06	4241.94	4245.15	693.0
2014-03-14 03:00:00	NQ	Futures	4245.15	4247.19	4241.65	4246.89	2036.0
2014-03-14 04:00:00	NQ	Futures	4246.6	4254.47	4244.56	4248.64	3703.0
2014-03-14 05:00:00	NQ	Futures	4248.35	4254.76	4247.19	4254.17	2613.0
2014-03-14 06:00:00	NQ	Futures	4254.17	4255.92	4249.81	4253.3	1937.0
2014-03-14 07:00:00	NQ	Futures	4253.3	4257.09	4243.98	4246.31	5012.0
2014-03-14 08:00:00	NQ	Futures	4246.02	4247.77	4232.33	4245.15	11828.0
2014-03-14 09:00:00	NQ	Futures	4245.44	4253.01	4230.0	4230.59	50050.0
2014-03-14 10:00:00	NQ	Futures	4230.59	4251.85	4225.64	4228.26	49723.0
2014-03-14 11:00:00	NQ	Futures	4228.55	4251.26	4217.48	4247.77	55080.0
2014-03-14 12:00:00	NQ	Futures	4247.48	4249.52	4232.33	4242.23	32561.0
2014-03-14 13:00:00	NQ	Futures	4242.53	4245.15	4227.67	4232.62	18496.0
2014-03-14 14:00:00	NQ	Futures	4232.33	4233.21	4218.65	4219.81	16712.0
2014-03-14 15:00:00	NQ	Futures	4219.52	4229.71	4216.9	4217.48	28840.0
2014-03-14 16:00:00	NQ	Futures	4217.77	4220.98	4216.02	4217.48	5847.0
2014-03-14 17:00:00	NQ	Futures	4217.77	4218.94	4217.48	4217.77	146.0
2014-03-14 00:00:00	YM	Futures	16538.5	16539.5	16527.2	16529.2	135.0
2014-03-14 01:00:00	YM	Futures	16528.2	16529.2	16508.6	16514.8	547.0
2014-03-14 02:00:00	YM	Futures	16513.8	16517.9	16499.4	16510.7	563.0
2014-03-14 03:00:00	YM	Futures	16509.7	16518.9	16497.3	16517.9	872.0
2014-03-14 04:00:00	YM	Futures	16517.9	16544.7	16514.8	16526.2	3091.0
2014-03-14 05:00:00	YM	Futures	16526.2	16546.8	16522.0	16545.7	2009.0
2014-03-14 06:00:00	YM	Futures	16545.7	16550.9	16530.3	16538.5	1721.0
2014-03-14 07:00:00	YM	Futures	16537.5	16541.6	16508.6	16509.7	3407.0
2014-03-14 08:00:00	YM	Futures	16510.7	16512.8	16458.2	16501.4	8760.0
2014-03-14 09:00:00	YM	Futures	16502.5	16569.4	16482.9	16529.2	23086.0
2014-03-14 10:00:00	YM	Futures	16529.2	16579.7	16502.5	16508.6	18599.0
2014-03-14 11:00:00	YM	Futures	16507.6	16572.5	16470.5	16555.0	24932.0
2014-03-14 12:00:00	YM	Futures	16557.1	16561.2	16502.5	16539.5	18228.0
2014-03-14 13:00:00	YM	Futures	16540.6	16548.8	16496.3	16514.8	9679.0

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

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