PREVIEW / futures_1hour / 2018-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-07.parquet
  size:    52 KB
  rows:    1,664

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-08-07 00:00:00	ES	Futures	3108.57	3108.84	3107.75	3108.02	1728.0
2018-08-07 01:00:00	ES	Futures	3107.75	3108.84	3107.75	3108.84	2364.0
2018-08-07 02:00:00	ES	Futures	3108.84	3113.2	3108.57	3111.29	10378.0
2018-08-07 03:00:00	ES	Futures	3111.57	3113.47	3111.02	3113.2	12104.0
2018-08-07 04:00:00	ES	Futures	3113.47	3115.38	3111.84	3114.02	12781.0
2018-08-07 05:00:00	ES	Futures	3114.02	3114.56	3112.11	3112.93	8799.0
2018-08-07 06:00:00	ES	Futures	3112.65	3113.74	3111.57	3113.2	7922.0
2018-08-07 07:00:00	ES	Futures	3113.2	3113.74	3111.57	3111.84	8409.0
2018-08-07 08:00:00	ES	Futures	3111.57	3113.2	3111.57	3112.65	10864.0
2018-08-07 09:00:00	ES	Futures	3112.93	3117.29	3112.38	3116.74	122582.0
2018-08-07 10:00:00	ES	Futures	3116.74	3121.1	3115.38	3117.29	133821.0
2018-08-07 11:00:00	ES	Futures	3117.56	3119.74	3114.83	3117.83	85806.0
2018-08-07 12:00:00	ES	Futures	3117.83	3120.56	3117.29	3119.47	54655.0
2018-08-07 13:00:00	ES	Futures	3119.47	3120.28	3115.92	3119.19	52659.0
2018-08-07 14:00:00	ES	Futures	3118.92	3120.28	3117.29	3119.19	52815.0
2018-08-07 15:00:00	ES	Futures	3118.92	3119.74	3114.56	3115.65	102869.0
2018-08-07 16:00:00	ES	Futures	3115.92	3118.38	3115.38	3117.83	58299.0
2018-08-07 18:00:00	ES	Futures	3117.56	3117.83	3115.38	3115.65	3110.0
2018-08-07 19:00:00	ES	Futures	3115.65	3116.74	3115.38	3115.92	2304.0
2018-08-07 20:00:00	ES	Futures	3115.65	3118.38	3115.65	3116.74	4715.0
2018-08-07 21:00:00	ES	Futures	3116.74	3118.38	3115.92	3117.01	4948.0
2018-08-07 22:00:00	ES	Futures	3117.29	3117.56	3116.2	3117.01	2316.0
2018-08-07 23:00:00	ES	Futures	3117.01	3118.1	3117.01	3117.83	1954.0
2018-08-07 00:00:00	NQ	Futures	8781.61	8785.44	8780.73	8782.79	827.0
2018-08-07 01:00:00	NQ	Futures	8782.49	8784.55	8780.73	8784.55	945.0
2018-08-07 02:00:00	NQ	Futures	8784.55	8802.51	8783.67	8794.27	3873.0
2018-08-07 03:00:00	NQ	Futures	8794.27	8800.16	8790.74	8794.56	3225.0
2018-08-07 04:00:00	NQ	Futures	8794.86	8802.22	8792.5	8798.39	2928.0
2018-08-07 05:00:00	NQ	Futures	8798.1	8799.57	8791.91	8793.09	1986.0
2018-08-07 06:00:00	NQ	Futures	8793.39	8798.39	8787.5	8791.91	2929.0
2018-08-07 07:00:00	NQ	Futures	8792.5	8794.86	8786.32	8787.2	2295.0
2018-08-07 08:00:00	NQ	Futures	8786.62	8792.21	8786.32	8791.03	3915.0
2018-08-07 09:00:00	NQ	Futures	8791.03	8816.94	8777.49	8799.57	52700.0
2018-08-07 10:00:00	NQ	Futures	8799.28	8815.47	8778.37	8783.38	49981.0
2018-08-07 11:00:00	NQ	Futures	8783.67	8796.63	8774.25	8791.33	34720.0
2018-08-07 12:00:00	NQ	Futures	8791.33	8812.23	8788.97	8807.52	19966.0
2018-08-07 13:00:00	NQ	Futures	8808.11	8809.58	8791.91	8808.11	20407.0
2018-08-07 14:00:00	NQ	Futures	8808.11	8813.7	8798.1	8804.87	16520.0
2018-08-07 15:00:00	NQ	Futures	8805.16	8807.81	8793.98	8798.69	26238.0
2018-08-07 16:00:00	NQ	Futures	8798.69	8810.46	8798.1	8809.58	7783.0
2018-08-07 18:00:00	NQ	Futures	8806.93	8808.11	8798.98	8800.16	1230.0
2018-08-07 19:00:00	NQ	Futures	8800.45	8804.28	8798.69	8802.22	1135.0
2018-08-07 20:00:00	NQ	Futures	8802.81	8810.76	8801.93	8806.05	1354.0
2018-08-07 21:00:00	NQ	Futures	8805.75	8811.05	8803.1	8807.81	1371.0
2018-08-07 22:00:00	NQ	Futures	8807.22	8807.81	8798.69	8802.22	1497.0
2018-08-07 23:00:00	NQ	Futures	8801.93	8809.29	8801.34	8806.93	679.0
2018-08-07 00:00:00	YM	Futures	27729.7	27735.1	27719.9	27723.1	495.0
2018-08-07 01:00:00	YM	Futures	27723.1	27732.9	27717.7	27731.8	719.0
2018-08-07 02:00:00	YM	Futures	27730.7	27775.3	27729.7	27762.3	2682.0
2018-08-07 03:00:00	YM	Futures	27763.4	27777.5	27752.5	27774.2	2036.0

> showing 50 of 1,664 rows — these rows as CSV

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