PREVIEW / futures_1hour / 2011-08-21

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-21.parquet
  size:    14 KB
  rows:    262

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-08-21 18:00:00	ES	Futures	1119.33	1120.08	1108.61	1113.1	28868.0
2011-08-21 19:00:00	ES	Futures	1113.35	1116.59	1111.85	1115.84	7731.0
2011-08-21 20:00:00	ES	Futures	1115.84	1118.83	1113.6	1116.09	15841.0
2011-08-21 21:00:00	ES	Futures	1115.84	1127.06	1114.59	1126.07	24156.0
2011-08-21 22:00:00	ES	Futures	1126.32	1130.06	1122.57	1123.32	15984.0
2011-08-21 23:00:00	ES	Futures	1123.07	1123.57	1116.84	1119.33	11726.0
2011-08-21 18:00:00	NQ	Futures	2349.32	2349.32	2327.73	2334.93	1300.0
2011-08-21 19:00:00	NQ	Futures	2335.5	2341.26	2332.34	2340.97	423.0
2011-08-21 20:00:00	NQ	Futures	2340.68	2345.86	2334.93	2340.97	771.0
2011-08-21 21:00:00	NQ	Futures	2340.97	2363.99	2339.53	2361.98	1389.0
2011-08-21 22:00:00	NQ	Futures	2361.98	2368.31	2355.07	2355.36	1061.0
2011-08-21 23:00:00	NQ	Futures	2355.07	2357.09	2342.7	2347.88	825.0
2011-08-21 18:00:00	YM	Futures	10461.6	10461.6	10374.5	10402.5	1498.0
2011-08-21 19:00:00	YM	Futures	10401.6	10426.8	10392.9	10423.9	423.0
2011-08-21 20:00:00	YM	Futures	10424.8	10452.9	10410.3	10424.8	606.0
2011-08-21 21:00:00	YM	Futures	10426.8	10532.3	10416.1	10517.8	1090.0
2011-08-21 22:00:00	YM	Futures	10523.6	10543.9	10484.9	10488.7	790.0
2011-08-21 23:00:00	YM	Futures	10487.8	10493.6	10440.3	10454.8	646.0
2011-08-21 18:00:00	CL	Futures	139.39	140.27	138.29	138.76	3627.0
2011-08-21 19:00:00	CL	Futures	138.78	138.9	138.2	138.49	1458.0
2011-08-21 20:00:00	CL	Futures	138.51	139.62	138.27	138.91	2529.0
2011-08-21 21:00:00	CL	Futures	138.9	140.96	138.85	140.76	3056.0
2011-08-21 22:00:00	CL	Futures	140.76	141.22	140.23	140.3	1860.0
2011-08-21 23:00:00	CL	Futures	140.3	140.37	139.37	139.42	1657.0
2011-08-21 18:00:00	GC	Futures	2594.3	2616.7	2587.4	2610.7	7646.0
2011-08-21 19:00:00	GC	Futures	2610.7	2612.1	2594.4	2610.3	4881.0
2011-08-21 20:00:00	GC	Futures	2610.4	2620.7	2602.6	2616.0	7169.0
2011-08-21 21:00:00	GC	Futures	2615.9	2618.2	2601.5	2607.2	5983.0
2011-08-21 22:00:00	GC	Futures	2607.5	2612.4	2598.6	2602.3	4476.0
2011-08-21 23:00:00	GC	Futures	2602.3	2613.6	2602.3	2608.9	2999.0
2011-08-21 18:00:00	ZN	Futures	112.683673	112.777845	112.656767	112.737486	4624.0
2011-08-21 19:00:00	ZN	Futures	112.724033	112.750939	112.67022	112.71058	3581.0
2011-08-21 20:00:00	ZN	Futures	112.71058	112.71058	112.549142	112.629861	7278.0
2011-08-21 21:00:00	ZN	Futures	112.643314	112.67022	112.495329	112.535688	7088.0
2011-08-21 22:00:00	ZN	Futures	112.535688	112.576048	112.481876	112.535688	5862.0
2011-08-21 23:00:00	ZN	Futures	112.535688	112.576048	112.508782	112.535688	4794.0

> showing 36 of 262 rows — these rows as CSV

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