PREVIEW / futures_1hour / 2016-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-20.parquet
  size:    15 KB
  rows:    302

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-11-20 18:00:00	ES	Futures	2371.98	2374.16	2371.71	2373.35	5399.0
2016-11-20 19:00:00	ES	Futures	2373.62	2375.25	2370.9	2374.71	6793.0
2016-11-20 20:00:00	ES	Futures	2374.98	2375.25	2373.07	2374.98	5278.0
2016-11-20 21:00:00	ES	Futures	2374.98	2377.43	2374.71	2376.34	5680.0
2016-11-20 22:00:00	ES	Futures	2376.61	2378.51	2375.79	2377.97	6408.0
2016-11-20 23:00:00	ES	Futures	2377.7	2378.24	2376.61	2377.43	2019.0
2016-11-20 18:00:00	NQ	Futures	5744.14	5744.14	5735.49	5739.67	634.0
2016-11-20 19:00:00	NQ	Futures	5739.96	5742.95	5731.91	5742.65	1234.0
2016-11-20 20:00:00	NQ	Futures	5742.65	5743.84	5736.38	5741.75	862.0
2016-11-20 21:00:00	NQ	Futures	5742.65	5747.42	5741.46	5745.04	1138.0
2016-11-20 22:00:00	NQ	Futures	5745.33	5748.02	5742.65	5747.12	967.0
2016-11-20 23:00:00	NQ	Futures	5747.72	5748.32	5745.63	5747.72	580.0
2016-11-20 18:00:00	YM	Futures	20374.5	20383.2	20365.9	20379.9	1035.0
2016-11-20 19:00:00	YM	Futures	20379.9	20392.9	20363.7	20390.7	1407.0
2016-11-20 20:00:00	YM	Futures	20390.7	20392.9	20369.1	20376.7	2336.0
2016-11-20 21:00:00	YM	Futures	20377.8	20394.0	20376.7	20388.6	1289.0
2016-11-20 22:00:00	YM	Futures	20389.7	20400.5	20385.3	20397.2	1175.0
2016-11-20 23:00:00	YM	Futures	20398.3	20399.4	20387.5	20392.9	564.0
2016-11-20 18:00:00	CL	Futures	45.64	46.07	45.5	45.87	10829.0
2016-11-20 19:00:00	CL	Futures	45.87	45.93	45.82	45.9	3260.0
2016-11-20 20:00:00	CL	Futures	45.91	45.92	45.72	45.77	5297.0
2016-11-20 21:00:00	CL	Futures	45.77	45.91	45.77	45.89	3082.0
2016-11-20 22:00:00	CL	Futures	45.9	46.0	45.86	45.93	3436.0
2016-11-20 23:00:00	CL	Futures	45.93	46.04	45.9	46.02	2752.0
2016-11-20 18:00:00	GC	Futures	1633.4	1634.4	1630.9	1631.7	2347.0
2016-11-20 19:00:00	GC	Futures	1631.7	1636.3	1631.7	1634.2	5659.0
2016-11-20 20:00:00	GC	Futures	1634.2	1642.1	1634.2	1640.1	7687.0
2016-11-20 21:00:00	GC	Futures	1640.2	1641.1	1638.2	1639.2	3891.0
2016-11-20 22:00:00	GC	Futures	1639.4	1639.9	1636.8	1637.9	4028.0
2016-11-20 23:00:00	GC	Futures	1637.9	1638.4	1636.4	1637.8	2398.0
2016-11-20 18:00:00	ZN	Futures	122.972547	123.03385	122.911245	122.987873	15537.0
2016-11-20 19:00:00	ZN	Futures	122.987873	123.125803	122.972547	123.003198	27308.0
2016-11-20 20:00:00	ZN	Futures	123.003198	123.141129	122.972547	123.125803	17267.0
2016-11-20 21:00:00	ZN	Futures	123.125803	123.141129	123.064501	123.064501	5287.0
2016-11-20 22:00:00	ZN	Futures	123.079826	123.141129	123.049175	123.125803	12276.0
2016-11-20 23:00:00	ZN	Futures	123.125803	123.141129	123.095152	123.095152	5825.0

> showing 36 of 302 rows — these rows as CSV

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