PREVIEW / futures_1hour / 2012-01-11

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-11.parquet
  size:    48 KB
  rows:    1,476

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-01-11 00:00:00	ES	Futures	1292.7	1294.21	1292.45	1292.95	3516.0
2012-01-11 01:00:00	ES	Futures	1292.95	1294.97	1292.95	1294.21	3070.0
2012-01-11 02:00:00	ES	Futures	1294.46	1295.72	1293.96	1294.97	4677.0
2012-01-11 03:00:00	ES	Futures	1294.97	1297.49	1294.21	1295.97	25400.0
2012-01-11 04:00:00	ES	Futures	1295.97	1297.99	1295.22	1297.49	21084.0
2012-01-11 05:00:00	ES	Futures	1297.49	1297.99	1295.72	1296.23	13228.0
2012-01-11 06:00:00	ES	Futures	1295.97	1296.98	1291.44	1292.19	34770.0
2012-01-11 07:00:00	ES	Futures	1292.19	1295.22	1289.42	1293.45	46288.0
2012-01-11 08:00:00	ES	Futures	1293.71	1294.71	1290.68	1293.2	72897.0
2012-01-11 09:00:00	ES	Futures	1292.95	1296.48	1291.44	1292.19	228035.0
2012-01-11 10:00:00	ES	Futures	1291.94	1297.23	1290.93	1293.71	320664.0
2012-01-11 11:00:00	ES	Futures	1293.71	1296.23	1292.19	1294.46	237656.0
2012-01-11 12:00:00	ES	Futures	1294.46	1296.48	1293.2	1295.47	162220.0
2012-01-11 13:00:00	ES	Futures	1295.22	1298.24	1295.22	1296.23	134115.0
2012-01-11 14:00:00	ES	Futures	1296.23	1297.49	1294.21	1295.97	204614.0
2012-01-11 15:00:00	ES	Futures	1295.97	1299.75	1295.72	1298.49	180930.0
2012-01-11 16:00:00	ES	Futures	1298.49	1299.0	1297.74	1298.49	62454.0
2012-01-11 17:00:00	ES	Futures	1298.49	1298.75	1297.49	1298.49	2074.0
2012-01-11 18:00:00	ES	Futures	1298.49	1299.0	1297.74	1297.99	2633.0
2012-01-11 19:00:00	ES	Futures	1297.74	1297.99	1296.73	1297.23	5742.0
2012-01-11 20:00:00	ES	Futures	1296.98	1297.74	1295.97	1296.98	5509.0
2012-01-11 21:00:00	ES	Futures	1296.98	1298.24	1296.98	1296.98	5412.0
2012-01-11 22:00:00	ES	Futures	1296.98	1297.49	1296.23	1296.73	3008.0
2012-01-11 23:00:00	ES	Futures	1296.73	1296.98	1296.23	1296.48	2515.0
2012-01-11 00:00:00	NQ	Futures	2720.48	2723.95	2719.9	2723.37	509.0
2012-01-11 01:00:00	NQ	Futures	2723.37	2725.97	2723.37	2725.1	288.0
2012-01-11 02:00:00	NQ	Futures	2725.39	2728.28	2724.52	2727.12	638.0
2012-01-11 03:00:00	NQ	Futures	2727.12	2731.45	2725.68	2728.57	1418.0
2012-01-11 04:00:00	NQ	Futures	2728.57	2732.03	2726.83	2731.45	778.0
2012-01-11 05:00:00	NQ	Futures	2731.45	2732.32	2727.7	2728.28	1108.0
2012-01-11 06:00:00	NQ	Futures	2728.57	2730.3	2721.06	2723.37	2911.0
2012-01-11 07:00:00	NQ	Futures	2722.79	2729.14	2717.59	2725.39	2915.0
2012-01-11 08:00:00	NQ	Futures	2725.68	2727.7	2719.9	2726.55	10154.0
2012-01-11 09:00:00	NQ	Futures	2726.26	2736.36	2722.21	2722.79	31676.0
2012-01-11 10:00:00	NQ	Futures	2722.79	2738.96	2719.61	2733.19	30843.0
2012-01-11 11:00:00	NQ	Futures	2733.19	2738.96	2729.14	2733.77	20876.0
2012-01-11 12:00:00	NQ	Futures	2733.77	2736.65	2730.88	2733.19	12583.0
2012-01-11 13:00:00	NQ	Futures	2733.48	2740.12	2730.88	2732.32	13260.0
2012-01-11 14:00:00	NQ	Futures	2732.32	2738.96	2732.32	2736.65	16644.0
2012-01-11 15:00:00	NQ	Futures	2736.94	2741.56	2735.5	2735.79	17082.0
2012-01-11 16:00:00	NQ	Futures	2735.79	2736.36	2733.48	2734.34	5738.0
2012-01-11 17:00:00	NQ	Futures	2734.34	2735.21	2733.48	2734.92	117.0
2012-01-11 18:00:00	NQ	Futures	2734.34	2735.79	2734.34	2734.63	168.0
2012-01-11 19:00:00	NQ	Futures	2734.63	2734.63	2732.61	2733.48	296.0
2012-01-11 20:00:00	NQ	Futures	2733.48	2734.05	2730.88	2732.61	237.0
2012-01-11 21:00:00	NQ	Futures	2733.19	2735.21	2732.61	2733.48	291.0
2012-01-11 22:00:00	NQ	Futures	2733.48	2734.05	2730.88	2732.32	163.0
2012-01-11 23:00:00	NQ	Futures	2732.03	2732.61	2730.59	2732.03	126.0
2012-01-11 00:00:00	YM	Futures	12249.4	12258.4	12247.5	12254.4	348.0
2012-01-11 01:00:00	YM	Futures	12253.4	12268.3	12253.4	12264.3	248.0

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

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