PREVIEW / futures_1hour / 2013-11-12

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-12.parquet
  size:    49 KB
  rows:    1,549

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-11-12 00:00:00	ES	Futures	1825.07	1826.1	1824.81	1825.84	5560.0
2013-11-12 01:00:00	ES	Futures	1825.59	1826.1	1824.04	1824.3	3697.0
2013-11-12 02:00:00	ES	Futures	1824.3	1824.55	1822.75	1823.01	6620.0
2013-11-12 03:00:00	ES	Futures	1822.75	1824.55	1820.94	1821.46	25409.0
2013-11-12 04:00:00	ES	Futures	1821.46	1821.97	1818.88	1819.91	28987.0
2013-11-12 05:00:00	ES	Futures	1819.91	1821.2	1819.65	1820.17	14074.0
2013-11-12 06:00:00	ES	Futures	1820.17	1821.46	1819.39	1820.17	15217.0
2013-11-12 07:00:00	ES	Futures	1820.43	1822.23	1820.17	1820.68	25092.0
2013-11-12 08:00:00	ES	Futures	1820.68	1821.46	1818.62	1819.39	29582.0
2013-11-12 09:00:00	ES	Futures	1819.14	1823.52	1818.36	1822.49	160579.0
2013-11-12 10:00:00	ES	Futures	1822.75	1824.81	1819.65	1821.2	227741.0
2013-11-12 11:00:00	ES	Futures	1821.2	1823.26	1817.59	1819.39	193039.0
2013-11-12 12:00:00	ES	Futures	1819.14	1820.17	1816.04	1818.36	132702.0
2013-11-12 13:00:00	ES	Futures	1818.36	1819.39	1814.49	1816.04	113606.0
2013-11-12 14:00:00	ES	Futures	1816.04	1820.94	1815.53	1820.43	106461.0
2013-11-12 15:00:00	ES	Futures	1820.43	1821.97	1818.11	1820.94	197604.0
2013-11-12 16:00:00	ES	Futures	1820.68	1821.72	1819.91	1821.46	66592.0
2013-11-12 17:00:00	ES	Futures	1821.46	1821.72	1820.68	1820.94	2428.0
2013-11-12 18:00:00	ES	Futures	1820.94	1821.46	1820.17	1820.68	4004.0
2013-11-12 19:00:00	ES	Futures	1820.94	1822.23	1820.43	1821.97	5020.0
2013-11-12 20:00:00	ES	Futures	1821.97	1821.97	1819.14	1819.39	6758.0
2013-11-12 21:00:00	ES	Futures	1819.65	1820.43	1818.88	1818.88	3389.0
2013-11-12 22:00:00	ES	Futures	1819.14	1819.39	1816.82	1817.07	4510.0
2013-11-12 23:00:00	ES	Futures	1817.33	1817.33	1813.72	1814.49	14547.0
2013-11-12 00:00:00	NQ	Futures	3898.19	3901.09	3897.89	3900.22	1029.0
2013-11-12 01:00:00	NQ	Futures	3899.93	3901.09	3897.31	3897.31	332.0
2013-11-12 02:00:00	NQ	Futures	3897.02	3897.6	3893.54	3893.54	680.0
2013-11-12 03:00:00	NQ	Futures	3893.54	3898.48	3889.18	3890.34	3055.0
2013-11-12 04:00:00	NQ	Futures	3890.34	3890.92	3885.12	3886.86	3514.0
2013-11-12 05:00:00	NQ	Futures	3886.57	3888.89	3885.99	3887.44	1876.0
2013-11-12 06:00:00	NQ	Futures	3887.44	3892.38	3886.86	3889.18	3029.0
2013-11-12 07:00:00	NQ	Futures	3889.47	3893.25	3888.6	3890.34	2093.0
2013-11-12 08:00:00	NQ	Futures	3890.63	3891.51	3884.53	3885.99	3817.0
2013-11-12 09:00:00	NQ	Futures	3885.7	3904.57	3885.12	3901.38	32029.0
2013-11-12 10:00:00	NQ	Futures	3901.67	3911.25	3892.96	3903.12	35877.0
2013-11-12 11:00:00	NQ	Futures	3903.12	3906.32	3892.09	3897.31	27978.0
2013-11-12 12:00:00	NQ	Futures	3897.31	3899.93	3888.89	3897.02	18359.0
2013-11-12 13:00:00	NQ	Futures	3896.73	3901.09	3888.89	3894.12	13142.0
2013-11-12 14:00:00	NQ	Futures	3894.12	3905.45	3892.67	3904.57	16535.0
2013-11-12 15:00:00	NQ	Futures	3904.87	3908.06	3901.67	3905.74	22117.0
2013-11-12 16:00:00	NQ	Futures	3906.03	3909.51	3904.28	3908.35	4516.0
2013-11-12 17:00:00	NQ	Futures	3908.64	3909.22	3907.48	3907.77	118.0
2013-11-12 18:00:00	NQ	Futures	3907.48	3908.64	3904.57	3905.74	587.0
2013-11-12 19:00:00	NQ	Futures	3906.03	3908.64	3905.74	3906.61	546.0
2013-11-12 20:00:00	NQ	Futures	3906.61	3907.19	3900.51	3901.67	1177.0
2013-11-12 21:00:00	NQ	Futures	3901.67	3904.28	3900.51	3901.09	568.0
2013-11-12 22:00:00	NQ	Futures	3901.09	3901.96	3896.73	3897.89	684.0
2013-11-12 23:00:00	NQ	Futures	3897.89	3897.89	3889.47	3890.05	1658.0
2013-11-12 00:00:00	YM	Futures	16074.4	16086.7	16072.4	16083.6	829.0
2013-11-12 01:00:00	YM	Futures	16081.6	16083.6	16071.4	16072.4	414.0

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

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