PREVIEW / futures_1hour / 2012-01-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-13.parquet
  size:    42 KB
  rows:    1,191

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-13 00:00:00	ES	Futures	1302.53	1304.04	1301.52	1303.28	3735.0
2012-01-13 01:00:00	ES	Futures	1303.53	1305.3	1303.28	1304.04	6409.0
2012-01-13 02:00:00	ES	Futures	1304.29	1305.05	1303.28	1303.79	7527.0
2012-01-13 03:00:00	ES	Futures	1303.79	1305.05	1302.78	1303.03	21482.0
2012-01-13 04:00:00	ES	Futures	1302.78	1303.28	1300.51	1303.03	22542.0
2012-01-13 05:00:00	ES	Futures	1303.03	1304.04	1299.5	1301.27	42264.0
2012-01-13 06:00:00	ES	Futures	1301.01	1302.27	1299.75	1300.51	17134.0
2012-01-13 07:00:00	ES	Futures	1300.51	1301.01	1296.98	1297.99	40094.0
2012-01-13 08:00:00	ES	Futures	1298.24	1299.0	1292.7	1293.45	72342.0
2012-01-13 09:00:00	ES	Futures	1293.45	1293.96	1287.91	1290.93	332459.0
2012-01-13 10:00:00	ES	Futures	1290.93	1291.44	1282.87	1288.41	514782.0
2012-01-13 11:00:00	ES	Futures	1288.67	1292.95	1288.16	1290.68	269015.0
2012-01-13 12:00:00	ES	Futures	1290.93	1290.93	1287.15	1289.67	156278.0
2012-01-13 13:00:00	ES	Futures	1289.42	1290.93	1285.89	1289.67	114054.0
2012-01-13 14:00:00	ES	Futures	1289.67	1291.94	1288.67	1291.44	106538.0
2012-01-13 15:00:00	ES	Futures	1291.44	1295.47	1291.44	1295.47	266202.0
2012-01-13 16:00:00	ES	Futures	1295.47	1300.01	1294.97	1299.75	93133.0
2012-01-13 00:00:00	NQ	Futures	2750.23	2753.98	2749.36	2752.83	288.0
2012-01-13 01:00:00	NQ	Futures	2753.11	2756.0	2753.11	2754.56	459.0
2012-01-13 02:00:00	NQ	Futures	2754.56	2755.43	2753.11	2754.85	813.0
2012-01-13 03:00:00	NQ	Futures	2754.85	2757.16	2753.11	2753.98	1373.0
2012-01-13 04:00:00	NQ	Futures	2753.69	2753.69	2748.78	2752.83	1056.0
2012-01-13 05:00:00	NQ	Futures	2752.54	2755.71	2746.47	2749.65	1887.0
2012-01-13 06:00:00	NQ	Futures	2749.07	2751.38	2746.47	2747.63	1089.0
2012-01-13 07:00:00	NQ	Futures	2747.92	2749.65	2743.3	2745.89	2379.0
2012-01-13 08:00:00	NQ	Futures	2745.89	2747.63	2737.23	2737.81	6147.0
2012-01-13 09:00:00	NQ	Futures	2737.52	2738.39	2723.37	2732.9	34304.0
2012-01-13 10:00:00	NQ	Futures	2732.9	2732.9	2712.97	2723.66	50437.0
2012-01-13 11:00:00	NQ	Futures	2723.66	2733.48	2722.5	2729.72	22152.0
2012-01-13 12:00:00	NQ	Futures	2730.01	2730.01	2723.95	2727.7	16241.0
2012-01-13 13:00:00	NQ	Futures	2727.41	2730.01	2721.35	2727.12	14683.0
2012-01-13 14:00:00	NQ	Futures	2727.12	2733.19	2725.68	2730.3	12779.0
2012-01-13 15:00:00	NQ	Futures	2730.3	2737.23	2730.01	2736.94	24278.0
2012-01-13 16:00:00	NQ	Futures	2736.94	2743.58	2736.65	2743.3	6677.0
2012-01-13 00:00:00	YM	Futures	12303.0	12317.8	12298.0	12312.9	255.0
2012-01-13 01:00:00	YM	Futures	12313.9	12329.7	12313.9	12319.8	467.0
2012-01-13 02:00:00	YM	Futures	12321.8	12327.7	12314.9	12319.8	764.0
2012-01-13 03:00:00	YM	Futures	12317.8	12329.7	12308.9	12312.9	1712.0
2012-01-13 04:00:00	YM	Futures	12311.9	12311.9	12291.1	12307.9	1545.0
2012-01-13 05:00:00	YM	Futures	12307.9	12321.8	12282.1	12297.0	2476.0
2012-01-13 06:00:00	YM	Futures	12298.0	12308.9	12287.1	12293.1	1332.0
2012-01-13 07:00:00	YM	Futures	12293.1	12297.0	12271.2	12278.2	1900.0
2012-01-13 08:00:00	YM	Futures	12278.2	12290.1	12241.5	12244.5	3431.0
2012-01-13 09:00:00	YM	Futures	12244.5	12245.5	12172.1	12201.9	23530.0
2012-01-13 10:00:00	YM	Futures	12200.9	12205.8	12139.4	12185.0	25378.0
2012-01-13 11:00:00	YM	Futures	12185.0	12226.6	12181.1	12209.8	11100.0
2012-01-13 12:00:00	YM	Futures	12209.8	12209.8	12180.1	12199.9	7499.0
2012-01-13 13:00:00	YM	Futures	12199.9	12207.8	12169.2	12201.9	5795.0
2012-01-13 14:00:00	YM	Futures	12201.9	12220.7	12194.9	12217.7	5532.0
2012-01-13 15:00:00	YM	Futures	12217.7	12256.4	12216.7	12254.4	14373.0

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

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