PREVIEW / futures_1hour / 2018-06-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	3020.02	3021.38	3019.74	3020.56	2498.0
2018-06-18 01:00:00	ES	Futures	3020.56	3021.65	3019.74	3021.38	3501.0
2018-06-18 02:00:00	ES	Futures	3021.38	3022.74	3020.02	3020.83	7666.0
2018-06-18 03:00:00	ES	Futures	3020.83	3024.1	3019.47	3019.74	14109.0
2018-06-18 04:00:00	ES	Futures	3019.74	3023.56	3018.93	3021.65	12826.0
2018-06-18 05:00:00	ES	Futures	3021.92	3022.47	3018.93	3021.65	12158.0
2018-06-18 06:00:00	ES	Futures	3021.65	3022.2	3015.11	3016.47	22018.0
2018-06-18 07:00:00	ES	Futures	3016.2	3017.29	3012.39	3012.66	21396.0
2018-06-18 08:00:00	ES	Futures	3012.66	3017.02	3011.84	3017.02	29289.0
2018-06-18 09:00:00	ES	Futures	3017.02	3017.84	3009.39	3015.66	157459.0
2018-06-18 10:00:00	ES	Futures	3015.38	3024.92	3013.48	3022.74	175774.0
2018-06-18 11:00:00	ES	Futures	3022.74	3027.65	3020.83	3021.65	106216.0
2018-06-18 12:00:00	ES	Futures	3021.65	3024.38	3019.47	3023.01	55490.0
2018-06-18 13:00:00	ES	Futures	3023.01	3026.56	3022.74	3025.19	52512.0
2018-06-18 14:00:00	ES	Futures	3024.92	3027.65	3022.47	3023.29	66000.0
2018-06-18 15:00:00	ES	Futures	3023.01	3028.74	3022.47	3027.37	125774.0
2018-06-18 16:00:00	ES	Futures	3027.37	3029.83	3027.1	3027.92	51889.0
2018-06-18 18:00:00	ES	Futures	3027.92	3030.1	3027.37	3027.37	3322.0
2018-06-18 19:00:00	ES	Futures	3027.65	3028.19	3011.3	3013.48	22685.0
2018-06-18 20:00:00	ES	Futures	3013.75	3015.93	3010.75	3015.11	22853.0
2018-06-18 21:00:00	ES	Futures	3015.11	3016.47	3004.76	3005.58	19183.0
2018-06-18 22:00:00	ES	Futures	3005.3	3006.94	3000.94	3005.58	21729.0
2018-06-18 23:00:00	ES	Futures	3005.3	3006.39	3000.13	3002.31	8881.0
2018-06-18 00:00:00	NQ	Futures	8524.29	8527.82	8522.23	8523.7	844.0
2018-06-18 01:00:00	NQ	Futures	8523.7	8527.53	8522.23	8526.64	1126.0
2018-06-18 02:00:00	NQ	Futures	8526.64	8527.23	8520.76	8521.93	2483.0
2018-06-18 03:00:00	NQ	Futures	8522.23	8534.89	8521.34	8525.47	4234.0
2018-06-18 04:00:00	NQ	Futures	8525.47	8536.36	8523.7	8530.18	3401.0
2018-06-18 05:00:00	NQ	Futures	8530.18	8533.71	8520.46	8532.24	2514.0
2018-06-18 06:00:00	NQ	Futures	8532.53	8532.83	8510.16	8512.81	4476.0
2018-06-18 07:00:00	NQ	Futures	8513.1	8517.81	8503.39	8503.39	5574.0
2018-06-18 08:00:00	NQ	Futures	8503.39	8518.4	8500.74	8518.11	6742.0
2018-06-18 09:00:00	NQ	Futures	8517.81	8531.65	8489.55	8519.28	55138.0
2018-06-18 10:00:00	NQ	Futures	8519.58	8564.62	8509.57	8558.74	57185.0
2018-06-18 11:00:00	NQ	Futures	8559.03	8574.34	8553.14	8555.2	31931.0
2018-06-18 12:00:00	NQ	Futures	8555.5	8562.86	8544.6	8553.14	16867.0
2018-06-18 13:00:00	NQ	Futures	8552.85	8570.22	8552.26	8564.04	18768.0
2018-06-18 14:00:00	NQ	Futures	8564.04	8569.33	8554.91	8559.91	22218.0
2018-06-18 15:00:00	NQ	Futures	8559.91	8572.87	8557.85	8566.98	27731.0
2018-06-18 16:00:00	NQ	Futures	8566.98	8570.81	8562.27	8565.8	7030.0
2018-06-18 18:00:00	NQ	Futures	8567.57	8572.28	8563.74	8564.33	986.0
2018-06-18 19:00:00	NQ	Futures	8564.92	8568.16	8509.86	8517.81	6695.0
2018-06-18 20:00:00	NQ	Futures	8518.11	8522.52	8506.92	8516.93	6968.0
2018-06-18 21:00:00	NQ	Futures	8516.93	8523.7	8487.49	8491.61	6668.0
2018-06-18 22:00:00	NQ	Futures	8491.31	8498.38	8466.29	8483.95	9743.0
2018-06-18 23:00:00	NQ	Futures	8483.95	8484.25	8469.23	8476.3	2237.0
2018-06-18 00:00:00	YM	Futures	27156.7	27173.0	27156.7	27162.2	842.0
2018-06-18 01:00:00	YM	Futures	27162.2	27174.1	27149.1	27168.7	1233.0
2018-06-18 02:00:00	YM	Futures	27168.7	27178.5	27155.7	27164.3	1987.0
2018-06-18 03:00:00	YM	Futures	27165.4	27188.3	27126.3	27129.6	3783.0

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

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