PREVIEW / futures_1hour / 2018-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-23.parquet
  size:    14 KB
  rows:    295

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-09-23 18:00:00	ES	Futures	3187.28	3187.82	3182.11	3184.28	14012.0
2018-09-23 19:00:00	ES	Futures	3184.01	3185.92	3182.92	3185.64	4442.0
2018-09-23 20:00:00	ES	Futures	3185.64	3185.64	3183.47	3183.47	2964.0
2018-09-23 21:00:00	ES	Futures	3183.47	3184.28	3180.48	3183.74	9236.0
2018-09-23 22:00:00	ES	Futures	3183.74	3185.64	3183.47	3185.37	3641.0
2018-09-23 23:00:00	ES	Futures	3185.1	3186.19	3185.1	3185.64	1815.0
2018-09-23 18:00:00	NQ	Futures	8846.06	8846.94	8815.85	8820.54	5585.0
2018-09-23 19:00:00	NQ	Futures	8819.96	8828.76	8812.04	8828.17	2458.0
2018-09-23 20:00:00	NQ	Futures	8828.17	8828.46	8818.2	8818.49	1762.0
2018-09-23 21:00:00	NQ	Futures	8818.2	8821.72	8807.64	8820.54	3733.0
2018-09-23 22:00:00	NQ	Futures	8820.25	8825.82	8817.61	8824.06	1385.0
2018-09-23 23:00:00	NQ	Futures	8824.06	8828.46	8822.6	8826.12	751.0
2018-09-23 18:00:00	YM	Futures	29019.7	29045.7	28965.3	28990.3	3472.0
2018-09-23 19:00:00	YM	Futures	28991.4	29011.0	28980.5	29006.6	987.0
2018-09-23 20:00:00	YM	Futures	29006.6	29007.7	28984.9	28986.0	1209.0
2018-09-23 21:00:00	YM	Futures	28984.9	28990.3	28955.6	28984.9	2583.0
2018-09-23 22:00:00	YM	Futures	28983.8	29005.5	28979.5	29002.3	844.0
2018-09-23 23:00:00	YM	Futures	29002.3	29012.1	28992.5	29009.9	578.0
2018-09-23 18:00:00	CL	Futures	65.53	66.01	65.53	65.84	8575.0
2018-09-23 19:00:00	CL	Futures	65.84	65.98	65.81	65.98	3146.0
2018-09-23 20:00:00	CL	Futures	65.98	65.98	65.86	65.88	3249.0
2018-09-23 21:00:00	CL	Futures	65.88	65.94	65.86	65.87	2457.0
2018-09-23 22:00:00	CL	Futures	65.88	65.93	65.84	65.91	2205.0
2018-09-23 23:00:00	CL	Futures	65.91	65.99	65.87	65.97	2256.0
2018-09-23 18:00:00	GC	Futures	1568.6	1569.0	1566.0	1566.2	1989.0
2018-09-23 19:00:00	GC	Futures	1566.3	1567.2	1565.2	1566.4	1944.0
2018-09-23 20:00:00	GC	Futures	1566.4	1566.9	1564.2	1564.7	3647.0
2018-09-23 21:00:00	GC	Futures	1564.7	1565.6	1563.9	1564.1	2722.0
2018-09-23 22:00:00	GC	Futures	1564.1	1564.7	1563.6	1563.6	2320.0
2018-09-23 23:00:00	GC	Futures	1563.7	1565.4	1563.6	1565.0	2586.0
2018-09-23 18:00:00	ZN	Futures	119.566641	119.58238	119.550903	119.550903	10745.0
2018-09-23 19:00:00	ZN	Futures	119.550903	119.550903	119.535164	119.550903	2574.0
2018-09-23 20:00:00	ZN	Futures	119.535164	119.566641	119.535164	119.550903	4725.0
2018-09-23 21:00:00	ZN	Futures	119.566641	119.566641	119.535164	119.550903	3939.0
2018-09-23 22:00:00	ZN	Futures	119.550903	119.550903	119.535164	119.535164	1723.0
2018-09-23 23:00:00	ZN	Futures	119.535164	119.550903	119.535164	119.550903	915.0

> showing 36 of 295 rows — these rows as CSV

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