PREVIEW / futures_1hour / 2017-02-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-17.parquet
  size:    46 KB
  rows:    1,362

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
2017-02-17 00:00:00	ES	Futures	2558.03	2558.57	2558.03	2558.03	988.0
2017-02-17 01:00:00	ES	Futures	2558.3	2558.57	2556.39	2556.39	2292.0
2017-02-17 02:00:00	ES	Futures	2556.66	2558.03	2556.39	2556.66	4697.0
2017-02-17 03:00:00	ES	Futures	2556.94	2558.03	2554.21	2555.3	15841.0
2017-02-17 04:00:00	ES	Futures	2555.3	2555.84	2551.48	2552.84	27096.0
2017-02-17 05:00:00	ES	Futures	2552.57	2552.84	2550.66	2551.48	17888.0
2017-02-17 06:00:00	ES	Futures	2551.48	2554.21	2549.84	2553.39	22281.0
2017-02-17 07:00:00	ES	Futures	2553.12	2554.48	2552.57	2553.39	23599.0
2017-02-17 08:00:00	ES	Futures	2553.66	2553.66	2549.3	2552.3	49580.0
2017-02-17 09:00:00	ES	Futures	2552.57	2556.12	2549.57	2554.48	266852.0
2017-02-17 10:00:00	ES	Futures	2554.75	2556.66	2552.84	2553.39	209121.0
2017-02-17 11:00:00	ES	Futures	2553.12	2555.03	2550.66	2553.66	145792.0
2017-02-17 12:00:00	ES	Futures	2553.94	2556.12	2553.12	2555.3	86369.0
2017-02-17 13:00:00	ES	Futures	2555.57	2556.12	2553.39	2555.03	70214.0
2017-02-17 14:00:00	ES	Futures	2555.3	2558.85	2554.75	2557.21	92097.0
2017-02-17 15:00:00	ES	Futures	2557.48	2562.66	2557.21	2562.12	225120.0
2017-02-17 16:00:00	ES	Futures	2562.12	2562.66	2561.3	2562.39	88339.0
2017-02-17 00:00:00	NQ	Futures	6322.29	6324.38	6321.99	6322.89	549.0
2017-02-17 01:00:00	NQ	Futures	6322.89	6323.78	6319.61	6320.2	689.0
2017-02-17 02:00:00	NQ	Futures	6320.2	6323.19	6319.91	6321.99	1282.0
2017-02-17 03:00:00	NQ	Futures	6322.59	6324.38	6316.92	6321.4	3659.0
2017-02-17 04:00:00	NQ	Futures	6321.1	6322.29	6311.55	6315.13	3927.0
2017-02-17 05:00:00	NQ	Futures	6315.13	6315.43	6309.17	6312.15	2595.0
2017-02-17 06:00:00	NQ	Futures	6312.45	6318.71	6308.57	6316.92	2877.0
2017-02-17 07:00:00	NQ	Futures	6316.62	6319.01	6314.24	6317.22	3899.0
2017-02-17 08:00:00	NQ	Futures	6317.52	6319.01	6310.06	6318.41	5123.0
2017-02-17 09:00:00	NQ	Futures	6318.41	6331.54	6313.04	6329.75	36894.0
2017-02-17 10:00:00	NQ	Futures	6330.05	6337.51	6325.87	6329.15	26421.0
2017-02-17 11:00:00	NQ	Futures	6329.45	6332.73	6323.49	6330.35	16124.0
2017-02-17 12:00:00	NQ	Futures	6330.65	6337.8	6328.56	6337.8	9514.0
2017-02-17 13:00:00	NQ	Futures	6337.51	6339.0	6333.63	6335.42	8887.0
2017-02-17 14:00:00	NQ	Futures	6335.72	6344.67	6334.82	6341.38	11774.0
2017-02-17 15:00:00	NQ	Futures	6341.38	6353.91	6341.38	6353.62	23142.0
2017-02-17 16:00:00	NQ	Futures	6353.62	6358.69	6351.53	6358.39	7190.0
2017-02-17 00:00:00	YM	Futures	22329.9	22332.1	22326.7	22327.7	388.0
2017-02-17 01:00:00	YM	Futures	22328.8	22331.0	22318.0	22319.1	702.0
2017-02-17 02:00:00	YM	Futures	22319.1	22327.7	22315.8	22320.1	1125.0
2017-02-17 03:00:00	YM	Futures	22321.2	22328.8	22301.7	22310.4	3113.0
2017-02-17 04:00:00	YM	Futures	22310.4	22312.5	22273.5	22283.3	4819.0
2017-02-17 05:00:00	YM	Futures	22283.3	22284.3	22265.9	22275.7	3060.0
2017-02-17 06:00:00	YM	Futures	22274.6	22301.7	22263.7	22293.0	3939.0
2017-02-17 07:00:00	YM	Futures	22294.1	22301.7	22283.3	22289.8	3257.0
2017-02-17 08:00:00	YM	Futures	22290.9	22291.9	22254.0	22273.5	5904.0
2017-02-17 09:00:00	YM	Futures	22273.5	22303.9	22244.2	22294.1	25479.0
2017-02-17 10:00:00	YM	Futures	22294.1	22307.1	22269.2	22280.0	15776.0
2017-02-17 11:00:00	YM	Futures	22280.0	22297.4	22262.7	22281.1	10545.0
2017-02-17 12:00:00	YM	Futures	22281.1	22294.1	22273.5	22281.1	6020.0
2017-02-17 13:00:00	YM	Futures	22281.1	22286.5	22270.2	22277.8	5388.0
2017-02-17 14:00:00	YM	Futures	22277.8	22308.2	22275.7	22297.4	6822.0
2017-02-17 15:00:00	YM	Futures	22297.4	22345.1	22296.3	22341.8	13488.0

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

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