PREVIEW / futures_1hour / 2011-12-09

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-09.parquet
  size:    42 KB
  rows:    1,184

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-09 00:00:00	ES	Futures	1241.5	1241.5	1236.24	1237.49	4240.0
2011-12-09 01:00:00	ES	Futures	1237.49	1240.0	1235.74	1236.74	5385.0
2011-12-09 02:00:00	ES	Futures	1236.74	1236.99	1232.23	1234.73	18899.0
2011-12-09 03:00:00	ES	Futures	1234.98	1246.27	1234.73	1245.77	34780.0
2011-12-09 04:00:00	ES	Futures	1245.52	1246.52	1239.75	1242.26	14606.0
2011-12-09 05:00:00	ES	Futures	1242.26	1250.78	1240.5	1250.28	17659.0
2011-12-09 06:00:00	ES	Futures	1250.53	1253.29	1248.02	1252.54	27202.0
2011-12-09 07:00:00	ES	Futures	1252.54	1253.04	1249.03	1249.28	18771.0
2011-12-09 08:00:00	ES	Futures	1249.53	1250.03	1242.76	1244.26	38008.0
2011-12-09 09:00:00	ES	Futures	1244.01	1251.53	1242.0	1249.28	94542.0
2011-12-09 10:00:00	ES	Futures	1249.03	1253.79	1247.77	1252.79	107287.0
2011-12-09 11:00:00	ES	Futures	1252.79	1259.06	1252.54	1255.29	74323.0
2011-12-09 12:00:00	ES	Futures	1255.29	1258.3	1254.04	1256.3	48136.0
2011-12-09 13:00:00	ES	Futures	1256.55	1259.31	1255.55	1257.3	33915.0
2011-12-09 14:00:00	ES	Futures	1257.3	1262.07	1256.3	1260.31	46853.0
2011-12-09 15:00:00	ES	Futures	1260.06	1261.81	1257.3	1258.3	78608.0
2011-12-09 16:00:00	ES	Futures	1258.3	1264.32	1258.3	1263.57	34924.0
2011-12-09 00:00:00	NQ	Futures	2633.83	2633.83	2624.89	2626.62	363.0
2011-12-09 01:00:00	NQ	Futures	2626.62	2631.23	2624.31	2626.04	369.0
2011-12-09 02:00:00	NQ	Futures	2625.75	2625.75	2616.81	2621.43	1080.0
2011-12-09 03:00:00	NQ	Futures	2621.72	2647.67	2621.72	2645.07	2048.0
2011-12-09 04:00:00	NQ	Futures	2645.65	2647.38	2635.27	2639.3	756.0
2011-12-09 05:00:00	NQ	Futures	2638.73	2653.14	2635.84	2652.86	931.0
2011-12-09 06:00:00	NQ	Futures	2652.57	2661.79	2650.26	2659.49	2236.0
2011-12-09 07:00:00	NQ	Futures	2660.35	2661.79	2651.13	2652.28	1609.0
2011-12-09 08:00:00	NQ	Futures	2652.57	2652.57	2637.57	2640.46	2249.0
2011-12-09 09:00:00	NQ	Futures	2640.17	2656.31	2637.57	2649.97	11853.0
2011-12-09 10:00:00	NQ	Futures	2649.97	2664.1	2647.67	2662.66	12039.0
2011-12-09 11:00:00	NQ	Futures	2662.95	2672.75	2662.08	2665.83	6326.0
2011-12-09 12:00:00	NQ	Futures	2666.12	2673.33	2662.95	2671.02	5318.0
2011-12-09 13:00:00	NQ	Futures	2671.02	2678.52	2668.71	2673.9	5208.0
2011-12-09 14:00:00	NQ	Futures	2673.33	2683.13	2671.88	2680.53	5787.0
2011-12-09 15:00:00	NQ	Futures	2680.25	2681.4	2673.61	2674.77	11801.0
2011-12-09 16:00:00	NQ	Futures	2674.77	2683.71	2674.48	2679.96	2552.0
2011-12-09 00:00:00	YM	Futures	11848.2	11848.2	11805.9	11812.8	671.0
2011-12-09 01:00:00	YM	Futures	11810.8	11833.4	11799.0	11805.9	600.0
2011-12-09 02:00:00	YM	Futures	11803.9	11803.9	11772.4	11790.1	1113.0
2011-12-09 03:00:00	YM	Futures	11792.1	11882.7	11790.1	11873.8	1897.0
2011-12-09 04:00:00	YM	Futures	11877.7	11884.6	11835.4	11846.2	1110.0
2011-12-09 05:00:00	YM	Futures	11846.2	11923.0	11836.4	11919.1	1271.0
2011-12-09 06:00:00	YM	Futures	11917.1	11942.7	11904.3	11934.8	1384.0
2011-12-09 07:00:00	YM	Futures	11936.8	11942.7	11908.3	11912.2	767.0
2011-12-09 08:00:00	YM	Futures	11916.1	11916.1	11843.3	11856.1	2864.0
2011-12-09 09:00:00	YM	Futures	11853.1	11980.1	11840.3	11913.2	10106.0
2011-12-09 10:00:00	YM	Futures	11914.2	11949.6	11900.4	11943.7	8982.0
2011-12-09 11:00:00	YM	Futures	11941.7	11991.0	11939.8	11963.4	5242.0
2011-12-09 12:00:00	YM	Futures	11963.4	11981.1	11952.6	11966.3	2425.0
2011-12-09 13:00:00	YM	Futures	11966.3	11990.0	11959.5	11973.2	1933.0
2011-12-09 14:00:00	YM	Futures	11973.2	12018.5	11966.3	12000.8	3751.0
2011-12-09 15:00:00	YM	Futures	11999.8	12011.6	11975.2	11986.0	4972.0

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

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