PREVIEW / futures_1hour / 2014-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-14.parquet
  size:    51 KB
  rows:    1,564

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-01-14 00:00:00	ES	Futures	1878.08	1878.34	1877.05	1877.82	4462.0
2014-01-14 01:00:00	ES	Futures	1877.56	1878.34	1877.31	1877.56	2808.0
2014-01-14 02:00:00	ES	Futures	1877.56	1878.08	1876.53	1878.08	10295.0
2014-01-14 03:00:00	ES	Futures	1877.82	1880.15	1875.49	1879.89	32018.0
2014-01-14 04:00:00	ES	Futures	1879.63	1880.67	1878.86	1879.12	12015.0
2014-01-14 05:00:00	ES	Futures	1878.86	1880.15	1878.34	1879.37	9896.0
2014-01-14 06:00:00	ES	Futures	1879.63	1881.44	1879.37	1880.67	13730.0
2014-01-14 07:00:00	ES	Futures	1880.67	1882.22	1879.12	1881.7	25513.0
2014-01-14 08:00:00	ES	Futures	1881.44	1883.0	1879.63	1882.48	44862.0
2014-01-14 09:00:00	ES	Futures	1882.74	1884.81	1878.6	1880.93	229356.0
2014-01-14 10:00:00	ES	Futures	1880.93	1888.94	1880.93	1888.17	250749.0
2014-01-14 11:00:00	ES	Futures	1888.17	1892.57	1887.39	1891.01	201497.0
2014-01-14 12:00:00	ES	Futures	1890.76	1895.41	1890.24	1892.82	182332.0
2014-01-14 13:00:00	ES	Futures	1893.08	1895.93	1892.31	1893.34	135075.0
2014-01-14 14:00:00	ES	Futures	1893.34	1896.19	1891.79	1894.38	145142.0
2014-01-14 15:00:00	ES	Futures	1894.38	1897.74	1893.86	1896.7	169303.0
2014-01-14 16:00:00	ES	Futures	1896.7	1896.96	1895.67	1896.19	87478.0
2014-01-14 17:00:00	ES	Futures	1895.93	1896.7	1895.93	1896.19	3906.0
2014-01-14 18:00:00	ES	Futures	1896.45	1897.74	1895.15	1896.45	6263.0
2014-01-14 19:00:00	ES	Futures	1896.45	1896.96	1895.67	1896.45	3682.0
2014-01-14 20:00:00	ES	Futures	1896.19	1896.96	1894.89	1894.89	4090.0
2014-01-14 21:00:00	ES	Futures	1895.15	1896.19	1894.89	1895.41	2486.0
2014-01-14 22:00:00	ES	Futures	1895.67	1895.93	1895.15	1895.41	1910.0
2014-01-14 23:00:00	ES	Futures	1895.41	1896.45	1895.41	1896.19	2229.0
2014-01-14 00:00:00	NQ	Futures	4079.18	4079.47	4076.85	4078.6	527.0
2014-01-14 01:00:00	NQ	Futures	4078.31	4079.18	4077.14	4077.43	375.0
2014-01-14 02:00:00	NQ	Futures	4077.14	4078.89	4074.82	4078.31	841.0
2014-01-14 03:00:00	NQ	Futures	4078.31	4084.41	4073.37	4083.25	3425.0
2014-01-14 04:00:00	NQ	Futures	4082.96	4086.74	4082.38	4082.38	1816.0
2014-01-14 05:00:00	NQ	Futures	4082.38	4085.57	4081.21	4083.25	1127.0
2014-01-14 06:00:00	NQ	Futures	4083.54	4085.86	4081.5	4084.41	1662.0
2014-01-14 07:00:00	NQ	Futures	4084.41	4090.52	4082.67	4089.64	3983.0
2014-01-14 08:00:00	NQ	Futures	4089.64	4093.42	4084.99	4091.68	6286.0
2014-01-14 09:00:00	NQ	Futures	4091.97	4100.4	4089.93	4097.78	36645.0
2014-01-14 10:00:00	NQ	Futures	4097.78	4126.85	4097.78	4126.27	55848.0
2014-01-14 11:00:00	NQ	Futures	4126.56	4139.93	4126.56	4138.48	45214.0
2014-01-14 12:00:00	NQ	Futures	4138.48	4153.88	4136.44	4148.07	33744.0
2014-01-14 13:00:00	NQ	Futures	4148.07	4156.21	4146.91	4151.85	27560.0
2014-01-14 14:00:00	NQ	Futures	4151.85	4157.37	4145.46	4153.01	31167.0
2014-01-14 15:00:00	NQ	Futures	4152.72	4158.54	4151.27	4155.05	32747.0
2014-01-14 16:00:00	NQ	Futures	4154.76	4156.5	4152.72	4155.05	6793.0
2014-01-14 17:00:00	NQ	Futures	4155.34	4157.08	4155.34	4156.5	230.0
2014-01-14 18:00:00	NQ	Futures	4155.34	4158.54	4153.59	4157.37	500.0
2014-01-14 19:00:00	NQ	Futures	4157.37	4157.95	4154.47	4155.92	677.0
2014-01-14 20:00:00	NQ	Futures	4156.21	4157.37	4152.14	4152.14	469.0
2014-01-14 21:00:00	NQ	Futures	4152.14	4154.18	4151.85	4153.01	404.0
2014-01-14 22:00:00	NQ	Futures	4153.01	4153.88	4152.43	4152.72	254.0
2014-01-14 23:00:00	NQ	Futures	4152.43	4154.18	4152.14	4153.88	203.0
2014-01-14 00:00:00	YM	Futures	16613.6	16615.6	16605.4	16611.5	1020.0
2014-01-14 01:00:00	YM	Futures	16612.6	16615.6	16610.5	16612.6	551.0

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

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