PREVIEW / futures_1hour / 2018-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-09.parquet
  size:    53 KB
  rows:    1,661

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-07-09 00:00:00	ES	Futures	3022.47	3023.01	3021.38	3021.65	2587.0
2018-07-09 01:00:00	ES	Futures	3021.65	3022.47	3020.29	3021.38	4494.0
2018-07-09 02:00:00	ES	Futures	3021.38	3022.47	3020.29	3021.11	6235.0
2018-07-09 03:00:00	ES	Futures	3021.38	3024.1	3020.29	3023.56	13003.0
2018-07-09 04:00:00	ES	Futures	3023.56	3023.83	3019.74	3019.74	11304.0
2018-07-09 05:00:00	ES	Futures	3019.74	3023.29	3019.2	3023.29	7079.0
2018-07-09 06:00:00	ES	Futures	3023.01	3024.1	3021.92	3023.29	6973.0
2018-07-09 07:00:00	ES	Futures	3023.29	3024.65	3021.11	3022.2	10209.0
2018-07-09 08:00:00	ES	Futures	3022.2	3023.01	3020.83	3021.11	13289.0
2018-07-09 09:00:00	ES	Futures	3021.38	3028.74	3021.38	3025.74	122343.0
2018-07-09 10:00:00	ES	Futures	3026.01	3030.1	3021.92	3029.83	155492.0
2018-07-09 11:00:00	ES	Futures	3030.1	3034.18	3028.74	3032.55	121041.0
2018-07-09 12:00:00	ES	Futures	3032.82	3035.82	3030.64	3032.82	106170.0
2018-07-09 13:00:00	ES	Futures	3032.82	3034.18	3029.01	3032.82	55177.0
2018-07-09 14:00:00	ES	Futures	3032.82	3036.09	3031.19	3035.27	50681.0
2018-07-09 15:00:00	ES	Futures	3035.55	3037.73	3032.28	3036.91	150003.0
2018-07-09 16:00:00	ES	Futures	3036.64	3038.54	3036.36	3037.73	63373.0
2018-07-09 18:00:00	ES	Futures	3038.0	3041.54	3036.64	3041.0	4824.0
2018-07-09 19:00:00	ES	Futures	3041.0	3042.9	3040.72	3041.81	3821.0
2018-07-09 20:00:00	ES	Futures	3041.81	3049.17	3041.0	3046.99	13927.0
2018-07-09 21:00:00	ES	Futures	3046.72	3047.26	3042.63	3042.9	11374.0
2018-07-09 22:00:00	ES	Futures	3043.18	3045.08	3042.63	3043.45	4992.0
2018-07-09 23:00:00	ES	Futures	3043.18	3044.81	3042.63	3043.18	3106.0
2018-07-09 00:00:00	NQ	Futures	8552.85	8554.91	8549.9	8550.79	1285.0
2018-07-09 01:00:00	NQ	Futures	8550.49	8550.49	8543.72	8545.78	2441.0
2018-07-09 02:00:00	NQ	Futures	8545.78	8549.61	8541.36	8544.6	2404.0
2018-07-09 03:00:00	NQ	Futures	8544.31	8557.26	8541.36	8556.09	4776.0
2018-07-09 04:00:00	NQ	Futures	8556.09	8556.97	8546.96	8547.84	3234.0
2018-07-09 05:00:00	NQ	Futures	8547.84	8557.56	8545.49	8554.32	2914.0
2018-07-09 06:00:00	NQ	Futures	8554.32	8560.21	8547.84	8551.96	2564.0
2018-07-09 07:00:00	NQ	Futures	8552.26	8555.79	8546.37	8551.38	2564.0
2018-07-09 08:00:00	NQ	Futures	8551.38	8563.74	8548.73	8557.85	6069.0
2018-07-09 09:00:00	NQ	Futures	8557.85	8575.81	8545.78	8554.02	43160.0
2018-07-09 10:00:00	NQ	Futures	8553.73	8556.97	8526.64	8550.49	60435.0
2018-07-09 11:00:00	NQ	Futures	8549.9	8564.04	8543.43	8559.62	33745.0
2018-07-09 12:00:00	NQ	Futures	8559.91	8566.39	8544.6	8551.38	20148.0
2018-07-09 13:00:00	NQ	Futures	8551.67	8564.62	8541.07	8563.15	17750.0
2018-07-09 14:00:00	NQ	Futures	8562.86	8578.17	8556.67	8574.63	12478.0
2018-07-09 15:00:00	NQ	Futures	8574.63	8594.65	8567.57	8592.89	26681.0
2018-07-09 16:00:00	NQ	Futures	8592.89	8601.13	8591.42	8600.54	8420.0
2018-07-09 18:00:00	NQ	Futures	8597.89	8612.32	8594.36	8609.67	2179.0
2018-07-09 19:00:00	NQ	Futures	8609.38	8616.44	8608.2	8612.61	1959.0
2018-07-09 20:00:00	NQ	Futures	8612.61	8638.82	8611.73	8633.52	4654.0
2018-07-09 21:00:00	NQ	Futures	8633.52	8635.58	8623.51	8624.69	3486.0
2018-07-09 22:00:00	NQ	Futures	8624.69	8631.16	8623.51	8625.86	1804.0
2018-07-09 23:00:00	NQ	Futures	8624.98	8630.28	8623.51	8626.75	1068.0
2018-07-09 00:00:00	YM	Futures	26733.8	26743.6	26728.4	26732.8	1643.0
2018-07-09 01:00:00	YM	Futures	26731.7	26738.2	26719.7	26733.8	1296.0
2018-07-09 02:00:00	YM	Futures	26732.8	26737.1	26705.6	26717.5	2222.0
2018-07-09 03:00:00	YM	Futures	26718.6	26737.1	26704.5	26729.5	2535.0

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

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