PREVIEW / futures_1hour / 2013-12-10

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-10.parquet
  size:    46 KB
  rows:    1,436

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-10 00:00:00	ES	Futures	1868.15	1868.92	1867.63	1868.15	4599.0
2013-12-10 01:00:00	ES	Futures	1868.15	1868.41	1867.12	1867.89	2522.0
2013-12-10 02:00:00	ES	Futures	1867.63	1867.89	1865.83	1866.34	5515.0
2013-12-10 03:00:00	ES	Futures	1866.34	1869.18	1865.57	1868.67	15998.0
2013-12-10 04:00:00	ES	Futures	1868.41	1868.92	1867.38	1868.67	9776.0
2013-12-10 05:00:00	ES	Futures	1868.41	1869.18	1867.63	1867.63	7075.0
2013-12-10 06:00:00	ES	Futures	1867.89	1868.92	1867.63	1868.41	5627.0
2013-12-10 07:00:00	ES	Futures	1868.41	1868.67	1865.05	1865.05	23604.0
2013-12-10 08:00:00	ES	Futures	1865.31	1865.31	1859.89	1860.67	60197.0
2013-12-10 09:00:00	ES	Futures	1860.67	1864.02	1860.15	1862.99	174679.0
2013-12-10 10:00:00	ES	Futures	1863.25	1865.83	1862.47	1863.76	160851.0
2013-12-10 11:00:00	ES	Futures	1863.76	1864.28	1859.89	1860.93	135810.0
2013-12-10 12:00:00	ES	Futures	1860.67	1862.73	1858.86	1861.96	107308.0
2013-12-10 13:00:00	ES	Futures	1861.96	1862.99	1858.35	1859.38	74834.0
2013-12-10 14:00:00	ES	Futures	1859.38	1861.7	1859.12	1861.18	60274.0
2013-12-10 15:00:00	ES	Futures	1861.18	1863.25	1859.12	1859.89	141974.0
2013-12-10 16:00:00	ES	Futures	1859.89	1861.18	1859.64	1860.93	51089.0
2013-12-10 17:00:00	ES	Futures	1860.93	1861.18	1860.67	1860.67	2020.0
2013-12-10 18:00:00	ES	Futures	1861.7	1864.54	1861.44	1862.47	20591.0
2013-12-10 19:00:00	ES	Futures	1862.47	1865.57	1862.47	1865.05	12629.0
2013-12-10 20:00:00	ES	Futures	1865.05	1865.57	1864.02	1864.28	6334.0
2013-12-10 21:00:00	ES	Futures	1864.28	1864.54	1863.51	1864.02	3396.0
2013-12-10 22:00:00	ES	Futures	1864.02	1864.28	1860.93	1860.93	7987.0
2013-12-10 23:00:00	ES	Futures	1861.18	1861.7	1860.41	1860.93	6439.0
2013-12-10 00:00:00	NQ	Futures	4092.77	4093.65	4091.9	4092.77	291.0
2013-12-10 01:00:00	NQ	Futures	4093.07	4093.36	4091.32	4092.19	153.0
2013-12-10 02:00:00	NQ	Futures	4092.19	4092.19	4089.29	4089.58	546.0
2013-12-10 03:00:00	NQ	Futures	4089.87	4093.65	4088.71	4091.9	1891.0
2013-12-10 04:00:00	NQ	Futures	4092.19	4094.23	4090.16	4093.65	1124.0
2013-12-10 05:00:00	NQ	Futures	4093.65	4094.23	4091.32	4091.9	910.0
2013-12-10 06:00:00	NQ	Futures	4091.61	4092.77	4091.61	4091.9	783.0
2013-12-10 07:00:00	NQ	Futures	4091.61	4091.9	4085.51	4085.51	2324.0
2013-12-10 08:00:00	NQ	Futures	4085.51	4085.8	4075.35	4076.8	6168.0
2013-12-10 09:00:00	NQ	Futures	4076.51	4085.22	4075.06	4079.42	30665.0
2013-12-10 10:00:00	NQ	Futures	4079.42	4090.74	4078.25	4085.8	25955.0
2013-12-10 11:00:00	NQ	Futures	4085.8	4090.45	4081.45	4083.48	22619.0
2013-12-10 12:00:00	NQ	Futures	4083.19	4087.55	4077.96	4084.93	15093.0
2013-12-10 13:00:00	NQ	Futures	4084.64	4087.26	4078.25	4080.29	10061.0
2013-12-10 14:00:00	NQ	Futures	4080.0	4086.09	4078.83	4085.22	22451.0
2013-12-10 15:00:00	NQ	Futures	4085.22	4090.45	4082.9	4083.48	31914.0
2013-12-10 16:00:00	NQ	Futures	4083.77	4086.97	4083.48	4085.51	3493.0
2013-12-10 17:00:00	NQ	Futures	4085.51	4086.39	4085.22	4086.09	246.0
2013-12-10 18:00:00	NQ	Futures	4086.39	4090.16	4085.8	4086.68	2145.0
2013-12-10 19:00:00	NQ	Futures	4086.97	4090.45	4086.39	4089.87	2078.0
2013-12-10 20:00:00	NQ	Futures	4090.16	4091.9	4088.42	4089.0	829.0
2013-12-10 21:00:00	NQ	Futures	4088.71	4091.03	4088.71	4089.87	813.0
2013-12-10 22:00:00	NQ	Futures	4089.58	4089.87	4082.9	4082.9	905.0
2013-12-10 23:00:00	NQ	Futures	4082.9	4084.35	4082.32	4082.9	787.0
2013-12-10 00:00:00	YM	Futures	16378.8	16378.8	16371.6	16374.7	7.0
2013-12-10 01:00:00	YM	Futures	16375.7	16375.7	16367.5	16369.5	5.0

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

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