PREVIEW / futures_1hour / 2018-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-20.parquet
  size:    54 KB
  rows:    1,669

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-06-20 00:00:00	ES	Futures	3017.02	3017.29	3015.11	3016.75	2937.0
2018-06-20 01:00:00	ES	Futures	3016.47	3024.38	3016.47	3022.47	14695.0
2018-06-20 02:00:00	ES	Futures	3022.2	3022.74	3018.93	3020.29	10829.0
2018-06-20 03:00:00	ES	Futures	3020.29	3025.19	3020.02	3023.83	21577.0
2018-06-20 04:00:00	ES	Futures	3023.83	3024.38	3021.11	3023.01	12600.0
2018-06-20 05:00:00	ES	Futures	3022.74	3025.74	3022.74	3024.92	12043.0
2018-06-20 06:00:00	ES	Futures	3024.92	3025.74	3023.56	3024.1	8715.0
2018-06-20 07:00:00	ES	Futures	3024.1	3024.1	3019.47	3021.38	16873.0
2018-06-20 08:00:00	ES	Futures	3021.38	3024.38	3020.83	3023.83	19336.0
2018-06-20 09:00:00	ES	Futures	3024.1	3025.74	3021.11	3023.83	163118.0
2018-06-20 10:00:00	ES	Futures	3023.56	3024.92	3015.66	3020.02	158664.0
2018-06-20 11:00:00	ES	Futures	3019.74	3023.83	3016.47	3023.29	109731.0
2018-06-20 12:00:00	ES	Futures	3023.29	3027.92	3022.47	3026.56	90377.0
2018-06-20 13:00:00	ES	Futures	3026.56	3027.1	3023.01	3026.56	52565.0
2018-06-20 14:00:00	ES	Futures	3026.56	3027.1	3019.47	3020.56	77377.0
2018-06-20 15:00:00	ES	Futures	3020.29	3024.38	3018.93	3020.02	164562.0
2018-06-20 16:00:00	ES	Futures	3020.02	3021.65	3018.93	3019.74	47199.0
2018-06-20 18:00:00	ES	Futures	3020.83	3022.74	3018.93	3021.11	5066.0
2018-06-20 19:00:00	ES	Futures	3021.11	3023.83	3021.11	3023.29	2186.0
2018-06-20 20:00:00	ES	Futures	3023.29	3026.28	3022.2	3023.56	5093.0
2018-06-20 21:00:00	ES	Futures	3023.83	3035.0	3023.29	3033.64	13481.0
2018-06-20 22:00:00	ES	Futures	3033.91	3035.55	3031.19	3033.09	12481.0
2018-06-20 23:00:00	ES	Futures	3033.09	3034.18	3029.28	3030.1	8163.0
2018-06-20 00:00:00	NQ	Futures	8546.37	8549.9	8541.66	8548.73	1447.0
2018-06-20 01:00:00	NQ	Futures	8548.73	8567.27	8547.25	8562.27	5231.0
2018-06-20 02:00:00	NQ	Futures	8561.97	8561.97	8551.96	8552.55	3231.0
2018-06-20 03:00:00	NQ	Futures	8552.55	8564.92	8551.96	8561.68	5166.0
2018-06-20 04:00:00	NQ	Futures	8561.68	8563.74	8555.5	8561.09	3262.0
2018-06-20 05:00:00	NQ	Futures	8561.09	8571.69	8561.09	8569.33	2854.0
2018-06-20 06:00:00	NQ	Futures	8569.33	8571.69	8563.74	8567.86	2183.0
2018-06-20 07:00:00	NQ	Futures	8568.16	8568.45	8556.38	8561.39	3844.0
2018-06-20 08:00:00	NQ	Futures	8561.09	8587.0	8559.62	8582.29	8300.0
2018-06-20 09:00:00	NQ	Futures	8581.99	8604.66	8577.28	8598.19	57820.0
2018-06-20 10:00:00	NQ	Futures	8597.89	8607.31	8573.46	8603.49	57933.0
2018-06-20 11:00:00	NQ	Futures	8603.19	8616.44	8591.42	8616.15	31239.0
2018-06-20 12:00:00	NQ	Futures	8615.85	8634.7	8614.38	8628.51	28956.0
2018-06-20 13:00:00	NQ	Futures	8628.22	8631.16	8617.91	8629.4	16086.0
2018-06-20 14:00:00	NQ	Futures	8629.4	8640.0	8608.79	8611.44	22613.0
2018-06-20 15:00:00	NQ	Futures	8611.44	8618.5	8600.84	8604.37	35966.0
2018-06-20 16:00:00	NQ	Futures	8604.37	8615.56	8602.31	8613.2	8225.0
2018-06-20 18:00:00	NQ	Futures	8614.97	8619.09	8611.44	8616.74	1443.0
2018-06-20 19:00:00	NQ	Futures	8616.74	8624.69	8616.44	8622.92	1240.0
2018-06-20 20:00:00	NQ	Futures	8622.62	8631.16	8619.68	8624.39	2491.0
2018-06-20 21:00:00	NQ	Futures	8624.69	8656.78	8623.8	8655.89	5796.0
2018-06-20 22:00:00	NQ	Futures	8655.89	8665.9	8651.48	8662.37	4450.0
2018-06-20 23:00:00	NQ	Futures	8662.67	8665.02	8653.54	8654.13	3273.0
2018-06-20 00:00:00	YM	Futures	26905.6	26908.9	26888.2	26905.6	1374.0
2018-06-20 01:00:00	YM	Futures	26905.6	27024.1	26904.5	27012.1	6597.0
2018-06-20 02:00:00	YM	Futures	27010.0	27010.0	26955.6	26963.2	3494.0
2018-06-20 03:00:00	YM	Futures	26963.2	27012.1	26958.9	26994.8	4579.0

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

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