PREVIEW / futures_1hour / 2018-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-08.parquet
  size:    53 KB
  rows:    1,665

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-08 00:00:00	ES	Futures	3117.56	3117.83	3115.38	3115.65	2816.0
2018-08-08 01:00:00	ES	Futures	3115.92	3117.01	3115.65	3115.65	3070.0
2018-08-08 02:00:00	ES	Futures	3115.65	3115.92	3112.93	3114.02	7330.0
2018-08-08 03:00:00	ES	Futures	3114.29	3117.01	3114.02	3116.74	10339.0
2018-08-08 04:00:00	ES	Futures	3116.74	3117.01	3114.56	3116.47	7668.0
2018-08-08 05:00:00	ES	Futures	3116.47	3117.29	3115.11	3116.47	6220.0
2018-08-08 06:00:00	ES	Futures	3116.74	3118.1	3116.2	3117.83	8022.0
2018-08-08 07:00:00	ES	Futures	3117.83	3118.65	3116.47	3116.47	8006.0
2018-08-08 08:00:00	ES	Futures	3116.74	3117.01	3111.57	3112.93	23586.0
2018-08-08 09:00:00	ES	Futures	3112.65	3115.11	3110.2	3111.84	109703.0
2018-08-08 10:00:00	ES	Futures	3111.57	3116.47	3109.39	3116.2	121212.0
2018-08-08 11:00:00	ES	Futures	3116.2	3118.1	3114.02	3114.56	72401.0
2018-08-08 12:00:00	ES	Futures	3114.56	3116.47	3112.11	3114.56	52308.0
2018-08-08 13:00:00	ES	Futures	3114.29	3117.56	3113.74	3117.01	40521.0
2018-08-08 14:00:00	ES	Futures	3117.29	3118.1	3115.92	3116.74	40427.0
2018-08-08 15:00:00	ES	Futures	3116.74	3119.74	3114.02	3114.56	119646.0
2018-08-08 16:00:00	ES	Futures	3114.83	3115.38	3108.84	3109.93	65763.0
2018-08-08 18:00:00	ES	Futures	3109.93	3111.84	3109.11	3111.57	4247.0
2018-08-08 19:00:00	ES	Futures	3111.29	3111.84	3110.48	3111.57	1788.0
2018-08-08 20:00:00	ES	Futures	3111.29	3111.84	3109.39	3110.48	5105.0
2018-08-08 21:00:00	ES	Futures	3110.48	3112.93	3109.11	3112.65	7165.0
2018-08-08 22:00:00	ES	Futures	3112.65	3115.11	3112.65	3114.56	6440.0
2018-08-08 23:00:00	ES	Futures	3114.29	3115.38	3114.02	3114.29	2150.0
2018-08-08 00:00:00	NQ	Futures	8806.64	8809.87	8795.74	8797.8	1184.0
2018-08-08 01:00:00	NQ	Futures	8797.8	8802.22	8797.21	8798.98	910.0
2018-08-08 02:00:00	NQ	Futures	8798.69	8801.04	8790.15	8793.39	2027.0
2018-08-08 03:00:00	NQ	Futures	8793.39	8803.99	8792.21	8802.22	2346.0
2018-08-08 04:00:00	NQ	Futures	8802.51	8804.28	8797.51	8802.81	1763.0
2018-08-08 05:00:00	NQ	Futures	8802.81	8806.34	8796.63	8802.51	1455.0
2018-08-08 06:00:00	NQ	Futures	8802.81	8808.11	8801.34	8806.93	1855.0
2018-08-08 07:00:00	NQ	Futures	8806.93	8810.17	8799.86	8800.75	2298.0
2018-08-08 08:00:00	NQ	Futures	8800.45	8801.04	8778.08	8783.38	9462.0
2018-08-08 09:00:00	NQ	Futures	8783.08	8797.8	8764.83	8788.09	52231.0
2018-08-08 10:00:00	NQ	Futures	8787.79	8827.83	8781.61	8823.12	51766.0
2018-08-08 11:00:00	NQ	Futures	8823.12	8824.6	8798.69	8800.16	32895.0
2018-08-08 12:00:00	NQ	Futures	8799.86	8813.41	8791.91	8805.75	22648.0
2018-08-08 13:00:00	NQ	Futures	8805.46	8811.94	8800.16	8811.05	12313.0
2018-08-08 14:00:00	NQ	Futures	8811.35	8821.36	8804.28	8814.0	13996.0
2018-08-08 15:00:00	NQ	Futures	8814.0	8823.71	8805.16	8806.34	22320.0
2018-08-08 16:00:00	NQ	Futures	8805.75	8808.11	8786.62	8788.68	9827.0
2018-08-08 18:00:00	NQ	Futures	8789.56	8797.21	8786.62	8795.15	994.0
2018-08-08 19:00:00	NQ	Futures	8795.15	8796.92	8792.5	8795.45	538.0
2018-08-08 20:00:00	NQ	Futures	8795.45	8795.45	8783.97	8787.5	2389.0
2018-08-08 21:00:00	NQ	Futures	8787.5	8796.33	8784.26	8795.45	1948.0
2018-08-08 22:00:00	NQ	Futures	8795.74	8806.93	8795.74	8804.57	2202.0
2018-08-08 23:00:00	NQ	Futures	8804.57	8806.93	8801.63	8802.51	875.0
2018-08-08 00:00:00	YM	Futures	27860.1	27861.2	27828.6	27831.9	693.0
2018-08-08 01:00:00	YM	Futures	27831.9	27844.9	27830.8	27838.4	676.0
2018-08-08 02:00:00	YM	Futures	27837.3	27837.3	27805.8	27819.9	1690.0
2018-08-08 03:00:00	YM	Futures	27819.9	27846.0	27816.6	27838.4	1928.0

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

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