PREVIEW / futures_1hour / 2012-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-19.parquet
  size:    50 KB
  rows:    1,498

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-06-19 00:00:00	ES	Futures	1362.96	1363.72	1362.45	1362.45	1831.0
2012-06-19 01:00:00	ES	Futures	1362.45	1362.96	1361.43	1361.94	4360.0
2012-06-19 02:00:00	ES	Futures	1361.94	1363.47	1361.43	1361.69	8388.0
2012-06-19 03:00:00	ES	Futures	1361.69	1365.25	1361.43	1362.45	40230.0
2012-06-19 04:00:00	ES	Futures	1362.45	1364.99	1359.4	1363.98	42268.0
2012-06-19 05:00:00	ES	Futures	1363.98	1366.77	1361.69	1365.76	38893.0
2012-06-19 06:00:00	ES	Futures	1366.01	1367.03	1365.25	1365.5	17643.0
2012-06-19 07:00:00	ES	Futures	1365.5	1368.81	1365.5	1367.79	36614.0
2012-06-19 08:00:00	ES	Futures	1367.54	1368.55	1365.25	1366.77	46091.0
2012-06-19 09:00:00	ES	Futures	1366.77	1371.86	1365.76	1371.6	227738.0
2012-06-19 10:00:00	ES	Futures	1371.6	1375.16	1371.1	1374.4	333815.0
2012-06-19 11:00:00	ES	Futures	1374.66	1376.18	1372.62	1375.93	237594.0
2012-06-19 12:00:00	ES	Futures	1375.67	1376.69	1374.4	1376.18	93871.0
2012-06-19 13:00:00	ES	Futures	1376.44	1380.25	1375.42	1378.72	152317.0
2012-06-19 14:00:00	ES	Futures	1378.98	1378.98	1373.38	1376.44	160619.0
2012-06-19 15:00:00	ES	Futures	1376.44	1378.22	1373.38	1374.66	216003.0
2012-06-19 16:00:00	ES	Futures	1374.66	1375.67	1372.11	1373.13	84920.0
2012-06-19 17:00:00	ES	Futures	1372.88	1373.13	1372.11	1372.11	1371.0
2012-06-19 18:00:00	ES	Futures	1371.86	1373.38	1371.86	1373.13	3326.0
2012-06-19 19:00:00	ES	Futures	1373.13	1374.15	1372.88	1373.13	2934.0
2012-06-19 20:00:00	ES	Futures	1373.13	1373.64	1369.06	1369.82	11046.0
2012-06-19 21:00:00	ES	Futures	1369.82	1371.1	1369.57	1370.59	4080.0
2012-06-19 22:00:00	ES	Futures	1370.84	1371.6	1370.08	1371.1	2556.0
2012-06-19 23:00:00	ES	Futures	1371.1	1371.1	1370.33	1370.84	1423.0
2012-06-19 00:00:00	NQ	Futures	3004.08	3005.24	3002.63	3003.21	327.0
2012-06-19 01:00:00	NQ	Futures	3003.21	3003.79	3001.18	3002.34	463.0
2012-06-19 02:00:00	NQ	Futures	3002.05	3006.4	3001.47	3003.21	850.0
2012-06-19 03:00:00	NQ	Futures	3002.92	3010.46	3002.92	3004.37	5044.0
2012-06-19 04:00:00	NQ	Futures	3003.79	3009.01	2997.41	3006.4	5752.0
2012-06-19 05:00:00	NQ	Futures	3006.11	3012.48	3001.47	3010.75	5653.0
2012-06-19 06:00:00	NQ	Futures	3010.75	3013.06	3008.72	3009.3	2282.0
2012-06-19 07:00:00	NQ	Futures	3009.3	3016.54	3009.3	3013.93	4696.0
2012-06-19 08:00:00	NQ	Futures	3013.93	3014.8	3008.72	3011.04	4766.0
2012-06-19 09:00:00	NQ	Futures	3011.04	3030.17	3010.17	3029.01	37624.0
2012-06-19 10:00:00	NQ	Futures	3029.3	3034.23	3026.69	3033.36	39911.0
2012-06-19 11:00:00	NQ	Futures	3033.36	3038.57	3029.3	3036.83	22317.0
2012-06-19 12:00:00	NQ	Futures	3036.54	3038.57	3031.91	3036.54	10547.0
2012-06-19 13:00:00	NQ	Futures	3036.83	3044.95	3034.52	3041.47	18960.0
2012-06-19 14:00:00	NQ	Futures	3041.76	3042.63	3029.59	3036.26	21150.0
2012-06-19 15:00:00	NQ	Futures	3036.26	3041.18	3029.88	3032.2	27170.0
2012-06-19 16:00:00	NQ	Futures	3032.2	3033.94	3028.43	3029.88	6345.0
2012-06-19 17:00:00	NQ	Futures	3029.88	3030.17	3028.72	3028.72	90.0
2012-06-19 18:00:00	NQ	Futures	3029.59	3030.75	3028.72	3030.17	237.0
2012-06-19 19:00:00	NQ	Futures	3030.46	3031.91	3029.3	3030.17	193.0
2012-06-19 20:00:00	NQ	Futures	3030.17	3031.04	3023.79	3024.66	1061.0
2012-06-19 21:00:00	NQ	Futures	3024.95	3027.85	3024.66	3027.27	255.0
2012-06-19 22:00:00	NQ	Futures	3026.98	3028.43	3026.11	3027.56	245.0
2012-06-19 23:00:00	NQ	Futures	3027.85	3028.43	3026.4	3028.14	176.0
2012-06-19 00:00:00	YM	Futures	12610.0	12613.0	12606.0	12606.0	97.0
2012-06-19 01:00:00	YM	Futures	12606.0	12607.0	12597.1	12601.1	296.0

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

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