PREVIEW / futures_1hour / 2011-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-15.parquet
  size:    49 KB
  rows:    1,476

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-06-15 00:00:00	ES	Futures	1276.71	1277.95	1276.46	1277.21	3056.0
2011-06-15 01:00:00	ES	Futures	1277.21	1277.95	1276.96	1277.46	4069.0
2011-06-15 02:00:00	ES	Futures	1277.7	1277.7	1275.21	1276.21	13338.0
2011-06-15 03:00:00	ES	Futures	1276.21	1277.46	1275.71	1275.96	19463.0
2011-06-15 04:00:00	ES	Futures	1276.21	1276.71	1274.46	1274.46	17361.0
2011-06-15 05:00:00	ES	Futures	1274.71	1275.96	1273.71	1275.96	26490.0
2011-06-15 06:00:00	ES	Futures	1275.71	1276.71	1274.46	1274.96	22437.0
2011-06-15 07:00:00	ES	Futures	1274.71	1276.21	1274.46	1274.46	27442.0
2011-06-15 08:00:00	ES	Futures	1274.46	1275.21	1267.98	1268.48	156700.0
2011-06-15 09:00:00	ES	Futures	1268.48	1271.97	1266.23	1270.72	347858.0
2011-06-15 10:00:00	ES	Futures	1270.72	1272.72	1267.73	1270.72	314442.0
2011-06-15 11:00:00	ES	Futures	1270.72	1271.97	1259.75	1261.99	514228.0
2011-06-15 12:00:00	ES	Futures	1261.99	1262.99	1254.26	1257.75	432924.0
2011-06-15 13:00:00	ES	Futures	1258.0	1258.75	1254.51	1257.0	270486.0
2011-06-15 14:00:00	ES	Futures	1257.0	1260.5	1254.01	1255.51	393694.0
2011-06-15 15:00:00	ES	Futures	1255.76	1260.0	1252.76	1256.26	453378.0
2011-06-15 16:00:00	ES	Futures	1256.51	1258.75	1256.01	1256.75	145281.0
2011-06-15 17:00:00	ES	Futures	1257.0	1257.75	1256.75	1257.25	2284.0
2011-06-15 18:00:00	ES	Futures	1257.5	1259.25	1257.0	1259.25	5562.0
2011-06-15 19:00:00	ES	Futures	1259.25	1259.75	1256.26	1257.75	8924.0
2011-06-15 20:00:00	ES	Futures	1258.0	1259.5	1256.75	1259.5	6240.0
2011-06-15 21:00:00	ES	Futures	1259.5	1260.25	1257.5	1259.25	7240.0
2011-06-15 22:00:00	ES	Futures	1259.25	1261.74	1258.75	1260.74	9128.0
2011-06-15 23:00:00	ES	Futures	1260.5	1261.24	1259.75	1260.5	5020.0
2011-06-15 00:00:00	NQ	Futures	2578.38	2580.68	2577.8	2578.95	234.0
2011-06-15 01:00:00	NQ	Futures	2579.24	2580.39	2578.95	2580.39	205.0
2011-06-15 02:00:00	NQ	Futures	2580.1	2580.1	2575.5	2576.94	712.0
2011-06-15 03:00:00	NQ	Futures	2576.94	2578.09	2575.21	2575.79	1714.0
2011-06-15 04:00:00	NQ	Futures	2575.79	2576.94	2572.33	2572.33	1582.0
2011-06-15 05:00:00	NQ	Futures	2572.33	2574.64	2571.18	2574.35	1659.0
2011-06-15 06:00:00	NQ	Futures	2574.35	2576.65	2572.62	2573.2	2807.0
2011-06-15 07:00:00	NQ	Futures	2573.2	2574.92	2572.62	2572.62	2068.0
2011-06-15 08:00:00	NQ	Futures	2572.91	2574.06	2559.1	2560.25	13041.0
2011-06-15 09:00:00	NQ	Futures	2560.25	2571.76	2557.95	2570.61	42140.0
2011-06-15 10:00:00	NQ	Futures	2570.32	2577.23	2564.28	2566.87	41292.0
2011-06-15 11:00:00	NQ	Futures	2567.15	2568.88	2549.02	2551.33	48146.0
2011-06-15 12:00:00	NQ	Futures	2551.33	2553.92	2539.53	2542.69	51374.0
2011-06-15 13:00:00	NQ	Futures	2542.69	2545.86	2538.67	2542.98	36568.0
2011-06-15 14:00:00	NQ	Futures	2542.98	2547.87	2536.94	2538.09	62950.0
2011-06-15 15:00:00	NQ	Futures	2538.09	2541.83	2532.05	2537.8	46908.0
2011-06-15 16:00:00	NQ	Futures	2537.8	2541.54	2536.94	2539.24	9995.0
2011-06-15 17:00:00	NQ	Futures	2538.67	2540.1	2538.67	2539.24	98.0
2011-06-15 18:00:00	NQ	Futures	2539.82	2542.41	2538.38	2542.12	314.0
2011-06-15 19:00:00	NQ	Futures	2542.12	2543.27	2539.24	2541.54	918.0
2011-06-15 20:00:00	NQ	Futures	2541.26	2543.85	2538.95	2543.27	553.0
2011-06-15 21:00:00	NQ	Futures	2543.56	2545.0	2539.82	2542.98	668.0
2011-06-15 22:00:00	NQ	Futures	2542.98	2547.01	2541.83	2546.15	703.0
2011-06-15 23:00:00	NQ	Futures	2545.57	2546.15	2543.85	2545.28	208.0
2011-06-15 00:00:00	YM	Futures	11599.5	11610.1	11598.5	11604.3	290.0
2011-06-15 01:00:00	YM	Futures	11605.3	11609.2	11603.4	11608.2	211.0

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

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