PREVIEW / futures_1hour / 2013-12-11

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-11.parquet
  size:    47 KB
  rows:    1,481

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-11 00:00:00	ES	Futures	1860.93	1861.44	1860.41	1860.67	3147.0
2013-12-11 01:00:00	ES	Futures	1860.67	1860.93	1859.12	1859.89	4922.0
2013-12-11 02:00:00	ES	Futures	1860.15	1860.41	1856.8	1857.06	10655.0
2013-12-11 03:00:00	ES	Futures	1857.06	1859.38	1856.8	1858.6	16770.0
2013-12-11 04:00:00	ES	Futures	1858.6	1859.12	1856.28	1858.35	16335.0
2013-12-11 05:00:00	ES	Futures	1858.09	1860.41	1858.09	1859.64	8955.0
2013-12-11 06:00:00	ES	Futures	1859.64	1860.41	1858.35	1859.12	9031.0
2013-12-11 07:00:00	ES	Futures	1859.12	1861.7	1858.35	1861.18	17864.0
2013-12-11 08:00:00	ES	Futures	1861.18	1862.22	1860.41	1861.18	19695.0
2013-12-11 09:00:00	ES	Futures	1861.18	1861.7	1851.9	1854.74	202538.0
2013-12-11 10:00:00	ES	Futures	1854.48	1854.74	1848.03	1850.87	287163.0
2013-12-11 11:00:00	ES	Futures	1850.87	1851.38	1845.71	1848.03	177405.0
2013-12-11 12:00:00	ES	Futures	1847.77	1848.03	1842.61	1844.93	166964.0
2013-12-11 13:00:00	ES	Futures	1845.19	1848.54	1843.9	1848.54	115717.0
2013-12-11 14:00:00	ES	Futures	1848.54	1848.54	1842.61	1843.39	113406.0
2013-12-11 15:00:00	ES	Futures	1843.64	1844.42	1835.9	1837.97	351262.0
2013-12-11 16:00:00	ES	Futures	1837.71	1839.0	1837.19	1837.45	108450.0
2013-12-11 17:00:00	ES	Futures	1837.71	1837.71	1836.94	1837.19	5414.0
2013-12-11 18:00:00	ES	Futures	1837.45	1839.52	1837.45	1838.23	8641.0
2013-12-11 19:00:00	ES	Futures	1838.23	1839.26	1837.97	1838.74	3935.0
2013-12-11 20:00:00	ES	Futures	1838.74	1839.26	1837.19	1839.0	4610.0
2013-12-11 21:00:00	ES	Futures	1839.0	1839.0	1833.07	1834.1	16504.0
2013-12-11 22:00:00	ES	Futures	1834.36	1834.36	1832.55	1833.07	9202.0
2013-12-11 23:00:00	ES	Futures	1833.32	1833.84	1832.03	1833.84	6169.0
2013-12-11 00:00:00	NQ	Futures	4083.19	4083.48	4081.74	4082.32	352.0
2013-12-11 01:00:00	NQ	Futures	4082.61	4082.61	4079.42	4080.87	473.0
2013-12-11 02:00:00	NQ	Futures	4080.87	4081.45	4074.48	4075.06	1512.0
2013-12-11 03:00:00	NQ	Futures	4075.06	4080.0	4073.9	4078.54	2649.0
2013-12-11 04:00:00	NQ	Futures	4078.83	4080.58	4073.32	4078.83	3099.0
2013-12-11 05:00:00	NQ	Futures	4078.83	4083.19	4078.54	4081.74	1400.0
2013-12-11 06:00:00	NQ	Futures	4081.74	4083.77	4077.96	4079.71	2171.0
2013-12-11 07:00:00	NQ	Futures	4079.12	4085.51	4077.96	4084.06	3406.0
2013-12-11 08:00:00	NQ	Futures	4084.06	4087.26	4082.9	4084.06	2815.0
2013-12-11 09:00:00	NQ	Futures	4084.06	4088.71	4067.8	4075.35	32778.0
2013-12-11 10:00:00	NQ	Futures	4075.35	4075.64	4060.25	4066.93	46297.0
2013-12-11 11:00:00	NQ	Futures	4066.93	4069.25	4057.63	4060.83	23176.0
2013-12-11 12:00:00	NQ	Futures	4060.83	4060.83	4044.56	4047.18	30919.0
2013-12-11 13:00:00	NQ	Futures	4047.18	4055.89	4045.43	4055.31	23825.0
2013-12-11 14:00:00	NQ	Futures	4055.31	4055.31	4041.08	4042.53	23017.0
2013-12-11 15:00:00	NQ	Futures	4042.53	4044.27	4024.81	4031.2	61836.0
2013-12-11 16:00:00	NQ	Futures	4031.49	4034.69	4030.91	4032.36	9144.0
2013-12-11 17:00:00	NQ	Futures	4032.36	4032.66	4030.91	4030.91	245.0
2013-12-11 18:00:00	NQ	Futures	4032.66	4037.59	4032.66	4035.56	1442.0
2013-12-11 19:00:00	NQ	Futures	4035.27	4037.59	4035.27	4036.72	616.0
2013-12-11 20:00:00	NQ	Futures	4036.72	4038.17	4033.82	4037.01	869.0
2013-12-11 21:00:00	NQ	Futures	4037.01	4037.01	4025.39	4027.72	1695.0
2013-12-11 22:00:00	NQ	Futures	4027.72	4028.3	4023.36	4025.39	1253.0
2013-12-11 23:00:00	NQ	Futures	4025.69	4027.72	4023.94	4027.43	1061.0
2013-12-11 00:00:00	YM	Futures	16321.3	16323.4	16318.3	16320.3	26.0
2013-12-11 01:00:00	YM	Futures	16319.3	16319.3	16310.1	16317.2	21.0

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

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