PREVIEW / futures_1hour / 2014-02-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-17.parquet
  size:    34 KB
  rows:    1,054

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-17 00:00:00	ES	Futures	1897.22	1898.0	1896.7	1897.22	2326.0
2014-02-17 01:00:00	ES	Futures	1897.22	1898.77	1896.45	1898.26	2100.0
2014-02-17 02:00:00	ES	Futures	1898.26	1900.07	1898.0	1899.55	4157.0
2014-02-17 03:00:00	ES	Futures	1899.55	1903.69	1898.77	1899.29	25868.0
2014-02-17 04:00:00	ES	Futures	1899.29	1902.65	1899.03	1902.14	14228.0
2014-02-17 05:00:00	ES	Futures	1902.14	1903.69	1901.62	1903.17	11019.0
2014-02-17 06:00:00	ES	Futures	1903.17	1903.95	1901.36	1902.39	7667.0
2014-02-17 07:00:00	ES	Futures	1902.39	1903.43	1902.14	1903.43	5299.0
2014-02-17 08:00:00	ES	Futures	1903.43	1903.69	1901.36	1901.88	7154.0
2014-02-17 09:00:00	ES	Futures	1901.62	1902.39	1901.36	1901.62	6096.0
2014-02-17 10:00:00	ES	Futures	1901.62	1901.88	1900.33	1900.58	5252.0
2014-02-17 11:00:00	ES	Futures	1900.84	1901.1	1899.55	1900.58	5635.0
2014-02-17 18:00:00	ES	Futures	1899.81	1902.39	1899.81	1900.33	5837.0
2014-02-17 19:00:00	ES	Futures	1900.33	1901.88	1900.07	1900.84	2824.0
2014-02-17 20:00:00	ES	Futures	1901.1	1901.36	1899.03	1899.03	4185.0
2014-02-17 21:00:00	ES	Futures	1899.29	1899.81	1898.52	1898.77	2791.0
2014-02-17 22:00:00	ES	Futures	1898.77	1900.84	1898.52	1900.84	4986.0
2014-02-17 23:00:00	ES	Futures	1900.84	1901.62	1900.58	1900.58	3286.0
2014-02-17 00:00:00	NQ	Futures	4255.33	4257.37	4254.46	4255.92	314.0
2014-02-17 01:00:00	NQ	Futures	4255.62	4258.82	4255.04	4258.82	189.0
2014-02-17 02:00:00	NQ	Futures	4258.53	4263.18	4258.24	4262.02	491.0
2014-02-17 03:00:00	NQ	Futures	4262.31	4270.16	4260.57	4261.44	2677.0
2014-02-17 04:00:00	NQ	Futures	4260.86	4265.8	4259.11	4265.22	1148.0
2014-02-17 05:00:00	NQ	Futures	4265.22	4269.58	4264.35	4267.54	791.0
2014-02-17 06:00:00	NQ	Futures	4267.25	4269.58	4262.6	4264.93	764.0
2014-02-17 07:00:00	NQ	Futures	4264.93	4266.96	4263.47	4266.38	440.0
2014-02-17 08:00:00	NQ	Futures	4266.67	4266.67	4262.89	4264.05	883.0
2014-02-17 09:00:00	NQ	Futures	4263.76	4265.22	4262.02	4264.35	1305.0
2014-02-17 10:00:00	NQ	Futures	4264.35	4264.93	4262.02	4263.18	1050.0
2014-02-17 11:00:00	NQ	Futures	4263.76	4265.22	4261.44	4263.76	932.0
2014-02-17 18:00:00	NQ	Futures	4262.89	4266.09	4259.11	4261.44	642.0
2014-02-17 19:00:00	NQ	Futures	4261.44	4264.64	4260.57	4262.89	411.0
2014-02-17 20:00:00	NQ	Futures	4262.89	4263.47	4257.66	4258.53	658.0
2014-02-17 21:00:00	NQ	Futures	4258.53	4260.57	4257.66	4258.24	378.0
2014-02-17 22:00:00	NQ	Futures	4258.53	4264.05	4257.37	4263.47	1004.0
2014-02-17 23:00:00	NQ	Futures	4263.76	4265.51	4262.89	4263.76	583.0
2014-02-17 00:00:00	YM	Futures	16523.3	16531.5	16521.3	16527.4	393.0
2014-02-17 01:00:00	YM	Futures	16525.4	16538.7	16523.3	16536.7	296.0
2014-02-17 02:00:00	YM	Futures	16537.7	16550.0	16534.6	16548.0	502.0
2014-02-17 03:00:00	YM	Futures	16546.9	16600.2	16541.8	16553.1	4772.0
2014-02-17 04:00:00	YM	Futures	16553.1	16577.7	16548.0	16573.6	1908.0
2014-02-17 05:00:00	YM	Futures	16575.6	16590.0	16571.5	16584.9	1839.0
2014-02-17 06:00:00	YM	Futures	16583.8	16592.0	16570.5	16576.7	891.0
2014-02-17 07:00:00	YM	Futures	16577.7	16582.8	16571.5	16581.8	676.0
2014-02-17 08:00:00	YM	Futures	16583.8	16585.9	16561.3	16564.4	1130.0
2014-02-17 09:00:00	YM	Futures	16565.4	16575.6	16560.3	16572.6	1312.0
2014-02-17 10:00:00	YM	Futures	16573.6	16575.6	16562.3	16567.4	751.0
2014-02-17 11:00:00	YM	Futures	16566.4	16570.5	16560.3	16564.4	579.0
2014-02-17 18:00:00	YM	Futures	16558.2	16577.7	16551.0	16560.3	936.0
2014-02-17 19:00:00	YM	Futures	16561.3	16569.5	16556.2	16563.3	715.0

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

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