PREVIEW / futures_1hour / 2013-11-26

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-26.parquet
  size:    47 KB
  rows:    1,495

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-26 00:00:00	ES	Futures	1862.22	1862.99	1861.7	1862.73	2811.0
2013-11-26 01:00:00	ES	Futures	1862.47	1862.99	1862.47	1862.47	2439.0
2013-11-26 02:00:00	ES	Futures	1862.47	1862.99	1860.41	1861.44	7135.0
2013-11-26 03:00:00	ES	Futures	1861.44	1862.73	1860.67	1860.93	14868.0
2013-11-26 04:00:00	ES	Futures	1861.18	1861.44	1858.35	1858.6	19163.0
2013-11-26 05:00:00	ES	Futures	1858.6	1859.38	1858.35	1859.12	8488.0
2013-11-26 06:00:00	ES	Futures	1858.86	1859.38	1858.35	1859.38	16326.0
2013-11-26 07:00:00	ES	Futures	1859.38	1861.7	1859.12	1860.93	20205.0
2013-11-26 08:00:00	ES	Futures	1860.93	1861.44	1859.12	1859.64	28830.0
2013-11-26 09:00:00	ES	Futures	1859.38	1861.96	1858.6	1859.64	118610.0
2013-11-26 10:00:00	ES	Futures	1859.64	1860.93	1856.03	1859.89	176208.0
2013-11-26 11:00:00	ES	Futures	1859.64	1861.44	1858.86	1858.86	124274.0
2013-11-26 12:00:00	ES	Futures	1858.86	1862.99	1858.86	1861.96	97814.0
2013-11-26 13:00:00	ES	Futures	1861.96	1864.02	1861.18	1863.51	70428.0
2013-11-26 14:00:00	ES	Futures	1863.76	1864.28	1861.7	1863.25	69639.0
2013-11-26 15:00:00	ES	Futures	1863.25	1864.54	1858.6	1859.38	190775.0
2013-11-26 16:00:00	ES	Futures	1859.38	1860.15	1858.6	1860.15	85317.0
2013-11-26 17:00:00	ES	Futures	1860.15	1860.15	1859.38	1859.38	2015.0
2013-11-26 18:00:00	ES	Futures	1859.38	1859.38	1858.6	1859.12	3632.0
2013-11-26 19:00:00	ES	Futures	1858.86	1859.89	1858.6	1859.64	2393.0
2013-11-26 20:00:00	ES	Futures	1859.64	1860.67	1859.38	1859.64	3902.0
2013-11-26 21:00:00	ES	Futures	1859.38	1859.64	1858.86	1858.86	1900.0
2013-11-26 22:00:00	ES	Futures	1858.86	1860.41	1858.6	1859.12	3699.0
2013-11-26 23:00:00	ES	Futures	1859.38	1859.64	1859.38	1859.64	742.0
2013-11-26 00:00:00	NQ	Futures	3989.38	3990.25	3988.8	3989.96	463.0
2013-11-26 01:00:00	NQ	Futures	3989.96	3989.96	3989.38	3989.38	97.0
2013-11-26 02:00:00	NQ	Futures	3989.38	3991.12	3986.48	3988.22	926.0
2013-11-26 03:00:00	NQ	Futures	3988.22	3990.54	3985.61	3986.77	3087.0
2013-11-26 04:00:00	NQ	Futures	3986.77	3987.35	3981.25	3982.12	3734.0
2013-11-26 05:00:00	NQ	Futures	3981.83	3984.73	3981.83	3982.99	1399.0
2013-11-26 06:00:00	NQ	Futures	3982.99	3983.57	3980.96	3982.99	3017.0
2013-11-26 07:00:00	NQ	Futures	3983.28	3988.22	3982.99	3986.77	2578.0
2013-11-26 08:00:00	NQ	Futures	3986.48	3987.93	3984.44	3984.73	3632.0
2013-11-26 09:00:00	NQ	Futures	3984.73	3989.96	3979.51	3980.96	23715.0
2013-11-26 10:00:00	NQ	Futures	3981.25	3992.58	3976.31	3991.41	30908.0
2013-11-26 11:00:00	NQ	Futures	3991.12	3997.22	3990.83	3991.41	18348.0
2013-11-26 12:00:00	NQ	Futures	3991.7	4005.94	3991.41	4003.9	19709.0
2013-11-26 13:00:00	NQ	Futures	4003.9	4010.29	4003.03	4007.97	15342.0
2013-11-26 14:00:00	NQ	Futures	4007.97	4013.2	4005.06	4011.16	20529.0
2013-11-26 15:00:00	NQ	Futures	4011.45	4014.94	4003.32	4004.19	30422.0
2013-11-26 16:00:00	NQ	Futures	4004.19	4006.23	4003.32	4005.65	5977.0
2013-11-26 17:00:00	NQ	Futures	4005.94	4006.23	4005.35	4006.23	126.0
2013-11-26 18:00:00	NQ	Futures	4004.48	4005.35	4003.03	4004.19	585.0
2013-11-26 19:00:00	NQ	Futures	4004.19	4005.65	4003.32	4004.19	243.0
2013-11-26 20:00:00	NQ	Futures	4004.48	4007.39	4004.19	4005.35	469.0
2013-11-26 21:00:00	NQ	Futures	4005.35	4005.35	4004.19	4005.06	327.0
2013-11-26 22:00:00	NQ	Futures	4004.77	4007.39	4004.48	4005.94	328.0
2013-11-26 23:00:00	NQ	Futures	4006.23	4007.1	4005.94	4006.52	267.0
2013-11-26 00:00:00	YM	Futures	16420.6	16425.7	16416.5	16422.7	407.0
2013-11-26 01:00:00	YM	Futures	16422.7	16424.7	16419.6	16419.6	237.0

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

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