PREVIEW / futures_1hour / 2018-10-08

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-08.parquet
  size:    55 KB
  rows:    1,688

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-10-08 00:00:00	ES	Futures	3148.65	3150.83	3147.56	3149.47	4878.0
2018-10-08 01:00:00	ES	Futures	3149.47	3150.83	3148.11	3148.92	3088.0
2018-10-08 02:00:00	ES	Futures	3148.92	3149.47	3143.76	3143.76	7254.0
2018-10-08 03:00:00	ES	Futures	3144.03	3144.57	3139.13	3140.76	22820.0
2018-10-08 04:00:00	ES	Futures	3141.04	3142.67	3136.68	3136.68	19876.0
2018-10-08 05:00:00	ES	Futures	3136.68	3143.48	3136.14	3141.85	22246.0
2018-10-08 06:00:00	ES	Futures	3141.85	3143.21	3138.32	3140.22	14280.0
2018-10-08 07:00:00	ES	Futures	3139.95	3144.03	3139.4	3142.94	14901.0
2018-10-08 08:00:00	ES	Futures	3142.67	3143.48	3139.13	3139.95	20101.0
2018-10-08 09:00:00	ES	Futures	3139.95	3145.66	3131.24	3142.4	244197.0
2018-10-08 10:00:00	ES	Futures	3142.4	3147.56	3138.86	3141.04	176079.0
2018-10-08 11:00:00	ES	Futures	3140.76	3141.04	3118.19	3125.26	269560.0
2018-10-08 12:00:00	ES	Futures	3125.26	3129.61	3119.28	3119.55	183365.0
2018-10-08 13:00:00	ES	Futures	3119.28	3131.52	3118.73	3128.25	155911.0
2018-10-08 14:00:00	ES	Futures	3127.98	3145.12	3127.71	3141.31	198347.0
2018-10-08 15:00:00	ES	Futures	3141.31	3148.38	3140.49	3144.03	228824.0
2018-10-08 16:00:00	ES	Futures	3144.03	3148.65	3143.48	3147.02	68534.0
2018-10-08 18:00:00	ES	Futures	3146.75	3147.84	3145.93	3147.29	3932.0
2018-10-08 19:00:00	ES	Futures	3147.29	3147.84	3144.84	3145.66	4753.0
2018-10-08 20:00:00	ES	Futures	3145.39	3146.2	3143.48	3145.66	7763.0
2018-10-08 21:00:00	ES	Futures	3145.66	3147.29	3143.21	3145.12	9679.0
2018-10-08 22:00:00	ES	Futures	3144.84	3148.92	3144.3	3147.56	8454.0
2018-10-08 23:00:00	ES	Futures	3147.56	3147.56	3144.03	3145.12	6186.0
2018-10-08 00:00:00	NQ	Futures	8718.47	8724.92	8713.19	8720.52	2906.0
2018-10-08 01:00:00	NQ	Futures	8721.11	8729.03	8717.59	8722.58	2129.0
2018-10-08 02:00:00	NQ	Futures	8722.87	8724.63	8699.11	8699.7	3726.0
2018-10-08 03:00:00	NQ	Futures	8699.7	8702.34	8683.57	8688.26	9725.0
2018-10-08 04:00:00	NQ	Futures	8688.26	8694.12	8667.14	8668.02	9851.0
2018-10-08 05:00:00	NQ	Futures	8667.73	8696.76	8666.85	8692.36	7582.0
2018-10-08 06:00:00	NQ	Futures	8692.36	8699.4	8683.86	8690.31	5901.0
2018-10-08 07:00:00	NQ	Futures	8690.31	8710.84	8687.97	8705.56	6395.0
2018-10-08 08:00:00	NQ	Futures	8705.56	8707.32	8687.09	8690.9	8458.0
2018-10-08 09:00:00	NQ	Futures	8690.9	8708.79	8634.29	8699.4	79982.0
2018-10-08 10:00:00	NQ	Futures	8700.28	8727.86	8669.49	8684.15	69517.0
2018-10-08 11:00:00	NQ	Futures	8684.45	8685.62	8557.44	8604.96	104797.0
2018-10-08 12:00:00	NQ	Futures	8604.96	8612.58	8549.52	8552.16	74064.0
2018-10-08 13:00:00	NQ	Futures	8552.45	8616.4	8548.93	8596.16	64084.0
2018-10-08 14:00:00	NQ	Futures	8595.86	8668.02	8594.4	8650.71	60864.0
2018-10-08 15:00:00	NQ	Futures	8650.71	8675.65	8644.55	8654.53	59493.0
2018-10-08 16:00:00	NQ	Futures	8654.53	8675.35	8650.71	8672.71	12703.0
2018-10-08 18:00:00	NQ	Futures	8671.54	8674.18	8665.38	8670.66	1630.0
2018-10-08 19:00:00	NQ	Futures	8670.95	8671.25	8660.98	8664.79	1353.0
2018-10-08 20:00:00	NQ	Futures	8664.5	8669.78	8659.51	8668.31	2511.0
2018-10-08 21:00:00	NQ	Futures	8668.02	8672.42	8656.58	8665.09	3722.0
2018-10-08 22:00:00	NQ	Futures	8665.09	8680.34	8662.45	8676.53	3681.0
2018-10-08 23:00:00	NQ	Futures	8676.53	8676.53	8663.03	8668.02	3049.0
2018-10-08 00:00:00	YM	Futures	28780.6	28801.3	28773.0	28786.1	1100.0
2018-10-08 01:00:00	YM	Futures	28787.1	28801.3	28779.5	28785.0	997.0
2018-10-08 02:00:00	YM	Futures	28783.9	28792.6	28719.8	28719.8	2589.0
2018-10-08 03:00:00	YM	Futures	28719.8	28728.5	28670.9	28691.5	6086.0

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

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