PREVIEW / futures_1hour / 2011-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-01.parquet
  size:    50 KB
  rows:    1,504

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-01 00:00:00	ES	Futures	1272.76	1273.01	1269.55	1272.02	6663.0
2011-02-01 01:00:00	ES	Futures	1272.02	1273.26	1271.78	1272.02	2987.0
2011-02-01 02:00:00	ES	Futures	1272.02	1274.0	1271.53	1273.51	10204.0
2011-02-01 03:00:00	ES	Futures	1273.26	1274.25	1271.28	1272.02	23455.0
2011-02-01 04:00:00	ES	Futures	1272.02	1274.5	1271.28	1274.25	22045.0
2011-02-01 05:00:00	ES	Futures	1274.5	1275.49	1273.75	1275.24	19091.0
2011-02-01 06:00:00	ES	Futures	1275.24	1275.98	1274.5	1275.49	15959.0
2011-02-01 07:00:00	ES	Futures	1275.49	1276.72	1274.0	1276.23	28263.0
2011-02-01 08:00:00	ES	Futures	1275.98	1277.71	1275.49	1276.97	39437.0
2011-02-01 09:00:00	ES	Futures	1276.97	1281.42	1276.48	1281.18	258941.0
2011-02-01 10:00:00	ES	Futures	1281.42	1285.63	1279.45	1285.14	394452.0
2011-02-01 11:00:00	ES	Futures	1285.14	1287.86	1283.65	1286.37	239564.0
2011-02-01 12:00:00	ES	Futures	1286.37	1291.57	1286.13	1291.57	281705.0
2011-02-01 13:00:00	ES	Futures	1291.57	1292.06	1289.34	1289.34	166013.0
2011-02-01 14:00:00	ES	Futures	1289.34	1290.83	1288.6	1290.83	153733.0
2011-02-01 15:00:00	ES	Futures	1290.83	1292.56	1289.59	1290.08	273403.0
2011-02-01 16:00:00	ES	Futures	1290.08	1290.58	1287.61	1288.85	114265.0
2011-02-01 17:00:00	ES	Futures	1288.85	1289.1	1288.11	1288.6	1520.0
2011-02-01 18:00:00	ES	Futures	1289.1	1289.34	1286.62	1288.6	10481.0
2011-02-01 19:00:00	ES	Futures	1288.85	1289.59	1288.11	1289.34	5567.0
2011-02-01 20:00:00	ES	Futures	1289.34	1289.59	1287.86	1289.1	6531.0
2011-02-01 21:00:00	ES	Futures	1289.34	1289.84	1288.85	1289.34	3646.0
2011-02-01 22:00:00	ES	Futures	1289.34	1289.84	1288.6	1289.1	3121.0
2011-02-01 23:00:00	ES	Futures	1289.1	1290.08	1288.6	1289.34	3140.0
2011-02-01 00:00:00	NQ	Futures	2628.93	2630.37	2624.34	2629.79	1103.0
2011-02-01 01:00:00	NQ	Futures	2630.08	2630.37	2628.07	2628.36	486.0
2011-02-01 02:00:00	NQ	Futures	2628.07	2630.37	2627.5	2629.79	899.0
2011-02-01 03:00:00	NQ	Futures	2629.5	2630.37	2626.35	2628.36	2585.0
2011-02-01 04:00:00	NQ	Futures	2628.36	2630.37	2627.21	2630.08	1201.0
2011-02-01 05:00:00	NQ	Futures	2630.08	2634.67	2630.08	2634.38	1579.0
2011-02-01 06:00:00	NQ	Futures	2634.38	2635.24	2632.95	2633.81	1104.0
2011-02-01 07:00:00	NQ	Futures	2633.81	2634.96	2630.94	2634.1	1617.0
2011-02-01 08:00:00	NQ	Futures	2634.1	2636.39	2632.95	2634.96	2974.0
2011-02-01 09:00:00	NQ	Futures	2634.96	2648.45	2633.52	2646.15	50899.0
2011-02-01 10:00:00	NQ	Futures	2646.15	2660.5	2641.27	2659.36	84801.0
2011-02-01 11:00:00	NQ	Futures	2659.64	2663.09	2651.89	2660.79	34377.0
2011-02-01 12:00:00	NQ	Futures	2660.5	2672.27	2660.22	2671.41	39106.0
2011-02-01 13:00:00	NQ	Futures	2671.7	2673.13	2666.24	2667.68	20000.0
2011-02-01 14:00:00	NQ	Futures	2667.68	2670.84	2665.67	2670.55	15321.0
2011-02-01 15:00:00	NQ	Futures	2670.55	2672.56	2665.96	2666.53	26936.0
2011-02-01 16:00:00	NQ	Futures	2666.53	2667.68	2661.36	2664.52	10299.0
2011-02-01 17:00:00	NQ	Futures	2664.52	2665.1	2663.37	2664.52	73.0
2011-02-01 18:00:00	NQ	Futures	2664.52	2665.96	2660.5	2665.38	620.0
2011-02-01 19:00:00	NQ	Futures	2665.1	2666.82	2663.95	2666.24	416.0
2011-02-01 20:00:00	NQ	Futures	2666.24	2666.24	2662.8	2665.1	510.0
2011-02-01 21:00:00	NQ	Futures	2665.1	2666.24	2664.24	2665.67	353.0
2011-02-01 22:00:00	NQ	Futures	2665.1	2665.96	2663.95	2664.81	91.0
2011-02-01 23:00:00	NQ	Futures	2664.81	2665.67	2663.95	2665.38	97.0
2011-02-01 00:00:00	YM	Futures	11367.0	11367.9	11338.2	11359.3	414.0
2011-02-01 01:00:00	YM	Futures	11359.3	11367.9	11359.3	11362.2	188.0

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

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