PREVIEW / futures_1hour / 2018-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-21.parquet
  size:    15 KB
  rows:    303

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
2018-01-21 18:00:00	ES	Futures	3065.65	3071.39	3063.46	3069.47	16052.0
2018-01-21 19:00:00	ES	Futures	3069.47	3070.29	3067.83	3069.75	6498.0
2018-01-21 20:00:00	ES	Futures	3069.47	3071.11	3068.38	3070.84	6979.0
2018-01-21 21:00:00	ES	Futures	3070.84	3072.75	3069.75	3070.29	6245.0
2018-01-21 22:00:00	ES	Futures	3070.29	3070.57	3069.47	3070.02	2104.0
2018-01-21 23:00:00	ES	Futures	3070.02	3070.02	3068.65	3069.2	2185.0
2018-01-21 18:00:00	NQ	Futures	8103.84	8118.97	8096.13	8112.45	4057.0
2018-01-21 19:00:00	NQ	Futures	8112.15	8113.63	8104.44	8112.74	1927.0
2018-01-21 20:00:00	NQ	Futures	8112.74	8114.23	8104.14	8112.15	2270.0
2018-01-21 21:00:00	NQ	Futures	8112.74	8118.67	8110.67	8112.15	1678.0
2018-01-21 22:00:00	NQ	Futures	8112.15	8113.63	8108.59	8110.96	797.0
2018-01-21 23:00:00	NQ	Futures	8110.96	8114.23	8109.18	8112.15	731.0
2018-01-21 18:00:00	YM	Futures	28238.2	28287.1	28198.0	28261.1	3615.0
2018-01-21 19:00:00	YM	Futures	28262.1	28269.8	28253.5	28263.2	1821.0
2018-01-21 20:00:00	YM	Futures	28263.2	28278.4	28253.5	28277.4	1218.0
2018-01-21 21:00:00	YM	Futures	28276.3	28296.9	28270.8	28274.1	1309.0
2018-01-21 22:00:00	YM	Futures	28274.1	28278.4	28267.6	28273.0	625.0
2018-01-21 23:00:00	YM	Futures	28273.0	28276.3	28262.1	28269.8	447.0
2018-01-21 18:00:00	CL	Futures	56.39	56.42	56.16	56.32	5651.0
2018-01-21 19:00:00	CL	Futures	56.31	56.43	56.26	56.35	4420.0
2018-01-21 20:00:00	CL	Futures	56.36	56.4	56.27	56.39	6775.0
2018-01-21 21:00:00	CL	Futures	56.39	56.45	56.35	56.41	4139.0
2018-01-21 22:00:00	CL	Futures	56.4	56.44	56.37	56.42	2125.0
2018-01-21 23:00:00	CL	Futures	56.41	56.43	56.34	56.35	2283.0
2018-01-21 18:00:00	GC	Futures	1771.6	1774.0	1768.5	1772.2	7929.0
2018-01-21 19:00:00	GC	Futures	1772.2	1772.5	1770.1	1770.7	5473.0
2018-01-21 20:00:00	GC	Futures	1770.7	1771.6	1767.2	1767.7	9219.0
2018-01-21 21:00:00	GC	Futures	1767.7	1769.5	1766.4	1768.4	9740.0
2018-01-21 22:00:00	GC	Futures	1768.3	1768.4	1767.1	1767.7	3579.0
2018-01-21 23:00:00	GC	Futures	1767.6	1768.1	1766.7	1768.1	4052.0
2018-01-21 18:00:00	ZN	Futures	122.022536	122.022536	121.788657	121.851025	46098.0
2018-01-21 19:00:00	ZN	Futures	121.866616	121.882208	121.804249	121.835433	24858.0
2018-01-21 20:00:00	ZN	Futures	121.835433	121.866616	121.835433	121.851025	17689.0
2018-01-21 21:00:00	ZN	Futures	121.851025	121.866616	121.819841	121.835433	11128.0
2018-01-21 22:00:00	ZN	Futures	121.835433	121.8978	121.835433	121.8978	11374.0
2018-01-21 23:00:00	ZN	Futures	121.8978	121.97576	121.882208	121.960168	26366.0

> showing 36 of 303 rows — these rows as CSV

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