PREVIEW / futures_1hour / 2014-02-11

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-11.parquet
  size:    51 KB
  rows:    1,581

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-02-11 00:00:00	ES	Futures	1862.3	1863.34	1861.53	1862.04	3418.0
2014-02-11 01:00:00	ES	Futures	1861.79	1862.04	1860.75	1861.27	2870.0
2014-02-11 02:00:00	ES	Futures	1861.27	1863.6	1861.01	1861.79	9745.0
2014-02-11 03:00:00	ES	Futures	1861.79	1865.92	1861.01	1864.63	41779.0
2014-02-11 04:00:00	ES	Futures	1864.89	1865.92	1863.86	1865.41	15023.0
2014-02-11 05:00:00	ES	Futures	1865.15	1866.96	1864.63	1864.63	16902.0
2014-02-11 06:00:00	ES	Futures	1864.63	1865.41	1861.79	1861.79	18786.0
2014-02-11 07:00:00	ES	Futures	1862.04	1863.86	1861.79	1863.34	20947.0
2014-02-11 08:00:00	ES	Futures	1863.34	1865.41	1858.42	1859.2	115543.0
2014-02-11 09:00:00	ES	Futures	1859.2	1864.63	1857.13	1862.04	219683.0
2014-02-11 10:00:00	ES	Futures	1862.04	1866.44	1860.75	1864.89	228003.0
2014-02-11 11:00:00	ES	Futures	1864.89	1872.65	1864.63	1872.39	273969.0
2014-02-11 12:00:00	ES	Futures	1872.39	1873.68	1870.58	1873.43	129958.0
2014-02-11 13:00:00	ES	Futures	1873.43	1877.82	1873.17	1875.75	155209.0
2014-02-11 14:00:00	ES	Futures	1876.01	1880.15	1874.98	1879.89	130134.0
2014-02-11 15:00:00	ES	Futures	1879.63	1882.48	1876.53	1877.31	243831.0
2014-02-11 16:00:00	ES	Futures	1877.31	1877.82	1875.24	1875.24	99323.0
2014-02-11 17:00:00	ES	Futures	1875.24	1876.27	1875.24	1876.01	2531.0
2014-02-11 18:00:00	ES	Futures	1876.01	1876.27	1874.46	1875.75	6971.0
2014-02-11 19:00:00	ES	Futures	1875.75	1876.01	1874.72	1874.98	4747.0
2014-02-11 20:00:00	ES	Futures	1874.98	1876.53	1874.72	1874.98	5718.0
2014-02-11 21:00:00	ES	Futures	1874.98	1877.82	1873.94	1875.24	14151.0
2014-02-11 22:00:00	ES	Futures	1875.24	1877.05	1874.98	1876.79	4361.0
2014-02-11 23:00:00	ES	Futures	1876.79	1877.56	1876.53	1876.79	2253.0
2014-02-11 00:00:00	NQ	Futures	4170.74	4174.52	4170.74	4172.78	873.0
2014-02-11 01:00:00	NQ	Futures	4172.2	4172.78	4169.0	4169.58	253.0
2014-02-11 02:00:00	NQ	Futures	4170.16	4174.52	4169.58	4171.91	617.0
2014-02-11 03:00:00	NQ	Futures	4171.91	4178.88	4170.16	4175.98	4008.0
2014-02-11 04:00:00	NQ	Futures	4175.98	4178.59	4174.23	4177.72	1636.0
2014-02-11 05:00:00	NQ	Futures	4177.72	4181.5	4176.27	4177.14	1635.0
2014-02-11 06:00:00	NQ	Futures	4177.14	4177.72	4171.91	4171.91	1589.0
2014-02-11 07:00:00	NQ	Futures	4172.2	4176.85	4171.62	4174.81	2066.0
2014-02-11 08:00:00	NQ	Futures	4174.81	4180.05	4167.55	4169.87	11993.0
2014-02-11 09:00:00	NQ	Futures	4169.58	4178.88	4164.06	4174.81	35712.0
2014-02-11 10:00:00	NQ	Futures	4174.81	4185.28	4170.74	4179.47	44061.0
2014-02-11 11:00:00	NQ	Futures	4179.17	4191.09	4174.81	4190.22	38070.0
2014-02-11 12:00:00	NQ	Futures	4190.51	4195.74	4185.86	4195.16	18248.0
2014-02-11 13:00:00	NQ	Futures	4195.16	4207.37	4195.16	4199.23	24289.0
2014-02-11 14:00:00	NQ	Futures	4199.52	4210.28	4198.65	4209.11	18309.0
2014-02-11 15:00:00	NQ	Futures	4209.41	4216.09	4203.3	4207.08	32407.0
2014-02-11 16:00:00	NQ	Futures	4207.08	4207.37	4194.0	4201.27	10011.0
2014-02-11 17:00:00	NQ	Futures	4201.56	4202.14	4200.98	4200.98	205.0
2014-02-11 18:00:00	NQ	Futures	4199.81	4201.85	4197.78	4200.1	738.0
2014-02-11 19:00:00	NQ	Futures	4200.1	4200.98	4197.78	4198.65	414.0
2014-02-11 20:00:00	NQ	Futures	4198.36	4202.43	4198.07	4199.52	516.0
2014-02-11 21:00:00	NQ	Futures	4199.23	4207.37	4198.65	4200.39	1570.0
2014-02-11 22:00:00	NQ	Futures	4200.69	4203.59	4200.1	4203.01	501.0
2014-02-11 23:00:00	NQ	Futures	4203.01	4205.92	4201.85	4204.17	402.0
2014-02-11 00:00:00	YM	Futures	16187.0	16201.4	16187.0	16190.1	983.0
2014-02-11 01:00:00	YM	Futures	16188.0	16191.1	16178.8	16180.9	400.0

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

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