PREVIEW / futures_1hour / 2013-12-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-18.parquet
  size:    51 KB
  rows:    1,570

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
2013-12-18 00:00:00	ES	Futures	1837.21	1838.51	1836.96	1837.99	3497.0
2013-12-18 01:00:00	ES	Futures	1837.99	1839.28	1837.73	1839.28	2638.0
2013-12-18 02:00:00	ES	Futures	1839.02	1840.32	1839.02	1839.28	7092.0
2013-12-18 03:00:00	ES	Futures	1839.28	1840.58	1837.99	1839.28	14825.0
2013-12-18 04:00:00	ES	Futures	1839.28	1841.61	1838.25	1840.06	16573.0
2013-12-18 05:00:00	ES	Futures	1839.8	1841.61	1839.02	1841.09	12892.0
2013-12-18 06:00:00	ES	Futures	1840.84	1841.35	1837.73	1839.28	17036.0
2013-12-18 07:00:00	ES	Futures	1839.28	1839.28	1836.96	1837.73	13954.0
2013-12-18 08:00:00	ES	Futures	1837.99	1838.25	1836.44	1837.99	17425.0
2013-12-18 09:00:00	ES	Futures	1837.99	1840.58	1836.7	1838.51	151891.0
2013-12-18 10:00:00	ES	Futures	1838.51	1840.32	1835.66	1837.47	119762.0
2013-12-18 11:00:00	ES	Futures	1837.47	1838.25	1833.33	1834.37	123033.0
2013-12-18 12:00:00	ES	Futures	1834.11	1835.4	1832.3	1832.82	81731.0
2013-12-18 13:00:00	ES	Futures	1832.56	1837.21	1827.64	1833.33	186623.0
2013-12-18 14:00:00	ES	Futures	1833.08	1858.17	1821.69	1855.32	785608.0
2013-12-18 15:00:00	ES	Futures	1855.32	1868.25	1853.51	1867.48	554601.0
2013-12-18 16:00:00	ES	Futures	1867.74	1869.29	1865.67	1866.18	144524.0
2013-12-18 17:00:00	ES	Futures	1866.18	1866.7	1866.18	1866.44	1156.0
2013-12-18 18:00:00	ES	Futures	1866.44	1869.29	1866.18	1867.48	7725.0
2013-12-18 19:00:00	ES	Futures	1867.22	1867.48	1865.41	1865.67	4776.0
2013-12-18 20:00:00	ES	Futures	1865.41	1865.67	1863.86	1863.86	4925.0
2013-12-18 21:00:00	ES	Futures	1864.11	1865.15	1863.6	1863.86	4303.0
2013-12-18 22:00:00	ES	Futures	1863.86	1864.89	1863.86	1864.37	2834.0
2013-12-18 23:00:00	ES	Futures	1864.37	1864.37	1862.82	1863.08	3844.0
2013-12-18 00:00:00	NQ	Futures	4029.76	4032.67	4029.47	4032.67	496.0
2013-12-18 01:00:00	NQ	Futures	4032.09	4032.96	4031.51	4032.67	202.0
2013-12-18 02:00:00	NQ	Futures	4032.96	4035.29	4032.67	4033.54	635.0
2013-12-18 03:00:00	NQ	Futures	4033.54	4035.87	4028.6	4031.8	2360.0
2013-12-18 04:00:00	NQ	Futures	4032.09	4037.03	4030.63	4035.29	2577.0
2013-12-18 05:00:00	NQ	Futures	4035.58	4038.77	4033.54	4037.61	1174.0
2013-12-18 06:00:00	NQ	Futures	4037.9	4038.19	4030.05	4032.09	2143.0
2013-12-18 07:00:00	NQ	Futures	4032.09	4032.38	4027.73	4029.76	2445.0
2013-12-18 08:00:00	NQ	Futures	4029.76	4031.22	4027.15	4031.22	3316.0
2013-12-18 09:00:00	NQ	Futures	4030.93	4034.12	4015.81	4017.84	30940.0
2013-12-18 10:00:00	NQ	Futures	4017.84	4027.73	4013.77	4019.01	28385.0
2013-12-18 11:00:00	NQ	Futures	4019.3	4022.2	4002.15	4005.05	28105.0
2013-12-18 12:00:00	NQ	Futures	4005.05	4009.12	3996.33	3998.95	22253.0
2013-12-18 13:00:00	NQ	Futures	3998.66	4003.89	3985.29	3999.82	34914.0
2013-12-18 14:00:00	NQ	Futures	3999.53	4049.24	3971.04	4042.26	118566.0
2013-12-18 15:00:00	NQ	Futures	4042.26	4078.02	4039.06	4075.4	72278.0
2013-12-18 16:00:00	NQ	Futures	4075.4	4080.92	4073.66	4078.02	12821.0
2013-12-18 17:00:00	NQ	Futures	4078.02	4079.76	4077.73	4079.18	294.0
2013-12-18 18:00:00	NQ	Futures	4079.76	4084.41	4078.6	4082.09	792.0
2013-12-18 19:00:00	NQ	Futures	4081.8	4081.8	4077.43	4077.73	703.0
2013-12-18 20:00:00	NQ	Futures	4077.43	4077.73	4073.66	4073.66	688.0
2013-12-18 21:00:00	NQ	Futures	4074.24	4075.98	4072.49	4072.78	742.0
2013-12-18 22:00:00	NQ	Futures	4073.07	4075.11	4072.78	4073.95	494.0
2013-12-18 23:00:00	NQ	Futures	4073.37	4074.82	4071.62	4072.78	303.0
2013-12-18 00:00:00	YM	Futures	16233.2	16247.5	16233.2	16242.4	454.0
2013-12-18 01:00:00	YM	Futures	16241.4	16250.6	16241.4	16249.6	299.0

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

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