PREVIEW / futures_1hour / 2011-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-31.parquet
  size:    14 KB
  rows:    265

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-31 18:00:00	ES	Futures	1302.89	1305.64	1298.65	1301.9	45580.0
2011-07-31 19:00:00	ES	Futures	1302.15	1304.39	1300.9	1301.65	14565.0
2011-07-31 20:00:00	ES	Futures	1301.9	1306.39	1301.65	1305.14	27151.0
2011-07-31 21:00:00	ES	Futures	1304.89	1306.14	1303.89	1305.14	10725.0
2011-07-31 22:00:00	ES	Futures	1305.14	1305.39	1303.14	1303.64	9541.0
2011-07-31 23:00:00	ES	Futures	1303.64	1305.39	1303.39	1305.14	5173.0
2011-07-31 18:00:00	NQ	Futures	2746.43	2755.06	2742.4	2749.6	2601.0
2011-07-31 19:00:00	NQ	Futures	2749.31	2752.76	2745.28	2745.86	434.0
2011-07-31 20:00:00	NQ	Futures	2746.72	2754.2	2746.43	2752.47	1221.0
2011-07-31 21:00:00	NQ	Futures	2752.19	2755.64	2750.46	2751.04	1007.0
2011-07-31 22:00:00	NQ	Futures	2750.75	2751.61	2747.3	2748.45	545.0
2011-07-31 23:00:00	NQ	Futures	2748.45	2752.19	2748.16	2751.61	177.0
2011-07-31 18:00:00	YM	Futures	11853.2	11874.5	11825.1	11856.1	3037.0
2011-07-31 19:00:00	YM	Futures	11854.2	11872.6	11843.5	11848.4	1144.0
2011-07-31 20:00:00	YM	Futures	11850.3	11891.9	11850.3	11877.4	1493.0
2011-07-31 21:00:00	YM	Futures	11878.4	11887.1	11868.7	11879.4	656.0
2011-07-31 22:00:00	YM	Futures	11880.3	11887.1	11856.1	11874.5	1714.0
2011-07-31 23:00:00	YM	Futures	11873.5	11881.3	11868.7	11881.3	236.0
2011-07-31 18:00:00	CL	Futures	164.14	165.67	164.1	165.12	3690.0
2011-07-31 19:00:00	CL	Futures	165.11	165.53	165.09	165.48	883.0
2011-07-31 20:00:00	CL	Futures	165.47	165.89	165.26	165.65	1465.0
2011-07-31 21:00:00	CL	Futures	165.67	166.0	165.59	165.84	1043.0
2011-07-31 22:00:00	CL	Futures	165.84	165.91	165.3	165.48	701.0
2011-07-31 23:00:00	CL	Futures	165.48	165.64	165.28	165.4	513.0
2011-07-31 18:00:00	GC	Futures	2259.1	2259.5	2239.6	2252.5	7176.0
2011-07-31 19:00:00	GC	Futures	2252.4	2253.2	2249.9	2252.7	1072.0
2011-07-31 20:00:00	GC	Futures	2252.9	2255.7	2243.9	2246.4	4759.0
2011-07-31 21:00:00	GC	Futures	2246.4	2250.3	2246.1	2249.5	2436.0
2011-07-31 22:00:00	GC	Futures	2249.5	2250.2	2247.1	2249.5	1511.0
2011-07-31 23:00:00	GC	Futures	2249.5	2252.5	2249.0	2251.8	1037.0
2011-07-31 18:00:00	ZN	Futures	108.015426	108.176864	108.001973	108.109599	7760.0
2011-07-31 19:00:00	ZN	Futures	108.109599	108.203771	108.096145	108.136505	5699.0
2011-07-31 20:00:00	ZN	Futures	108.136505	108.149958	107.880895	107.975067	21910.0
2011-07-31 21:00:00	ZN	Futures	107.975067	108.082692	107.948161	108.055786	10218.0
2011-07-31 22:00:00	ZN	Futures	108.055786	108.096145	108.042333	108.055786	4290.0
2011-07-31 23:00:00	ZN	Futures	108.069239	108.069239	107.975067	108.042333	6228.0

> showing 36 of 265 rows — these rows as CSV

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