PREVIEW / futures_1hour / 2012-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-27.parquet
  size:    47 KB
  rows:    1,492

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-27 00:00:00	ES	Futures	1437.24	1437.75	1436.98	1437.49	2628.0
2012-11-27 01:00:00	ES	Futures	1437.24	1437.49	1435.96	1436.98	3080.0
2012-11-27 02:00:00	ES	Futures	1436.98	1437.75	1435.71	1436.22	7525.0
2012-11-27 03:00:00	ES	Futures	1435.96	1437.49	1434.17	1435.96	26671.0
2012-11-27 04:00:00	ES	Futures	1435.71	1437.49	1434.43	1435.45	18778.0
2012-11-27 05:00:00	ES	Futures	1435.71	1435.71	1432.13	1432.39	22790.0
2012-11-27 06:00:00	ES	Futures	1432.39	1433.92	1431.62	1433.66	18236.0
2012-11-27 07:00:00	ES	Futures	1433.66	1435.45	1433.41	1434.68	23476.0
2012-11-27 08:00:00	ES	Futures	1434.68	1435.71	1432.64	1434.94	59157.0
2012-11-27 09:00:00	ES	Futures	1434.94	1437.49	1431.36	1436.22	180685.0
2012-11-27 10:00:00	ES	Futures	1436.47	1437.24	1428.3	1430.85	286626.0
2012-11-27 11:00:00	ES	Futures	1430.6	1437.49	1430.6	1436.47	148989.0
2012-11-27 12:00:00	ES	Futures	1436.22	1437.75	1434.17	1435.96	93594.0
2012-11-27 13:00:00	ES	Futures	1435.71	1435.96	1432.9	1434.17	103077.0
2012-11-27 14:00:00	ES	Futures	1433.92	1435.96	1426.76	1430.09	229779.0
2012-11-27 15:00:00	ES	Futures	1430.09	1432.39	1426.0	1427.79	276782.0
2012-11-27 16:00:00	ES	Futures	1428.04	1429.32	1427.28	1428.04	79452.0
2012-11-27 17:00:00	ES	Futures	1428.04	1428.55	1427.53	1428.3	1542.0
2012-11-27 18:00:00	ES	Futures	1428.04	1428.04	1425.49	1426.0	7276.0
2012-11-27 19:00:00	ES	Futures	1425.74	1427.02	1425.49	1426.25	5616.0
2012-11-27 20:00:00	ES	Futures	1426.25	1426.51	1423.95	1424.47	9770.0
2012-11-27 21:00:00	ES	Futures	1424.47	1425.49	1423.95	1424.98	3870.0
2012-11-27 22:00:00	ES	Futures	1425.23	1426.51	1424.21	1425.49	7925.0
2012-11-27 23:00:00	ES	Futures	1425.49	1427.53	1425.23	1427.02	4032.0
2012-11-27 00:00:00	NQ	Futures	3084.76	3084.76	3083.6	3084.47	236.0
2012-11-27 01:00:00	NQ	Futures	3084.18	3085.05	3082.43	3085.05	301.0
2012-11-27 02:00:00	NQ	Futures	3085.05	3085.63	3081.27	3081.56	889.0
2012-11-27 03:00:00	NQ	Futures	3081.85	3085.63	3080.69	3083.89	2938.0
2012-11-27 04:00:00	NQ	Futures	3083.6	3086.79	3078.95	3083.89	2957.0
2012-11-27 05:00:00	NQ	Futures	3083.89	3083.89	3077.2	3077.79	2048.0
2012-11-27 06:00:00	NQ	Futures	3077.79	3080.11	3075.75	3080.11	2206.0
2012-11-27 07:00:00	NQ	Futures	3079.82	3084.76	3079.24	3082.14	6643.0
2012-11-27 08:00:00	NQ	Futures	3082.14	3084.18	3077.2	3080.69	6403.0
2012-11-27 09:00:00	NQ	Futures	3080.4	3086.21	3074.01	3081.85	37096.0
2012-11-27 10:00:00	NQ	Futures	3081.85	3082.72	3064.42	3069.65	51586.0
2012-11-27 11:00:00	NQ	Futures	3069.94	3085.34	3069.94	3083.89	27239.0
2012-11-27 12:00:00	NQ	Futures	3083.89	3090.28	3078.37	3087.66	19605.0
2012-11-27 13:00:00	NQ	Futures	3087.66	3087.66	3079.53	3083.6	33074.0
2012-11-27 14:00:00	NQ	Futures	3083.89	3088.25	3067.03	3074.59	33233.0
2012-11-27 15:00:00	NQ	Futures	3074.59	3080.4	3066.74	3069.07	30697.0
2012-11-27 16:00:00	NQ	Futures	3069.07	3072.55	3068.49	3069.94	5118.0
2012-11-27 17:00:00	NQ	Futures	3070.23	3071.1	3069.94	3071.1	61.0
2012-11-27 18:00:00	NQ	Futures	3068.49	3069.94	3066.16	3066.74	426.0
2012-11-27 19:00:00	NQ	Futures	3067.03	3069.94	3065.87	3069.07	580.0
2012-11-27 20:00:00	NQ	Futures	3069.07	3069.65	3065.87	3066.45	1041.0
2012-11-27 21:00:00	NQ	Futures	3066.16	3067.91	3065.87	3067.61	473.0
2012-11-27 22:00:00	NQ	Futures	3067.61	3069.65	3066.45	3067.91	1250.0
2012-11-27 23:00:00	NQ	Futures	3067.61	3072.26	3067.61	3071.97	407.0
2012-11-27 00:00:00	YM	Futures	12965.7	12966.7	12959.7	12963.7	718.0
2012-11-27 01:00:00	YM	Futures	12962.7	12967.7	12955.7	12965.7	528.0

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

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