PREVIEW / futures_1hour / 2012-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-09.parquet
  size:    47 KB
  rows:    1,483

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-07-09 00:00:00	ES	Futures	1371.35	1371.6	1370.84	1371.35	3370.0
2012-07-09 01:00:00	ES	Futures	1371.35	1371.6	1370.33	1370.84	4348.0
2012-07-09 02:00:00	ES	Futures	1370.84	1371.1	1369.06	1369.32	8930.0
2012-07-09 03:00:00	ES	Futures	1369.57	1371.6	1367.28	1368.04	32730.0
2012-07-09 04:00:00	ES	Futures	1367.79	1368.81	1366.52	1366.77	27380.0
2012-07-09 05:00:00	ES	Futures	1366.77	1369.32	1366.01	1368.55	17821.0
2012-07-09 06:00:00	ES	Futures	1368.3	1370.59	1367.79	1369.82	16632.0
2012-07-09 07:00:00	ES	Futures	1369.82	1370.33	1368.04	1368.3	19427.0
2012-07-09 08:00:00	ES	Futures	1368.55	1371.6	1368.3	1370.59	38828.0
2012-07-09 09:00:00	ES	Futures	1370.33	1372.62	1366.26	1367.54	204145.0
2012-07-09 10:00:00	ES	Futures	1367.28	1370.08	1364.74	1369.06	256305.0
2012-07-09 11:00:00	ES	Futures	1369.06	1369.32	1363.98	1364.23	196331.0
2012-07-09 12:00:00	ES	Futures	1364.23	1367.54	1363.98	1365.76	160569.0
2012-07-09 13:00:00	ES	Futures	1365.5	1370.59	1365.5	1369.32	93820.0
2012-07-09 14:00:00	ES	Futures	1369.32	1369.57	1365.25	1366.52	90909.0
2012-07-09 15:00:00	ES	Futures	1366.52	1371.6	1366.26	1370.33	193756.0
2012-07-09 16:00:00	ES	Futures	1370.33	1372.88	1369.82	1370.08	76239.0
2012-07-09 17:00:00	ES	Futures	1370.08	1370.84	1369.57	1369.82	1799.0
2012-07-09 18:00:00	ES	Futures	1370.08	1370.33	1368.81	1370.08	2612.0
2012-07-09 19:00:00	ES	Futures	1370.33	1370.84	1369.57	1370.84	3063.0
2012-07-09 20:00:00	ES	Futures	1370.59	1371.1	1369.32	1369.82	5808.0
2012-07-09 21:00:00	ES	Futures	1369.57	1370.33	1369.06	1369.57	3489.0
2012-07-09 22:00:00	ES	Futures	1369.82	1370.59	1366.77	1366.77	7627.0
2012-07-09 23:00:00	ES	Futures	1366.77	1367.28	1366.01	1366.77	4011.0
2012-07-09 00:00:00	NQ	Futures	3019.15	3019.44	3018.28	3018.86	93.0
2012-07-09 01:00:00	NQ	Futures	3018.86	3019.73	3017.12	3017.99	403.0
2012-07-09 02:00:00	NQ	Futures	3018.28	3018.86	3014.22	3014.8	814.0
2012-07-09 03:00:00	NQ	Futures	3014.8	3019.44	3011.04	3012.48	3481.0
2012-07-09 04:00:00	NQ	Futures	3012.48	3015.96	3011.32	3011.9	2503.0
2012-07-09 05:00:00	NQ	Futures	3012.19	3017.7	3010.75	3016.83	1821.0
2012-07-09 06:00:00	NQ	Futures	3016.54	3021.47	3015.38	3020.31	1830.0
2012-07-09 07:00:00	NQ	Futures	3020.31	3021.18	3016.54	3017.41	2061.0
2012-07-09 08:00:00	NQ	Futures	3017.7	3024.95	3017.12	3023.21	3551.0
2012-07-09 09:00:00	NQ	Futures	3023.5	3032.78	3013.06	3013.93	30673.0
2012-07-09 10:00:00	NQ	Futures	3014.22	3020.31	3004.95	3019.15	35309.0
2012-07-09 11:00:00	NQ	Futures	3019.15	3019.15	3005.82	3006.11	18300.0
2012-07-09 12:00:00	NQ	Futures	3005.82	3013.06	3005.53	3010.46	13040.0
2012-07-09 13:00:00	NQ	Futures	3010.17	3022.92	3009.3	3020.02	12579.0
2012-07-09 14:00:00	NQ	Futures	3020.31	3021.18	3007.56	3012.19	10337.0
2012-07-09 15:00:00	NQ	Futures	3011.9	3021.76	3011.32	3020.02	18786.0
2012-07-09 16:00:00	NQ	Futures	3020.02	3024.66	3017.12	3018.28	6266.0
2012-07-09 17:00:00	NQ	Futures	3018.28	3018.86	3017.7	3017.7	84.0
2012-07-09 18:00:00	NQ	Futures	3019.15	3019.15	3016.83	3018.57	137.0
2012-07-09 19:00:00	NQ	Futures	3018.86	3020.89	3017.99	3020.31	105.0
2012-07-09 20:00:00	NQ	Futures	3020.31	3020.6	3017.41	3017.7	422.0
2012-07-09 21:00:00	NQ	Futures	3017.99	3018.57	3016.83	3017.41	238.0
2012-07-09 22:00:00	NQ	Futures	3017.7	3019.15	3011.04	3011.32	964.0
2012-07-09 23:00:00	NQ	Futures	3011.61	3012.48	3009.88	3010.75	317.0
2012-07-09 00:00:00	YM	Futures	12633.9	12634.9	12625.9	12630.9	390.0
2012-07-09 01:00:00	YM	Futures	12630.9	12631.9	12622.9	12624.9	396.0

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

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