PREVIEW / futures_1hour / 2011-11-11

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-11.parquet
  size:    41 KB
  rows:    1,168

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-11-11 00:00:00	ES	Futures	1250.53	1251.78	1247.27	1249.53	6210.0
2011-11-11 01:00:00	ES	Futures	1249.53	1249.78	1246.02	1246.77	5383.0
2011-11-11 02:00:00	ES	Futures	1247.02	1248.52	1243.01	1243.51	9878.0
2011-11-11 03:00:00	ES	Futures	1243.76	1252.29	1240.5	1250.53	45569.0
2011-11-11 04:00:00	ES	Futures	1250.28	1250.78	1244.76	1247.52	29020.0
2011-11-11 05:00:00	ES	Futures	1247.52	1249.28	1245.52	1246.77	18803.0
2011-11-11 06:00:00	ES	Futures	1247.02	1250.78	1246.77	1247.77	17202.0
2011-11-11 07:00:00	ES	Futures	1247.52	1252.79	1246.52	1252.54	23660.0
2011-11-11 08:00:00	ES	Futures	1252.29	1255.04	1251.78	1253.29	45134.0
2011-11-11 09:00:00	ES	Futures	1253.54	1261.81	1253.04	1259.31	251146.0
2011-11-11 10:00:00	ES	Futures	1259.31	1267.83	1259.31	1266.33	307117.0
2011-11-11 11:00:00	ES	Futures	1266.58	1268.58	1264.82	1265.33	182414.0
2011-11-11 12:00:00	ES	Futures	1265.33	1267.08	1263.57	1265.58	117673.0
2011-11-11 13:00:00	ES	Futures	1265.33	1267.83	1264.57	1265.07	96804.0
2011-11-11 14:00:00	ES	Futures	1265.07	1267.58	1263.32	1264.07	97623.0
2011-11-11 15:00:00	ES	Futures	1264.07	1265.83	1261.81	1265.58	215666.0
2011-11-11 16:00:00	ES	Futures	1265.33	1265.83	1263.32	1265.58	77692.0
2011-11-11 00:00:00	NQ	Futures	2678.23	2680.53	2672.75	2677.36	353.0
2011-11-11 01:00:00	NQ	Futures	2677.07	2677.36	2671.31	2672.17	330.0
2011-11-11 02:00:00	NQ	Futures	2672.46	2673.33	2661.79	2662.66	1333.0
2011-11-11 03:00:00	NQ	Futures	2662.95	2682.26	2656.03	2677.94	3590.0
2011-11-11 04:00:00	NQ	Futures	2678.23	2678.23	2664.68	2670.15	2411.0
2011-11-11 05:00:00	NQ	Futures	2670.44	2674.19	2665.25	2667.56	1277.0
2011-11-11 06:00:00	NQ	Futures	2667.85	2675.63	2667.56	2669.0	2328.0
2011-11-11 07:00:00	NQ	Futures	2668.71	2679.96	2666.41	2679.09	1692.0
2011-11-11 08:00:00	NQ	Futures	2678.52	2685.72	2676.79	2679.96	4759.0
2011-11-11 09:00:00	NQ	Futures	2680.25	2696.1	2679.38	2689.18	33413.0
2011-11-11 10:00:00	NQ	Futures	2689.18	2711.96	2688.61	2708.5	36824.0
2011-11-11 11:00:00	NQ	Futures	2708.5	2719.17	2707.06	2713.4	25433.0
2011-11-11 12:00:00	NQ	Futures	2713.4	2718.59	2710.52	2715.71	13481.0
2011-11-11 13:00:00	NQ	Futures	2716.29	2722.05	2713.4	2715.13	13987.0
2011-11-11 14:00:00	NQ	Futures	2715.42	2721.19	2709.65	2711.96	12800.0
2011-11-11 15:00:00	NQ	Futures	2711.67	2714.56	2707.35	2713.11	23712.0
2011-11-11 16:00:00	NQ	Futures	2713.4	2713.69	2709.08	2713.4	5754.0
2011-11-11 00:00:00	YM	Futures	11742.9	11751.7	11719.2	11740.9	422.0
2011-11-11 01:00:00	YM	Futures	11739.9	11739.9	11712.3	11719.2	342.0
2011-11-11 02:00:00	YM	Futures	11717.3	11734.0	11687.7	11691.7	631.0
2011-11-11 03:00:00	YM	Futures	11695.6	11762.5	11665.1	11743.8	2764.0
2011-11-11 04:00:00	YM	Futures	11743.8	11744.8	11695.6	11717.3	1918.0
2011-11-11 05:00:00	YM	Futures	11715.3	11736.0	11702.5	11714.3	1481.0
2011-11-11 06:00:00	YM	Futures	11715.3	11746.8	11715.3	11720.2	1258.0
2011-11-11 07:00:00	YM	Futures	11718.2	11761.6	11709.4	11756.6	1859.0
2011-11-11 08:00:00	YM	Futures	11757.6	11780.3	11752.7	11769.4	2183.0
2011-11-11 09:00:00	YM	Futures	11768.4	11886.6	11766.5	11872.8	17594.0
2011-11-11 10:00:00	YM	Futures	11872.8	11947.6	11872.8	11940.7	19781.0
2011-11-11 11:00:00	YM	Futures	11940.7	11954.5	11927.0	11928.9	12511.0
2011-11-11 12:00:00	YM	Futures	11928.9	11944.7	11918.1	11927.9	7215.0
2011-11-11 13:00:00	YM	Futures	11927.9	11948.6	11927.0	11932.9	6118.0
2011-11-11 14:00:00	YM	Futures	11932.9	11948.6	11915.1	11923.0	6571.0
2011-11-11 15:00:00	YM	Futures	11922.0	11932.9	11895.5	11931.9	13662.0

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

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