PREVIEW / futures_1hour / 2012-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-16.parquet
  size:    47 KB
  rows:    1,447

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-08-16 00:00:00	ES	Futures	1430.09	1430.85	1429.33	1429.84	4587.0
2012-08-16 01:00:00	ES	Futures	1429.84	1431.87	1429.58	1431.62	5396.0
2012-08-16 02:00:00	ES	Futures	1431.36	1431.62	1428.06	1428.82	8309.0
2012-08-16 03:00:00	ES	Futures	1428.56	1429.07	1427.04	1427.55	20010.0
2012-08-16 04:00:00	ES	Futures	1427.55	1429.58	1427.29	1428.56	15477.0
2012-08-16 05:00:00	ES	Futures	1428.31	1429.07	1428.06	1428.82	10135.0
2012-08-16 06:00:00	ES	Futures	1428.56	1429.33	1427.55	1429.33	10120.0
2012-08-16 07:00:00	ES	Futures	1429.33	1430.6	1429.07	1429.58	20653.0
2012-08-16 08:00:00	ES	Futures	1429.58	1431.87	1429.33	1430.09	45103.0
2012-08-16 09:00:00	ES	Futures	1430.09	1430.85	1426.78	1427.55	146059.0
2012-08-16 10:00:00	ES	Futures	1427.55	1432.12	1425.77	1431.36	263192.0
2012-08-16 11:00:00	ES	Futures	1431.36	1435.68	1430.6	1434.92	258081.0
2012-08-16 12:00:00	ES	Futures	1434.92	1436.45	1434.16	1435.94	96386.0
2012-08-16 13:00:00	ES	Futures	1435.94	1437.21	1435.43	1436.19	88064.0
2012-08-16 14:00:00	ES	Futures	1436.45	1439.75	1435.94	1438.23	172462.0
2012-08-16 15:00:00	ES	Futures	1438.23	1439.75	1436.19	1437.97	210751.0
2012-08-16 16:00:00	ES	Futures	1437.97	1439.24	1436.7	1438.23	85845.0
2012-08-16 17:00:00	ES	Futures	1438.23	1438.48	1437.97	1438.23	1180.0
2012-08-16 18:00:00	ES	Futures	1437.72	1438.23	1437.72	1437.97	1721.0
2012-08-16 19:00:00	ES	Futures	1437.97	1438.23	1437.46	1437.97	1785.0
2012-08-16 20:00:00	ES	Futures	1437.97	1437.97	1436.19	1436.19	5192.0
2012-08-16 21:00:00	ES	Futures	1436.45	1438.23	1436.19	1436.45	5590.0
2012-08-16 22:00:00	ES	Futures	1436.45	1437.46	1436.19	1436.7	3272.0
2012-08-16 23:00:00	ES	Futures	1436.7	1436.96	1436.19	1436.7	2018.0
2012-08-16 00:00:00	NQ	Futures	3184.39	3185.55	3182.65	3183.52	480.0
2012-08-16 01:00:00	NQ	Futures	3183.23	3187.0	3182.65	3187.0	431.0
2012-08-16 02:00:00	NQ	Futures	3187.0	3187.0	3179.46	3181.2	1062.0
2012-08-16 03:00:00	NQ	Futures	3181.49	3181.49	3175.11	3176.27	2579.0
2012-08-16 04:00:00	NQ	Futures	3176.27	3180.33	3175.69	3178.01	1405.0
2012-08-16 05:00:00	NQ	Futures	3177.72	3179.17	3176.27	3177.72	839.0
2012-08-16 06:00:00	NQ	Futures	3177.72	3178.59	3175.4	3178.3	915.0
2012-08-16 07:00:00	NQ	Futures	3178.3	3181.78	3178.3	3181.78	2265.0
2012-08-16 08:00:00	NQ	Futures	3181.78	3187.86	3181.49	3182.65	4911.0
2012-08-16 09:00:00	NQ	Futures	3182.65	3186.42	3180.33	3183.23	24492.0
2012-08-16 10:00:00	NQ	Futures	3183.23	3195.98	3179.17	3193.95	37187.0
2012-08-16 11:00:00	NQ	Futures	3193.95	3204.97	3192.5	3203.23	25267.0
2012-08-16 12:00:00	NQ	Futures	3203.52	3206.42	3201.2	3205.26	14093.0
2012-08-16 13:00:00	NQ	Futures	3205.26	3207.29	3202.07	3205.26	14337.0
2012-08-16 14:00:00	NQ	Futures	3205.26	3215.69	3204.1	3214.24	33420.0
2012-08-16 15:00:00	NQ	Futures	3214.53	3216.56	3207.87	3209.03	29074.0
2012-08-16 16:00:00	NQ	Futures	3209.03	3210.19	3204.68	3208.16	12642.0
2012-08-16 17:00:00	NQ	Futures	3208.16	3208.45	3207.87	3208.16	150.0
2012-08-16 18:00:00	NQ	Futures	3207.87	3208.45	3207.29	3207.58	137.0
2012-08-16 19:00:00	NQ	Futures	3207.87	3209.03	3207.0	3207.87	165.0
2012-08-16 20:00:00	NQ	Futures	3207.87	3207.87	3204.39	3204.39	452.0
2012-08-16 21:00:00	NQ	Futures	3204.39	3208.16	3204.1	3204.68	684.0
2012-08-16 22:00:00	NQ	Futures	3204.97	3207.87	3204.39	3206.42	518.0
2012-08-16 23:00:00	NQ	Futures	3206.71	3206.71	3205.26	3205.55	259.0
2012-08-16 00:00:00	YM	Futures	13084.4	13091.3	13079.4	13083.4	454.0
2012-08-16 01:00:00	YM	Futures	13082.4	13097.3	13080.4	13095.3	610.0

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

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