PREVIEW / futures_1hour / 2019-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-20.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
2019-01-20 18:00:00	ES	Futures	2899.71	2904.33	2897.54	2898.62	6612.0
2019-01-20 19:00:00	ES	Futures	2898.62	2899.71	2895.91	2898.08	7209.0
2019-01-20 20:00:00	ES	Futures	2897.81	2898.08	2890.47	2893.73	14539.0
2019-01-20 21:00:00	ES	Futures	2894.01	2897.81	2892.92	2896.72	8548.0
2019-01-20 22:00:00	ES	Futures	2896.45	2896.72	2893.73	2893.73	3792.0
2019-01-20 23:00:00	ES	Futures	2894.01	2896.72	2892.65	2896.45	4509.0
2019-01-20 18:00:00	NQ	Futures	7941.12	7941.12	7920.96	7924.76	2828.0
2019-01-20 19:00:00	NQ	Futures	7923.59	7930.31	7917.16	7920.96	4316.0
2019-01-20 20:00:00	NQ	Futures	7920.67	7921.84	7897.0	7909.27	7234.0
2019-01-20 21:00:00	NQ	Futures	7909.27	7924.17	7907.52	7918.92	5076.0
2019-01-20 22:00:00	NQ	Futures	7918.92	7920.38	7907.23	7908.98	2473.0
2019-01-20 23:00:00	NQ	Futures	7908.69	7916.87	7904.01	7916.58	1889.0
2019-01-20 18:00:00	YM	Futures	26806.1	26819.1	26754.0	26767.0	1792.0
2019-01-20 19:00:00	YM	Futures	26764.8	26775.7	26736.6	26755.1	1926.0
2019-01-20 20:00:00	YM	Futures	26754.0	26757.2	26687.8	26722.5	4160.0
2019-01-20 21:00:00	YM	Futures	26721.4	26764.8	26714.9	26756.2	2331.0
2019-01-20 22:00:00	YM	Futures	26756.2	26757.2	26719.2	26722.5	1354.0
2019-01-20 23:00:00	YM	Futures	26721.4	26741.0	26710.6	26741.0	1143.0
2019-01-20 18:00:00	CL	Futures	48.97	49.07	48.59	48.69	4840.0
2019-01-20 19:00:00	CL	Futures	48.7	48.86	48.62	48.78	4769.0
2019-01-20 20:00:00	CL	Futures	48.78	48.94	48.69	48.79	7311.0
2019-01-20 21:00:00	CL	Futures	48.79	49.24	48.79	49.16	11143.0
2019-01-20 22:00:00	CL	Futures	49.17	49.38	49.13	49.27	9592.0
2019-01-20 23:00:00	CL	Futures	49.28	49.29	49.23	49.27	3126.0
2019-01-20 18:00:00	GC	Futures	1659.1	1661.9	1658.9	1660.8	2559.0
2019-01-20 19:00:00	GC	Futures	1660.8	1662.1	1660.6	1661.9	2213.0
2019-01-20 20:00:00	GC	Futures	1661.8	1662.1	1660.4	1661.3	4306.0
2019-01-20 21:00:00	GC	Futures	1661.3	1661.5	1660.6	1660.8	2632.0
2019-01-20 22:00:00	GC	Futures	1660.9	1661.0	1659.3	1659.6	3016.0
2019-01-20 23:00:00	GC	Futures	1659.6	1660.1	1658.9	1659.2	1890.0
2019-01-20 18:00:00	ZN	Futures	122.069134	122.084875	122.053393	122.084875	7574.0
2019-01-20 19:00:00	ZN	Futures	122.084875	122.116356	122.069134	122.116356	9203.0
2019-01-20 20:00:00	ZN	Futures	122.100616	122.19506	122.100616	122.179319	20244.0
2019-01-20 21:00:00	ZN	Futures	122.179319	122.179319	122.069134	122.084875	10255.0
2019-01-20 22:00:00	ZN	Futures	122.084875	122.132097	122.084875	122.116356	2294.0
2019-01-20 23:00:00	ZN	Futures	122.132097	122.163578	122.132097	122.163578	5006.0

> showing 36 of 278 rows — these rows as CSV

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