PREVIEW / futures_1hour / 2019-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-06.parquet
  size:    54 KB
  rows:    1,736

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-06 00:00:00	ES	Futures	3023.82	3026.27	3023.55	3024.64	6158.0
2019-03-06 01:00:00	ES	Futures	3024.91	3027.62	3023.28	3026.81	6607.0
2019-03-06 02:00:00	ES	Futures	3027.08	3027.62	3025.18	3026.81	6189.0
2019-03-06 03:00:00	ES	Futures	3026.81	3029.8	3025.72	3026.54	14536.0
2019-03-06 04:00:00	ES	Futures	3026.54	3028.98	3025.72	3027.08	18384.0
2019-03-06 05:00:00	ES	Futures	3026.81	3028.17	3026.0	3027.62	9151.0
2019-03-06 06:00:00	ES	Futures	3027.62	3029.53	3027.35	3029.25	5364.0
2019-03-06 07:00:00	ES	Futures	3029.53	3029.53	3025.72	3026.27	9383.0
2019-03-06 08:00:00	ES	Futures	3026.27	3030.88	3024.64	3029.8	26523.0
2019-03-06 09:00:00	ES	Futures	3029.8	3033.87	3021.38	3024.91	160303.0
2019-03-06 10:00:00	ES	Futures	3024.91	3027.08	3015.13	3020.29	238564.0
2019-03-06 11:00:00	ES	Futures	3020.29	3024.64	3011.6	3014.59	168532.0
2019-03-06 12:00:00	ES	Futures	3014.32	3020.29	3010.24	3010.79	143257.0
2019-03-06 13:00:00	ES	Futures	3010.51	3017.3	3008.61	3016.76	130120.0
2019-03-06 14:00:00	ES	Futures	3016.76	3018.66	3012.42	3014.05	115368.0
2019-03-06 15:00:00	ES	Futures	3014.05	3016.49	3007.53	3011.33	186343.0
2019-03-06 16:00:00	ES	Futures	3011.06	3014.05	3009.16	3010.24	63142.0
2019-03-06 18:00:00	ES	Futures	3009.7	3010.79	3005.08	3006.98	9513.0
2019-03-06 19:00:00	ES	Futures	3006.98	3007.53	3004.27	3005.35	9363.0
2019-03-06 20:00:00	ES	Futures	3005.08	3008.34	3004.81	3006.44	10878.0
2019-03-06 21:00:00	ES	Futures	3006.17	3009.16	3006.17	3007.26	7334.0
2019-03-06 22:00:00	ES	Futures	3007.53	3008.07	3005.08	3006.44	4385.0
2019-03-06 23:00:00	ES	Futures	3006.44	3006.98	3005.08	3005.35	2023.0
2019-03-06 00:00:00	NQ	Futures	8353.11	8361.0	8351.65	8356.03	1863.0
2019-03-06 01:00:00	NQ	Futures	8356.32	8364.8	8349.6	8361.58	2108.0
2019-03-06 02:00:00	NQ	Futures	8361.87	8366.84	8358.37	8363.92	2101.0
2019-03-06 03:00:00	NQ	Futures	8364.21	8375.32	8360.12	8363.63	4306.0
2019-03-06 04:00:00	NQ	Futures	8363.34	8370.35	8361.29	8365.67	3281.0
2019-03-06 05:00:00	NQ	Futures	8365.97	8368.89	8362.17	8367.43	2126.0
2019-03-06 06:00:00	NQ	Futures	8367.43	8371.81	8365.97	8369.76	1867.0
2019-03-06 07:00:00	NQ	Futures	8369.76	8370.06	8353.69	8356.32	5460.0
2019-03-06 08:00:00	NQ	Futures	8356.61	8374.15	8352.23	8371.52	8078.0
2019-03-06 09:00:00	NQ	Futures	8371.22	8381.45	8347.26	8363.04	58900.0
2019-03-06 10:00:00	NQ	Futures	8362.75	8370.35	8319.51	8340.25	77164.0
2019-03-06 11:00:00	NQ	Futures	8340.25	8354.28	8311.33	8324.77	61806.0
2019-03-06 12:00:00	NQ	Futures	8324.77	8340.25	8313.96	8316.88	49431.0
2019-03-06 13:00:00	NQ	Futures	8316.88	8333.24	8306.94	8332.07	42234.0
2019-03-06 14:00:00	NQ	Futures	8332.36	8339.96	8319.51	8327.98	35810.0
2019-03-06 15:00:00	NQ	Futures	8327.69	8335.87	8306.36	8318.63	54592.0
2019-03-06 16:00:00	NQ	Futures	8318.34	8324.18	8306.65	8309.86	11799.0
2019-03-06 18:00:00	NQ	Futures	8308.7	8312.79	8298.18	8301.98	2727.0
2019-03-06 19:00:00	NQ	Futures	8301.98	8303.73	8291.46	8295.55	3570.0
2019-03-06 20:00:00	NQ	Futures	8295.55	8305.19	8293.79	8299.93	3425.0
2019-03-06 21:00:00	NQ	Futures	8299.35	8310.74	8298.76	8303.73	3329.0
2019-03-06 22:00:00	NQ	Futures	8303.44	8306.65	8296.42	8301.1	1917.0
2019-03-06 23:00:00	NQ	Futures	8300.81	8302.27	8296.72	8297.3	694.0
2019-03-06 00:00:00	YM	Futures	27961.3	27980.8	27958.0	27968.9	1364.0
2019-03-06 01:00:00	YM	Futures	27970.0	27991.7	27949.3	27984.1	1967.0
2019-03-06 02:00:00	YM	Futures	27984.1	27989.5	27963.5	27980.8	1508.0
2019-03-06 03:00:00	YM	Futures	27980.8	28011.2	27965.6	27973.2	3305.0

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

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