PREVIEW / futures_1hour / 2018-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-15.parquet
  size:    48 KB
  rows:    1,391

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-15 00:00:00	ES	Futures	3037.45	3038.54	3037.18	3038.0	2304.0
2018-06-15 01:00:00	ES	Futures	3037.73	3039.09	3037.45	3038.0	3559.0
2018-06-15 02:00:00	ES	Futures	3038.27	3039.09	3035.27	3035.82	8917.0
2018-06-15 03:00:00	ES	Futures	3036.09	3036.36	3024.65	3026.56	39104.0
2018-06-15 04:00:00	ES	Futures	3026.83	3028.19	3022.74	3026.01	24895.0
2018-06-15 05:00:00	ES	Futures	3026.28	3029.01	3024.92	3026.28	15931.0
2018-06-15 06:00:00	ES	Futures	3026.01	3027.65	3021.11	3027.1	26773.0
2018-06-15 07:00:00	ES	Futures	3027.1	3032.28	3026.28	3029.83	21792.0
2018-06-15 08:00:00	ES	Futures	3029.83	3030.92	3021.38	3023.01	69895.0
2018-06-15 09:00:00	ES	Futures	3023.01	3029.55	3020.29	3026.56	265222.0
2018-06-15 10:00:00	ES	Futures	3026.83	3028.46	3014.02	3023.83	235146.0
2018-06-15 11:00:00	ES	Futures	3023.83	3027.1	3019.74	3024.92	134796.0
2018-06-15 12:00:00	ES	Futures	3024.92	3027.37	3021.92	3027.1	54622.0
2018-06-15 13:00:00	ES	Futures	3027.1	3028.19	3023.29	3023.83	63160.0
2018-06-15 14:00:00	ES	Futures	3024.1	3038.0	3023.29	3035.0	149259.0
2018-06-15 15:00:00	ES	Futures	3035.0	3035.27	3030.1	3035.0	205916.0
2018-06-15 16:00:00	ES	Futures	3035.0	3037.18	3030.64	3031.46	102726.0
2018-06-15 00:00:00	NQ	Futures	8611.44	8614.38	8609.96	8611.44	813.0
2018-06-15 01:00:00	NQ	Futures	8611.73	8615.56	8608.79	8613.79	1330.0
2018-06-15 02:00:00	NQ	Futures	8614.09	8616.15	8601.72	8605.84	2935.0
2018-06-15 03:00:00	NQ	Futures	8606.14	8608.2	8583.76	8594.36	7044.0
2018-06-15 04:00:00	NQ	Futures	8594.36	8597.3	8580.52	8586.12	6412.0
2018-06-15 05:00:00	NQ	Futures	8586.71	8595.24	8585.82	8591.12	4124.0
2018-06-15 06:00:00	NQ	Futures	8591.71	8593.77	8575.52	8587.88	5866.0
2018-06-15 07:00:00	NQ	Futures	8589.94	8607.31	8577.87	8599.66	7480.0
2018-06-15 08:00:00	NQ	Futures	8599.37	8602.9	8562.56	8569.63	18126.0
2018-06-15 09:00:00	NQ	Futures	8569.92	8584.35	8532.24	8561.09	86323.0
2018-06-15 10:00:00	NQ	Futures	8560.8	8575.52	8537.24	8562.86	57919.0
2018-06-15 11:00:00	NQ	Futures	8562.56	8570.81	8549.02	8562.56	36315.0
2018-06-15 12:00:00	NQ	Futures	8562.27	8580.23	8558.74	8578.76	16082.0
2018-06-15 13:00:00	NQ	Futures	8578.76	8579.34	8561.97	8564.33	15115.0
2018-06-15 14:00:00	NQ	Futures	8564.62	8589.65	8559.91	8581.7	29326.0
2018-06-15 15:00:00	NQ	Futures	8581.7	8582.58	8566.1	8575.81	37153.0
2018-06-15 16:00:00	NQ	Futures	8575.81	8580.82	8566.68	8569.92	11636.0
2018-06-15 00:00:00	YM	Futures	27376.3	27385.0	27373.1	27378.5	470.0
2018-06-15 01:00:00	YM	Futures	27379.6	27392.6	27374.2	27390.5	986.0
2018-06-15 02:00:00	YM	Futures	27391.6	27399.2	27350.3	27355.7	1822.0
2018-06-15 03:00:00	YM	Futures	27355.7	27360.0	27239.4	27254.6	9031.0
2018-06-15 04:00:00	YM	Futures	27254.6	27273.1	27226.3	27254.6	4632.0
2018-06-15 05:00:00	YM	Futures	27256.8	27282.8	27238.3	27251.3	3628.0
2018-06-15 06:00:00	YM	Futures	27250.2	27255.7	27200.2	27248.1	4762.0
2018-06-15 07:00:00	YM	Futures	27250.2	27294.8	27242.6	27268.7	3676.0
2018-06-15 08:00:00	YM	Futures	27268.7	27277.4	27175.2	27193.7	11973.0
2018-06-15 09:00:00	YM	Futures	27192.6	27263.3	27166.5	27241.5	43419.0
2018-06-15 10:00:00	YM	Futures	27240.4	27256.8	27078.5	27148.0	41999.0
2018-06-15 11:00:00	YM	Futures	27147.0	27176.3	27098.0	27144.8	24923.0
2018-06-15 12:00:00	YM	Futures	27144.8	27164.3	27116.5	27154.6	10761.0
2018-06-15 13:00:00	YM	Futures	27155.7	27172.0	27135.0	27145.9	10391.0
2018-06-15 14:00:00	YM	Futures	27145.9	27345.9	27144.8	27318.7	29163.0
2018-06-15 15:00:00	YM	Futures	27318.7	27318.7	27247.0	27299.2	22450.0

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

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