PREVIEW / futures_1hour / 2011-09-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-18.parquet
  size:    14 KB
  rows:    259

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-09-18 18:00:00	ES	Futures	1202.89	1203.14	1198.12	1200.38	23111.0
2011-09-18 19:00:00	ES	Futures	1200.38	1201.13	1198.62	1199.88	7878.0
2011-09-18 20:00:00	ES	Futures	1199.88	1201.63	1198.87	1198.87	10177.0
2011-09-18 21:00:00	ES	Futures	1198.87	1200.13	1195.87	1197.12	14213.0
2011-09-18 22:00:00	ES	Futures	1196.87	1197.12	1194.86	1195.61	12788.0
2011-09-18 23:00:00	ES	Futures	1195.36	1197.62	1195.36	1197.12	5273.0
2011-09-18 18:00:00	NQ	Futures	2638.73	2638.73	2624.89	2630.94	2456.0
2011-09-18 19:00:00	NQ	Futures	2631.23	2633.25	2628.06	2630.08	587.0
2011-09-18 20:00:00	NQ	Futures	2629.79	2633.83	2628.92	2628.92	779.0
2011-09-18 21:00:00	NQ	Futures	2629.21	2630.37	2622.58	2625.46	1100.0
2011-09-18 22:00:00	NQ	Futures	2625.18	2625.46	2621.14	2622.29	893.0
2011-09-18 23:00:00	NQ	Futures	2622.58	2626.33	2622.0	2625.18	460.0
2011-09-18 18:00:00	YM	Futures	11175.7	11175.7	11127.5	11147.2	789.0
2011-09-18 19:00:00	YM	Futures	11148.2	11159.0	11133.4	11143.3	486.0
2011-09-18 20:00:00	YM	Futures	11149.2	11161.0	11140.3	11140.3	577.0
2011-09-18 21:00:00	YM	Futures	11140.3	11146.2	11114.7	11120.6	637.0
2011-09-18 22:00:00	YM	Futures	11117.7	11121.6	11107.8	11113.7	564.0
2011-09-18 23:00:00	YM	Futures	11110.8	11128.5	11110.8	11123.6	328.0
2011-09-18 18:00:00	CL	Futures	148.62	148.62	147.71	148.03	1836.0
2011-09-18 19:00:00	CL	Futures	148.06	148.08	147.76	147.93	579.0
2011-09-18 20:00:00	CL	Futures	148.05	148.2	147.86	148.03	446.0
2011-09-18 21:00:00	CL	Futures	148.06	148.06	147.24	147.25	1490.0
2011-09-18 22:00:00	CL	Futures	147.25	147.42	147.08	147.39	1058.0
2011-09-18 23:00:00	CL	Futures	147.32	147.49	147.0	147.22	637.0
2011-09-18 18:00:00	GC	Futures	2534.5	2552.5	2530.1	2543.9	4051.0
2011-09-18 19:00:00	GC	Futures	2543.6	2546.4	2539.5	2545.2	1283.0
2011-09-18 20:00:00	GC	Futures	2545.5	2547.1	2534.8	2535.2	1834.0
2011-09-18 21:00:00	GC	Futures	2535.2	2541.1	2531.7	2536.8	4554.0
2011-09-18 22:00:00	GC	Futures	2536.6	2546.1	2535.2	2546.1	2424.0
2011-09-18 23:00:00	GC	Futures	2546.1	2548.2	2541.9	2542.6	1873.0
2011-09-18 18:00:00	ZN	Futures	112.682265	112.790692	112.641605	112.750032	6171.0
2011-09-18 19:00:00	ZN	Futures	112.750032	112.804245	112.750032	112.777139	2162.0
2011-09-18 20:00:00	ZN	Futures	112.777139	112.804245	112.750032	112.750032	3203.0
2011-09-18 21:00:00	ZN	Futures	112.750032	112.912672	112.750032	112.885565	5704.0
2011-09-18 22:00:00	ZN	Futures	112.899118	112.899118	112.872012	112.872012	2105.0
2011-09-18 23:00:00	ZN	Futures	112.885565	112.885565	112.831352	112.844905	1138.0

> showing 36 of 259 rows — these rows as CSV

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