PREVIEW / futures_1hour / 2011-01-13

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-13.parquet
  size:    49 KB
  rows:    1,488

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-01-13 00:00:00	ES	Futures	1268.81	1269.55	1268.81	1269.3	1395.0
2011-01-13 01:00:00	ES	Futures	1269.3	1269.3	1268.56	1269.05	1200.0
2011-01-13 02:00:00	ES	Futures	1268.81	1270.79	1268.56	1269.3	7969.0
2011-01-13 03:00:00	ES	Futures	1269.3	1270.54	1267.82	1268.56	25745.0
2011-01-13 04:00:00	ES	Futures	1268.31	1270.29	1268.31	1269.3	15712.0
2011-01-13 05:00:00	ES	Futures	1269.05	1269.55	1267.57	1268.56	19633.0
2011-01-13 06:00:00	ES	Futures	1268.56	1270.04	1268.31	1269.8	10366.0
2011-01-13 07:00:00	ES	Futures	1270.04	1271.28	1269.05	1270.54	18686.0
2011-01-13 08:00:00	ES	Futures	1270.54	1271.28	1267.07	1267.32	67491.0
2011-01-13 09:00:00	ES	Futures	1267.57	1269.55	1266.83	1268.06	174522.0
2011-01-13 10:00:00	ES	Futures	1268.31	1268.56	1264.6	1267.82	272005.0
2011-01-13 11:00:00	ES	Futures	1267.82	1269.8	1267.07	1268.56	162218.0
2011-01-13 12:00:00	ES	Futures	1268.56	1269.8	1267.57	1268.06	104173.0
2011-01-13 13:00:00	ES	Futures	1268.06	1269.3	1266.83	1267.57	144127.0
2011-01-13 14:00:00	ES	Futures	1267.57	1268.06	1264.1	1264.85	229236.0
2011-01-13 15:00:00	ES	Futures	1264.6	1267.07	1263.12	1266.83	285276.0
2011-01-13 16:00:00	ES	Futures	1267.07	1269.55	1266.83	1269.05	120672.0
2011-01-13 17:00:00	ES	Futures	1269.05	1271.03	1269.05	1270.79	5913.0
2011-01-13 18:00:00	ES	Futures	1270.79	1270.79	1269.3	1269.55	5910.0
2011-01-13 19:00:00	ES	Futures	1269.8	1269.8	1268.56	1269.05	3819.0
2011-01-13 20:00:00	ES	Futures	1269.05	1269.8	1268.56	1268.81	2925.0
2011-01-13 21:00:00	ES	Futures	1268.81	1269.8	1268.31	1268.56	3014.0
2011-01-13 22:00:00	ES	Futures	1268.56	1269.05	1268.31	1268.56	1766.0
2011-01-13 23:00:00	ES	Futures	1268.31	1268.56	1267.57	1268.31	1864.0
2011-01-13 00:00:00	NQ	Futures	2645.0	2645.29	2643.86	2645.29	64.0
2011-01-13 01:00:00	NQ	Futures	2645.0	2645.29	2643.28	2644.43	104.0
2011-01-13 02:00:00	NQ	Futures	2645.0	2648.16	2644.14	2645.58	459.0
2011-01-13 03:00:00	NQ	Futures	2646.15	2648.16	2641.56	2643.28	1842.0
2011-01-13 04:00:00	NQ	Futures	2643.86	2645.87	2642.99	2644.43	1063.0
2011-01-13 05:00:00	NQ	Futures	2644.72	2646.15	2642.13	2643.28	1469.0
2011-01-13 06:00:00	NQ	Futures	2643.57	2647.59	2643.57	2645.87	1060.0
2011-01-13 07:00:00	NQ	Futures	2645.58	2649.6	2644.72	2648.45	1690.0
2011-01-13 08:00:00	NQ	Futures	2648.45	2649.31	2641.27	2641.85	6125.0
2011-01-13 09:00:00	NQ	Futures	2642.13	2645.87	2638.4	2643.57	29094.0
2011-01-13 10:00:00	NQ	Futures	2643.57	2650.74	2640.12	2649.31	35248.0
2011-01-13 11:00:00	NQ	Futures	2649.31	2651.61	2646.44	2646.44	17601.0
2011-01-13 12:00:00	NQ	Futures	2646.44	2650.46	2646.44	2647.59	9753.0
2011-01-13 13:00:00	NQ	Futures	2647.59	2650.17	2645.0	2646.73	14614.0
2011-01-13 14:00:00	NQ	Futures	2646.73	2647.87	2639.26	2640.12	23978.0
2011-01-13 15:00:00	NQ	Futures	2640.41	2645.58	2636.97	2645.29	31762.0
2011-01-13 16:00:00	NQ	Futures	2645.58	2650.46	2644.43	2649.88	9919.0
2011-01-13 17:00:00	NQ	Futures	2649.88	2653.04	2649.6	2652.47	2069.0
2011-01-13 18:00:00	NQ	Futures	2652.18	2652.18	2650.74	2650.74	637.0
2011-01-13 19:00:00	NQ	Futures	2650.74	2650.74	2648.74	2649.88	297.0
2011-01-13 20:00:00	NQ	Futures	2649.6	2650.74	2648.45	2648.74	269.0
2011-01-13 21:00:00	NQ	Futures	2648.74	2651.32	2648.74	2649.6	382.0
2011-01-13 22:00:00	NQ	Futures	2649.31	2650.46	2649.02	2649.31	119.0
2011-01-13 23:00:00	NQ	Futures	2649.02	2650.17	2647.87	2650.17	212.0
2011-01-13 00:00:00	YM	Futures	11206.1	11210.8	11206.1	11208.9	122.0
2011-01-13 01:00:00	YM	Futures	11208.9	11208.9	11201.3	11202.2	89.0

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

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