PREVIEW / futures_1hour / 2016-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-06.parquet
  size:    14 KB
  rows:    278

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
2016-03-06 18:00:00	ES	Futures	2143.76	2144.03	2140.54	2141.34	7728.0
2016-03-06 19:00:00	ES	Futures	2141.34	2141.61	2138.92	2139.73	7678.0
2016-03-06 20:00:00	ES	Futures	2140.0	2143.76	2138.39	2142.69	9778.0
2016-03-06 21:00:00	ES	Futures	2142.95	2143.76	2138.92	2139.46	6959.0
2016-03-06 22:00:00	ES	Futures	2139.73	2142.95	2138.92	2142.15	4364.0
2016-03-06 23:00:00	ES	Futures	2142.42	2143.22	2140.54	2141.88	3130.0
2016-03-06 18:00:00	NQ	Futures	5132.16	5132.76	5118.21	5127.41	1859.0
2016-03-06 19:00:00	NQ	Futures	5126.82	5127.41	5119.39	5122.96	1347.0
2016-03-06 20:00:00	NQ	Futures	5122.07	5131.86	5117.31	5130.38	1191.0
2016-03-06 21:00:00	NQ	Futures	5130.08	5131.57	5117.31	5119.39	1222.0
2016-03-06 22:00:00	NQ	Futures	5119.39	5128.0	5117.31	5127.11	499.0
2016-03-06 23:00:00	NQ	Futures	5127.11	5128.0	5122.36	5125.03	350.0
2016-03-06 18:00:00	YM	Futures	18066.3	18067.4	18042.9	18052.5	1398.0
2016-03-06 19:00:00	YM	Futures	18051.4	18051.4	18029.1	18040.8	1027.0
2016-03-06 20:00:00	YM	Futures	18039.7	18065.3	18026.9	18061.0	1185.0
2016-03-06 21:00:00	YM	Futures	18062.1	18066.3	18029.1	18034.4	1018.0
2016-03-06 22:00:00	YM	Futures	18034.4	18057.8	18026.9	18054.6	555.0
2016-03-06 23:00:00	YM	Futures	18054.6	18059.9	18044.0	18051.4	376.0
2016-03-06 18:00:00	CL	Futures	41.84	42.18	41.84	41.93	4911.0
2016-03-06 19:00:00	CL	Futures	41.91	42.15	41.82	42.12	4653.0
2016-03-06 20:00:00	CL	Futures	42.13	42.45	41.91	42.28	6087.0
2016-03-06 21:00:00	CL	Futures	42.27	42.34	42.17	42.24	3068.0
2016-03-06 22:00:00	CL	Futures	42.24	42.35	42.19	42.34	1901.0
2016-03-06 23:00:00	CL	Futures	42.34	42.37	42.25	42.3	1308.0
2016-03-06 18:00:00	GC	Futures	1720.7	1726.4	1718.5	1726.2	3115.0
2016-03-06 19:00:00	GC	Futures	1726.3	1728.9	1723.8	1728.8	4220.0
2016-03-06 20:00:00	GC	Futures	1728.8	1732.9	1721.8	1724.0	9308.0
2016-03-06 21:00:00	GC	Futures	1724.0	1724.1	1716.5	1722.5	7784.0
2016-03-06 22:00:00	GC	Futures	1722.3	1723.2	1719.1	1721.1	3505.0
2016-03-06 23:00:00	GC	Futures	1720.8	1722.6	1719.5	1720.6	1604.0
2016-03-06 18:00:00	ZN	Futures	125.723413	125.723413	125.723413	125.723413	1.0
2016-03-06 19:00:00	ZN	Futures	125.662772	125.662772	125.602131	125.602131	112.0
2016-03-06 20:00:00	ZN	Futures	125.632452	125.632452	125.51117	125.51117	50.0
2016-03-06 21:00:00	ZN	Futures	125.556651	125.556651	125.541491	125.541491	11.0
2016-03-06 22:00:00	ZN	Futures	125.617292	125.617292	125.602131	125.602131	90.0
2016-03-06 23:00:00	ZN	Futures	125.617292	125.617292	125.617292	125.617292	1.0

> showing 36 of 278 rows — these rows as CSV

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