PREVIEW / futures_1hour / 2014-01-24

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-24.parquet
  size:    46 KB
  rows:    1,300

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-24 00:00:00	ES	Futures	1885.32	1886.36	1883.25	1886.36	13821.0
2014-01-24 01:00:00	ES	Futures	1886.36	1888.69	1886.1	1887.91	6185.0
2014-01-24 02:00:00	ES	Futures	1887.91	1888.69	1886.62	1886.88	6843.0
2014-01-24 03:00:00	ES	Futures	1886.62	1888.17	1881.96	1882.22	41515.0
2014-01-24 04:00:00	ES	Futures	1882.48	1882.74	1879.37	1880.67	43021.0
2014-01-24 05:00:00	ES	Futures	1880.67	1880.93	1874.72	1874.72	41849.0
2014-01-24 06:00:00	ES	Futures	1874.72	1876.53	1870.58	1876.27	78725.0
2014-01-24 07:00:00	ES	Futures	1876.27	1876.79	1872.65	1874.98	41079.0
2014-01-24 08:00:00	ES	Futures	1874.98	1878.86	1873.43	1877.05	45551.0
2014-01-24 09:00:00	ES	Futures	1877.05	1877.05	1867.99	1871.62	276616.0
2014-01-24 10:00:00	ES	Futures	1871.87	1873.94	1861.53	1864.63	408327.0
2014-01-24 11:00:00	ES	Futures	1864.63	1866.18	1856.61	1863.6	394064.0
2014-01-24 12:00:00	ES	Futures	1863.6	1864.37	1858.68	1861.27	172437.0
2014-01-24 13:00:00	ES	Futures	1861.27	1862.56	1858.42	1859.46	127590.0
2014-01-24 14:00:00	ES	Futures	1859.2	1859.2	1852.47	1854.54	213110.0
2014-01-24 15:00:00	ES	Futures	1854.29	1855.32	1846.01	1846.27	399460.0
2014-01-24 16:00:00	ES	Futures	1846.53	1849.11	1841.61	1842.39	204665.0
2014-01-24 17:00:00	ES	Futures	1842.39	1842.9	1841.61	1841.87	4039.0
2014-01-24 00:00:00	NQ	Futures	4197.2	4199.23	4192.84	4198.65	1865.0
2014-01-24 01:00:00	NQ	Futures	4199.23	4203.59	4198.94	4202.72	693.0
2014-01-24 02:00:00	NQ	Futures	4202.43	4203.59	4200.1	4200.69	663.0
2014-01-24 03:00:00	NQ	Futures	4200.39	4202.43	4189.06	4190.22	5068.0
2014-01-24 04:00:00	NQ	Futures	4189.64	4192.55	4184.7	4187.6	5326.0
2014-01-24 05:00:00	NQ	Futures	4187.6	4187.6	4174.52	4174.81	5564.0
2014-01-24 06:00:00	NQ	Futures	4174.52	4178.01	4165.51	4177.43	8742.0
2014-01-24 07:00:00	NQ	Futures	4177.72	4181.21	4169.58	4176.27	5418.0
2014-01-24 08:00:00	NQ	Futures	4176.56	4186.15	4174.23	4180.92	6777.0
2014-01-24 09:00:00	NQ	Futures	4181.21	4181.21	4153.88	4161.44	56372.0
2014-01-24 10:00:00	NQ	Futures	4161.44	4169.29	4142.26	4152.72	62339.0
2014-01-24 11:00:00	NQ	Futures	4153.01	4155.34	4127.43	4147.78	63131.0
2014-01-24 12:00:00	NQ	Futures	4147.78	4151.27	4138.77	4145.46	27653.0
2014-01-24 13:00:00	NQ	Futures	4145.75	4147.49	4134.99	4136.73	17946.0
2014-01-24 14:00:00	NQ	Futures	4136.44	4136.44	4123.36	4130.63	32453.0
2014-01-24 15:00:00	NQ	Futures	4130.34	4130.92	4109.12	4109.99	62074.0
2014-01-24 16:00:00	NQ	Futures	4110.28	4118.13	4101.85	4102.43	11055.0
2014-01-24 17:00:00	NQ	Futures	4102.72	4104.18	4101.85	4101.85	267.0
2014-01-24 00:00:00	YM	Futures	16536.7	16543.9	16521.3	16543.9	1568.0
2014-01-24 01:00:00	YM	Futures	16543.9	16562.3	16543.9	16560.3	599.0
2014-01-24 02:00:00	YM	Futures	16559.2	16564.4	16550.0	16551.0	819.0
2014-01-24 03:00:00	YM	Futures	16551.0	16559.2	16502.8	16505.9	5018.0
2014-01-24 04:00:00	YM	Futures	16504.9	16519.2	16493.6	16504.9	5050.0
2014-01-24 05:00:00	YM	Futures	16503.9	16503.9	16452.6	16453.6	4896.0
2014-01-24 06:00:00	YM	Futures	16453.6	16474.1	16417.7	16474.1	7300.0
2014-01-24 07:00:00	YM	Futures	16474.1	16475.1	16444.4	16463.9	4427.0
2014-01-24 08:00:00	YM	Futures	16463.9	16492.6	16451.6	16478.2	4469.0
2014-01-24 09:00:00	YM	Futures	16478.2	16478.2	16405.4	16446.4	25938.0
2014-01-24 10:00:00	YM	Futures	16446.4	16470.0	16360.3	16383.9	44714.0
2014-01-24 11:00:00	YM	Futures	16382.9	16404.4	16331.6	16369.5	34783.0
2014-01-24 12:00:00	YM	Futures	16370.6	16376.7	16326.5	16347.0	18664.0
2014-01-24 13:00:00	YM	Futures	16347.0	16357.2	16327.5	16334.7	13436.0

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

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