PREVIEW / futures_1hour / 2018-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-01.parquet
  size:    54 KB
  rows:    1,693

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-08-01 00:00:00	ES	Futures	3068.52	3070.15	3067.7	3069.88	3418.0
2018-08-01 01:00:00	ES	Futures	3069.88	3070.15	3068.79	3069.88	4640.0
2018-08-01 02:00:00	ES	Futures	3069.88	3075.05	3069.88	3072.06	11689.0
2018-08-01 03:00:00	ES	Futures	3072.06	3073.69	3068.79	3071.24	20798.0
2018-08-01 04:00:00	ES	Futures	3071.24	3072.6	3068.52	3069.06	14061.0
2018-08-01 05:00:00	ES	Futures	3068.79	3069.61	3065.79	3066.61	9446.0
2018-08-01 06:00:00	ES	Futures	3066.88	3070.97	3066.34	3066.88	9753.0
2018-08-01 07:00:00	ES	Futures	3066.88	3070.7	3066.61	3070.42	12663.0
2018-08-01 08:00:00	ES	Futures	3070.42	3073.42	3069.33	3073.15	23124.0
2018-08-01 09:00:00	ES	Futures	3073.15	3076.14	3070.97	3074.51	140266.0
2018-08-01 10:00:00	ES	Futures	3073.96	3079.69	3071.79	3076.42	129698.0
2018-08-01 11:00:00	ES	Futures	3076.69	3076.96	3065.79	3066.88	130086.0
2018-08-01 12:00:00	ES	Futures	3067.15	3067.43	3060.34	3064.16	128610.0
2018-08-01 13:00:00	ES	Futures	3064.16	3065.79	3060.34	3063.34	57692.0
2018-08-01 14:00:00	ES	Futures	3063.07	3067.7	3057.62	3067.43	121278.0
2018-08-01 15:00:00	ES	Futures	3067.43	3070.15	3064.7	3066.34	123215.0
2018-08-01 16:00:00	ES	Futures	3066.06	3067.43	3060.61	3066.61	71347.0
2018-08-01 18:00:00	ES	Futures	3066.88	3067.97	3065.79	3067.15	3800.0
2018-08-01 19:00:00	ES	Futures	3067.15	3067.43	3065.52	3066.88	3030.0
2018-08-01 20:00:00	ES	Futures	3066.61	3067.97	3065.52	3066.88	3620.0
2018-08-01 21:00:00	ES	Futures	3067.15	3067.7	3064.43	3064.7	7236.0
2018-08-01 22:00:00	ES	Futures	3064.43	3065.79	3061.98	3063.07	6287.0
2018-08-01 23:00:00	ES	Futures	3062.79	3063.88	3059.52	3059.8	7538.0
2018-08-01 00:00:00	NQ	Futures	8551.08	8559.03	8549.9	8557.26	1398.0
2018-08-01 01:00:00	NQ	Futures	8557.85	8559.91	8552.26	8556.38	1459.0
2018-08-01 02:00:00	NQ	Futures	8556.38	8573.16	8556.38	8563.45	3381.0
2018-08-01 03:00:00	NQ	Futures	8563.45	8566.98	8543.13	8554.02	4753.0
2018-08-01 04:00:00	NQ	Futures	8554.32	8558.74	8546.96	8551.08	2956.0
2018-08-01 05:00:00	NQ	Futures	8550.79	8554.32	8543.13	8546.96	2545.0
2018-08-01 06:00:00	NQ	Futures	8546.96	8558.15	8544.31	8546.08	3379.0
2018-08-01 07:00:00	NQ	Futures	8546.08	8557.85	8543.72	8556.09	3954.0
2018-08-01 08:00:00	NQ	Futures	8555.79	8559.62	8547.84	8558.44	7793.0
2018-08-01 09:00:00	NQ	Futures	8558.15	8583.47	8541.66	8579.93	66811.0
2018-08-01 10:00:00	NQ	Futures	8579.05	8601.43	8564.62	8583.47	60619.0
2018-08-01 11:00:00	NQ	Futures	8583.76	8588.18	8545.78	8552.85	45271.0
2018-08-01 12:00:00	NQ	Futures	8552.85	8566.68	8541.07	8559.03	38906.0
2018-08-01 13:00:00	NQ	Futures	8558.44	8564.92	8546.96	8555.79	15553.0
2018-08-01 14:00:00	NQ	Futures	8555.79	8577.28	8527.53	8564.62	43603.0
2018-08-01 15:00:00	NQ	Futures	8564.62	8582.29	8558.15	8575.81	28857.0
2018-08-01 16:00:00	NQ	Futures	8575.81	8581.7	8558.15	8580.52	11737.0
2018-08-01 18:00:00	NQ	Futures	8578.46	8587.0	8578.46	8582.29	1539.0
2018-08-01 19:00:00	NQ	Futures	8582.29	8585.23	8579.05	8582.58	1081.0
2018-08-01 20:00:00	NQ	Futures	8582.58	8589.06	8579.93	8585.23	1707.0
2018-08-01 21:00:00	NQ	Futures	8585.82	8587.0	8573.46	8574.63	2290.0
2018-08-01 22:00:00	NQ	Futures	8574.34	8579.93	8566.39	8569.92	2255.0
2018-08-01 23:00:00	NQ	Futures	8569.33	8569.63	8548.73	8551.67	3106.0
2018-08-01 00:00:00	YM	Futures	27593.8	27611.2	27591.6	27607.9	656.0
2018-08-01 01:00:00	YM	Futures	27607.9	27613.3	27593.8	27605.7	970.0
2018-08-01 02:00:00	YM	Futures	27606.8	27649.2	27606.8	27626.4	2470.0
2018-08-01 03:00:00	YM	Futures	27626.4	27636.2	27587.2	27602.5	2814.0

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

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