PREVIEW / futures_1hour / 2014-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-27.parquet
  size:    51 KB
  rows:    1,558

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-27 00:00:00	ES	Futures	1848.34	1848.59	1846.01	1846.53	4886.0
2014-01-27 01:00:00	ES	Futures	1846.78	1847.04	1843.94	1846.01	7217.0
2014-01-27 02:00:00	ES	Futures	1846.01	1851.96	1846.01	1851.7	24653.0
2014-01-27 03:00:00	ES	Futures	1851.7	1851.96	1847.3	1850.41	47332.0
2014-01-27 04:00:00	ES	Futures	1850.41	1850.66	1846.27	1848.85	42908.0
2014-01-27 05:00:00	ES	Futures	1848.59	1849.37	1843.94	1848.85	39384.0
2014-01-27 06:00:00	ES	Futures	1848.59	1852.73	1846.01	1851.96	38946.0
2014-01-27 07:00:00	ES	Futures	1851.96	1854.03	1850.15	1850.66	48833.0
2014-01-27 08:00:00	ES	Futures	1850.41	1852.73	1849.11	1850.92	47123.0
2014-01-27 09:00:00	ES	Futures	1850.92	1852.99	1846.27	1850.92	287981.0
2014-01-27 10:00:00	ES	Futures	1850.92	1851.7	1837.99	1841.09	462269.0
2014-01-27 11:00:00	ES	Futures	1841.09	1843.68	1834.63	1835.66	370359.0
2014-01-27 12:00:00	ES	Futures	1835.66	1835.66	1828.16	1833.08	366210.0
2014-01-27 13:00:00	ES	Futures	1832.82	1844.97	1831.78	1841.87	239112.0
2014-01-27 14:00:00	ES	Futures	1841.61	1850.41	1841.61	1849.37	208627.0
2014-01-27 15:00:00	ES	Futures	1849.63	1850.15	1836.7	1837.21	289210.0
2014-01-27 16:00:00	ES	Futures	1837.21	1838.25	1832.04	1834.37	134526.0
2014-01-27 17:00:00	ES	Futures	1834.37	1835.14	1832.3	1833.59	7701.0
2014-01-27 18:00:00	ES	Futures	1832.56	1838.25	1832.3	1836.96	15541.0
2014-01-27 19:00:00	ES	Futures	1836.96	1837.99	1835.92	1837.73	6081.0
2014-01-27 20:00:00	ES	Futures	1837.47	1840.06	1836.96	1839.8	8979.0
2014-01-27 21:00:00	ES	Futures	1839.8	1840.32	1838.51	1839.54	4478.0
2014-01-27 22:00:00	ES	Futures	1839.8	1843.68	1839.54	1842.65	11018.0
2014-01-27 23:00:00	ES	Futures	1842.9	1842.9	1842.13	1842.39	2740.0
2014-01-27 00:00:00	NQ	Futures	4112.61	4112.9	4106.21	4108.54	1005.0
2014-01-27 01:00:00	NQ	Futures	4109.41	4110.86	4102.72	4108.54	1051.0
2014-01-27 02:00:00	NQ	Futures	4108.54	4121.33	4108.54	4121.04	1994.0
2014-01-27 03:00:00	NQ	Futures	4120.75	4121.91	4109.41	4116.1	5513.0
2014-01-27 04:00:00	NQ	Futures	4116.39	4117.26	4110.57	4115.22	5188.0
2014-01-27 05:00:00	NQ	Futures	4114.93	4115.81	4103.02	4112.61	3988.0
2014-01-27 06:00:00	NQ	Futures	4112.9	4116.97	4105.34	4115.51	4325.0
2014-01-27 07:00:00	NQ	Futures	4115.51	4121.33	4112.03	4113.48	3827.0
2014-01-27 08:00:00	NQ	Futures	4113.19	4118.13	4110.57	4114.35	4950.0
2014-01-27 09:00:00	NQ	Futures	4114.06	4118.13	4098.95	4107.96	48048.0
2014-01-27 10:00:00	NQ	Futures	4107.96	4113.48	4061.16	4079.76	90971.0
2014-01-27 11:00:00	NQ	Futures	4079.76	4087.03	4066.68	4068.71	51416.0
2014-01-27 12:00:00	NQ	Futures	4068.71	4068.71	4041.1	4057.09	64677.0
2014-01-27 13:00:00	NQ	Futures	4056.8	4088.77	4053.6	4083.54	35955.0
2014-01-27 14:00:00	NQ	Futures	4083.54	4105.34	4083.54	4102.72	35040.0
2014-01-27 15:00:00	NQ	Futures	4102.72	4104.18	4071.62	4072.2	47423.0
2014-01-27 16:00:00	NQ	Futures	4072.49	4080.34	4037.9	4044.59	24055.0
2014-01-27 17:00:00	NQ	Futures	4044.3	4044.59	4032.38	4033.54	2721.0
2014-01-27 18:00:00	NQ	Futures	4033.54	4043.13	4029.76	4040.52	2769.0
2014-01-27 19:00:00	NQ	Futures	4040.81	4044.01	4038.48	4043.72	1079.0
2014-01-27 20:00:00	NQ	Futures	4043.72	4050.11	4040.52	4048.66	1787.0
2014-01-27 21:00:00	NQ	Futures	4048.66	4049.82	4044.88	4048.95	956.0
2014-01-27 22:00:00	NQ	Futures	4048.66	4054.76	4048.66	4052.44	1329.0
2014-01-27 23:00:00	NQ	Futures	4052.44	4053.31	4045.75	4045.75	1076.0
2014-01-27 00:00:00	YM	Futures	16227.0	16230.1	16210.6	16216.7	1179.0
2014-01-27 01:00:00	YM	Futures	16217.8	16218.8	16194.2	16210.6	1161.0

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

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