PREVIEW / futures_1hour / 2013-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-07.parquet
  size:    49 KB
  rows:    1,516

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-03-07 00:00:00	ES	Futures	1579.32	1579.57	1578.04	1578.55	2925.0
2013-03-07 01:00:00	ES	Futures	1578.55	1579.57	1578.29	1579.06	2584.0
2013-03-07 02:00:00	ES	Futures	1578.8	1580.86	1578.55	1580.34	7158.0
2013-03-07 03:00:00	ES	Futures	1580.09	1582.14	1580.09	1581.11	16116.0
2013-03-07 04:00:00	ES	Futures	1581.11	1583.17	1580.86	1582.91	15840.0
2013-03-07 05:00:00	ES	Futures	1582.91	1583.17	1581.88	1581.88	9778.0
2013-03-07 06:00:00	ES	Futures	1581.88	1582.91	1581.37	1582.14	11120.0
2013-03-07 07:00:00	ES	Futures	1582.14	1582.65	1579.32	1580.86	32718.0
2013-03-07 08:00:00	ES	Futures	1580.86	1584.96	1580.6	1583.42	69221.0
2013-03-07 09:00:00	ES	Futures	1583.68	1585.48	1581.11	1583.94	206824.0
2013-03-07 10:00:00	ES	Futures	1583.94	1585.22	1581.88	1583.17	173251.0
2013-03-07 11:00:00	ES	Futures	1583.17	1586.25	1582.91	1584.96	103387.0
2013-03-07 12:00:00	ES	Futures	1584.96	1585.48	1583.68	1585.22	62518.0
2013-03-07 13:00:00	ES	Futures	1585.22	1585.48	1582.91	1583.94	52864.0
2013-03-07 14:00:00	ES	Futures	1583.94	1584.71	1581.37	1584.19	79986.0
2013-03-07 15:00:00	ES	Futures	1584.19	1585.99	1583.68	1584.45	140343.0
2013-03-07 16:00:00	ES	Futures	1584.45	1585.22	1583.42	1584.71	56430.0
2013-03-07 17:00:00	ES	Futures	1584.96	1585.22	1584.45	1584.71	2232.0
2013-03-07 18:00:00	ES	Futures	1583.42	1584.19	1582.14	1582.65	6603.0
2013-03-07 19:00:00	ES	Futures	1582.4	1582.65	1580.86	1581.88	4574.0
2013-03-07 20:00:00	ES	Futures	1581.88	1582.91	1581.37	1582.65	3017.0
2013-03-07 21:00:00	ES	Futures	1582.65	1583.42	1582.4	1582.91	3122.0
2013-03-07 22:00:00	ES	Futures	1583.17	1583.68	1582.4	1583.42	2274.0
2013-03-07 23:00:00	ES	Futures	1583.17	1584.71	1583.17	1583.68	2837.0
2013-03-07 00:00:00	NQ	Futures	3249.2	3249.2	3246.88	3247.46	277.0
2013-03-07 01:00:00	NQ	Futures	3247.46	3248.91	3247.17	3248.04	136.0
2013-03-07 02:00:00	NQ	Futures	3248.04	3251.53	3247.75	3251.24	719.0
2013-03-07 03:00:00	NQ	Futures	3251.24	3253.28	3250.95	3252.41	1406.0
2013-03-07 04:00:00	NQ	Futures	3252.7	3256.77	3252.41	3256.77	1329.0
2013-03-07 05:00:00	NQ	Futures	3256.48	3256.77	3254.73	3254.73	844.0
2013-03-07 06:00:00	NQ	Futures	3254.73	3256.77	3253.57	3253.86	1260.0
2013-03-07 07:00:00	NQ	Futures	3253.86	3254.15	3248.62	3250.95	2895.0
2013-03-07 08:00:00	NQ	Futures	3250.95	3257.94	3249.2	3255.03	6067.0
2013-03-07 09:00:00	NQ	Futures	3255.03	3257.94	3251.24	3255.32	30092.0
2013-03-07 10:00:00	NQ	Futures	3255.32	3257.06	3248.91	3252.99	21864.0
2013-03-07 11:00:00	NQ	Futures	3252.99	3265.21	3252.41	3260.26	18802.0
2013-03-07 12:00:00	NQ	Futures	3259.97	3261.43	3255.32	3260.85	10356.0
2013-03-07 13:00:00	NQ	Futures	3260.85	3262.01	3252.41	3256.48	10169.0
2013-03-07 14:00:00	NQ	Futures	3256.77	3259.68	3249.2	3258.52	12496.0
2013-03-07 15:00:00	NQ	Futures	3258.81	3264.63	3257.35	3260.56	18859.0
2013-03-07 16:00:00	NQ	Futures	3260.56	3261.14	3257.06	3259.39	3093.0
2013-03-07 17:00:00	NQ	Futures	3259.68	3260.56	3258.52	3259.1	146.0
2013-03-07 18:00:00	NQ	Futures	3258.23	3258.23	3255.9	3257.06	151.0
2013-03-07 19:00:00	NQ	Futures	3256.48	3256.77	3253.86	3255.32	237.0
2013-03-07 20:00:00	NQ	Futures	3255.61	3258.81	3254.73	3258.52	256.0
2013-03-07 21:00:00	NQ	Futures	3258.52	3260.85	3257.65	3259.68	274.0
2013-03-07 22:00:00	NQ	Futures	3259.68	3260.85	3258.23	3259.1	96.0
2013-03-07 23:00:00	NQ	Futures	3259.39	3261.43	3259.39	3259.68	163.0
2013-03-07 00:00:00	YM	Futures	14356.0	14357.0	14346.9	14350.9	250.0
2013-03-07 01:00:00	YM	Futures	14349.9	14358.0	14349.9	14357.0	194.0

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

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