PREVIEW / futures_1hour / 2013-10-22

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-22.parquet
  size:    50 KB
  rows:    1,562

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
2013-10-22 00:00:00	ES	Futures	1792.31	1792.57	1792.05	1792.31	569.0
2013-10-22 01:00:00	ES	Futures	1792.57	1793.34	1792.31	1793.08	2555.0
2013-10-22 02:00:00	ES	Futures	1793.08	1793.08	1791.54	1791.79	4425.0
2013-10-22 03:00:00	ES	Futures	1791.79	1793.86	1791.54	1792.57	12248.0
2013-10-22 04:00:00	ES	Futures	1792.57	1793.34	1792.05	1793.08	6087.0
2013-10-22 05:00:00	ES	Futures	1793.08	1793.08	1792.31	1792.57	6860.0
2013-10-22 06:00:00	ES	Futures	1792.31	1793.08	1792.05	1792.57	12317.0
2013-10-22 07:00:00	ES	Futures	1792.57	1794.37	1792.05	1793.08	16626.0
2013-10-22 08:00:00	ES	Futures	1793.08	1800.31	1793.08	1798.24	130543.0
2013-10-22 09:00:00	ES	Futures	1798.24	1805.21	1798.24	1804.43	230853.0
2013-10-22 10:00:00	ES	Futures	1804.69	1810.37	1797.21	1801.34	454512.0
2013-10-22 11:00:00	ES	Futures	1801.08	1804.43	1798.5	1804.18	240416.0
2013-10-22 12:00:00	ES	Futures	1804.18	1804.69	1800.05	1801.6	123381.0
2013-10-22 13:00:00	ES	Futures	1801.6	1805.21	1801.08	1804.43	113550.0
2013-10-22 14:00:00	ES	Futures	1804.69	1807.27	1802.11	1805.72	152166.0
2013-10-22 15:00:00	ES	Futures	1805.72	1809.08	1804.18	1804.95	234275.0
2013-10-22 16:00:00	ES	Futures	1805.21	1805.72	1803.92	1805.46	77564.0
2013-10-22 17:00:00	ES	Futures	1805.46	1805.98	1805.21	1805.46	1750.0
2013-10-22 18:00:00	ES	Futures	1805.21	1805.21	1802.89	1803.4	5090.0
2013-10-22 19:00:00	ES	Futures	1803.66	1804.18	1803.4	1803.92	1339.0
2013-10-22 20:00:00	ES	Futures	1804.18	1804.69	1802.37	1802.63	5258.0
2013-10-22 21:00:00	ES	Futures	1802.63	1804.18	1802.11	1803.92	3698.0
2013-10-22 22:00:00	ES	Futures	1803.92	1804.18	1803.4	1803.92	1736.0
2013-10-22 23:00:00	ES	Futures	1803.92	1803.92	1800.82	1801.08	9685.0
2013-10-22 00:00:00	NQ	Futures	3894.99	3896.15	3894.99	3895.86	99.0
2013-10-22 01:00:00	NQ	Futures	3896.15	3898.19	3895.86	3897.31	327.0
2013-10-22 02:00:00	NQ	Futures	3897.02	3897.02	3894.7	3894.7	557.0
2013-10-22 03:00:00	NQ	Futures	3894.99	3899.35	3893.83	3896.44	2006.0
2013-10-22 04:00:00	NQ	Futures	3896.73	3898.77	3895.86	3897.89	821.0
2013-10-22 05:00:00	NQ	Futures	3897.6	3898.48	3896.44	3897.89	938.0
2013-10-22 06:00:00	NQ	Futures	3897.89	3898.77	3897.02	3898.48	933.0
2013-10-22 07:00:00	NQ	Futures	3898.19	3899.93	3897.02	3897.31	2278.0
2013-10-22 08:00:00	NQ	Futures	3897.6	3913.87	3897.31	3909.8	14588.0
2013-10-22 09:00:00	NQ	Futures	3909.8	3917.35	3908.64	3913.0	33799.0
2013-10-22 10:00:00	NQ	Futures	3912.71	3923.45	3877.85	3893.83	90935.0
2013-10-22 11:00:00	NQ	Futures	3893.83	3906.61	3884.24	3906.32	56487.0
2013-10-22 12:00:00	NQ	Futures	3906.32	3907.48	3889.76	3894.99	25328.0
2013-10-22 13:00:00	NQ	Futures	3894.7	3904.87	3893.25	3902.83	17246.0
2013-10-22 14:00:00	NQ	Futures	3902.83	3908.35	3890.05	3900.8	32597.0
2013-10-22 15:00:00	NQ	Futures	3901.09	3912.42	3899.64	3900.51	41382.0
2013-10-22 16:00:00	NQ	Futures	3900.8	3906.32	3898.77	3901.09	7651.0
2013-10-22 17:00:00	NQ	Futures	3901.38	3901.67	3900.22	3900.51	158.0
2013-10-22 18:00:00	NQ	Futures	3898.77	3900.22	3894.7	3894.99	1077.0
2013-10-22 19:00:00	NQ	Futures	3895.28	3896.73	3894.99	3896.44	385.0
2013-10-22 20:00:00	NQ	Futures	3896.73	3897.31	3893.25	3893.25	718.0
2013-10-22 21:00:00	NQ	Futures	3893.25	3897.89	3892.96	3897.02	797.0
2013-10-22 22:00:00	NQ	Futures	3897.31	3897.89	3895.57	3896.73	333.0
2013-10-22 23:00:00	NQ	Futures	3896.73	3896.73	3890.05	3890.05	1486.0
2013-10-22 00:00:00	YM	Futures	15639.4	15642.4	15638.4	15641.4	111.0
2013-10-22 01:00:00	YM	Futures	15642.4	15647.5	15640.4	15646.5	459.0

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

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