PREVIEW / futures_1hour / 2012-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-07.parquet
  size:    50 KB
  rows:    1,509

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-11-07 00:00:00	ES	Futures	1447.2	1454.1	1446.18	1451.8	15921.0
2012-11-07 01:00:00	ES	Futures	1451.54	1455.63	1450.52	1454.87	11751.0
2012-11-07 02:00:00	ES	Futures	1454.87	1463.04	1454.1	1460.74	33653.0
2012-11-07 03:00:00	ES	Futures	1460.74	1461.51	1457.16	1458.95	33546.0
2012-11-07 04:00:00	ES	Futures	1458.7	1459.98	1456.91	1459.21	23090.0
2012-11-07 05:00:00	ES	Futures	1459.46	1461.51	1458.95	1458.95	16374.0
2012-11-07 06:00:00	ES	Futures	1458.95	1458.95	1455.38	1455.89	28084.0
2012-11-07 07:00:00	ES	Futures	1455.89	1455.89	1445.16	1446.44	106680.0
2012-11-07 08:00:00	ES	Futures	1446.44	1446.95	1442.35	1443.63	91012.0
2012-11-07 09:00:00	ES	Futures	1443.37	1444.14	1432.64	1435.2	417842.0
2012-11-07 10:00:00	ES	Futures	1435.2	1435.45	1420.89	1421.4	581076.0
2012-11-07 11:00:00	ES	Futures	1421.4	1425.49	1414.25	1422.42	523046.0
2012-11-07 12:00:00	ES	Futures	1422.42	1425.23	1421.4	1423.7	205504.0
2012-11-07 13:00:00	ES	Futures	1423.7	1429.06	1423.19	1426.25	237738.0
2012-11-07 14:00:00	ES	Futures	1426.51	1429.32	1423.19	1427.02	177033.0
2012-11-07 15:00:00	ES	Futures	1427.02	1430.34	1420.89	1421.14	395220.0
2012-11-07 16:00:00	ES	Futures	1421.4	1422.68	1418.08	1421.91	153595.0
2012-11-07 17:00:00	ES	Futures	1421.91	1423.19	1420.12	1422.93	8878.0
2012-11-07 18:00:00	ES	Futures	1423.19	1425.23	1422.93	1423.7	10632.0
2012-11-07 19:00:00	ES	Futures	1423.7	1424.72	1422.17	1424.47	5827.0
2012-11-07 20:00:00	ES	Futures	1424.47	1425.49	1422.42	1422.42	6713.0
2012-11-07 21:00:00	ES	Futures	1422.42	1425.23	1422.17	1423.19	7259.0
2012-11-07 22:00:00	ES	Futures	1423.44	1423.95	1421.66	1422.68	4167.0
2012-11-07 23:00:00	ES	Futures	1422.68	1424.72	1421.91	1424.21	4081.0
2012-11-07 00:00:00	NQ	Futures	3096.96	3109.17	3094.93	3105.97	2012.0
2012-11-07 01:00:00	NQ	Futures	3105.97	3113.82	3103.94	3112.07	1695.0
2012-11-07 02:00:00	NQ	Futures	3112.07	3124.28	3110.33	3121.08	2848.0
2012-11-07 03:00:00	NQ	Futures	3121.08	3122.24	3113.53	3117.3	3211.0
2012-11-07 04:00:00	NQ	Futures	3117.01	3119.05	3112.94	3115.85	1832.0
2012-11-07 05:00:00	NQ	Futures	3115.85	3121.37	3115.85	3117.3	1480.0
2012-11-07 06:00:00	NQ	Futures	3117.01	3117.01	3108.59	3108.88	2065.0
2012-11-07 07:00:00	NQ	Futures	3108.88	3108.88	3084.47	3085.92	8414.0
2012-11-07 08:00:00	NQ	Futures	3085.92	3086.79	3078.08	3079.24	11697.0
2012-11-07 09:00:00	NQ	Futures	3078.95	3080.69	3063.84	3071.1	57847.0
2012-11-07 10:00:00	NQ	Futures	3071.1	3072.55	3033.33	3033.91	70485.0
2012-11-07 11:00:00	NQ	Futures	3034.2	3044.08	3020.83	3038.56	61639.0
2012-11-07 12:00:00	NQ	Futures	3038.56	3042.33	3030.71	3032.46	31166.0
2012-11-07 13:00:00	NQ	Futures	3032.46	3049.89	3030.71	3040.3	36104.0
2012-11-07 14:00:00	NQ	Futures	3040.01	3046.69	3031.87	3045.53	27434.0
2012-11-07 15:00:00	NQ	Futures	3045.53	3051.92	3033.62	3034.2	55349.0
2012-11-07 16:00:00	NQ	Futures	3034.2	3041.75	3033.33	3038.56	10931.0
2012-11-07 17:00:00	NQ	Futures	3038.27	3042.33	3035.94	3041.46	312.0
2012-11-07 18:00:00	NQ	Futures	3042.04	3045.53	3041.75	3042.63	999.0
2012-11-07 19:00:00	NQ	Futures	3042.63	3044.95	3040.01	3044.66	474.0
2012-11-07 20:00:00	NQ	Futures	3044.95	3046.4	3041.46	3041.46	842.0
2012-11-07 21:00:00	NQ	Futures	3041.46	3046.11	3040.88	3043.5	1114.0
2012-11-07 22:00:00	NQ	Futures	3043.5	3044.95	3040.59	3042.63	443.0
2012-11-07 23:00:00	NQ	Futures	3042.33	3046.4	3041.75	3045.53	487.0
2012-11-07 00:00:00	YM	Futures	13137.8	13190.8	13134.8	13171.8	2475.0
2012-11-07 01:00:00	YM	Futures	13172.8	13200.8	13163.8	13194.8	1473.0

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

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