PREVIEW / futures_1hour / 2011-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-15.parquet
  size:    53 KB
  rows:    1,523

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-03-15 00:00:00	ES	Futures	1253.08	1253.58	1244.39	1252.09	61851.0
2011-03-15 01:00:00	ES	Futures	1251.84	1258.05	1250.85	1255.57	30280.0
2011-03-15 02:00:00	ES	Futures	1255.57	1258.3	1253.08	1256.56	20320.0
2011-03-15 03:00:00	ES	Futures	1256.31	1260.78	1255.57	1258.05	42938.0
2011-03-15 04:00:00	ES	Futures	1258.05	1263.27	1257.06	1258.3	75733.0
2011-03-15 05:00:00	ES	Futures	1258.3	1258.55	1243.15	1248.36	130706.0
2011-03-15 06:00:00	ES	Futures	1248.36	1250.85	1245.63	1250.35	59776.0
2011-03-15 07:00:00	ES	Futures	1250.35	1255.07	1248.61	1251.1	87993.0
2011-03-15 08:00:00	ES	Futures	1250.85	1253.08	1246.38	1249.11	119645.0
2011-03-15 09:00:00	ES	Futures	1249.11	1257.31	1247.37	1250.85	541482.0
2011-03-15 10:00:00	ES	Futures	1250.85	1261.53	1250.85	1260.29	474598.0
2011-03-15 11:00:00	ES	Futures	1260.54	1262.28	1257.06	1261.78	267935.0
2011-03-15 12:00:00	ES	Futures	1261.78	1267.74	1260.29	1263.02	327974.0
2011-03-15 13:00:00	ES	Futures	1263.27	1265.01	1260.29	1264.76	161933.0
2011-03-15 14:00:00	ES	Futures	1264.76	1271.22	1261.28	1267.99	308212.0
2011-03-15 15:00:00	ES	Futures	1268.24	1275.69	1267.74	1268.73	445111.0
2011-03-15 16:00:00	ES	Futures	1268.73	1268.98	1265.01	1266.5	154201.0
2011-03-15 17:00:00	ES	Futures	1266.75	1267.24	1266.0	1266.75	2141.0
2011-03-15 18:00:00	ES	Futures	1266.5	1266.75	1257.8	1261.28	26693.0
2011-03-15 19:00:00	ES	Futures	1261.53	1268.73	1261.03	1267.74	13829.0
2011-03-15 20:00:00	ES	Futures	1267.49	1275.44	1263.52	1275.19	31441.0
2011-03-15 21:00:00	ES	Futures	1275.19	1275.19	1270.72	1270.97	18239.0
2011-03-15 22:00:00	ES	Futures	1270.97	1271.22	1263.77	1263.77	18538.0
2011-03-15 23:00:00	ES	Futures	1264.01	1267.99	1261.78	1265.26	19901.0
2011-03-15 00:00:00	NQ	Futures	2575.78	2576.64	2557.39	2572.33	3749.0
2011-03-15 01:00:00	NQ	Futures	2572.33	2584.97	2571.18	2578.94	1975.0
2011-03-15 02:00:00	NQ	Futures	2578.36	2583.53	2574.34	2582.39	909.0
2011-03-15 03:00:00	NQ	Futures	2580.95	2591.58	2574.92	2585.55	3682.0
2011-03-15 04:00:00	NQ	Futures	2585.26	2596.18	2583.25	2585.26	5318.0
2011-03-15 05:00:00	NQ	Futures	2585.55	2585.83	2551.64	2557.68	11351.0
2011-03-15 06:00:00	NQ	Futures	2557.68	2564.0	2554.8	2563.71	5580.0
2011-03-15 07:00:00	NQ	Futures	2563.71	2573.19	2553.94	2559.97	8340.0
2011-03-15 08:00:00	NQ	Futures	2559.69	2564.57	2549.92	2557.1	9611.0
2011-03-15 09:00:00	NQ	Futures	2556.81	2571.18	2544.17	2554.8	70562.0
2011-03-15 10:00:00	NQ	Futures	2554.8	2580.95	2552.79	2579.22	63453.0
2011-03-15 11:00:00	NQ	Futures	2579.8	2586.12	2572.33	2584.4	27765.0
2011-03-15 12:00:00	NQ	Futures	2584.4	2595.31	2577.79	2585.26	39110.0
2011-03-15 13:00:00	NQ	Futures	2585.26	2587.84	2580.37	2587.56	18146.0
2011-03-15 14:00:00	NQ	Futures	2587.27	2600.49	2583.53	2594.45	30624.0
2011-03-15 15:00:00	NQ	Futures	2594.45	2608.24	2593.02	2593.3	46802.0
2011-03-15 16:00:00	NQ	Futures	2593.3	2593.59	2578.36	2582.1	17402.0
2011-03-15 17:00:00	NQ	Futures	2582.1	2583.53	2581.24	2582.96	482.0
2011-03-15 18:00:00	NQ	Futures	2582.96	2582.96	2567.16	2573.19	1600.0
2011-03-15 19:00:00	NQ	Futures	2573.48	2587.27	2573.48	2584.97	1473.0
2011-03-15 20:00:00	NQ	Futures	2584.68	2599.34	2576.93	2599.34	2662.0
2011-03-15 21:00:00	NQ	Futures	2599.05	2599.05	2588.42	2589.57	1672.0
2011-03-15 22:00:00	NQ	Futures	2589.57	2589.57	2574.92	2575.2	2019.0
2011-03-15 23:00:00	NQ	Futures	2575.2	2581.24	2570.03	2576.64	2199.0
2011-03-15 00:00:00	YM	Futures	11240.4	11266.4	11179.7	11250.0	3170.0
2011-03-15 01:00:00	YM	Futures	11250.0	11297.2	11242.3	11271.2	1740.0

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

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