PREVIEW / futures_1hour / 2018-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-07.parquet
  size:    55 KB
  rows:    1,666

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-07 00:00:00	ES	Futures	3028.46	3029.01	3028.19	3028.19	1658.0
2018-06-07 01:00:00	ES	Futures	3028.19	3029.55	3028.19	3029.55	2577.0
2018-06-07 02:00:00	ES	Futures	3029.55	3033.37	3028.73	3032.01	10072.0
2018-06-07 03:00:00	ES	Futures	3032.01	3034.46	3029.83	3032.55	16781.0
2018-06-07 04:00:00	ES	Futures	3032.55	3033.1	3027.64	3027.64	15742.0
2018-06-07 05:00:00	ES	Futures	3027.64	3029.55	3027.1	3028.73	7690.0
2018-06-07 06:00:00	ES	Futures	3028.46	3030.1	3026.28	3030.1	11046.0
2018-06-07 07:00:00	ES	Futures	3030.1	3031.19	3027.1	3028.46	10416.0
2018-06-07 08:00:00	ES	Futures	3028.46	3030.64	3027.64	3029.01	13429.0
2018-06-07 09:00:00	ES	Futures	3029.01	3034.19	3027.37	3031.46	131364.0
2018-06-07 10:00:00	ES	Futures	3031.74	3033.92	3019.18	3025.73	220227.0
2018-06-07 11:00:00	ES	Futures	3025.73	3030.37	3022.18	3024.37	134518.0
2018-06-07 12:00:00	ES	Futures	3024.37	3028.46	3020.27	3023.28	90733.0
2018-06-07 13:00:00	ES	Futures	3023.28	3024.09	3012.9	3014.54	169279.0
2018-06-07 14:00:00	ES	Futures	3014.82	3024.64	3012.9	3022.46	135227.0
2018-06-07 15:00:00	ES	Futures	3022.46	3026.28	3018.09	3023.55	181622.0
2018-06-07 16:00:00	ES	Futures	3023.82	3029.01	3023.28	3027.1	68870.0
2018-06-07 18:00:00	ES	Futures	3024.91	3026.55	3024.37	3025.19	2947.0
2018-06-07 19:00:00	ES	Futures	3025.19	3027.37	3023.55	3026.55	2008.0
2018-06-07 20:00:00	ES	Futures	3026.82	3028.19	3024.64	3027.64	3803.0
2018-06-07 21:00:00	ES	Futures	3027.91	3029.28	3025.73	3025.73	4322.0
2018-06-07 22:00:00	ES	Futures	3026.0	3026.55	3024.09	3025.19	2932.0
2018-06-07 23:00:00	ES	Futures	3025.46	3025.73	3022.73	3023.28	2514.0
2018-06-07 00:00:00	NQ	Futures	8541.77	8542.95	8539.4	8540.58	706.0
2018-06-07 01:00:00	NQ	Futures	8540.29	8541.77	8537.92	8540.88	892.0
2018-06-07 02:00:00	NQ	Futures	8540.58	8551.81	8537.04	8546.49	3327.0
2018-06-07 03:00:00	NQ	Futures	8546.79	8550.63	8542.06	8543.83	3696.0
2018-06-07 04:00:00	NQ	Futures	8543.83	8545.9	8532.01	8532.9	4455.0
2018-06-07 05:00:00	NQ	Futures	8532.9	8538.81	8530.54	8532.9	2506.0
2018-06-07 06:00:00	NQ	Futures	8533.49	8534.08	8524.33	8530.83	3418.0
2018-06-07 07:00:00	NQ	Futures	8531.13	8534.08	8519.6	8525.51	3339.0
2018-06-07 08:00:00	NQ	Futures	8525.51	8529.65	8518.12	8522.26	5251.0
2018-06-07 09:00:00	NQ	Futures	8522.26	8529.65	8502.16	8511.62	43173.0
2018-06-07 10:00:00	NQ	Futures	8511.62	8515.76	8435.08	8464.34	82792.0
2018-06-07 11:00:00	NQ	Futures	8464.34	8480.59	8446.9	8459.61	45183.0
2018-06-07 12:00:00	NQ	Futures	8459.9	8472.32	8431.83	8443.35	35411.0
2018-06-07 13:00:00	NQ	Futures	8443.35	8448.08	8412.91	8422.07	47619.0
2018-06-07 14:00:00	NQ	Futures	8422.07	8464.04	8414.69	8453.4	37587.0
2018-06-07 15:00:00	NQ	Futures	8453.4	8467.29	8441.58	8457.54	39893.0
2018-06-07 16:00:00	NQ	Futures	8457.54	8469.06	8450.74	8466.11	9525.0
2018-06-07 18:00:00	NQ	Futures	8464.04	8464.93	8457.54	8459.02	854.0
2018-06-07 19:00:00	NQ	Futures	8459.02	8463.45	8451.63	8461.09	989.0
2018-06-07 20:00:00	NQ	Futures	8461.38	8464.93	8453.7	8462.27	956.0
2018-06-07 21:00:00	NQ	Futures	8462.86	8464.93	8452.22	8452.81	855.0
2018-06-07 22:00:00	NQ	Futures	8453.4	8454.29	8441.28	8446.01	1599.0
2018-06-07 23:00:00	NQ	Futures	8446.31	8448.08	8440.69	8445.13	886.0
2018-06-07 00:00:00	YM	Futures	27336.3	27342.8	27333.0	27334.1	510.0
2018-06-07 01:00:00	YM	Futures	27334.1	27341.7	27331.9	27341.7	653.0
2018-06-07 02:00:00	YM	Futures	27341.7	27410.1	27336.3	27394.9	4632.0
2018-06-07 03:00:00	YM	Futures	27396.0	27422.1	27375.4	27398.2	3510.0

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

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