PREVIEW / futures_1hour / 2018-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-31.parquet
  size:    55 KB
  rows:    1,666

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-07-31 00:00:00	ES	Futures	3057.34	3060.34	3057.07	3059.25	8352.0
2018-07-31 01:00:00	ES	Futures	3059.25	3060.61	3058.43	3059.8	4456.0
2018-07-31 02:00:00	ES	Futures	3060.07	3060.61	3058.16	3058.71	5517.0
2018-07-31 03:00:00	ES	Futures	3058.71	3061.98	3058.16	3060.07	16675.0
2018-07-31 04:00:00	ES	Futures	3060.34	3060.34	3056.8	3059.25	15336.0
2018-07-31 05:00:00	ES	Futures	3059.52	3060.89	3057.89	3058.16	12853.0
2018-07-31 06:00:00	ES	Futures	3057.89	3063.61	3057.89	3063.34	13254.0
2018-07-31 07:00:00	ES	Futures	3063.34	3064.16	3061.7	3063.61	10429.0
2018-07-31 08:00:00	ES	Futures	3063.61	3064.43	3060.34	3061.43	16370.0
2018-07-31 09:00:00	ES	Futures	3061.7	3072.06	3058.71	3064.43	223899.0
2018-07-31 10:00:00	ES	Futures	3064.16	3069.61	3060.89	3065.52	171317.0
2018-07-31 11:00:00	ES	Futures	3065.25	3074.24	3064.97	3074.24	116332.0
2018-07-31 12:00:00	ES	Futures	3074.24	3078.87	3074.24	3076.14	105891.0
2018-07-31 13:00:00	ES	Futures	3076.14	3077.51	3072.6	3075.6	77822.0
2018-07-31 14:00:00	ES	Futures	3075.33	3076.14	3071.79	3073.96	86122.0
2018-07-31 15:00:00	ES	Futures	3074.24	3074.24	3066.34	3070.15	282466.0
2018-07-31 16:00:00	ES	Futures	3070.15	3081.87	3070.15	3079.96	110927.0
2018-07-31 18:00:00	ES	Futures	3078.05	3079.41	3066.06	3066.34	18857.0
2018-07-31 19:00:00	ES	Futures	3066.61	3072.06	3063.34	3071.51	14210.0
2018-07-31 20:00:00	ES	Futures	3071.79	3072.87	3069.33	3069.88	7956.0
2018-07-31 21:00:00	ES	Futures	3069.88	3071.51	3066.88	3067.43	11405.0
2018-07-31 22:00:00	ES	Futures	3067.7	3069.88	3066.88	3067.97	4039.0
2018-07-31 23:00:00	ES	Futures	3068.24	3070.42	3067.97	3068.52	3271.0
2018-07-31 00:00:00	NQ	Futures	8477.77	8499.85	8476.89	8495.73	3753.0
2018-07-31 01:00:00	NQ	Futures	8495.44	8501.62	8490.73	8499.85	1901.0
2018-07-31 02:00:00	NQ	Futures	8499.85	8503.68	8493.96	8495.14	2745.0
2018-07-31 03:00:00	NQ	Futures	8495.14	8507.8	8491.9	8494.55	5391.0
2018-07-31 04:00:00	NQ	Futures	8494.55	8496.61	8482.78	8490.73	4077.0
2018-07-31 05:00:00	NQ	Futures	8491.31	8496.02	8486.01	8487.49	3073.0
2018-07-31 06:00:00	NQ	Futures	8487.49	8497.2	8485.43	8496.61	7050.0
2018-07-31 07:00:00	NQ	Futures	8496.32	8513.98	8496.02	8511.33	6027.0
2018-07-31 08:00:00	NQ	Futures	8511.33	8514.57	8493.96	8501.32	7117.0
2018-07-31 09:00:00	NQ	Futures	8501.32	8562.56	8490.14	8507.21	85863.0
2018-07-31 10:00:00	NQ	Futures	8506.92	8527.82	8466.58	8501.62	88695.0
2018-07-31 11:00:00	NQ	Futures	8501.32	8560.21	8501.03	8557.26	48460.0
2018-07-31 12:00:00	NQ	Futures	8557.26	8578.46	8551.96	8556.67	35212.0
2018-07-31 13:00:00	NQ	Futures	8556.67	8563.45	8535.77	8552.85	28640.0
2018-07-31 14:00:00	NQ	Futures	8552.85	8558.44	8536.95	8549.31	22091.0
2018-07-31 15:00:00	NQ	Futures	8549.61	8549.61	8518.4	8531.94	45728.0
2018-07-31 16:00:00	NQ	Futures	8532.24	8594.65	8531.94	8588.18	19591.0
2018-07-31 18:00:00	NQ	Futures	8588.77	8592.3	8544.01	8545.19	5857.0
2018-07-31 19:00:00	NQ	Futures	8545.19	8566.68	8536.07	8565.21	3893.0
2018-07-31 20:00:00	NQ	Futures	8565.51	8569.04	8553.14	8555.5	3160.0
2018-07-31 21:00:00	NQ	Futures	8554.91	8563.15	8541.66	8551.08	4289.0
2018-07-31 22:00:00	NQ	Futures	8551.38	8555.79	8545.78	8548.43	1458.0
2018-07-31 23:00:00	NQ	Futures	8548.73	8556.97	8547.55	8550.49	1306.0
2018-07-31 00:00:00	YM	Futures	27504.6	27534.0	27499.2	27513.3	1717.0
2018-07-31 01:00:00	YM	Futures	27513.3	27527.5	27502.4	27520.9	1158.0
2018-07-31 02:00:00	YM	Futures	27520.9	27525.3	27491.6	27494.8	1653.0
2018-07-31 03:00:00	YM	Futures	27495.9	27520.9	27490.5	27510.1	2564.0

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

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