PREVIEW / futures_1hour / 2014-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-07.parquet
  size:    43 KB
  rows:    1,271

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-07 00:00:00	ES	Futures	1828.68	1830.49	1828.68	1829.97	2662.0
2014-02-07 01:00:00	ES	Futures	1830.23	1836.96	1829.97	1835.4	16136.0
2014-02-07 02:00:00	ES	Futures	1835.66	1835.66	1832.82	1833.08	9094.0
2014-02-07 03:00:00	ES	Futures	1833.33	1833.33	1827.64	1829.45	35036.0
2014-02-07 04:00:00	ES	Futures	1829.2	1834.63	1829.2	1833.85	23046.0
2014-02-07 05:00:00	ES	Futures	1833.85	1834.11	1832.3	1833.08	11916.0
2014-02-07 06:00:00	ES	Futures	1833.33	1833.85	1831.27	1833.08	16517.0
2014-02-07 07:00:00	ES	Futures	1833.08	1835.4	1832.82	1835.4	26638.0
2014-02-07 08:00:00	ES	Futures	1835.14	1847.82	1819.11	1841.09	406628.0
2014-02-07 09:00:00	ES	Futures	1841.35	1845.49	1836.7	1841.61	360138.0
2014-02-07 10:00:00	ES	Futures	1841.61	1843.68	1833.59	1839.54	350289.0
2014-02-07 11:00:00	ES	Futures	1839.54	1846.27	1837.99	1846.01	191182.0
2014-02-07 12:00:00	ES	Futures	1846.01	1846.01	1843.16	1845.49	106651.0
2014-02-07 13:00:00	ES	Futures	1845.49	1851.44	1845.23	1850.66	198306.0
2014-02-07 14:00:00	ES	Futures	1850.66	1852.22	1849.63	1851.18	156317.0
2014-02-07 15:00:00	ES	Futures	1851.18	1855.84	1850.92	1854.03	285238.0
2014-02-07 16:00:00	ES	Futures	1853.77	1856.1	1853.51	1855.06	115281.0
2014-02-07 17:00:00	ES	Futures	1855.06	1855.58	1854.54	1855.58	1616.0
2014-02-07 00:00:00	NQ	Futures	4059.12	4062.9	4059.12	4062.32	428.0
2014-02-07 01:00:00	NQ	Futures	4062.32	4077.14	4062.32	4074.82	2005.0
2014-02-07 02:00:00	NQ	Futures	4074.24	4074.53	4068.42	4069.88	660.0
2014-02-07 03:00:00	NQ	Futures	4069.88	4070.17	4060.58	4062.9	5183.0
2014-02-07 04:00:00	NQ	Futures	4062.9	4077.73	4062.9	4076.56	3664.0
2014-02-07 05:00:00	NQ	Futures	4076.56	4076.56	4073.37	4076.27	1403.0
2014-02-07 06:00:00	NQ	Futures	4076.27	4078.31	4072.49	4076.56	2244.0
2014-02-07 07:00:00	NQ	Futures	4076.27	4079.47	4074.82	4078.6	2921.0
2014-02-07 08:00:00	NQ	Futures	4078.6	4090.52	4045.75	4086.16	40600.0
2014-02-07 09:00:00	NQ	Futures	4086.16	4100.98	4079.76	4091.97	62684.0
2014-02-07 10:00:00	NQ	Futures	4091.97	4097.2	4074.24	4092.84	55658.0
2014-02-07 11:00:00	NQ	Futures	4093.13	4113.77	4090.22	4113.77	36255.0
2014-02-07 12:00:00	NQ	Futures	4113.77	4116.97	4110.57	4115.51	22914.0
2014-02-07 13:00:00	NQ	Futures	4115.22	4128.89	4115.22	4127.72	35311.0
2014-02-07 14:00:00	NQ	Futures	4128.01	4135.57	4125.4	4128.01	43646.0
2014-02-07 15:00:00	NQ	Futures	4128.3	4139.06	4128.3	4134.99	41530.0
2014-02-07 16:00:00	NQ	Futures	4134.7	4141.39	4132.37	4140.51	8291.0
2014-02-07 17:00:00	NQ	Futures	4140.51	4141.39	4139.64	4141.39	166.0
2014-02-07 00:00:00	YM	Futures	15952.2	15963.5	15952.2	15962.4	470.0
2014-02-07 01:00:00	YM	Futures	15962.4	16018.8	15960.4	16009.6	2576.0
2014-02-07 02:00:00	YM	Futures	16008.6	16010.6	15985.0	15987.1	1193.0
2014-02-07 03:00:00	YM	Futures	15987.1	15989.1	15945.0	15953.2	5848.0
2014-02-07 04:00:00	YM	Futures	15951.2	15989.1	15951.2	15984.0	3247.0
2014-02-07 05:00:00	YM	Futures	15983.0	15983.0	15966.5	15972.7	1637.0
2014-02-07 06:00:00	YM	Futures	15971.7	15979.9	15958.3	15974.8	1979.0
2014-02-07 07:00:00	YM	Futures	15973.7	15998.3	15971.7	15997.3	3125.0
2014-02-07 08:00:00	YM	Futures	15997.3	16047.6	15864.0	16027.0	31612.0
2014-02-07 09:00:00	YM	Futures	16027.0	16060.9	15995.3	16030.1	35260.0
2014-02-07 10:00:00	YM	Futures	16031.1	16049.6	15962.4	16019.9	32641.0
2014-02-07 11:00:00	YM	Futures	16019.9	16073.2	16006.5	16072.2	17647.0
2014-02-07 12:00:00	YM	Futures	16072.2	16075.2	16048.6	16073.2	10690.0
2014-02-07 13:00:00	YM	Futures	16072.2	16118.3	16070.1	16112.2	16028.0

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

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