PREVIEW / futures_1hour / 2013-11-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	1862.99	1863.76	1862.99	1863.76	1784.0
2013-11-25 01:00:00	ES	Futures	1863.76	1864.28	1862.99	1863.51	2825.0
2013-11-25 02:00:00	ES	Futures	1863.51	1865.05	1863.25	1863.51	5490.0
2013-11-25 03:00:00	ES	Futures	1863.51	1865.57	1862.73	1864.28	30406.0
2013-11-25 04:00:00	ES	Futures	1864.28	1865.05	1863.25	1864.28	22489.0
2013-11-25 05:00:00	ES	Futures	1864.02	1865.05	1863.25	1864.8	15893.0
2013-11-25 06:00:00	ES	Futures	1864.8	1865.57	1864.02	1865.31	20174.0
2013-11-25 07:00:00	ES	Futures	1865.31	1865.31	1864.02	1864.8	16112.0
2013-11-25 08:00:00	ES	Futures	1864.54	1865.57	1864.28	1864.54	27641.0
2013-11-25 09:00:00	ES	Futures	1864.28	1865.05	1860.67	1860.93	142558.0
2013-11-25 10:00:00	ES	Futures	1861.18	1862.73	1859.64	1861.18	132013.0
2013-11-25 11:00:00	ES	Futures	1861.18	1862.73	1860.67	1861.7	101050.0
2013-11-25 12:00:00	ES	Futures	1861.44	1862.47	1860.93	1861.18	75676.0
2013-11-25 13:00:00	ES	Futures	1861.18	1862.73	1860.41	1862.47	60788.0
2013-11-25 14:00:00	ES	Futures	1862.47	1863.25	1861.44	1861.44	61905.0
2013-11-25 15:00:00	ES	Futures	1861.44	1861.7	1855.77	1858.86	256442.0
2013-11-25 16:00:00	ES	Futures	1859.12	1860.15	1858.86	1859.38	76156.0
2013-11-25 17:00:00	ES	Futures	1859.64	1859.64	1858.6	1858.86	2174.0
2013-11-25 18:00:00	ES	Futures	1858.6	1859.89	1858.35	1859.38	3935.0
2013-11-25 19:00:00	ES	Futures	1859.64	1861.18	1859.12	1860.93	3415.0
2013-11-25 20:00:00	ES	Futures	1860.67	1863.25	1860.41	1862.47	6878.0
2013-11-25 21:00:00	ES	Futures	1862.47	1862.73	1860.93	1861.18	2531.0
2013-11-25 22:00:00	ES	Futures	1861.18	1862.47	1860.93	1861.96	2156.0
2013-11-25 23:00:00	ES	Futures	1862.22	1862.47	1861.96	1862.22	728.0
2013-11-25 00:00:00	NQ	Futures	3984.44	3985.31	3983.86	3985.31	198.0
2013-11-25 01:00:00	NQ	Futures	3985.31	3986.19	3984.15	3985.31	323.0
2013-11-25 02:00:00	NQ	Futures	3984.73	3988.22	3984.15	3985.9	605.0
2013-11-25 03:00:00	NQ	Futures	3985.9	3990.54	3984.44	3987.93	3141.0
2013-11-25 04:00:00	NQ	Futures	3987.93	3989.09	3985.02	3986.48	2466.0
2013-11-25 05:00:00	NQ	Futures	3986.48	3988.8	3985.31	3987.93	2311.0
2013-11-25 06:00:00	NQ	Futures	3987.64	3989.09	3986.19	3988.8	2797.0
2013-11-25 07:00:00	NQ	Futures	3989.09	3989.67	3987.06	3988.8	2042.0
2013-11-25 08:00:00	NQ	Futures	3988.51	3990.25	3987.64	3989.09	4858.0
2013-11-25 09:00:00	NQ	Futures	3989.09	3993.16	3980.38	3980.96	26480.0
2013-11-25 10:00:00	NQ	Futures	3980.96	3982.99	3974.28	3978.93	26530.0
2013-11-25 11:00:00	NQ	Futures	3978.93	3987.06	3978.34	3984.44	18590.0
2013-11-25 12:00:00	NQ	Futures	3984.73	3988.51	3982.41	3983.28	19987.0
2013-11-25 13:00:00	NQ	Futures	3983.28	3990.83	3982.41	3990.25	13285.0
2013-11-25 14:00:00	NQ	Futures	3989.96	3992.29	3989.09	3989.09	12978.0
2013-11-25 15:00:00	NQ	Futures	3989.09	3989.38	3978.05	3983.28	30200.0
2013-11-25 16:00:00	NQ	Futures	3983.28	3985.02	3982.7	3983.28	4549.0
2013-11-25 17:00:00	NQ	Futures	3983.28	3983.28	3981.83	3982.12	155.0
2013-11-25 18:00:00	NQ	Futures	3980.96	3983.86	3980.09	3982.99	495.0
2013-11-25 19:00:00	NQ	Futures	3982.99	3985.9	3982.12	3985.61	708.0
2013-11-25 20:00:00	NQ	Futures	3985.31	3990.83	3984.73	3989.67	1222.0
2013-11-25 21:00:00	NQ	Futures	3989.67	3989.67	3986.48	3987.06	719.0
2013-11-25 22:00:00	NQ	Futures	3987.35	3989.67	3986.77	3989.38	232.0
2013-11-25 23:00:00	NQ	Futures	3989.09	3989.67	3988.8	3989.09	367.0
2013-11-25 00:00:00	YM	Futures	16412.5	16418.6	16412.5	16418.6	350.0
2013-11-25 01:00:00	YM	Futures	16418.6	16419.6	16411.4	16414.5	503.0

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

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