PREVIEW / futures_1hour / 2011-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-23.parquet
  size:    37 KB
  rows:    1,086

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
2011-12-23 00:00:00	ES	Futures	1265.48	1266.24	1265.23	1265.74	1530.0
2011-12-23 01:00:00	ES	Futures	1265.74	1267.5	1265.74	1266.74	2916.0
2011-12-23 02:00:00	ES	Futures	1266.49	1267.5	1264.98	1267.25	9101.0
2011-12-23 03:00:00	ES	Futures	1267.0	1267.5	1263.22	1263.72	17525.0
2011-12-23 04:00:00	ES	Futures	1263.47	1263.97	1262.21	1263.47	10738.0
2011-12-23 05:00:00	ES	Futures	1263.47	1264.98	1262.96	1263.97	7517.0
2011-12-23 06:00:00	ES	Futures	1264.22	1265.48	1263.47	1264.73	8286.0
2011-12-23 07:00:00	ES	Futures	1264.98	1266.49	1264.73	1265.74	11602.0
2011-12-23 08:00:00	ES	Futures	1265.74	1267.25	1262.71	1263.47	33257.0
2011-12-23 09:00:00	ES	Futures	1263.47	1263.72	1259.69	1262.21	112999.0
2011-12-23 10:00:00	ES	Futures	1262.71	1263.97	1261.2	1262.96	100662.0
2011-12-23 11:00:00	ES	Futures	1262.96	1266.49	1262.71	1266.24	87617.0
2011-12-23 12:00:00	ES	Futures	1266.24	1268.51	1265.48	1267.75	47618.0
2011-12-23 13:00:00	ES	Futures	1267.75	1268.0	1265.99	1267.0	29346.0
2011-12-23 14:00:00	ES	Futures	1266.74	1267.0	1265.99	1266.24	18598.0
2011-12-23 15:00:00	ES	Futures	1266.24	1270.27	1265.48	1269.52	99565.0
2011-12-23 16:00:00	ES	Futures	1269.52	1270.78	1268.76	1269.52	60120.0
2011-12-23 00:00:00	NQ	Futures	2624.02	2625.18	2623.44	2624.02	76.0
2011-12-23 01:00:00	NQ	Futures	2624.31	2626.62	2623.73	2626.04	198.0
2011-12-23 02:00:00	NQ	Futures	2625.47	2627.78	2621.71	2626.91	538.0
2011-12-23 03:00:00	NQ	Futures	2626.91	2627.78	2617.09	2617.09	1966.0
2011-12-23 04:00:00	NQ	Futures	2617.09	2618.82	2615.65	2617.67	993.0
2011-12-23 05:00:00	NQ	Futures	2617.96	2619.69	2617.09	2619.69	450.0
2011-12-23 06:00:00	NQ	Futures	2619.4	2621.71	2617.96	2620.27	500.0
2011-12-23 07:00:00	NQ	Futures	2620.27	2623.44	2620.27	2622.29	518.0
2011-12-23 08:00:00	NQ	Futures	2622.29	2625.18	2617.67	2619.11	2588.0
2011-12-23 09:00:00	NQ	Futures	2619.11	2623.44	2616.51	2622.0	13845.0
2011-12-23 10:00:00	NQ	Futures	2622.58	2624.02	2613.05	2618.53	11439.0
2011-12-23 11:00:00	NQ	Futures	2618.53	2627.2	2617.96	2626.91	7986.0
2011-12-23 12:00:00	NQ	Futures	2626.62	2633.55	2625.75	2633.26	7787.0
2011-12-23 13:00:00	NQ	Futures	2633.55	2633.55	2629.22	2632.4	4438.0
2011-12-23 14:00:00	NQ	Futures	2632.69	2632.97	2628.93	2629.22	2966.0
2011-12-23 15:00:00	NQ	Futures	2629.22	2636.73	2627.78	2635.86	10413.0
2011-12-23 16:00:00	NQ	Futures	2635.86	2637.6	2633.26	2633.26	4106.0
2011-12-23 00:00:00	YM	Futures	12044.3	12048.2	12041.3	12046.3	108.0
2011-12-23 01:00:00	YM	Futures	12047.3	12065.1	12047.3	12058.2	362.0
2011-12-23 02:00:00	YM	Futures	12054.2	12069.1	12039.3	12059.1	1262.0
2011-12-23 03:00:00	YM	Futures	12060.1	12064.1	12030.4	12032.4	1270.0
2011-12-23 04:00:00	YM	Futures	12032.4	12035.4	12018.5	12029.4	834.0
2011-12-23 05:00:00	YM	Futures	12031.4	12041.3	12025.4	12038.3	773.0
2011-12-23 06:00:00	YM	Futures	12038.3	12047.3	12034.4	12041.3	386.0
2011-12-23 07:00:00	YM	Futures	12040.3	12055.2	12040.3	12049.2	638.0
2011-12-23 08:00:00	YM	Futures	12052.2	12056.2	12022.5	12028.4	1578.0
2011-12-23 09:00:00	YM	Futures	12028.4	12039.3	11999.7	12025.4	6631.0
2011-12-23 10:00:00	YM	Futures	12025.4	12044.3	12015.5	12036.3	6781.0
2011-12-23 11:00:00	YM	Futures	12036.3	12070.0	12036.3	12068.1	5332.0
2011-12-23 12:00:00	YM	Futures	12067.1	12092.8	12062.1	12085.9	3925.0
2011-12-23 13:00:00	YM	Futures	12086.9	12087.9	12075.0	12083.9	2266.0
2011-12-23 14:00:00	YM	Futures	12082.9	12084.9	12076.0	12076.0	1294.0
2011-12-23 15:00:00	YM	Futures	12075.0	12117.6	12072.0	12108.7	3955.0

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

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