PREVIEW / futures_1hour / 2014-02-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-03.parquet
  size:    52 KB
  rows:    1,567

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-03 00:00:00	ES	Futures	1842.13	1842.13	1840.06	1840.32	2844.0
2014-02-03 01:00:00	ES	Futures	1840.58	1840.58	1835.66	1836.7	7388.0
2014-02-03 02:00:00	ES	Futures	1836.7	1839.28	1835.92	1838.51	6534.0
2014-02-03 03:00:00	ES	Futures	1838.25	1843.94	1836.96	1839.8	39523.0
2014-02-03 04:00:00	ES	Futures	1840.06	1840.32	1834.63	1835.66	27468.0
2014-02-03 05:00:00	ES	Futures	1835.66	1838.25	1832.82	1833.33	23915.0
2014-02-03 06:00:00	ES	Futures	1833.33	1839.02	1832.82	1837.21	22488.0
2014-02-03 07:00:00	ES	Futures	1837.47	1842.39	1836.7	1842.13	25907.0
2014-02-03 08:00:00	ES	Futures	1842.13	1843.68	1837.47	1837.99	41373.0
2014-02-03 09:00:00	ES	Futures	1838.25	1840.58	1830.23	1833.08	225911.0
2014-02-03 10:00:00	ES	Futures	1833.08	1833.33	1818.07	1820.92	575883.0
2014-02-03 11:00:00	ES	Futures	1820.66	1820.92	1809.02	1809.8	411289.0
2014-02-03 12:00:00	ES	Futures	1809.8	1811.87	1805.4	1808.5	306543.0
2014-02-03 13:00:00	ES	Futures	1808.5	1809.8	1797.9	1800.23	368208.0
2014-02-03 14:00:00	ES	Futures	1800.49	1804.11	1795.57	1795.83	279314.0
2014-02-03 15:00:00	ES	Futures	1795.83	1800.23	1793.5	1797.12	431959.0
2014-02-03 16:00:00	ES	Futures	1797.12	1799.19	1792.21	1797.12	175404.0
2014-02-03 17:00:00	ES	Futures	1796.86	1797.12	1796.09	1796.61	2885.0
2014-02-03 18:00:00	ES	Futures	1798.42	1799.97	1796.61	1799.71	11949.0
2014-02-03 19:00:00	ES	Futures	1799.71	1800.49	1797.12	1800.23	10111.0
2014-02-03 20:00:00	ES	Futures	1800.23	1800.74	1797.38	1800.23	10562.0
2014-02-03 21:00:00	ES	Futures	1800.23	1803.07	1797.9	1799.45	14584.0
2014-02-03 22:00:00	ES	Futures	1799.45	1800.23	1797.38	1797.9	6899.0
2014-02-03 23:00:00	ES	Futures	1798.16	1801.26	1797.64	1800.74	6905.0
2014-02-03 00:00:00	NQ	Futures	4093.42	4094.0	4088.77	4089.93	575.0
2014-02-03 01:00:00	NQ	Futures	4090.22	4090.52	4079.18	4082.67	923.0
2014-02-03 02:00:00	NQ	Futures	4082.67	4089.64	4080.92	4087.03	612.0
2014-02-03 03:00:00	NQ	Futures	4087.03	4101.56	4086.74	4092.26	5777.0
2014-02-03 04:00:00	NQ	Futures	4092.84	4094.29	4078.31	4080.05	4493.0
2014-02-03 05:00:00	NQ	Futures	4080.05	4085.28	4072.78	4073.95	3048.0
2014-02-03 06:00:00	NQ	Futures	4074.24	4088.48	4072.2	4084.12	3542.0
2014-02-03 07:00:00	NQ	Futures	4083.83	4096.33	4082.38	4095.75	3099.0
2014-02-03 08:00:00	NQ	Futures	4095.46	4098.07	4085.86	4085.86	5359.0
2014-02-03 09:00:00	NQ	Futures	4085.86	4098.65	4065.81	4076.56	44586.0
2014-02-03 10:00:00	NQ	Futures	4076.56	4076.56	4039.06	4050.69	91797.0
2014-02-03 11:00:00	NQ	Futures	4050.4	4051.85	4024.53	4025.4	53477.0
2014-02-03 12:00:00	NQ	Futures	4025.4	4031.8	4014.07	4019.88	45059.0
2014-02-03 13:00:00	NQ	Futures	4019.59	4022.79	3985.58	3992.55	58202.0
2014-02-03 14:00:00	NQ	Futures	3992.26	4003.89	3983.25	3983.54	37906.0
2014-02-03 15:00:00	NQ	Futures	3983.83	3999.24	3982.67	3994.88	60498.0
2014-02-03 16:00:00	NQ	Futures	3995.17	4000.69	3987.32	3997.21	12800.0
2014-02-03 17:00:00	NQ	Futures	3997.5	3997.79	3995.17	3996.92	277.0
2014-02-03 18:00:00	NQ	Futures	3999.24	4003.02	3996.92	4003.02	1248.0
2014-02-03 19:00:00	NQ	Futures	4002.44	4004.47	3997.5	4004.18	1215.0
2014-02-03 20:00:00	NQ	Futures	4004.18	4005.34	3996.92	4003.6	1517.0
2014-02-03 21:00:00	NQ	Futures	4003.6	4009.41	3998.66	4002.15	1631.0
2014-02-03 22:00:00	NQ	Futures	4002.15	4003.89	3998.08	3998.95	1435.0
2014-02-03 23:00:00	NQ	Futures	3998.95	4005.34	3998.08	4004.47	1046.0
2014-02-03 00:00:00	YM	Futures	16059.9	16060.9	16042.4	16045.5	462.0
2014-02-03 01:00:00	YM	Futures	16046.5	16046.5	16012.7	16019.9	1280.0

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

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