PREVIEW / futures_1hour / 2012-12-11

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-11.parquet
  size:    45 KB
  rows:    1,413

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-12-11 00:00:00	ES	Futures	1448.73	1449.25	1447.97	1448.48	2277.0
2012-12-11 01:00:00	ES	Futures	1448.73	1449.25	1448.22	1448.99	2587.0
2012-12-11 02:00:00	ES	Futures	1448.99	1449.25	1447.71	1448.73	5634.0
2012-12-11 03:00:00	ES	Futures	1448.73	1450.01	1447.46	1449.25	15306.0
2012-12-11 04:00:00	ES	Futures	1449.5	1453.08	1449.25	1452.82	18265.0
2012-12-11 05:00:00	ES	Futures	1452.82	1454.87	1452.57	1453.33	26787.0
2012-12-11 06:00:00	ES	Futures	1453.08	1454.61	1453.08	1454.61	17909.0
2012-12-11 07:00:00	ES	Futures	1454.61	1455.89	1453.33	1455.12	25482.0
2012-12-11 08:00:00	ES	Futures	1454.87	1455.63	1453.84	1454.87	32372.0
2012-12-11 09:00:00	ES	Futures	1454.61	1458.95	1453.84	1458.95	185817.0
2012-12-11 10:00:00	ES	Futures	1458.95	1462.53	1458.7	1460.74	263119.0
2012-12-11 11:00:00	ES	Futures	1461.0	1465.6	1460.23	1462.27	276224.0
2012-12-11 12:00:00	ES	Futures	1462.53	1464.06	1459.46	1462.27	169652.0
2012-12-11 13:00:00	ES	Futures	1462.27	1463.04	1461.25	1462.02	64743.0
2012-12-11 14:00:00	ES	Futures	1462.02	1462.79	1457.93	1458.7	122504.0
2012-12-11 15:00:00	ES	Futures	1458.7	1459.46	1454.35	1458.44	281556.0
2012-12-11 16:00:00	ES	Futures	1458.44	1463.81	1457.68	1463.55	117049.0
2012-12-11 17:00:00	ES	Futures	1463.3	1463.3	1462.53	1463.3	1899.0
2012-12-11 18:00:00	ES	Futures	1462.53	1462.79	1461.25	1462.27	4264.0
2012-12-11 19:00:00	ES	Futures	1462.27	1462.53	1460.74	1461.51	7194.0
2012-12-11 20:00:00	ES	Futures	1461.51	1462.53	1460.74	1462.27	4512.0
2012-12-11 21:00:00	ES	Futures	1462.27	1463.3	1461.25	1461.51	3697.0
2012-12-11 22:00:00	ES	Futures	1461.51	1461.76	1460.74	1461.0	2369.0
2012-12-11 23:00:00	ES	Futures	1461.0	1461.25	1460.49	1460.74	2199.0
2012-12-11 00:00:00	NQ	Futures	3078.95	3079.53	3076.91	3078.66	212.0
2012-12-11 01:00:00	NQ	Futures	3078.66	3079.24	3076.91	3078.37	259.0
2012-12-11 02:00:00	NQ	Futures	3078.37	3079.53	3076.04	3077.49	553.0
2012-12-11 03:00:00	NQ	Futures	3077.49	3080.69	3074.88	3078.66	2056.0
2012-12-11 04:00:00	NQ	Futures	3078.95	3086.21	3078.66	3085.63	2001.0
2012-12-11 05:00:00	NQ	Futures	3085.92	3088.54	3084.47	3084.76	2915.0
2012-12-11 06:00:00	NQ	Futures	3085.05	3088.25	3085.05	3087.66	1959.0
2012-12-11 07:00:00	NQ	Futures	3087.96	3091.15	3085.92	3090.28	2344.0
2012-12-11 08:00:00	NQ	Futures	3090.28	3095.51	3088.83	3093.19	4545.0
2012-12-11 09:00:00	NQ	Futures	3092.9	3115.56	3092.02	3114.4	42704.0
2012-12-11 10:00:00	NQ	Futures	3114.4	3127.47	3111.2	3123.12	47566.0
2012-12-11 11:00:00	NQ	Futures	3123.41	3134.16	3122.82	3124.28	35517.0
2012-12-11 12:00:00	NQ	Futures	3124.57	3130.09	3118.76	3126.89	25386.0
2012-12-11 13:00:00	NQ	Futures	3126.89	3128.05	3122.53	3127.18	12509.0
2012-12-11 14:00:00	NQ	Futures	3127.18	3130.09	3116.43	3118.76	20548.0
2012-12-11 15:00:00	NQ	Futures	3118.76	3120.79	3107.13	3116.72	49995.0
2012-12-11 16:00:00	NQ	Futures	3116.43	3124.86	3114.11	3124.28	9034.0
2012-12-11 17:00:00	NQ	Futures	3124.28	3124.57	3121.95	3122.82	179.0
2012-12-11 18:00:00	NQ	Futures	3122.24	3123.12	3119.63	3122.24	657.0
2012-12-11 19:00:00	NQ	Futures	3122.53	3123.12	3120.21	3121.66	923.0
2012-12-11 20:00:00	NQ	Futures	3121.66	3123.7	3120.21	3122.53	546.0
2012-12-11 21:00:00	NQ	Futures	3123.41	3124.57	3121.37	3121.95	421.0
2012-12-11 22:00:00	NQ	Futures	3121.66	3121.95	3120.21	3120.79	295.0
2012-12-11 23:00:00	NQ	Futures	3120.21	3121.08	3119.34	3119.92	184.0
2012-12-11 00:00:00	YM	Futures	13184.0	13184.0	13176.9	13179.9	12.0
2012-12-11 01:00:00	YM	Futures	13185.0	13185.0	13180.9	13180.9	10.0

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

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