PREVIEW / futures_1hour / 2013-12-09

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-09.parquet
  size:    47 KB
  rows:    1,497

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-12-09 00:00:00	ES	Futures	1865.31	1866.09	1865.05	1865.83	5572.0
2013-12-09 01:00:00	ES	Futures	1865.57	1866.09	1865.05	1865.31	1990.0
2013-12-09 02:00:00	ES	Futures	1865.31	1866.09	1864.02	1865.83	7637.0
2013-12-09 03:00:00	ES	Futures	1865.57	1865.83	1862.99	1864.54	21742.0
2013-12-09 04:00:00	ES	Futures	1864.54	1865.31	1863.51	1864.02	18755.0
2013-12-09 05:00:00	ES	Futures	1864.02	1864.54	1862.47	1863.51	15612.0
2013-12-09 06:00:00	ES	Futures	1863.51	1864.54	1862.22	1862.99	22661.0
2013-12-09 07:00:00	ES	Futures	1862.99	1864.8	1862.47	1864.54	14163.0
2013-12-09 08:00:00	ES	Futures	1864.54	1866.34	1863.76	1865.31	23907.0
2013-12-09 09:00:00	ES	Futures	1865.31	1869.18	1864.54	1868.67	193090.0
2013-12-09 10:00:00	ES	Futures	1868.92	1869.18	1863.76	1866.34	173102.0
2013-12-09 11:00:00	ES	Futures	1866.34	1869.18	1866.09	1867.12	110889.0
2013-12-09 12:00:00	ES	Futures	1867.12	1868.15	1865.57	1866.86	55376.0
2013-12-09 13:00:00	ES	Futures	1866.86	1868.92	1866.09	1866.6	58729.0
2013-12-09 14:00:00	ES	Futures	1866.34	1867.38	1864.8	1865.83	59571.0
2013-12-09 15:00:00	ES	Futures	1865.83	1866.86	1864.02	1866.09	128837.0
2013-12-09 16:00:00	ES	Futures	1866.09	1866.86	1865.31	1866.34	67118.0
2013-12-09 17:00:00	ES	Futures	1866.34	1867.12	1865.57	1866.86	2669.0
2013-12-09 18:00:00	ES	Futures	1866.86	1868.15	1866.6	1866.86	4070.0
2013-12-09 19:00:00	ES	Futures	1866.86	1868.41	1866.6	1867.89	2895.0
2013-12-09 20:00:00	ES	Futures	1867.89	1868.92	1867.38	1868.41	3396.0
2013-12-09 21:00:00	ES	Futures	1868.67	1868.67	1867.63	1868.15	2619.0
2013-12-09 22:00:00	ES	Futures	1868.41	1868.92	1867.89	1868.67	2137.0
2013-12-09 23:00:00	ES	Futures	1868.67	1868.92	1867.63	1868.41	2424.0
2013-12-09 00:00:00	NQ	Futures	4079.42	4080.29	4078.83	4080.0	398.0
2013-12-09 01:00:00	NQ	Futures	4079.71	4079.71	4078.83	4078.83	197.0
2013-12-09 02:00:00	NQ	Futures	4078.83	4080.0	4076.51	4079.12	569.0
2013-12-09 03:00:00	NQ	Futures	4079.12	4079.42	4074.19	4078.25	2347.0
2013-12-09 04:00:00	NQ	Futures	4078.54	4079.42	4076.51	4077.38	2875.0
2013-12-09 05:00:00	NQ	Futures	4077.38	4078.54	4073.9	4076.51	1498.0
2013-12-09 06:00:00	NQ	Futures	4076.8	4078.25	4074.77	4076.22	2323.0
2013-12-09 07:00:00	NQ	Futures	4075.93	4081.45	4075.35	4081.16	1977.0
2013-12-09 08:00:00	NQ	Futures	4080.87	4084.35	4080.58	4082.32	3044.0
2013-12-09 09:00:00	NQ	Futures	4082.32	4092.48	4079.42	4091.61	31504.0
2013-12-09 10:00:00	NQ	Futures	4091.61	4093.07	4082.32	4090.16	27875.0
2013-12-09 11:00:00	NQ	Futures	4090.16	4094.81	4087.84	4087.84	16967.0
2013-12-09 12:00:00	NQ	Futures	4088.13	4090.45	4084.35	4086.68	15217.0
2013-12-09 13:00:00	NQ	Futures	4086.97	4091.03	4086.39	4089.0	8278.0
2013-12-09 14:00:00	NQ	Futures	4088.71	4089.29	4082.9	4086.09	15482.0
2013-12-09 15:00:00	NQ	Futures	4086.39	4087.84	4081.16	4084.93	44906.0
2013-12-09 16:00:00	NQ	Futures	4084.93	4089.0	4082.9	4088.42	7207.0
2013-12-09 17:00:00	NQ	Futures	4088.13	4089.58	4086.97	4089.58	198.0
2013-12-09 18:00:00	NQ	Futures	4088.42	4091.03	4088.13	4089.0	550.0
2013-12-09 19:00:00	NQ	Futures	4088.71	4091.9	4088.13	4091.03	1062.0
2013-12-09 20:00:00	NQ	Futures	4091.03	4092.48	4090.45	4091.61	405.0
2013-12-09 21:00:00	NQ	Futures	4091.61	4092.19	4090.16	4091.9	247.0
2013-12-09 22:00:00	NQ	Futures	4091.61	4093.36	4091.32	4092.77	288.0
2013-12-09 23:00:00	NQ	Futures	4092.48	4093.07	4091.32	4092.77	288.0
2013-12-09 00:00:00	YM	Futures	16380.8	16386.9	16376.7	16385.9	465.0
2013-12-09 01:00:00	YM	Futures	16385.9	16385.9	16380.8	16382.8	241.0

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

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