PREVIEW / futures_1hour / 2013-12-19

all futures 1-hour files

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

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-19 00:00:00	ES	Futures	1863.08	1864.63	1863.08	1863.08	7724.0
2013-12-19 01:00:00	ES	Futures	1863.08	1864.11	1861.53	1862.56	5682.0
2013-12-19 02:00:00	ES	Futures	1862.56	1862.82	1861.27	1861.53	6817.0
2013-12-19 03:00:00	ES	Futures	1861.53	1866.44	1861.27	1865.92	33104.0
2013-12-19 04:00:00	ES	Futures	1865.92	1866.18	1864.37	1865.15	12544.0
2013-12-19 05:00:00	ES	Futures	1865.15	1865.41	1863.6	1865.15	11337.0
2013-12-19 06:00:00	ES	Futures	1865.15	1866.96	1864.37	1865.67	12609.0
2013-12-19 07:00:00	ES	Futures	1865.67	1867.48	1864.37	1864.89	19257.0
2013-12-19 08:00:00	ES	Futures	1864.89	1865.92	1857.65	1857.91	65326.0
2013-12-19 09:00:00	ES	Futures	1857.91	1864.63	1857.13	1862.04	207462.0
2013-12-19 10:00:00	ES	Futures	1861.79	1863.86	1857.13	1862.3	221722.0
2013-12-19 11:00:00	ES	Futures	1862.56	1864.89	1860.75	1864.11	117633.0
2013-12-19 12:00:00	ES	Futures	1864.11	1865.67	1862.56	1864.63	87041.0
2013-12-19 13:00:00	ES	Futures	1864.63	1866.7	1863.34	1865.92	85774.0
2013-12-19 14:00:00	ES	Futures	1865.67	1866.44	1863.34	1865.41	73808.0
2013-12-19 15:00:00	ES	Futures	1865.15	1867.48	1863.86	1865.41	203989.0
2013-12-19 16:00:00	ES	Futures	1865.67	1865.92	1863.6	1864.11	74547.0
2013-12-19 17:00:00	ES	Futures	1863.86	1864.89	1863.86	1864.89	1465.0
2013-12-19 18:00:00	ES	Futures	1864.89	1866.44	1864.89	1864.89	5619.0
2013-12-19 19:00:00	ES	Futures	1865.15	1866.7	1864.89	1866.18	2842.0
2013-12-19 20:00:00	ES	Futures	1865.92	1867.22	1865.67	1867.22	5384.0
2013-12-19 21:00:00	ES	Futures	1866.96	1868.77	1866.96	1867.22	4076.0
2013-12-19 22:00:00	ES	Futures	1867.22	1868.51	1866.96	1866.96	2878.0
2013-12-19 23:00:00	ES	Futures	1866.96	1867.74	1866.96	1867.74	2089.0
2013-12-19 00:00:00	NQ	Futures	4072.49	4075.11	4071.33	4072.2	536.0
2013-12-19 01:00:00	NQ	Futures	4072.49	4073.07	4069.3	4070.75	348.0
2013-12-19 02:00:00	NQ	Futures	4070.46	4071.91	4068.71	4069.0	604.0
2013-12-19 03:00:00	NQ	Futures	4069.0	4076.85	4069.0	4075.98	2913.0
2013-12-19 04:00:00	NQ	Futures	4075.98	4076.56	4072.78	4073.37	1258.0
2013-12-19 05:00:00	NQ	Futures	4073.07	4074.24	4069.3	4073.95	1362.0
2013-12-19 06:00:00	NQ	Futures	4073.95	4074.24	4068.71	4069.88	1987.0
2013-12-19 07:00:00	NQ	Futures	4070.17	4071.91	4068.42	4069.0	2149.0
2013-12-19 08:00:00	NQ	Futures	4069.3	4072.2	4057.09	4057.67	7501.0
2013-12-19 09:00:00	NQ	Futures	4057.96	4067.84	4055.92	4056.8	37512.0
2013-12-19 10:00:00	NQ	Futures	4056.8	4063.48	4044.01	4059.41	49923.0
2013-12-19 11:00:00	NQ	Futures	4059.7	4064.06	4055.92	4060.58	20588.0
2013-12-19 12:00:00	NQ	Futures	4060.58	4061.74	4056.51	4059.99	16864.0
2013-12-19 13:00:00	NQ	Futures	4059.99	4064.64	4057.38	4063.77	15384.0
2013-12-19 14:00:00	NQ	Futures	4063.48	4066.39	4058.25	4062.32	14338.0
2013-12-19 15:00:00	NQ	Futures	4062.03	4064.94	4057.09	4062.03	25034.0
2013-12-19 16:00:00	NQ	Futures	4062.03	4063.19	4059.12	4061.16	5324.0
2013-12-19 17:00:00	NQ	Futures	4061.16	4062.9	4061.16	4062.61	121.0
2013-12-19 18:00:00	NQ	Futures	4062.03	4066.68	4061.74	4062.03	511.0
2013-12-19 19:00:00	NQ	Futures	4062.03	4065.52	4062.03	4064.64	295.0
2013-12-19 20:00:00	NQ	Futures	4064.64	4067.55	4064.35	4066.68	432.0
2013-12-19 21:00:00	NQ	Futures	4066.97	4070.17	4066.68	4068.13	430.0
2013-12-19 22:00:00	NQ	Futures	4068.71	4070.46	4067.84	4067.84	416.0
2013-12-19 23:00:00	NQ	Futures	4067.84	4069.3	4067.55	4069.0	275.0
2013-12-19 00:00:00	YM	Futures	16492.6	16503.9	16488.5	16491.6	714.0
2013-12-19 01:00:00	YM	Futures	16491.6	16495.7	16476.2	16487.5	824.0

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

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