PREVIEW / futures_1hour / 2011-10-24

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-24.parquet
  size:    48 KB
  rows:    1,434

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-10-24 00:00:00	ES	Futures	1244.76	1244.76	1240.25	1242.26	7302.0
2011-10-24 01:00:00	ES	Futures	1242.0	1244.26	1241.5	1244.26	5827.0
2011-10-24 02:00:00	ES	Futures	1244.01	1246.52	1243.01	1244.51	13046.0
2011-10-24 03:00:00	ES	Futures	1244.51	1245.26	1241.0	1242.0	38326.0
2011-10-24 04:00:00	ES	Futures	1242.0	1245.77	1238.24	1239.25	34392.0
2011-10-24 05:00:00	ES	Futures	1239.0	1242.76	1238.24	1242.26	24414.0
2011-10-24 06:00:00	ES	Futures	1242.26	1243.01	1236.49	1236.74	25042.0
2011-10-24 07:00:00	ES	Futures	1236.74	1240.0	1236.24	1239.5	31933.0
2011-10-24 08:00:00	ES	Futures	1239.25	1243.51	1237.74	1242.26	46155.0
2011-10-24 09:00:00	ES	Futures	1242.51	1246.77	1238.74	1244.51	202254.0
2011-10-24 10:00:00	ES	Futures	1244.51	1250.03	1242.76	1247.02	283812.0
2011-10-24 11:00:00	ES	Futures	1247.27	1254.04	1247.02	1251.78	313875.0
2011-10-24 12:00:00	ES	Futures	1252.03	1252.79	1248.52	1251.28	172869.0
2011-10-24 13:00:00	ES	Futures	1251.28	1256.3	1250.28	1255.04	148898.0
2011-10-24 14:00:00	ES	Futures	1254.79	1255.55	1250.53	1254.29	164069.0
2011-10-24 15:00:00	ES	Futures	1254.29	1256.05	1249.03	1253.04	333851.0
2011-10-24 16:00:00	ES	Futures	1253.29	1253.79	1249.53	1250.78	94712.0
2011-10-24 17:00:00	ES	Futures	1250.53	1252.29	1250.28	1251.53	3709.0
2011-10-24 18:00:00	ES	Futures	1251.53	1252.03	1248.78	1249.03	7446.0
2011-10-24 19:00:00	ES	Futures	1249.03	1250.28	1248.78	1250.03	2690.0
2011-10-24 20:00:00	ES	Futures	1249.78	1250.53	1248.02	1248.78	6409.0
2011-10-24 21:00:00	ES	Futures	1248.52	1249.53	1248.02	1249.03	4595.0
2011-10-24 22:00:00	ES	Futures	1249.03	1249.28	1246.77	1247.27	4848.0
2011-10-24 23:00:00	ES	Futures	1247.27	1249.53	1247.02	1247.27	4672.0
2011-10-24 00:00:00	NQ	Futures	2703.31	2703.31	2696.97	2700.72	924.0
2011-10-24 01:00:00	NQ	Futures	2701.0	2705.04	2700.43	2704.75	750.0
2011-10-24 02:00:00	NQ	Futures	2704.46	2710.81	2703.31	2705.91	1755.0
2011-10-24 03:00:00	NQ	Futures	2705.91	2709.08	2698.41	2701.0	5026.0
2011-10-24 04:00:00	NQ	Futures	2700.72	2707.06	2692.64	2695.53	3514.0
2011-10-24 05:00:00	NQ	Futures	2695.53	2703.6	2693.51	2702.45	2218.0
2011-10-24 06:00:00	NQ	Futures	2702.45	2703.89	2691.49	2692.07	1998.0
2011-10-24 07:00:00	NQ	Futures	2691.78	2698.12	2690.91	2696.68	2768.0
2011-10-24 08:00:00	NQ	Futures	2697.26	2704.75	2693.22	2702.73	2942.0
2011-10-24 09:00:00	NQ	Futures	2702.73	2717.73	2694.95	2711.96	30472.0
2011-10-24 10:00:00	NQ	Futures	2711.67	2732.14	2706.48	2730.7	44802.0
2011-10-24 11:00:00	NQ	Futures	2730.7	2744.83	2730.41	2741.66	37524.0
2011-10-24 12:00:00	NQ	Futures	2741.08	2746.27	2739.06	2743.68	19378.0
2011-10-24 13:00:00	NQ	Futures	2743.96	2751.17	2740.51	2749.15	16045.0
2011-10-24 14:00:00	NQ	Futures	2749.44	2751.46	2741.95	2747.14	20344.0
2011-10-24 15:00:00	NQ	Futures	2747.14	2749.73	2736.18	2744.25	39705.0
2011-10-24 16:00:00	NQ	Futures	2744.25	2746.27	2735.6	2736.18	7403.0
2011-10-24 17:00:00	NQ	Futures	2736.18	2736.76	2734.45	2735.6	858.0
2011-10-24 18:00:00	NQ	Futures	2736.18	2737.62	2732.43	2732.43	539.0
2011-10-24 19:00:00	NQ	Futures	2733.3	2735.03	2732.14	2735.03	325.0
2011-10-24 20:00:00	NQ	Futures	2734.45	2735.89	2730.99	2732.72	502.0
2011-10-24 21:00:00	NQ	Futures	2732.43	2735.03	2731.86	2734.45	470.0
2011-10-24 22:00:00	NQ	Futures	2733.3	2733.87	2729.55	2730.13	346.0
2011-10-24 23:00:00	NQ	Futures	2730.13	2735.32	2730.13	2731.28	353.0
2011-10-24 00:00:00	YM	Futures	11639.5	11639.5	11603.0	11613.9	848.0
2011-10-24 01:00:00	YM	Futures	11613.9	11632.6	11610.9	11630.6	649.0

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

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