PREVIEW / futures_1hour / 2019-03-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-05.parquet
  size:    55 KB
  rows:    1,744

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-03-05 00:00:00	ES	Futures	3031.16	3032.51	3030.07	3032.24	4431.0
2019-03-05 01:00:00	ES	Futures	3032.24	3034.96	3032.24	3033.87	5309.0
2019-03-05 02:00:00	ES	Futures	3034.14	3036.04	3032.51	3034.96	6361.0
2019-03-05 03:00:00	ES	Futures	3034.96	3040.12	3033.33	3039.03	17337.0
2019-03-05 04:00:00	ES	Futures	3039.3	3040.66	3037.94	3039.3	11849.0
2019-03-05 05:00:00	ES	Futures	3039.3	3039.85	3035.77	3037.13	12108.0
2019-03-05 06:00:00	ES	Futures	3037.13	3037.67	3034.96	3037.67	11586.0
2019-03-05 07:00:00	ES	Futures	3037.4	3037.94	3031.7	3032.78	21959.0
2019-03-05 08:00:00	ES	Futures	3033.06	3037.94	3032.78	3033.87	19871.0
2019-03-05 09:00:00	ES	Futures	3034.14	3036.59	3023.55	3027.08	167901.0
2019-03-05 10:00:00	ES	Futures	3027.08	3034.69	3024.91	3028.44	228200.0
2019-03-05 11:00:00	ES	Futures	3028.44	3037.4	3026.54	3033.06	149097.0
2019-03-05 12:00:00	ES	Futures	3032.78	3034.41	3030.61	3033.6	66325.0
2019-03-05 13:00:00	ES	Futures	3033.6	3036.59	3028.44	3031.43	80105.0
2019-03-05 14:00:00	ES	Futures	3031.43	3037.4	3031.16	3036.86	62381.0
2019-03-05 15:00:00	ES	Futures	3036.86	3038.22	3030.61	3030.88	185213.0
2019-03-05 16:00:00	ES	Futures	3030.88	3033.06	3028.98	3029.53	42422.0
2019-03-05 18:00:00	ES	Futures	3027.08	3029.25	3024.91	3027.08	8844.0
2019-03-05 19:00:00	ES	Futures	3027.08	3027.35	3024.37	3026.27	8540.0
2019-03-05 20:00:00	ES	Futures	3026.27	3027.62	3022.46	3024.91	10303.0
2019-03-05 21:00:00	ES	Futures	3024.91	3028.71	3024.37	3025.18	9885.0
2019-03-05 22:00:00	ES	Futures	3025.18	3026.27	3022.74	3023.01	6229.0
2019-03-05 23:00:00	ES	Futures	3023.01	3024.09	3021.65	3023.55	5672.0
2019-03-05 00:00:00	NQ	Futures	8349.89	8353.99	8346.1	8352.52	1670.0
2019-03-05 01:00:00	NQ	Futures	8352.82	8361.29	8352.23	8358.08	1770.0
2019-03-05 02:00:00	NQ	Futures	8358.37	8363.92	8353.99	8360.12	2395.0
2019-03-05 03:00:00	NQ	Futures	8360.12	8378.82	8355.74	8375.61	5288.0
2019-03-05 04:00:00	NQ	Futures	8375.61	8379.11	8370.06	8374.44	3876.0
2019-03-05 05:00:00	NQ	Futures	8375.02	8376.48	8359.24	8364.8	4132.0
2019-03-05 06:00:00	NQ	Futures	8364.5	8365.38	8356.32	8365.38	3294.0
2019-03-05 07:00:00	NQ	Futures	8365.09	8365.09	8343.17	8347.85	12473.0
2019-03-05 08:00:00	NQ	Futures	8348.73	8372.39	8348.73	8356.03	7497.0
2019-03-05 09:00:00	NQ	Futures	8356.32	8371.22	8326.52	8340.84	61324.0
2019-03-05 10:00:00	NQ	Futures	8342.01	8376.19	8338.5	8364.21	76025.0
2019-03-05 11:00:00	NQ	Futures	8364.21	8388.46	8356.32	8375.02	47906.0
2019-03-05 12:00:00	NQ	Futures	8374.73	8379.99	8363.04	8371.81	23703.0
2019-03-05 13:00:00	NQ	Futures	8371.81	8382.91	8363.34	8371.81	22114.0
2019-03-05 14:00:00	NQ	Futures	8372.1	8391.09	8369.76	8389.92	20948.0
2019-03-05 15:00:00	NQ	Futures	8390.51	8394.02	8367.43	8368.3	38100.0
2019-03-05 16:00:00	NQ	Futures	8368.01	8378.53	8363.63	8366.84	8351.0
2019-03-05 18:00:00	NQ	Futures	8363.63	8367.72	8355.45	8360.12	2336.0
2019-03-05 19:00:00	NQ	Futures	8359.54	8360.71	8351.36	8358.37	3320.0
2019-03-05 20:00:00	NQ	Futures	8358.08	8362.17	8343.47	8351.65	4408.0
2019-03-05 21:00:00	NQ	Futures	8351.94	8366.84	8350.77	8355.45	3529.0
2019-03-05 22:00:00	NQ	Futures	8355.45	8360.41	8349.31	8349.6	1892.0
2019-03-05 23:00:00	NQ	Futures	8349.31	8354.28	8345.8	8352.82	1929.0
2019-03-05 00:00:00	YM	Futures	28003.6	28017.7	27993.9	28015.6	1421.0
2019-03-05 01:00:00	YM	Futures	28015.6	28043.8	28015.6	28031.9	1478.0
2019-03-05 02:00:00	YM	Futures	28031.9	28052.5	28019.9	28044.9	1822.0
2019-03-05 03:00:00	YM	Futures	28044.9	28095.9	28032.9	28088.3	3720.0

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

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