PREVIEW / futures_1hour / 2012-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-23.parquet
  size:    14 KB
  rows:    271

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
2012-09-23 18:00:00	ES	Futures	1481.94	1485.52	1481.94	1484.5	4759.0
2012-09-23 19:00:00	ES	Futures	1484.5	1485.01	1484.24	1484.76	1511.0
2012-09-23 20:00:00	ES	Futures	1484.5	1485.27	1483.73	1483.73	4516.0
2012-09-23 21:00:00	ES	Futures	1483.73	1483.99	1479.39	1480.41	13490.0
2012-09-23 22:00:00	ES	Futures	1480.16	1481.94	1479.65	1480.67	8522.0
2012-09-23 23:00:00	ES	Futures	1480.67	1482.97	1479.13	1482.46	10572.0
2012-09-23 18:00:00	NQ	Futures	3314.9	3321.0	3313.44	3318.96	642.0
2012-09-23 19:00:00	NQ	Futures	3319.25	3319.54	3318.38	3319.54	217.0
2012-09-23 20:00:00	NQ	Futures	3319.25	3320.13	3317.51	3317.51	360.0
2012-09-23 21:00:00	NQ	Futures	3317.22	3317.8	3307.34	3309.08	1631.0
2012-09-23 22:00:00	NQ	Futures	3309.08	3312.28	3307.92	3310.54	1136.0
2012-09-23 23:00:00	NQ	Futures	3310.83	3317.22	3307.63	3316.35	1544.0
2012-09-23 18:00:00	YM	Futures	13496.9	13515.0	13486.9	13508.0	574.0
2012-09-23 19:00:00	YM	Futures	13510.0	13513.0	13507.0	13512.0	177.0
2012-09-23 20:00:00	YM	Futures	13513.0	13519.0	13508.0	13508.0	450.0
2012-09-23 21:00:00	YM	Futures	13507.0	13507.0	13472.9	13478.9	1943.0
2012-09-23 22:00:00	YM	Futures	13476.9	13490.9	13472.9	13481.9	761.0
2012-09-23 23:00:00	YM	Futures	13481.9	13497.9	13469.9	13495.9	975.0
2012-09-23 18:00:00	CL	Futures	151.99	151.99	151.42	151.52	621.0
2012-09-23 19:00:00	CL	Futures	151.55	151.63	151.47	151.53	262.0
2012-09-23 20:00:00	CL	Futures	151.52	151.52	150.75	150.92	1756.0
2012-09-23 21:00:00	CL	Futures	150.92	150.92	149.71	149.89	3889.0
2012-09-23 22:00:00	CL	Futures	149.85	150.15	149.77	150.02	1253.0
2012-09-23 23:00:00	CL	Futures	150.03	150.34	149.99	150.23	961.0
2012-09-23 18:00:00	GC	Futures	2448.3	2449.1	2445.9	2446.5	1020.0
2012-09-23 19:00:00	GC	Futures	2446.3	2446.5	2444.9	2444.9	852.0
2012-09-23 20:00:00	GC	Futures	2444.9	2445.4	2435.3	2436.8	6262.0
2012-09-23 21:00:00	GC	Futures	2436.7	2436.8	2426.9	2431.0	11076.0
2012-09-23 22:00:00	GC	Futures	2430.9	2433.6	2428.1	2431.7	3187.0
2012-09-23 23:00:00	GC	Futures	2431.3	2435.0	2430.5	2434.3	2393.0
2012-09-23 18:00:00	ZN	Futures	117.7437	117.7437	117.688245	117.715973	2904.0
2012-09-23 19:00:00	ZN	Futures	117.715973	117.771427	117.715973	117.7437	2008.0
2012-09-23 20:00:00	ZN	Futures	117.7437	117.7437	117.702109	117.729836	2137.0
2012-09-23 21:00:00	ZN	Futures	117.729836	117.840745	117.715973	117.840745	10624.0
2012-09-23 22:00:00	ZN	Futures	117.826882	117.840745	117.785291	117.813018	4054.0
2012-09-23 23:00:00	ZN	Futures	117.813018	117.826882	117.757563	117.771427	3770.0

> showing 36 of 271 rows — these rows as CSV

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