PREVIEW / futures_1hour / 2018-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-21.parquet
  size:    57 KB
  rows:    1,712

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-21 00:00:00	ES	Futures	3030.37	3032.0	3029.83	3030.92	4623.0
2018-06-21 01:00:00	ES	Futures	3030.92	3033.09	3030.64	3031.46	5405.0
2018-06-21 02:00:00	ES	Futures	3031.46	3031.46	3025.74	3026.28	10721.0
2018-06-21 03:00:00	ES	Futures	3026.56	3030.1	3023.29	3023.29	18704.0
2018-06-21 04:00:00	ES	Futures	3023.29	3025.19	3017.29	3017.84	21478.0
2018-06-21 05:00:00	ES	Futures	3017.56	3018.11	3010.21	3011.3	42683.0
2018-06-21 06:00:00	ES	Futures	3011.57	3018.65	3010.75	3018.11	21136.0
2018-06-21 07:00:00	ES	Futures	3018.11	3020.02	3015.93	3020.02	23352.0
2018-06-21 08:00:00	ES	Futures	3020.02	3020.56	3014.84	3016.47	26772.0
2018-06-21 09:00:00	ES	Futures	3016.47	3019.47	3013.75	3014.29	110105.0
2018-06-21 10:00:00	ES	Futures	3014.29	3014.29	2997.4	3004.21	330185.0
2018-06-21 11:00:00	ES	Futures	3004.49	3011.84	3002.03	3008.85	161930.0
2018-06-21 12:00:00	ES	Futures	3008.85	3009.39	3000.4	3000.4	95563.0
2018-06-21 13:00:00	ES	Futures	3000.4	3007.48	2999.31	3007.21	81012.0
2018-06-21 14:00:00	ES	Futures	3007.21	3009.66	3001.76	3001.76	91843.0
2018-06-21 15:00:00	ES	Futures	3001.76	3004.76	2993.86	3000.4	301396.0
2018-06-21 16:00:00	ES	Futures	3000.13	3001.49	2997.95	2998.49	61458.0
2018-06-21 18:00:00	ES	Futures	2997.67	2999.58	2996.31	2999.58	4357.0
2018-06-21 19:00:00	ES	Futures	2999.58	3001.49	2998.22	2999.85	2721.0
2018-06-21 20:00:00	ES	Futures	2999.85	3003.12	2999.31	3003.12	6552.0
2018-06-21 21:00:00	ES	Futures	3003.12	3005.58	3001.49	3005.3	9743.0
2018-06-21 22:00:00	ES	Futures	3005.3	3006.94	3004.21	3006.67	7329.0
2018-06-21 23:00:00	ES	Futures	3006.94	3006.94	3002.85	3005.58	5132.0
2018-06-21 00:00:00	NQ	Futures	8654.13	8656.19	8645.88	8647.65	2022.0
2018-06-21 01:00:00	NQ	Futures	8647.65	8655.6	8645.88	8648.83	1914.0
2018-06-21 02:00:00	NQ	Futures	8649.12	8649.71	8631.75	8634.11	3348.0
2018-06-21 03:00:00	NQ	Futures	8633.81	8643.82	8622.62	8623.21	5002.0
2018-06-21 04:00:00	NQ	Futures	8623.21	8629.4	8609.96	8614.38	6099.0
2018-06-21 05:00:00	NQ	Futures	8614.09	8614.97	8586.41	8589.65	13143.0
2018-06-21 06:00:00	NQ	Futures	8589.65	8608.79	8583.76	8607.9	6855.0
2018-06-21 07:00:00	NQ	Futures	8607.31	8614.09	8604.08	8614.09	6133.0
2018-06-21 08:00:00	NQ	Futures	8614.38	8620.56	8599.66	8605.84	8814.0
2018-06-21 09:00:00	NQ	Futures	8605.84	8632.05	8594.07	8612.03	48419.0
2018-06-21 10:00:00	NQ	Futures	8611.73	8611.73	8520.46	8553.73	107592.0
2018-06-21 11:00:00	NQ	Futures	8553.73	8587.59	8544.31	8576.99	44079.0
2018-06-21 12:00:00	NQ	Futures	8576.7	8577.87	8530.18	8531.35	34872.0
2018-06-21 13:00:00	NQ	Futures	8531.06	8556.09	8528.12	8544.01	25830.0
2018-06-21 14:00:00	NQ	Futures	8544.01	8554.91	8531.06	8531.65	23066.0
2018-06-21 15:00:00	NQ	Futures	8531.65	8543.13	8510.16	8527.53	55110.0
2018-06-21 16:00:00	NQ	Futures	8527.23	8530.77	8512.22	8512.51	7838.0
2018-06-21 18:00:00	NQ	Futures	8512.22	8513.98	8505.15	8513.69	2352.0
2018-06-21 19:00:00	NQ	Futures	8513.98	8520.17	8509.27	8515.75	1227.0
2018-06-21 20:00:00	NQ	Futures	8516.05	8522.82	8512.51	8520.76	2685.0
2018-06-21 21:00:00	NQ	Futures	8520.76	8526.35	8514.57	8525.17	3654.0
2018-06-21 22:00:00	NQ	Futures	8525.17	8531.94	8522.82	8531.65	2670.0
2018-06-21 23:00:00	NQ	Futures	8531.65	8532.53	8519.28	8525.47	2290.0
2018-06-21 00:00:00	YM	Futures	26877.3	26904.5	26875.2	26891.5	1636.0
2018-06-21 01:00:00	YM	Futures	26891.5	26913.2	26886.0	26891.5	1963.0
2018-06-21 02:00:00	YM	Futures	26890.4	26890.4	26823.0	26826.2	3267.0
2018-06-21 03:00:00	YM	Futures	26826.2	26875.2	26802.3	26802.3	5202.0

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

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