PREVIEW / futures_1hour / 2012-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-07.parquet
  size:    46 KB
  rows:    1,388

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
2012-05-07 00:00:00	ES	Futures	1365.1	1365.86	1363.59	1365.1	4742.0
2012-05-07 01:00:00	ES	Futures	1365.36	1365.86	1363.08	1363.84	6923.0
2012-05-07 02:00:00	ES	Futures	1363.84	1366.37	1363.59	1365.86	15291.0
2012-05-07 03:00:00	ES	Futures	1366.12	1368.65	1364.85	1367.89	29147.0
2012-05-07 04:00:00	ES	Futures	1367.63	1369.15	1366.87	1368.14	18221.0
2012-05-07 05:00:00	ES	Futures	1368.14	1371.18	1367.13	1370.92	20502.0
2012-05-07 06:00:00	ES	Futures	1370.92	1373.2	1370.67	1371.68	26142.0
2012-05-07 07:00:00	ES	Futures	1371.93	1374.21	1370.92	1372.19	44612.0
2012-05-07 08:00:00	ES	Futures	1372.19	1375.22	1371.93	1374.46	51117.0
2012-05-07 09:00:00	ES	Futures	1374.46	1382.56	1374.21	1380.03	267057.0
2012-05-07 10:00:00	ES	Futures	1380.28	1382.56	1375.98	1379.02	271031.0
2012-05-07 11:00:00	ES	Futures	1379.02	1382.05	1378.76	1380.28	166597.0
2012-05-07 12:00:00	ES	Futures	1380.28	1384.33	1380.03	1383.07	152018.0
2012-05-07 13:00:00	ES	Futures	1383.07	1386.61	1382.56	1385.6	120975.0
2012-05-07 14:00:00	ES	Futures	1385.6	1386.35	1383.57	1385.09	64105.0
2012-05-07 15:00:00	ES	Futures	1384.84	1385.6	1380.54	1381.8	171836.0
2012-05-07 16:00:00	ES	Futures	1381.8	1383.32	1380.28	1382.81	70755.0
2012-05-07 17:00:00	ES	Futures	1382.56	1383.32	1382.31	1382.31	1830.0
2012-05-07 18:00:00	ES	Futures	1382.31	1383.32	1382.31	1382.81	2586.0
2012-05-07 19:00:00	ES	Futures	1382.81	1384.33	1382.31	1383.57	3291.0
2012-05-07 20:00:00	ES	Futures	1383.82	1383.82	1380.54	1381.55	8046.0
2012-05-07 21:00:00	ES	Futures	1381.55	1381.8	1379.27	1379.78	5501.0
2012-05-07 22:00:00	ES	Futures	1379.78	1380.54	1379.27	1380.28	2115.0
2012-05-07 23:00:00	ES	Futures	1380.28	1380.54	1379.27	1380.03	1774.0
2012-05-07 00:00:00	NQ	Futures	3007.11	3010.0	3004.22	3006.82	765.0
2012-05-07 01:00:00	NQ	Futures	3007.11	3008.84	3002.48	3005.37	757.0
2012-05-07 02:00:00	NQ	Futures	3005.08	3010.87	3003.35	3009.71	1396.0
2012-05-07 03:00:00	NQ	Futures	3010.0	3014.92	3006.24	3013.76	3371.0
2012-05-07 04:00:00	NQ	Futures	3013.47	3016.65	3011.73	3013.76	1980.0
2012-05-07 05:00:00	NQ	Futures	3013.47	3020.7	3010.87	3019.25	1682.0
2012-05-07 06:00:00	NQ	Futures	3019.54	3024.17	3019.25	3020.99	2574.0
2012-05-07 07:00:00	NQ	Futures	3021.28	3025.62	3019.25	3021.28	3064.0
2012-05-07 08:00:00	NQ	Futures	3020.99	3028.51	3020.41	3027.64	6416.0
2012-05-07 09:00:00	NQ	Futures	3027.64	3050.49	3026.77	3046.73	52343.0
2012-05-07 10:00:00	NQ	Futures	3046.73	3053.38	3033.14	3050.2	49190.0
2012-05-07 11:00:00	NQ	Futures	3049.91	3055.69	3042.39	3045.57	21505.0
2012-05-07 12:00:00	NQ	Futures	3045.57	3056.56	3042.97	3053.09	16907.0
2012-05-07 13:00:00	NQ	Futures	3053.38	3063.5	3050.49	3060.9	19432.0
2012-05-07 14:00:00	NQ	Futures	3061.19	3063.5	3054.54	3058.87	12390.0
2012-05-07 15:00:00	NQ	Futures	3058.87	3060.9	3046.15	3049.04	25797.0
2012-05-07 16:00:00	NQ	Futures	3049.33	3054.54	3045.86	3053.38	7685.0
2012-05-07 17:00:00	NQ	Futures	3053.38	3054.54	3051.93	3051.93	104.0
2012-05-07 18:00:00	NQ	Futures	3051.07	3054.25	3051.07	3053.38	347.0
2012-05-07 19:00:00	NQ	Futures	3052.8	3055.98	3051.64	3054.25	239.0
2012-05-07 20:00:00	NQ	Futures	3054.25	3054.54	3047.6	3048.17	657.0
2012-05-07 21:00:00	NQ	Futures	3048.46	3049.62	3044.7	3045.28	702.0
2012-05-07 22:00:00	NQ	Futures	3045.28	3047.02	3044.7	3046.44	173.0
2012-05-07 23:00:00	NQ	Futures	3046.44	3046.73	3044.7	3046.44	223.0
2012-05-07 00:00:00	YM	Futures	12789.5	12797.5	12780.5	12793.5	437.0
2012-05-07 01:00:00	YM	Futures	12794.5	12799.5	12775.5	12785.5	717.0

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

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