PREVIEW / futures_1hour / 2019-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-27.parquet
  size:    55 KB
  rows:    1,749

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
2019-02-27 00:00:00	ES	Futures	3031.7	3034.41	3031.16	3032.78	9373.0
2019-02-27 01:00:00	ES	Futures	3032.78	3033.06	3023.82	3026.0	12970.0
2019-02-27 02:00:00	ES	Futures	3026.0	3027.08	3023.01	3026.0	11169.0
2019-02-27 03:00:00	ES	Futures	3026.27	3027.9	3020.56	3021.11	18230.0
2019-02-27 04:00:00	ES	Futures	3021.38	3024.09	3020.84	3023.55	12339.0
2019-02-27 05:00:00	ES	Futures	3023.55	3026.54	3022.19	3025.72	10164.0
2019-02-27 06:00:00	ES	Futures	3025.72	3026.54	3024.64	3025.18	6965.0
2019-02-27 07:00:00	ES	Futures	3025.45	3028.17	3024.91	3026.54	10199.0
2019-02-27 08:00:00	ES	Futures	3026.54	3028.44	3024.09	3025.45	21742.0
2019-02-27 09:00:00	ES	Futures	3025.72	3033.6	3025.18	3028.44	138765.0
2019-02-27 10:00:00	ES	Futures	3028.17	3029.8	3014.59	3021.38	301053.0
2019-02-27 11:00:00	ES	Futures	3021.11	3028.98	3020.02	3027.35	136735.0
2019-02-27 12:00:00	ES	Futures	3027.62	3031.97	3027.08	3029.8	67493.0
2019-02-27 13:00:00	ES	Futures	3029.8	3036.32	3029.8	3033.06	80782.0
2019-02-27 14:00:00	ES	Futures	3033.33	3037.67	3031.7	3034.41	68943.0
2019-02-27 15:00:00	ES	Futures	3034.41	3037.13	3030.07	3033.87	128033.0
2019-02-27 16:00:00	ES	Futures	3033.87	3038.76	3032.78	3037.94	52066.0
2019-02-27 18:00:00	ES	Futures	3036.59	3037.13	3034.96	3036.04	6884.0
2019-02-27 19:00:00	ES	Futures	3036.04	3036.04	3031.7	3031.97	9489.0
2019-02-27 20:00:00	ES	Futures	3031.97	3034.96	3030.88	3034.69	9271.0
2019-02-27 21:00:00	ES	Futures	3034.96	3035.77	3033.33	3033.6	6523.0
2019-02-27 22:00:00	ES	Futures	3033.87	3034.14	3032.24	3033.6	3001.0
2019-02-27 23:00:00	ES	Futures	3033.6	3033.87	3031.97	3032.24	2571.0
2019-02-27 00:00:00	NQ	Futures	8320.38	8327.69	8317.46	8322.14	3096.0
2019-02-27 01:00:00	NQ	Futures	8322.14	8323.01	8293.5	8300.22	4529.0
2019-02-27 02:00:00	NQ	Futures	8300.22	8304.02	8290.87	8298.76	4163.0
2019-02-27 03:00:00	NQ	Futures	8298.76	8303.73	8285.32	8287.07	5580.0
2019-02-27 04:00:00	NQ	Futures	8287.07	8295.55	8286.2	8294.67	3982.0
2019-02-27 05:00:00	NQ	Futures	8294.67	8304.61	8292.04	8303.14	3379.0
2019-02-27 06:00:00	NQ	Futures	8303.14	8305.19	8297.3	8299.35	2656.0
2019-02-27 07:00:00	NQ	Futures	8299.35	8308.7	8298.47	8298.76	3853.0
2019-02-27 08:00:00	NQ	Futures	8298.47	8303.14	8291.46	8291.75	6483.0
2019-02-27 09:00:00	NQ	Futures	8291.75	8320.38	8281.81	8286.78	48639.0
2019-02-27 10:00:00	NQ	Futures	8287.07	8293.5	8237.4	8261.65	91974.0
2019-02-27 11:00:00	NQ	Futures	8261.36	8305.19	8257.27	8296.72	50027.0
2019-02-27 12:00:00	NQ	Futures	8297.01	8311.62	8296.72	8302.27	25692.0
2019-02-27 13:00:00	NQ	Futures	8302.27	8323.01	8301.39	8318.92	25403.0
2019-02-27 14:00:00	NQ	Futures	8318.63	8335.29	8314.25	8320.97	27885.0
2019-02-27 15:00:00	NQ	Futures	8321.26	8330.9	8308.7	8324.77	40361.0
2019-02-27 16:00:00	NQ	Futures	8324.77	8329.73	8319.21	8325.94	9494.0
2019-02-27 18:00:00	NQ	Futures	8323.01	8324.77	8317.17	8320.68	1965.0
2019-02-27 19:00:00	NQ	Futures	8320.68	8320.68	8306.65	8307.82	4235.0
2019-02-27 20:00:00	NQ	Futures	8307.82	8317.46	8304.02	8316.88	4043.0
2019-02-27 21:00:00	NQ	Futures	8316.88	8321.26	8312.49	8313.66	2578.0
2019-02-27 22:00:00	NQ	Futures	8313.37	8315.12	8308.7	8313.08	1521.0
2019-02-27 23:00:00	NQ	Futures	8313.08	8316.29	8308.99	8308.99	1168.0
2019-02-27 00:00:00	YM	Futures	28262.0	28289.2	28256.6	28274.0	1940.0
2019-02-27 01:00:00	YM	Futures	28274.0	28277.2	28193.6	28218.6	2675.0
2019-02-27 02:00:00	YM	Futures	28218.6	28226.2	28186.0	28207.7	3276.0
2019-02-27 03:00:00	YM	Futures	28206.7	28222.9	28157.8	28161.1	4332.0

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

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