PREVIEW / futures_1hour / 2011-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-01.parquet
  size:    40 KB
  rows:    1,167

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-07-01 00:00:00	ES	Futures	1310.63	1311.62	1310.38	1311.37	1930.0
2011-07-01 01:00:00	ES	Futures	1311.37	1312.12	1310.38	1311.62	4466.0
2011-07-01 02:00:00	ES	Futures	1311.62	1312.62	1310.88	1311.37	13972.0
2011-07-01 03:00:00	ES	Futures	1311.62	1312.37	1309.38	1309.88	26822.0
2011-07-01 04:00:00	ES	Futures	1309.88	1312.87	1309.88	1312.37	15396.0
2011-07-01 05:00:00	ES	Futures	1312.12	1313.37	1310.88	1312.12	16653.0
2011-07-01 06:00:00	ES	Futures	1312.12	1314.37	1311.87	1312.62	26288.0
2011-07-01 07:00:00	ES	Futures	1312.62	1313.37	1311.37	1312.12	18915.0
2011-07-01 08:00:00	ES	Futures	1312.37	1314.12	1311.37	1312.37	33807.0
2011-07-01 09:00:00	ES	Futures	1312.37	1313.87	1310.13	1313.37	169077.0
2011-07-01 10:00:00	ES	Futures	1313.62	1324.84	1313.37	1322.1	569664.0
2011-07-01 11:00:00	ES	Futures	1322.35	1325.34	1321.85	1324.34	186283.0
2011-07-01 12:00:00	ES	Futures	1324.34	1326.59	1323.6	1326.09	115313.0
2011-07-01 13:00:00	ES	Futures	1326.09	1329.83	1325.59	1329.08	166947.0
2011-07-01 14:00:00	ES	Futures	1329.08	1332.57	1328.33	1332.07	143645.0
2011-07-01 15:00:00	ES	Futures	1332.07	1333.32	1329.83	1331.58	292717.0
2011-07-01 16:00:00	ES	Futures	1331.58	1332.57	1331.08	1332.07	112011.0
2011-07-01 00:00:00	NQ	Futures	2668.16	2670.17	2668.16	2669.89	393.0
2011-07-01 01:00:00	NQ	Futures	2670.17	2671.61	2669.31	2670.17	465.0
2011-07-01 02:00:00	NQ	Futures	2670.17	2672.76	2669.89	2671.61	957.0
2011-07-01 03:00:00	NQ	Futures	2671.33	2673.63	2667.01	2668.16	3191.0
2011-07-01 04:00:00	NQ	Futures	2668.16	2674.2	2667.58	2672.76	1846.0
2011-07-01 05:00:00	NQ	Futures	2672.48	2676.22	2671.61	2673.63	2357.0
2011-07-01 06:00:00	NQ	Futures	2673.34	2677.94	2673.05	2674.78	2494.0
2011-07-01 07:00:00	NQ	Futures	2674.78	2675.64	2671.61	2672.76	2799.0
2011-07-01 08:00:00	NQ	Futures	2673.05	2677.08	2671.9	2672.19	4311.0
2011-07-01 09:00:00	NQ	Futures	2672.48	2678.81	2666.72	2677.08	23535.0
2011-07-01 10:00:00	NQ	Futures	2676.79	2694.06	2676.79	2691.47	58240.0
2011-07-01 11:00:00	NQ	Futures	2691.76	2700.96	2689.74	2698.38	28811.0
2011-07-01 12:00:00	NQ	Futures	2698.66	2704.42	2697.51	2702.69	20383.0
2011-07-01 13:00:00	NQ	Futures	2702.4	2712.19	2701.25	2711.04	26317.0
2011-07-01 14:00:00	NQ	Futures	2711.04	2716.22	2707.87	2715.35	20830.0
2011-07-01 15:00:00	NQ	Futures	2715.35	2716.79	2709.6	2713.34	28155.0
2011-07-01 16:00:00	NQ	Futures	2713.05	2717.37	2708.16	2709.6	10467.0
2011-07-01 00:00:00	YM	Futures	11948.1	11958.8	11948.1	11956.8	220.0
2011-07-01 01:00:00	YM	Futures	11957.8	11961.7	11952.0	11958.8	900.0
2011-07-01 02:00:00	YM	Futures	11959.7	11971.4	11956.8	11964.6	1862.0
2011-07-01 03:00:00	YM	Futures	11963.6	11969.4	11948.1	11953.9	2867.0
2011-07-01 04:00:00	YM	Futures	11953.9	11979.1	11951.0	11971.4	1595.0
2011-07-01 05:00:00	YM	Futures	11972.3	11981.0	11961.7	11971.4	1620.0
2011-07-01 06:00:00	YM	Futures	11969.4	11988.8	11969.4	11975.2	1878.0
2011-07-01 07:00:00	YM	Futures	11975.2	11980.1	11965.5	11971.4	2276.0
2011-07-01 08:00:00	YM	Futures	11970.4	11983.0	11965.5	11969.4	3927.0
2011-07-01 09:00:00	YM	Futures	11970.4	11982.0	11951.0	11978.1	14963.0
2011-07-01 10:00:00	YM	Futures	11979.1	12091.4	11978.1	12066.3	32595.0
2011-07-01 11:00:00	YM	Futures	12066.3	12088.5	12062.4	12080.8	11832.0
2011-07-01 12:00:00	YM	Futures	12080.8	12095.3	12075.0	12087.6	7708.0
2011-07-01 13:00:00	YM	Futures	12086.6	12119.5	12083.7	12109.8	10797.0
2011-07-01 14:00:00	YM	Futures	12109.8	12136.9	12101.1	12133.1	8627.0
2011-07-01 15:00:00	YM	Futures	12133.1	12137.9	12109.8	12123.4	13324.0

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

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