PREVIEW / futures_1hour / 2012-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-27.parquet
  size:    48 KB
  rows:    1,472

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-03-27 00:00:00	ES	Futures	1431.89	1432.9	1431.13	1432.4	4037.0
2012-03-27 01:00:00	ES	Futures	1432.14	1433.16	1431.89	1432.9	5931.0
2012-03-27 02:00:00	ES	Futures	1432.65	1433.92	1432.4	1432.65	8477.0
2012-03-27 03:00:00	ES	Futures	1432.9	1432.9	1430.12	1432.9	27789.0
2012-03-27 04:00:00	ES	Futures	1432.65	1436.45	1432.4	1435.18	35491.0
2012-03-27 05:00:00	ES	Futures	1435.18	1436.7	1432.4	1432.65	21215.0
2012-03-27 06:00:00	ES	Futures	1432.65	1433.41	1431.64	1432.9	18199.0
2012-03-27 07:00:00	ES	Futures	1432.9	1433.16	1429.36	1429.61	33614.0
2012-03-27 08:00:00	ES	Futures	1429.36	1432.14	1428.86	1431.13	52379.0
2012-03-27 09:00:00	ES	Futures	1431.39	1431.64	1428.6	1430.37	159139.0
2012-03-27 10:00:00	ES	Futures	1430.63	1430.63	1426.83	1427.08	219944.0
2012-03-27 11:00:00	ES	Futures	1427.34	1429.11	1426.83	1428.6	145221.0
2012-03-27 12:00:00	ES	Futures	1428.86	1430.12	1427.59	1428.86	72005.0
2012-03-27 13:00:00	ES	Futures	1428.86	1429.36	1426.58	1428.6	59027.0
2012-03-27 14:00:00	ES	Futures	1428.35	1429.87	1427.84	1428.86	69172.0
2012-03-27 15:00:00	ES	Futures	1428.86	1429.61	1423.04	1423.8	201240.0
2012-03-27 16:00:00	ES	Futures	1424.05	1424.55	1422.53	1422.78	81652.0
2012-03-27 17:00:00	ES	Futures	1422.78	1422.78	1421.77	1422.03	1922.0
2012-03-27 18:00:00	ES	Futures	1422.03	1423.54	1421.52	1423.54	3646.0
2012-03-27 19:00:00	ES	Futures	1423.29	1424.55	1423.29	1424.3	3556.0
2012-03-27 20:00:00	ES	Futures	1424.05	1425.57	1424.05	1425.31	5114.0
2012-03-27 21:00:00	ES	Futures	1425.31	1426.07	1424.05	1424.81	4674.0
2012-03-27 22:00:00	ES	Futures	1424.55	1424.81	1424.3	1424.3	2197.0
2012-03-27 23:00:00	ES	Futures	1424.55	1424.55	1423.8	1424.55	1837.0
2012-03-27 00:00:00	NQ	Futures	3213.02	3214.75	3211.57	3213.6	243.0
2012-03-27 01:00:00	NQ	Futures	3213.6	3216.49	3213.02	3215.62	357.0
2012-03-27 02:00:00	NQ	Futures	3215.91	3218.22	3214.75	3215.33	1070.0
2012-03-27 03:00:00	NQ	Futures	3215.04	3217.07	3209.55	3216.78	3436.0
2012-03-27 04:00:00	NQ	Futures	3216.78	3224.01	3215.91	3221.98	4186.0
2012-03-27 05:00:00	NQ	Futures	3221.98	3224.88	3214.75	3215.33	2361.0
2012-03-27 06:00:00	NQ	Futures	3215.33	3217.07	3213.02	3215.33	2261.0
2012-03-27 07:00:00	NQ	Futures	3215.62	3215.91	3207.52	3207.81	3789.0
2012-03-27 08:00:00	NQ	Futures	3207.81	3215.33	3206.66	3213.02	4570.0
2012-03-27 09:00:00	NQ	Futures	3213.31	3216.49	3209.26	3213.6	29327.0
2012-03-27 10:00:00	NQ	Futures	3214.17	3222.85	3210.13	3215.04	36061.0
2012-03-27 11:00:00	NQ	Futures	3215.04	3220.54	3215.04	3219.09	15364.0
2012-03-27 12:00:00	NQ	Futures	3219.09	3222.56	3218.8	3221.98	12306.0
2012-03-27 13:00:00	NQ	Futures	3222.27	3224.59	3217.93	3224.01	10075.0
2012-03-27 14:00:00	NQ	Futures	3223.72	3226.32	3222.27	3224.59	11955.0
2012-03-27 15:00:00	NQ	Futures	3224.59	3226.9	3211.86	3213.6	31175.0
2012-03-27 16:00:00	NQ	Futures	3213.89	3214.46	3210.42	3211.57	6919.0
2012-03-27 17:00:00	NQ	Futures	3211.86	3211.86	3209.55	3210.13	232.0
2012-03-27 18:00:00	NQ	Futures	3210.13	3212.73	3208.68	3212.73	291.0
2012-03-27 19:00:00	NQ	Futures	3212.44	3214.17	3211.57	3213.31	188.0
2012-03-27 20:00:00	NQ	Futures	3213.6	3215.91	3213.31	3215.62	351.0
2012-03-27 21:00:00	NQ	Futures	3215.91	3217.07	3212.73	3213.02	286.0
2012-03-27 22:00:00	NQ	Futures	3213.31	3213.6	3212.15	3212.73	196.0
2012-03-27 23:00:00	NQ	Futures	3213.02	3213.31	3211.28	3212.73	144.0
2012-03-27 00:00:00	YM	Futures	13153.1	13158.1	13146.2	13154.1	348.0
2012-03-27 01:00:00	YM	Futures	13155.1	13162.1	13154.1	13160.1	208.0

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

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