PREVIEW / futures_1hour / 2019-01-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-01.parquet
  size:    16 KB
  rows:    315

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-01 18:00:00	ES	Futures	2724.54	2738.66	2722.64	2734.31	14934.0
2019-01-01 19:00:00	ES	Futures	2734.58	2738.93	2732.68	2734.86	6718.0
2019-01-01 20:00:00	ES	Futures	2735.4	2737.3	2721.55	2721.82	12656.0
2019-01-01 21:00:00	ES	Futures	2722.09	2722.64	2702.81	2708.51	24736.0
2019-01-01 22:00:00	ES	Futures	2708.24	2710.14	2704.71	2708.24	7110.0
2019-01-01 23:00:00	ES	Futures	2708.51	2708.78	2693.03	2700.09	12146.0
2019-01-01 18:00:00	NQ	Futures	7421.02	7456.38	7414.6	7448.49	5538.0
2019-01-01 19:00:00	NQ	Futures	7447.91	7463.98	7444.4	7454.33	3491.0
2019-01-01 20:00:00	NQ	Futures	7454.63	7462.22	7414.01	7415.77	6206.0
2019-01-01 21:00:00	NQ	Futures	7416.64	7418.4	7354.11	7371.06	11669.0
2019-01-01 22:00:00	NQ	Futures	7370.48	7373.11	7356.45	7367.55	4237.0
2019-01-01 23:00:00	NQ	Futures	7367.85	7369.31	7314.96	7336.58	6629.0
2019-01-01 18:00:00	YM	Futures	25318.7	25424.0	25285.0	25377.3	3079.0
2019-01-01 19:00:00	YM	Futures	25377.3	25420.7	25357.8	25388.2	1979.0
2019-01-01 20:00:00	YM	Futures	25390.3	25407.7	25264.4	25274.2	4269.0
2019-01-01 21:00:00	YM	Futures	25272.0	25279.6	25107.0	25158.0	8032.0
2019-01-01 22:00:00	YM	Futures	25158.0	25173.2	25126.5	25151.5	2757.0
2019-01-01 23:00:00	YM	Futures	25154.7	25156.9	25006.0	25077.7	4833.0
2019-01-01 18:00:00	CL	Futures	41.8	41.94	41.73	41.89	2915.0
2019-01-01 19:00:00	CL	Futures	41.88	41.91	41.76	41.87	3959.0
2019-01-01 20:00:00	CL	Futures	41.87	41.99	41.45	41.52	15809.0
2019-01-01 21:00:00	CL	Futures	41.51	41.62	41.24	41.36	13485.0
2019-01-01 22:00:00	CL	Futures	41.35	41.4	41.17	41.2	7411.0
2019-01-01 23:00:00	CL	Futures	41.19	41.21	40.95	41.06	11173.0
2019-01-01 18:00:00	GC	Futures	1664.6	1664.6	1661.8	1662.4	1778.0
2019-01-01 19:00:00	GC	Futures	1662.4	1663.3	1660.9	1661.0	2387.0
2019-01-01 20:00:00	GC	Futures	1661.0	1661.3	1659.2	1660.6	6518.0
2019-01-01 21:00:00	GC	Futures	1660.6	1664.4	1660.5	1664.4	5801.0
2019-01-01 22:00:00	GC	Futures	1664.4	1665.2	1663.6	1663.9	3257.0
2019-01-01 23:00:00	GC	Futures	1663.7	1666.2	1663.5	1665.9	3050.0
2019-01-01 18:00:00	ZN	Futures	122.714503	122.840428	122.714503	122.777466	8515.0
2019-01-01 19:00:00	ZN	Futures	122.777466	122.793206	122.761725	122.793206	3450.0
2019-01-01 20:00:00	ZN	Futures	122.777466	122.856169	122.777466	122.856169	5218.0
2019-01-01 21:00:00	ZN	Futures	122.856169	122.982095	122.840428	122.903391	9564.0
2019-01-01 22:00:00	ZN	Futures	122.903391	122.966354	122.903391	122.934873	3848.0
2019-01-01 23:00:00	ZN	Futures	122.950613	122.997835	122.934873	122.950613	3169.0

> showing 36 of 315 rows — these rows as CSV

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