PREVIEW / futures_1hour / 2010-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-27.parquet
  size:    12 KB
  rows:    228

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
2010-06-27 18:00:00	ES	Futures	1054.4	1057.59	1054.4	1055.62	8835.0
2010-06-27 19:00:00	ES	Futures	1055.38	1056.6	1055.13	1055.62	2137.0
2010-06-27 20:00:00	ES	Futures	1055.38	1056.11	1053.41	1054.64	9461.0
2010-06-27 21:00:00	ES	Futures	1054.64	1058.08	1053.41	1056.6	9010.0
2010-06-27 22:00:00	ES	Futures	1056.6	1058.57	1056.36	1057.83	3272.0
2010-06-27 23:00:00	ES	Futures	1057.59	1057.59	1056.36	1056.85	2582.0
2010-06-27 18:00:00	NQ	Futures	2107.98	2113.42	2107.41	2109.41	510.0
2010-06-27 19:00:00	NQ	Futures	2109.7	2111.99	2109.41	2110.56	100.0
2010-06-27 20:00:00	NQ	Futures	2110.27	2111.13	2106.26	2108.55	731.0
2010-06-27 21:00:00	NQ	Futures	2108.55	2114.0	2106.55	2111.71	654.0
2010-06-27 22:00:00	NQ	Futures	2111.99	2116.0	2111.71	2114.86	304.0
2010-06-27 23:00:00	NQ	Futures	2114.28	2114.28	2111.71	2112.56	130.0
2010-06-27 18:00:00	YM	Futures	9564.5	9588.2	9564.5	9574.9	227.0
2010-06-27 19:00:00	YM	Futures	9572.1	9579.7	9571.1	9573.0	134.0
2010-06-27 20:00:00	YM	Futures	9572.1	9575.9	9555.0	9562.6	728.0
2010-06-27 21:00:00	YM	Futures	9562.6	9581.6	9554.1	9571.1	1040.0
2010-06-27 22:00:00	YM	Futures	9571.1	9588.2	9571.1	9582.5	391.0
2010-06-27 23:00:00	YM	Futures	9581.6	9581.6	9570.2	9574.0	206.0
2010-06-27 18:00:00	CL	Futures	152.51	152.51	151.7	152.03	1873.0
2010-06-27 19:00:00	CL	Futures	152.03	152.41	152.01	152.3	499.0
2010-06-27 20:00:00	CL	Futures	152.28	153.24	152.08	153.01	1913.0
2010-06-27 21:00:00	CL	Futures	152.99	153.24	152.76	152.86	870.0
2010-06-27 22:00:00	CL	Futures	152.89	153.07	152.86	152.89	567.0
2010-06-27 23:00:00	CL	Futures	152.88	152.88	151.99	152.08	1202.0
2010-06-27 18:00:00	GC	Futures	1762.5	1763.6	1760.7	1763.1	539.0
2010-06-27 19:00:00	GC	Futures	1763.1	1763.8	1761.1	1763.5	416.0
2010-06-27 20:00:00	GC	Futures	1763.5	1767.7	1762.1	1767.0	1816.0
2010-06-27 21:00:00	GC	Futures	1767.1	1767.4	1764.2	1764.2	1226.0
2010-06-27 22:00:00	GC	Futures	1764.2	1765.6	1763.4	1763.9	895.0
2010-06-27 23:00:00	GC	Futures	1764.1	1764.3	1762.0	1763.6	862.0
2010-06-27 18:00:00	ZN	Futures	100.640228	100.66609	100.588505	100.588505	2323.0
2010-06-27 19:00:00	ZN	Futures	100.601436	100.640228	100.575574	100.640228	2359.0
2010-06-27 20:00:00	ZN	Futures	100.640228	100.653159	100.601436	100.614366	3605.0
2010-06-27 21:00:00	ZN	Futures	100.601436	100.627297	100.588505	100.614366	2816.0
2010-06-27 22:00:00	ZN	Futures	100.614366	100.627297	100.588505	100.601436	1745.0
2010-06-27 23:00:00	ZN	Futures	100.601436	100.614366	100.588505	100.614366	1225.0

> showing 36 of 228 rows — these rows as CSV

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