PREVIEW / futures_1hour / 2012-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-20.parquet
  size:    34 KB
  rows:    991

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-02-20 00:00:00	ES	Futures	1377.62	1378.88	1377.37	1377.62	3093.0
2012-02-20 01:00:00	ES	Futures	1377.62	1378.12	1376.11	1376.61	4287.0
2012-02-20 02:00:00	ES	Futures	1376.61	1376.61	1374.85	1375.1	6800.0
2012-02-20 03:00:00	ES	Futures	1375.1	1375.6	1373.08	1374.34	23357.0
2012-02-20 04:00:00	ES	Futures	1374.34	1377.62	1374.09	1376.11	20522.0
2012-02-20 05:00:00	ES	Futures	1376.11	1378.37	1375.35	1377.87	18518.0
2012-02-20 06:00:00	ES	Futures	1377.87	1378.88	1377.37	1377.37	12766.0
2012-02-20 07:00:00	ES	Futures	1377.37	1378.37	1376.36	1378.12	8484.0
2012-02-20 08:00:00	ES	Futures	1378.12	1378.63	1376.11	1376.86	7549.0
2012-02-20 09:00:00	ES	Futures	1376.86	1377.11	1374.85	1375.6	15621.0
2012-02-20 10:00:00	ES	Futures	1375.6	1378.12	1375.35	1378.12	14276.0
2012-02-20 11:00:00	ES	Futures	1378.12	1378.37	1376.36	1377.37	9208.0
2012-02-20 18:00:00	ES	Futures	1376.86	1377.11	1372.58	1373.33	13032.0
2012-02-20 19:00:00	ES	Futures	1373.33	1376.11	1373.33	1375.6	7991.0
2012-02-20 20:00:00	ES	Futures	1375.6	1376.61	1375.35	1375.6	5777.0
2012-02-20 21:00:00	ES	Futures	1375.6	1377.37	1373.08	1375.6	13073.0
2012-02-20 22:00:00	ES	Futures	1375.6	1378.37	1374.59	1375.1	13945.0
2012-02-20 23:00:00	ES	Futures	1375.1	1376.11	1373.59	1375.85	5230.0
2012-02-20 00:00:00	NQ	Futures	3000.33	3002.35	3000.04	3000.33	520.0
2012-02-20 01:00:00	NQ	Futures	3000.33	3001.48	2997.15	2997.44	333.0
2012-02-20 02:00:00	NQ	Futures	2997.44	2998.02	2994.84	2996.57	539.0
2012-02-20 03:00:00	NQ	Futures	2996.57	2997.73	2990.51	2994.26	1341.0
2012-02-20 04:00:00	NQ	Futures	2994.55	3001.19	2994.26	2999.75	977.0
2012-02-20 05:00:00	NQ	Futures	2999.46	3002.64	2997.73	3001.19	893.0
2012-02-20 06:00:00	NQ	Futures	3002.06	3003.21	3000.04	3000.33	646.0
2012-02-20 07:00:00	NQ	Futures	3000.61	3001.48	2999.75	3000.61	476.0
2012-02-20 08:00:00	NQ	Futures	3000.33	3000.9	2995.99	2997.44	668.0
2012-02-20 09:00:00	NQ	Futures	2997.73	2999.46	2985.31	2990.22	3759.0
2012-02-20 10:00:00	NQ	Futures	2990.51	2996.28	2989.35	2996.28	1424.0
2012-02-20 11:00:00	NQ	Futures	2996.28	2996.57	2990.8	2994.84	936.0
2012-02-20 18:00:00	NQ	Futures	2994.26	2994.26	2984.44	2985.89	960.0
2012-02-20 19:00:00	NQ	Futures	2986.17	2991.08	2985.31	2990.22	376.0
2012-02-20 20:00:00	NQ	Futures	2989.93	2991.66	2989.64	2990.22	365.0
2012-02-20 21:00:00	NQ	Futures	2990.8	2994.26	2985.02	2990.8	836.0
2012-02-20 22:00:00	NQ	Futures	2990.8	2997.44	2987.91	2988.2	1114.0
2012-02-20 23:00:00	NQ	Futures	2988.2	2990.51	2985.6	2990.22	397.0
2012-02-20 00:00:00	YM	Futures	12880.8	12885.8	12876.8	12878.8	166.0
2012-02-20 01:00:00	YM	Futures	12879.8	12879.8	12852.1	12869.9	587.0
2012-02-20 02:00:00	YM	Futures	12866.9	12871.9	12856.0	12857.0	509.0
2012-02-20 03:00:00	YM	Futures	12858.0	12863.9	12843.1	12856.0	1722.0
2012-02-20 04:00:00	YM	Futures	12857.0	12884.8	12856.0	12873.9	1959.0
2012-02-20 05:00:00	YM	Futures	12874.8	12887.7	12865.9	12885.8	1128.0
2012-02-20 06:00:00	YM	Futures	12887.7	12893.7	12877.8	12877.8	962.0
2012-02-20 07:00:00	YM	Futures	12877.8	12886.7	12870.9	12885.8	841.0
2012-02-20 08:00:00	YM	Futures	12885.8	12889.7	12868.9	12874.8	643.0
2012-02-20 09:00:00	YM	Futures	12874.8	12879.8	12863.0	12869.9	1418.0
2012-02-20 10:00:00	YM	Futures	12870.9	12888.7	12865.9	12888.7	1733.0
2012-02-20 11:00:00	YM	Futures	12887.7	12890.7	12873.9	12885.8	553.0
2012-02-20 18:00:00	YM	Futures	12883.8	12885.8	12840.2	12849.1	599.0
2012-02-20 19:00:00	YM	Futures	12850.1	12871.9	12850.1	12867.9	404.0

> showing 50 of 991 rows — these rows as CSV

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