PREVIEW / futures_1hour / 2014-01-28

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-28.parquet
  size:    50 KB
  rows:    1,571

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-28 00:00:00	ES	Futures	1842.39	1843.42	1842.13	1842.9	3416.0
2014-01-28 01:00:00	ES	Futures	1842.9	1842.9	1840.58	1841.09	4279.0
2014-01-28 02:00:00	ES	Futures	1840.84	1846.27	1840.84	1845.49	20838.0
2014-01-28 03:00:00	ES	Futures	1845.49	1846.78	1843.42	1845.75	38083.0
2014-01-28 04:00:00	ES	Futures	1845.49	1848.34	1845.49	1847.04	24448.0
2014-01-28 05:00:00	ES	Futures	1847.04	1847.3	1845.75	1846.53	16527.0
2014-01-28 06:00:00	ES	Futures	1846.53	1847.04	1843.94	1845.75	16742.0
2014-01-28 07:00:00	ES	Futures	1845.75	1846.01	1841.87	1842.13	32049.0
2014-01-28 08:00:00	ES	Futures	1842.39	1845.75	1836.96	1843.42	115510.0
2014-01-28 09:00:00	ES	Futures	1843.42	1847.04	1837.47	1846.53	259671.0
2014-01-28 10:00:00	ES	Futures	1846.01	1850.15	1844.72	1848.08	271587.0
2014-01-28 11:00:00	ES	Futures	1848.08	1850.66	1839.8	1843.16	239781.0
2014-01-28 12:00:00	ES	Futures	1843.16	1847.56	1841.87	1845.49	111719.0
2014-01-28 13:00:00	ES	Futures	1845.75	1848.34	1844.46	1846.01	102229.0
2014-01-28 14:00:00	ES	Futures	1846.01	1849.37	1844.97	1848.59	100857.0
2014-01-28 15:00:00	ES	Futures	1848.59	1850.15	1846.53	1848.08	183676.0
2014-01-28 16:00:00	ES	Futures	1847.82	1850.92	1847.82	1850.41	78220.0
2014-01-28 17:00:00	ES	Futures	1850.41	1859.2	1850.41	1856.61	50433.0
2014-01-28 18:00:00	ES	Futures	1858.17	1863.6	1856.61	1857.39	38029.0
2014-01-28 19:00:00	ES	Futures	1857.65	1860.23	1857.39	1859.72	8652.0
2014-01-28 20:00:00	ES	Futures	1859.72	1860.49	1859.2	1860.49	4625.0
2014-01-28 21:00:00	ES	Futures	1860.23	1860.49	1859.2	1859.72	3434.0
2014-01-28 22:00:00	ES	Futures	1859.72	1861.79	1859.46	1860.23	6743.0
2014-01-28 23:00:00	ES	Futures	1859.98	1860.23	1858.42	1859.72	5962.0
2014-01-28 00:00:00	NQ	Futures	4046.33	4047.2	4044.88	4046.62	814.0
2014-01-28 01:00:00	NQ	Futures	4046.33	4046.91	4042.84	4044.3	584.0
2014-01-28 02:00:00	NQ	Futures	4044.3	4059.41	4044.3	4058.25	2107.0
2014-01-28 03:00:00	NQ	Futures	4058.25	4060.28	4050.69	4057.96	4418.0
2014-01-28 04:00:00	NQ	Futures	4057.96	4067.55	4057.67	4065.23	3699.0
2014-01-28 05:00:00	NQ	Futures	4065.52	4065.52	4062.03	4064.35	2050.0
2014-01-28 06:00:00	NQ	Futures	4064.64	4064.94	4057.67	4061.45	2318.0
2014-01-28 07:00:00	NQ	Futures	4061.16	4062.61	4054.76	4055.34	3858.0
2014-01-28 08:00:00	NQ	Futures	4055.63	4060.28	4045.46	4058.54	13246.0
2014-01-28 09:00:00	NQ	Futures	4057.96	4063.48	4044.88	4060.58	52873.0
2014-01-28 10:00:00	NQ	Futures	4060.58	4071.62	4058.54	4066.68	46823.0
2014-01-28 11:00:00	NQ	Futures	4066.97	4072.78	4043.13	4051.56	41730.0
2014-01-28 12:00:00	NQ	Futures	4051.56	4057.38	4046.33	4054.76	18574.0
2014-01-28 13:00:00	NQ	Futures	4055.05	4061.16	4049.82	4053.02	19325.0
2014-01-28 14:00:00	NQ	Futures	4053.02	4066.39	4051.27	4064.35	30659.0
2014-01-28 15:00:00	NQ	Futures	4064.35	4069.3	4059.12	4068.42	32773.0
2014-01-28 16:00:00	NQ	Futures	4068.71	4076.85	4068.42	4072.78	10488.0
2014-01-28 17:00:00	NQ	Futures	4071.62	4088.48	4071.62	4084.12	2668.0
2014-01-28 18:00:00	NQ	Futures	4085.28	4098.95	4083.25	4085.57	2565.0
2014-01-28 19:00:00	NQ	Futures	4085.57	4092.26	4085.57	4090.81	937.0
2014-01-28 20:00:00	NQ	Futures	4090.52	4093.13	4089.64	4092.55	803.0
2014-01-28 21:00:00	NQ	Futures	4092.26	4092.26	4089.64	4090.81	466.0
2014-01-28 22:00:00	NQ	Futures	4090.81	4096.33	4090.52	4093.13	1228.0
2014-01-28 23:00:00	NQ	Futures	4093.13	4093.71	4090.22	4093.71	816.0
2014-01-28 00:00:00	YM	Futures	16240.3	16252.6	16239.3	16249.6	687.0
2014-01-28 01:00:00	YM	Futures	16247.5	16248.5	16233.2	16235.2	600.0

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

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