PREVIEW / futures_1hour / 2012-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-30.parquet
  size:    14 KB
  rows:    277

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-30 18:00:00	ES	Futures	1464.06	1465.08	1461.76	1462.02	8646.0
2012-09-30 19:00:00	ES	Futures	1462.02	1462.27	1459.98	1461.51	7549.0
2012-09-30 20:00:00	ES	Futures	1461.51	1466.11	1461.51	1465.34	11903.0
2012-09-30 21:00:00	ES	Futures	1465.34	1465.6	1461.0	1461.76	9382.0
2012-09-30 22:00:00	ES	Futures	1461.51	1461.51	1458.95	1459.98	8022.0
2012-09-30 23:00:00	ES	Futures	1460.23	1461.51	1459.21	1459.98	3688.0
2012-09-30 18:00:00	NQ	Futures	3241.67	3243.12	3235.28	3236.73	1361.0
2012-09-30 19:00:00	NQ	Futures	3237.02	3237.02	3230.92	3234.99	1087.0
2012-09-30 20:00:00	NQ	Futures	3234.99	3243.7	3234.7	3243.12	1280.0
2012-09-30 21:00:00	NQ	Futures	3243.12	3243.12	3233.82	3235.57	879.0
2012-09-30 22:00:00	NQ	Futures	3235.28	3235.28	3231.21	3232.95	879.0
2012-09-30 23:00:00	NQ	Futures	3233.53	3236.15	3231.21	3232.66	414.0
2012-09-30 18:00:00	YM	Futures	13355.9	13367.9	13339.9	13346.9	1001.0
2012-09-30 19:00:00	YM	Futures	13345.9	13346.9	13329.9	13340.9	541.0
2012-09-30 20:00:00	YM	Futures	13342.9	13373.9	13341.9	13370.9	1176.0
2012-09-30 21:00:00	YM	Futures	13369.9	13369.9	13336.9	13341.9	899.0
2012-09-30 22:00:00	YM	Futures	13341.9	13341.9	13319.9	13330.9	800.0
2012-09-30 23:00:00	YM	Futures	13329.9	13340.9	13325.9	13328.9	686.0
2012-09-30 18:00:00	CL	Futures	150.31	150.36	149.41	149.71	1260.0
2012-09-30 19:00:00	CL	Futures	149.72	149.72	149.17	149.25	922.0
2012-09-30 20:00:00	CL	Futures	149.25	149.54	149.2	149.54	913.0
2012-09-30 21:00:00	CL	Futures	149.54	149.54	149.27	149.32	863.0
2012-09-30 22:00:00	CL	Futures	149.32	149.32	148.93	149.04	1260.0
2012-09-30 23:00:00	CL	Futures	149.04	149.12	148.86	149.06	842.0
2012-09-30 18:00:00	GC	Futures	2446.9	2447.0	2442.1	2443.2	1328.0
2012-09-30 19:00:00	GC	Futures	2443.4	2443.7	2437.8	2439.2	2035.0
2012-09-30 20:00:00	GC	Futures	2439.2	2440.4	2437.2	2440.3	2316.0
2012-09-30 21:00:00	GC	Futures	2440.4	2440.4	2436.4	2438.5	1391.0
2012-09-30 22:00:00	GC	Futures	2438.2	2438.3	2435.8	2436.9	1079.0
2012-09-30 23:00:00	GC	Futures	2436.9	2438.0	2436.1	2437.6	1207.0
2012-09-30 18:00:00	ZN	Futures	118.423017	118.506199	118.423017	118.492335	2050.0
2012-09-30 19:00:00	ZN	Futures	118.492335	118.603244	118.492335	118.561653	5853.0
2012-09-30 20:00:00	ZN	Futures	118.561653	118.575517	118.464608	118.492335	5849.0
2012-09-30 21:00:00	ZN	Futures	118.492335	118.561653	118.492335	118.54779	6567.0
2012-09-30 22:00:00	ZN	Futures	118.533926	118.561653	118.506199	118.54779	2562.0
2012-09-30 23:00:00	ZN	Futures	118.54779	118.58938	118.506199	118.575517	2512.0

> showing 36 of 277 rows — these rows as CSV

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