PREVIEW / futures_1hour / 2011-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-04.parquet
  size:    40 KB
  rows:    1,177

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-02-04 00:00:00	ES	Futures	1290.83	1291.57	1290.58	1290.83	2499.0
2011-02-04 01:00:00	ES	Futures	1291.07	1291.07	1289.59	1290.08	3601.0
2011-02-04 02:00:00	ES	Futures	1290.33	1290.58	1289.34	1289.34	3895.0
2011-02-04 03:00:00	ES	Futures	1289.1	1289.84	1288.35	1289.1	9869.0
2011-02-04 04:00:00	ES	Futures	1289.34	1290.83	1288.85	1290.33	7450.0
2011-02-04 05:00:00	ES	Futures	1290.58	1291.07	1289.84	1289.84	6942.0
2011-02-04 06:00:00	ES	Futures	1290.08	1290.83	1289.59	1290.08	4898.0
2011-02-04 07:00:00	ES	Futures	1290.08	1291.57	1289.84	1291.32	15638.0
2011-02-04 08:00:00	ES	Futures	1291.07	1295.03	1287.36	1291.32	168376.0
2011-02-04 09:00:00	ES	Futures	1291.32	1292.81	1286.62	1290.33	276141.0
2011-02-04 10:00:00	ES	Futures	1290.08	1292.56	1285.14	1286.87	313611.0
2011-02-04 11:00:00	ES	Futures	1286.62	1290.08	1284.64	1288.35	200694.0
2011-02-04 12:00:00	ES	Futures	1288.35	1290.58	1287.36	1290.33	70362.0
2011-02-04 13:00:00	ES	Futures	1290.08	1292.56	1289.59	1292.06	100026.0
2011-02-04 14:00:00	ES	Futures	1292.06	1292.31	1290.33	1292.31	85967.0
2011-02-04 15:00:00	ES	Futures	1292.06	1294.54	1291.07	1293.8	192237.0
2011-02-04 16:00:00	ES	Futures	1294.04	1294.79	1293.55	1294.04	96127.0
2011-02-04 00:00:00	NQ	Futures	2667.97	2669.98	2667.97	2668.25	133.0
2011-02-04 01:00:00	NQ	Futures	2668.25	2668.54	2665.96	2666.82	236.0
2011-02-04 02:00:00	NQ	Futures	2666.53	2667.68	2665.67	2665.67	155.0
2011-02-04 03:00:00	NQ	Futures	2665.67	2666.53	2663.95	2665.38	408.0
2011-02-04 04:00:00	NQ	Futures	2665.67	2667.39	2664.81	2667.11	495.0
2011-02-04 05:00:00	NQ	Futures	2667.11	2668.25	2665.96	2666.24	567.0
2011-02-04 06:00:00	NQ	Futures	2666.24	2667.11	2665.38	2665.96	284.0
2011-02-04 07:00:00	NQ	Futures	2666.24	2669.98	2665.96	2668.83	862.0
2011-02-04 08:00:00	NQ	Futures	2668.54	2686.05	2662.8	2667.68	18417.0
2011-02-04 09:00:00	NQ	Futures	2668.25	2672.56	2659.64	2670.55	52540.0
2011-02-04 10:00:00	NQ	Futures	2670.26	2675.72	2661.65	2665.1	41546.0
2011-02-04 11:00:00	NQ	Futures	2665.1	2669.98	2660.79	2667.97	19623.0
2011-02-04 12:00:00	NQ	Futures	2667.97	2675.14	2667.11	2674.28	9668.0
2011-02-04 13:00:00	NQ	Futures	2674.57	2683.47	2672.85	2681.74	23446.0
2011-02-04 14:00:00	NQ	Futures	2682.03	2682.32	2677.73	2680.88	10453.0
2011-02-04 15:00:00	NQ	Futures	2680.88	2684.04	2678.87	2681.74	35658.0
2011-02-04 16:00:00	NQ	Futures	2681.46	2684.61	2681.17	2682.61	7780.0
2011-02-04 00:00:00	YM	Futures	11514.5	11520.2	11514.5	11516.4	105.0
2011-02-04 01:00:00	YM	Futures	11515.4	11516.4	11507.8	11513.5	127.0
2011-02-04 02:00:00	YM	Futures	11511.6	11517.3	11505.8	11505.8	645.0
2011-02-04 03:00:00	YM	Futures	11505.8	11507.8	11500.1	11503.9	941.0
2011-02-04 04:00:00	YM	Futures	11505.8	11516.4	11504.9	11514.5	438.0
2011-02-04 05:00:00	YM	Futures	11513.5	11517.3	11510.6	11511.6	125.0
2011-02-04 06:00:00	YM	Futures	11510.6	11516.4	11508.7	11510.6	241.0
2011-02-04 07:00:00	YM	Futures	11511.6	11521.2	11510.6	11519.2	446.0
2011-02-04 08:00:00	YM	Futures	11519.2	11544.2	11489.6	11515.4	6708.0
2011-02-04 09:00:00	YM	Futures	11515.4	11522.1	11485.7	11504.9	13550.0
2011-02-04 10:00:00	YM	Futures	11504.9	11525.0	11477.1	11487.6	16142.0
2011-02-04 11:00:00	YM	Futures	11487.6	11506.8	11474.2	11496.3	11440.0
2011-02-04 12:00:00	YM	Futures	11495.3	11509.7	11489.6	11508.7	3257.0
2011-02-04 13:00:00	YM	Futures	11508.7	11520.2	11505.8	11515.4	4902.0
2011-02-04 14:00:00	YM	Futures	11516.4	11522.1	11505.8	11521.2	4938.0
2011-02-04 15:00:00	YM	Futures	11521.2	11535.5	11513.5	11534.6	12139.0

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

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