PREVIEW / futures_1hour / 2013-12-03

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-03.parquet
  size:    50 KB
  rows:    1,540

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-03 00:00:00	ES	Futures	1857.32	1858.09	1856.8	1857.32	4351.0
2013-12-03 01:00:00	ES	Futures	1857.32	1857.57	1856.54	1856.8	3002.0
2013-12-03 02:00:00	ES	Futures	1856.8	1858.35	1856.54	1857.32	6558.0
2013-12-03 03:00:00	ES	Futures	1857.32	1857.83	1856.28	1856.8	14255.0
2013-12-03 04:00:00	ES	Futures	1856.54	1856.8	1853.7	1854.22	33298.0
2013-12-03 05:00:00	ES	Futures	1854.22	1854.48	1852.16	1852.67	24000.0
2013-12-03 06:00:00	ES	Futures	1852.67	1852.67	1850.35	1850.87	36822.0
2013-12-03 07:00:00	ES	Futures	1851.12	1852.41	1850.35	1852.16	29881.0
2013-12-03 08:00:00	ES	Futures	1852.16	1852.67	1850.35	1850.87	42216.0
2013-12-03 09:00:00	ES	Futures	1850.87	1854.74	1849.06	1854.48	281069.0
2013-12-03 10:00:00	ES	Futures	1854.74	1855.77	1852.67	1854.74	205664.0
2013-12-03 11:00:00	ES	Futures	1854.74	1854.99	1845.96	1848.54	292051.0
2013-12-03 12:00:00	ES	Futures	1848.29	1850.35	1847.51	1849.32	129882.0
2013-12-03 13:00:00	ES	Futures	1849.32	1849.58	1844.42	1845.71	144104.0
2013-12-03 14:00:00	ES	Futures	1845.45	1849.06	1843.13	1849.06	138330.0
2013-12-03 15:00:00	ES	Futures	1849.06	1851.38	1845.45	1850.61	202120.0
2013-12-03 16:00:00	ES	Futures	1850.35	1850.61	1847.77	1848.54	72316.0
2013-12-03 17:00:00	ES	Futures	1848.54	1849.06	1848.54	1848.54	2127.0
2013-12-03 18:00:00	ES	Futures	1849.06	1849.83	1848.29	1849.06	7568.0
2013-12-03 19:00:00	ES	Futures	1849.06	1850.35	1848.8	1850.09	4196.0
2013-12-03 20:00:00	ES	Futures	1849.83	1850.35	1847.25	1848.8	9117.0
2013-12-03 21:00:00	ES	Futures	1848.8	1850.35	1848.54	1850.09	5592.0
2013-12-03 22:00:00	ES	Futures	1850.09	1851.12	1850.09	1850.61	3864.0
2013-12-03 23:00:00	ES	Futures	1850.87	1850.87	1849.58	1850.09	2861.0
2013-12-03 00:00:00	NQ	Futures	4048.05	4049.5	4047.18	4048.34	438.0
2013-12-03 01:00:00	NQ	Futures	4047.76	4048.63	4046.89	4047.76	151.0
2013-12-03 02:00:00	NQ	Futures	4047.47	4049.79	4047.18	4048.34	631.0
2013-12-03 03:00:00	NQ	Futures	4048.63	4049.21	4045.14	4047.18	4097.0
2013-12-03 04:00:00	NQ	Futures	4046.89	4048.05	4044.27	4046.6	4187.0
2013-12-03 05:00:00	NQ	Futures	4046.89	4046.89	4040.5	4042.24	4685.0
2013-12-03 06:00:00	NQ	Futures	4042.24	4042.24	4038.17	4040.5	3936.0
2013-12-03 07:00:00	NQ	Futures	4040.79	4042.24	4038.46	4041.95	3020.0
2013-12-03 08:00:00	NQ	Futures	4041.95	4041.95	4039.34	4039.92	4375.0
2013-12-03 09:00:00	NQ	Futures	4040.21	4049.5	4037.3	4046.6	47755.0
2013-12-03 10:00:00	NQ	Futures	4046.89	4052.99	4043.11	4047.18	33656.0
2013-12-03 11:00:00	NQ	Futures	4047.18	4049.5	4030.91	4036.72	35104.0
2013-12-03 12:00:00	NQ	Futures	4036.43	4040.21	4034.69	4039.34	13414.0
2013-12-03 13:00:00	NQ	Futures	4039.34	4039.92	4026.85	4030.62	18213.0
2013-12-03 14:00:00	NQ	Futures	4030.62	4039.92	4026.85	4039.63	17334.0
2013-12-03 15:00:00	NQ	Futures	4039.63	4043.69	4030.62	4041.95	24928.0
2013-12-03 16:00:00	NQ	Futures	4041.95	4042.82	4037.01	4039.34	4288.0
2013-12-03 17:00:00	NQ	Futures	4039.34	4040.21	4038.75	4039.04	126.0
2013-12-03 18:00:00	NQ	Futures	4038.46	4040.79	4037.59	4039.04	588.0
2013-12-03 19:00:00	NQ	Futures	4039.34	4041.37	4039.04	4041.08	529.0
2013-12-03 20:00:00	NQ	Futures	4040.79	4041.37	4035.85	4038.75	963.0
2013-12-03 21:00:00	NQ	Futures	4038.75	4041.37	4037.88	4041.08	622.0
2013-12-03 22:00:00	NQ	Futures	4041.08	4041.95	4040.5	4041.37	289.0
2013-12-03 23:00:00	NQ	Futures	4041.37	4041.95	4040.21	4040.79	268.0
2013-12-03 00:00:00	YM	Futures	16325.7	16330.8	16322.6	16324.6	431.0
2013-12-03 01:00:00	YM	Futures	16324.6	16325.7	16318.5	16319.5	373.0

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

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