PREVIEW / futures_1hour / 2011-02-17

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-17.parquet
  size:    47 KB
  rows:    1,437

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-02-17 00:00:00	ES	Futures	1318.54	1318.54	1316.81	1317.3	5684.0
2011-02-17 01:00:00	ES	Futures	1317.3	1318.29	1317.05	1318.29	2661.0
2011-02-17 02:00:00	ES	Futures	1318.29	1319.28	1318.04	1318.79	5955.0
2011-02-17 03:00:00	ES	Futures	1318.79	1319.53	1318.04	1319.03	12291.0
2011-02-17 04:00:00	ES	Futures	1319.03	1319.28	1317.3	1317.8	11263.0
2011-02-17 05:00:00	ES	Futures	1317.8	1318.79	1317.55	1317.8	9904.0
2011-02-17 06:00:00	ES	Futures	1317.8	1318.54	1317.3	1317.55	10160.0
2011-02-17 07:00:00	ES	Futures	1317.55	1319.53	1317.55	1319.28	11089.0
2011-02-17 08:00:00	ES	Futures	1319.28	1319.53	1314.83	1315.57	86302.0
2011-02-17 09:00:00	ES	Futures	1315.82	1318.04	1315.32	1317.55	200736.0
2011-02-17 10:00:00	ES	Futures	1317.8	1320.27	1316.81	1319.28	335712.0
2011-02-17 11:00:00	ES	Futures	1319.28	1323.49	1318.79	1322.75	270325.0
2011-02-17 12:00:00	ES	Futures	1322.5	1322.99	1321.51	1322.0	105057.0
2011-02-17 13:00:00	ES	Futures	1322.25	1325.22	1322.25	1324.72	173185.0
2011-02-17 14:00:00	ES	Futures	1324.72	1325.96	1323.73	1325.22	137212.0
2011-02-17 15:00:00	ES	Futures	1324.97	1326.21	1324.23	1324.48	195090.0
2011-02-17 16:00:00	ES	Futures	1324.48	1324.97	1323.49	1324.23	78372.0
2011-02-17 17:00:00	ES	Futures	1324.23	1324.23	1322.5	1322.75	2840.0
2011-02-17 18:00:00	ES	Futures	1322.99	1323.98	1322.75	1323.49	2940.0
2011-02-17 19:00:00	ES	Futures	1323.49	1323.73	1322.75	1323.24	2629.0
2011-02-17 20:00:00	ES	Futures	1323.49	1324.48	1323.24	1323.73	3426.0
2011-02-17 21:00:00	ES	Futures	1323.73	1324.72	1323.24	1324.48	2009.0
2011-02-17 22:00:00	ES	Futures	1324.48	1325.22	1323.98	1324.97	2105.0
2011-02-17 23:00:00	ES	Futures	1324.97	1325.47	1324.97	1324.97	2252.0
2011-02-17 00:00:00	NQ	Futures	2744.89	2744.89	2742.02	2742.31	187.0
2011-02-17 01:00:00	NQ	Futures	2742.6	2745.47	2742.31	2745.47	203.0
2011-02-17 02:00:00	NQ	Futures	2745.47	2747.19	2745.47	2747.19	492.0
2011-02-17 03:00:00	NQ	Futures	2747.47	2749.48	2745.75	2748.62	1574.0
2011-02-17 04:00:00	NQ	Futures	2748.62	2748.62	2744.03	2744.89	1046.0
2011-02-17 05:00:00	NQ	Futures	2744.89	2747.19	2742.31	2742.6	2010.0
2011-02-17 06:00:00	NQ	Futures	2742.88	2744.6	2742.02	2743.17	844.0
2011-02-17 07:00:00	NQ	Futures	2743.46	2746.33	2743.46	2746.33	2250.0
2011-02-17 08:00:00	NQ	Futures	2746.04	2747.47	2738.29	2739.72	7936.0
2011-02-17 09:00:00	NQ	Futures	2739.72	2746.61	2736.57	2746.04	36277.0
2011-02-17 10:00:00	NQ	Futures	2745.75	2749.77	2741.73	2743.46	31414.0
2011-02-17 11:00:00	NQ	Futures	2743.74	2755.8	2742.6	2753.79	29375.0
2011-02-17 12:00:00	NQ	Futures	2754.08	2754.65	2750.34	2750.63	17215.0
2011-02-17 13:00:00	NQ	Futures	2750.63	2756.09	2750.34	2753.5	16756.0
2011-02-17 14:00:00	NQ	Futures	2753.5	2756.37	2750.92	2752.64	13277.0
2011-02-17 15:00:00	NQ	Futures	2752.93	2754.94	2749.48	2751.49	25804.0
2011-02-17 16:00:00	NQ	Futures	2751.21	2752.64	2747.47	2748.91	9405.0
2011-02-17 17:00:00	NQ	Futures	2748.91	2749.48	2746.9	2746.9	327.0
2011-02-17 18:00:00	NQ	Futures	2748.05	2749.48	2747.19	2748.34	172.0
2011-02-17 19:00:00	NQ	Futures	2748.05	2748.62	2747.19	2748.05	127.0
2011-02-17 20:00:00	NQ	Futures	2748.05	2750.06	2747.76	2748.05	289.0
2011-02-17 21:00:00	NQ	Futures	2748.05	2750.06	2746.9	2749.48	212.0
2011-02-17 22:00:00	NQ	Futures	2749.48	2750.63	2748.34	2750.06	249.0
2011-02-17 23:00:00	NQ	Futures	2750.34	2750.92	2750.06	2750.06	269.0
2011-02-17 00:00:00	YM	Futures	11731.9	11732.8	11725.2	11728.0	214.0
2011-02-17 01:00:00	YM	Futures	11730.0	11731.9	11725.2	11731.9	106.0

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

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