PREVIEW / futures_1hour / 2012-04-11

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-11.parquet
  size:    48 KB
  rows:    1,495

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
2012-04-11 00:00:00	ES	Futures	1378.01	1379.02	1376.99	1378.76	4366.0
2012-04-11 01:00:00	ES	Futures	1378.76	1379.52	1378.26	1378.76	4777.0
2012-04-11 02:00:00	ES	Futures	1378.76	1379.02	1377.5	1379.02	12472.0
2012-04-11 03:00:00	ES	Futures	1379.02	1382.31	1375.98	1376.74	56299.0
2012-04-11 04:00:00	ES	Futures	1376.74	1381.55	1375.48	1379.02	42237.0
2012-04-11 05:00:00	ES	Futures	1379.02	1385.09	1379.02	1384.58	47418.0
2012-04-11 06:00:00	ES	Futures	1384.58	1385.34	1383.07	1384.84	35825.0
2012-04-11 07:00:00	ES	Futures	1384.84	1385.85	1382.31	1382.81	43401.0
2012-04-11 08:00:00	ES	Futures	1382.81	1384.58	1382.05	1383.57	55802.0
2012-04-11 09:00:00	ES	Futures	1383.82	1385.6	1381.55	1382.81	271796.0
2012-04-11 10:00:00	ES	Futures	1382.81	1386.86	1382.56	1384.58	282574.0
2012-04-11 11:00:00	ES	Futures	1384.58	1384.84	1380.28	1380.79	211672.0
2012-04-11 12:00:00	ES	Futures	1380.54	1384.58	1380.28	1384.33	120243.0
2012-04-11 13:00:00	ES	Futures	1384.58	1385.6	1382.05	1384.84	84488.0
2012-04-11 14:00:00	ES	Futures	1384.84	1385.09	1380.79	1382.31	113622.0
2012-04-11 15:00:00	ES	Futures	1382.05	1382.81	1378.76	1380.54	218742.0
2012-04-11 16:00:00	ES	Futures	1380.79	1381.8	1379.78	1381.8	87986.0
2012-04-11 17:00:00	ES	Futures	1381.55	1381.8	1381.29	1381.55	1590.0
2012-04-11 18:00:00	ES	Futures	1381.55	1383.82	1381.29	1383.32	3192.0
2012-04-11 19:00:00	ES	Futures	1383.32	1384.33	1381.29	1381.55	4402.0
2012-04-11 20:00:00	ES	Futures	1381.55	1382.05	1379.52	1380.28	6751.0
2012-04-11 21:00:00	ES	Futures	1380.28	1381.8	1379.52	1380.79	6024.0
2012-04-11 22:00:00	ES	Futures	1380.79	1385.09	1380.79	1384.84	10623.0
2012-04-11 23:00:00	ES	Futures	1384.84	1385.34	1383.57	1384.84	4502.0
2012-04-11 00:00:00	NQ	Futures	3129.44	3130.02	3127.41	3129.73	670.0
2012-04-11 01:00:00	NQ	Futures	3129.73	3130.89	3127.7	3128.57	989.0
2012-04-11 02:00:00	NQ	Futures	3128.28	3130.02	3126.26	3128.57	1680.0
2012-04-11 03:00:00	NQ	Futures	3128.86	3134.93	3122.21	3123.66	5899.0
2012-04-11 04:00:00	NQ	Futures	3123.66	3134.36	3121.63	3129.44	4726.0
2012-04-11 05:00:00	NQ	Futures	3129.15	3142.16	3129.15	3141.59	3113.0
2012-04-11 06:00:00	NQ	Futures	3141.01	3143.32	3138.69	3143.03	3284.0
2012-04-11 07:00:00	NQ	Futures	3143.03	3145.35	3138.98	3140.14	3947.0
2012-04-11 08:00:00	NQ	Futures	3140.14	3143.03	3137.54	3140.72	6292.0
2012-04-11 09:00:00	NQ	Futures	3141.01	3143.61	3130.6	3138.69	49240.0
2012-04-11 10:00:00	NQ	Futures	3138.69	3150.84	3138.4	3147.37	47186.0
2012-04-11 11:00:00	NQ	Futures	3147.08	3148.24	3135.51	3136.38	28229.0
2012-04-11 12:00:00	NQ	Futures	3136.38	3139.85	3130.6	3138.4	25821.0
2012-04-11 13:00:00	NQ	Futures	3138.4	3141.01	3132.62	3137.54	18651.0
2012-04-11 14:00:00	NQ	Futures	3137.83	3138.12	3123.37	3131.17	29098.0
2012-04-11 15:00:00	NQ	Futures	3131.17	3132.33	3121.92	3129.73	31183.0
2012-04-11 16:00:00	NQ	Futures	3129.73	3133.49	3128.86	3132.91	6851.0
2012-04-11 17:00:00	NQ	Futures	3133.2	3133.49	3132.91	3132.91	90.0
2012-04-11 18:00:00	NQ	Futures	3132.91	3136.09	3132.62	3135.22	539.0
2012-04-11 19:00:00	NQ	Futures	3135.22	3137.54	3132.04	3132.91	513.0
2012-04-11 20:00:00	NQ	Futures	3132.91	3133.2	3128.86	3130.31	530.0
2012-04-11 21:00:00	NQ	Futures	3130.02	3133.49	3128.86	3131.46	463.0
2012-04-11 22:00:00	NQ	Futures	3131.46	3138.12	3130.89	3137.83	828.0
2012-04-11 23:00:00	NQ	Futures	3137.83	3138.69	3135.8	3137.83	432.0
2012-04-11 00:00:00	YM	Futures	12668.9	12674.9	12660.0	12673.9	610.0
2012-04-11 01:00:00	YM	Futures	12673.9	12680.9	12671.9	12675.9	302.0

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

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