PREVIEW / futures_1hour / 2014-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-04.parquet
  size:    52 KB
  rows:    1,597

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-04 00:00:00	ES	Futures	1800.74	1801.26	1798.16	1798.67	6648.0
2014-02-04 01:00:00	ES	Futures	1798.67	1799.71	1794.02	1798.67	17028.0
2014-02-04 02:00:00	ES	Futures	1798.93	1801.78	1798.16	1801.52	13901.0
2014-02-04 03:00:00	ES	Futures	1801.52	1802.81	1799.19	1801.78	52205.0
2014-02-04 04:00:00	ES	Futures	1802.04	1804.11	1800.23	1802.55	39072.0
2014-02-04 05:00:00	ES	Futures	1802.55	1803.07	1797.9	1798.93	33164.0
2014-02-04 06:00:00	ES	Futures	1798.93	1801.0	1797.38	1799.19	31388.0
2014-02-04 07:00:00	ES	Futures	1799.19	1800.74	1797.9	1799.45	39789.0
2014-02-04 08:00:00	ES	Futures	1799.71	1806.43	1799.19	1805.66	82866.0
2014-02-04 09:00:00	ES	Futures	1805.92	1808.76	1798.93	1807.21	338934.0
2014-02-04 10:00:00	ES	Futures	1807.21	1808.5	1801.78	1803.33	368325.0
2014-02-04 11:00:00	ES	Futures	1803.33	1811.61	1802.3	1811.61	311738.0
2014-02-04 12:00:00	ES	Futures	1811.35	1813.42	1809.54	1812.12	192794.0
2014-02-04 13:00:00	ES	Futures	1812.12	1814.19	1805.66	1806.43	167551.0
2014-02-04 14:00:00	ES	Futures	1806.69	1811.87	1804.88	1811.09	141521.0
2014-02-04 15:00:00	ES	Futures	1810.83	1812.12	1803.59	1809.54	307724.0
2014-02-04 16:00:00	ES	Futures	1809.28	1809.8	1803.85	1804.88	113611.0
2014-02-04 17:00:00	ES	Futures	1804.88	1804.88	1803.59	1803.85	3676.0
2014-02-04 18:00:00	ES	Futures	1804.62	1806.43	1804.37	1806.18	6905.0
2014-02-04 19:00:00	ES	Futures	1806.18	1806.18	1802.81	1804.88	7784.0
2014-02-04 20:00:00	ES	Futures	1804.88	1805.14	1802.81	1803.07	4432.0
2014-02-04 21:00:00	ES	Futures	1803.07	1803.59	1797.12	1799.19	16595.0
2014-02-04 22:00:00	ES	Futures	1799.19	1801.0	1797.64	1799.71	9689.0
2014-02-04 23:00:00	ES	Futures	1799.97	1801.52	1798.42	1799.71	4959.0
2014-02-04 00:00:00	NQ	Futures	4004.47	4005.05	3998.66	3998.66	682.0
2014-02-04 01:00:00	NQ	Futures	3998.66	4000.98	3989.94	3999.24	1708.0
2014-02-04 02:00:00	NQ	Futures	3999.53	4005.05	3997.5	4003.89	1322.0
2014-02-04 03:00:00	NQ	Futures	4004.18	4005.93	3999.24	4003.6	4450.0
2014-02-04 04:00:00	NQ	Futures	4003.6	4008.25	3999.24	4004.76	3371.0
2014-02-04 05:00:00	NQ	Futures	4004.76	4005.34	3994.01	3996.04	2348.0
2014-02-04 06:00:00	NQ	Futures	3996.33	3999.82	3992.85	3996.33	2560.0
2014-02-04 07:00:00	NQ	Futures	3996.04	4004.76	3995.75	4001.28	4556.0
2014-02-04 08:00:00	NQ	Futures	4000.69	4015.23	3999.82	4014.94	8927.0
2014-02-04 09:00:00	NQ	Futures	4014.65	4023.08	4001.86	4020.75	52010.0
2014-02-04 10:00:00	NQ	Futures	4020.75	4024.24	4005.05	4009.12	54281.0
2014-02-04 11:00:00	NQ	Futures	4009.41	4035.58	4006.8	4034.99	43220.0
2014-02-04 12:00:00	NQ	Futures	4034.99	4036.74	4027.73	4034.99	24015.0
2014-02-04 13:00:00	NQ	Futures	4034.7	4039.06	4022.2	4022.79	21991.0
2014-02-04 14:00:00	NQ	Futures	4022.79	4033.83	4019.88	4033.25	20249.0
2014-02-04 15:00:00	NQ	Futures	4032.96	4035.58	4016.1	4024.53	61583.0
2014-02-04 16:00:00	NQ	Futures	4024.24	4024.82	4012.9	4014.94	8652.0
2014-02-04 17:00:00	NQ	Futures	4014.94	4014.94	4012.03	4012.32	123.0
2014-02-04 18:00:00	NQ	Futures	4013.77	4017.84	4012.03	4015.81	769.0
2014-02-04 19:00:00	NQ	Futures	4015.52	4015.52	4008.83	4013.48	748.0
2014-02-04 20:00:00	NQ	Futures	4013.48	4014.36	4010.29	4010.58	452.0
2014-02-04 21:00:00	NQ	Futures	4010.58	4011.45	3998.66	4002.15	1747.0
2014-02-04 22:00:00	NQ	Futures	4002.44	4008.25	4000.4	4005.64	999.0
2014-02-04 23:00:00	NQ	Futures	4005.93	4009.41	4002.44	4005.64	493.0
2014-02-04 00:00:00	YM	Futures	15730.7	15734.8	15709.2	15711.2	1256.0
2014-02-04 01:00:00	YM	Futures	15712.2	15715.3	15670.2	15708.1	3075.0

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

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