PREVIEW / futures_1hour / 2014-02-05

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-05.parquet
  size:    51 KB
  rows:    1,570

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-05 00:00:00	ES	Futures	1799.71	1801.0	1798.93	1799.97	4106.0
2014-02-05 01:00:00	ES	Futures	1799.97	1801.0	1799.71	1800.23	3531.0
2014-02-05 02:00:00	ES	Futures	1800.23	1801.78	1798.67	1801.52	12662.0
2014-02-05 03:00:00	ES	Futures	1801.26	1804.88	1799.19	1803.07	41280.0
2014-02-05 04:00:00	ES	Futures	1803.07	1804.88	1802.3	1803.07	19229.0
2014-02-05 05:00:00	ES	Futures	1803.07	1804.37	1801.26	1801.78	16304.0
2014-02-05 06:00:00	ES	Futures	1802.04	1803.07	1799.45	1800.74	20340.0
2014-02-05 07:00:00	ES	Futures	1800.74	1802.3	1797.9	1798.93	28467.0
2014-02-05 08:00:00	ES	Futures	1798.93	1804.37	1794.28	1803.07	130465.0
2014-02-05 09:00:00	ES	Futures	1802.81	1807.47	1798.93	1800.74	273959.0
2014-02-05 10:00:00	ES	Futures	1800.74	1809.8	1791.95	1798.42	547896.0
2014-02-05 11:00:00	ES	Futures	1798.16	1807.99	1794.02	1806.69	234610.0
2014-02-05 12:00:00	ES	Futures	1806.69	1809.02	1804.37	1806.95	108058.0
2014-02-05 13:00:00	ES	Futures	1807.21	1811.09	1806.95	1809.54	131210.0
2014-02-05 14:00:00	ES	Futures	1809.54	1811.35	1804.62	1805.66	132215.0
2014-02-05 15:00:00	ES	Futures	1805.66	1811.09	1804.37	1806.69	211011.0
2014-02-05 16:00:00	ES	Futures	1806.69	1806.95	1803.07	1805.92	100060.0
2014-02-05 17:00:00	ES	Futures	1805.92	1806.43	1804.88	1805.14	2865.0
2014-02-05 18:00:00	ES	Futures	1805.14	1806.69	1804.37	1806.18	9110.0
2014-02-05 19:00:00	ES	Futures	1805.92	1809.8	1805.66	1808.25	9968.0
2014-02-05 20:00:00	ES	Futures	1808.25	1808.5	1804.37	1807.21	6903.0
2014-02-05 21:00:00	ES	Futures	1807.21	1808.25	1804.88	1807.73	3040.0
2014-02-05 22:00:00	ES	Futures	1807.73	1808.25	1806.69	1807.99	2742.0
2014-02-05 23:00:00	ES	Futures	1808.25	1809.54	1808.25	1808.25	2957.0
2014-02-05 00:00:00	NQ	Futures	4005.64	4007.96	4002.73	4005.34	470.0
2014-02-05 01:00:00	NQ	Futures	4006.22	4007.67	4005.34	4005.93	187.0
2014-02-05 02:00:00	NQ	Futures	4005.93	4009.12	4003.6	4008.54	532.0
2014-02-05 03:00:00	NQ	Futures	4008.54	4015.81	4002.73	4012.03	4162.0
2014-02-05 04:00:00	NQ	Futures	4011.74	4015.81	4009.41	4010.87	1438.0
2014-02-05 05:00:00	NQ	Futures	4011.16	4014.65	4006.51	4006.8	1928.0
2014-02-05 06:00:00	NQ	Futures	4007.09	4011.16	4002.15	4007.96	2435.0
2014-02-05 07:00:00	NQ	Futures	4007.67	4012.61	4002.73	4004.47	3765.0
2014-02-05 08:00:00	NQ	Futures	4004.47	4016.97	3996.62	4014.65	16380.0
2014-02-05 09:00:00	NQ	Futures	4014.36	4022.79	3995.17	3997.79	46327.0
2014-02-05 10:00:00	NQ	Futures	3997.79	4018.72	3967.27	3983.83	105064.0
2014-02-05 11:00:00	NQ	Futures	3983.83	4016.1	3973.66	4013.77	49998.0
2014-02-05 12:00:00	NQ	Futures	4014.07	4021.04	4007.67	4017.26	20893.0
2014-02-05 13:00:00	NQ	Futures	4017.26	4026.86	4016.1	4022.2	23833.0
2014-02-05 14:00:00	NQ	Futures	4022.2	4025.98	4009.41	4011.45	20701.0
2014-02-05 15:00:00	NQ	Futures	4011.16	4021.04	4007.96	4011.45	42351.0
2014-02-05 16:00:00	NQ	Futures	4011.16	4013.19	4003.02	4010.29	10374.0
2014-02-05 17:00:00	NQ	Futures	4010.87	4014.65	4010.87	4012.03	535.0
2014-02-05 18:00:00	NQ	Futures	4011.74	4014.07	4010.0	4012.61	1078.0
2014-02-05 19:00:00	NQ	Futures	4012.32	4019.3	4011.74	4016.68	990.0
2014-02-05 20:00:00	NQ	Futures	4016.39	4017.26	4008.83	4014.36	961.0
2014-02-05 21:00:00	NQ	Futures	4014.65	4016.39	4009.71	4015.23	673.0
2014-02-05 22:00:00	NQ	Futures	4014.94	4016.97	4012.9	4015.81	504.0
2014-02-05 23:00:00	NQ	Futures	4016.1	4019.01	4015.81	4015.81	385.0
2014-02-05 00:00:00	YM	Futures	15708.1	15715.3	15697.9	15709.2	555.0
2014-02-05 01:00:00	YM	Futures	15707.1	15717.4	15706.1	15707.1	835.0

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

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