PREVIEW / futures_1hour / 2012-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-15.parquet
  size:    14 KB
  rows:    276

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-07-15 18:00:00	ES	Futures	1374.4	1374.91	1372.62	1372.88	6268.0
2012-07-15 19:00:00	ES	Futures	1372.88	1373.64	1372.62	1373.64	1885.0
2012-07-15 20:00:00	ES	Futures	1373.38	1373.38	1371.86	1372.11	4392.0
2012-07-15 21:00:00	ES	Futures	1371.86	1372.62	1371.35	1371.35	3652.0
2012-07-15 22:00:00	ES	Futures	1371.35	1372.11	1370.84	1372.11	3568.0
2012-07-15 23:00:00	ES	Futures	1371.86	1372.37	1371.6	1372.11	1665.0
2012-07-15 18:00:00	NQ	Futures	2988.42	2989.0	2983.79	2984.08	731.0
2012-07-15 19:00:00	NQ	Futures	2984.66	2985.53	2983.79	2985.24	216.0
2012-07-15 20:00:00	NQ	Futures	2985.24	2985.53	2982.34	2982.92	210.0
2012-07-15 21:00:00	NQ	Futures	2983.21	2983.5	2981.18	2981.76	459.0
2012-07-15 22:00:00	NQ	Futures	2981.76	2984.08	2979.44	2981.47	988.0
2012-07-15 23:00:00	NQ	Futures	2981.47	2983.21	2980.89	2982.34	110.0
2012-07-15 18:00:00	YM	Futures	12642.8	12646.8	12622.9	12625.9	357.0
2012-07-15 19:00:00	YM	Futures	12623.9	12637.9	12622.9	12637.9	199.0
2012-07-15 20:00:00	YM	Futures	12635.9	12635.9	12617.0	12618.0	293.0
2012-07-15 21:00:00	YM	Futures	12617.0	12622.0	12612.0	12614.0	319.0
2012-07-15 22:00:00	YM	Futures	12615.0	12618.0	12608.0	12616.0	299.0
2012-07-15 23:00:00	YM	Futures	12615.0	12619.0	12614.0	12615.0	129.0
2012-07-15 18:00:00	CL	Futures	143.71	144.08	143.71	143.97	181.0
2012-07-15 19:00:00	CL	Futures	143.97	144.0	143.63	143.71	45.0
2012-07-15 20:00:00	CL	Futures	143.64	143.64	143.0	143.0	174.0
2012-07-15 21:00:00	CL	Futures	143.0	143.13	142.94	143.02	211.0
2012-07-15 22:00:00	CL	Futures	142.98	143.08	142.8	143.08	144.0
2012-07-15 23:00:00	CL	Futures	143.0	143.44	143.0	143.21	160.0
2012-07-15 18:00:00	GC	Futures	2202.2	2203.8	2196.2	2203.2	726.0
2012-07-15 19:00:00	GC	Futures	2203.1	2203.5	2200.0	2200.9	298.0
2012-07-15 20:00:00	GC	Futures	2201.1	2201.1	2194.2	2195.2	1133.0
2012-07-15 21:00:00	GC	Futures	2194.9	2195.2	2191.0	2193.1	2404.0
2012-07-15 22:00:00	GC	Futures	2193.1	2195.0	2193.0	2194.1	1020.0
2012-07-15 23:00:00	GC	Futures	2193.9	2197.8	2193.4	2197.7	1285.0
2012-07-15 18:00:00	ZN	Futures	118.474737	118.48849	118.447229	118.48849	2019.0
2012-07-15 19:00:00	ZN	Futures	118.48849	118.48849	118.460983	118.474737	521.0
2012-07-15 20:00:00	ZN	Futures	118.474737	118.48849	118.433475	118.48849	2479.0
2012-07-15 21:00:00	ZN	Futures	118.474737	118.515998	118.474737	118.515998	1949.0
2012-07-15 22:00:00	ZN	Futures	118.502244	118.515998	118.48849	118.502244	1258.0
2012-07-15 23:00:00	ZN	Futures	118.48849	118.502244	118.48849	118.502244	143.0

> showing 36 of 276 rows — these rows as CSV

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