PREVIEW / futures_1hour / 2018-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-15.parquet
  size:    53 KB
  rows:    1,644

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-03-15 00:00:00	ES	Futures	3010.99	3011.81	3009.63	3009.63	2565.0
2018-03-15 01:00:00	ES	Futures	3009.9	3012.63	3006.08	3012.63	4823.0
2018-03-15 02:00:00	ES	Futures	3012.36	3013.18	3011.27	3012.36	3103.0
2018-03-15 03:00:00	ES	Futures	3012.36	3015.36	3011.54	3013.72	9987.0
2018-03-15 04:00:00	ES	Futures	3014.0	3014.0	3009.36	3011.27	10248.0
2018-03-15 05:00:00	ES	Futures	3011.27	3014.54	3009.36	3012.09	9452.0
2018-03-15 06:00:00	ES	Futures	3012.36	3012.36	3004.72	3005.26	15533.0
2018-03-15 07:00:00	ES	Futures	3005.26	3009.9	3004.44	3007.45	14771.0
2018-03-15 08:00:00	ES	Futures	3007.45	3012.36	3006.08	3010.45	20347.0
2018-03-15 09:00:00	ES	Futures	3010.45	3014.0	3003.63	3006.08	117623.0
2018-03-15 10:00:00	ES	Futures	3006.36	3013.45	3005.81	3011.27	153328.0
2018-03-15 11:00:00	ES	Futures	3011.27	3020.82	3008.54	3012.36	167633.0
2018-03-15 12:00:00	ES	Futures	3012.36	3015.09	3008.27	3009.63	107458.0
2018-03-15 13:00:00	ES	Futures	3009.9	3011.81	2998.44	2998.44	131776.0
2018-03-15 14:00:00	ES	Futures	2998.71	3004.17	2997.35	3003.9	123937.0
2018-03-15 15:00:00	ES	Futures	3003.9	3007.72	2999.81	3003.35	156776.0
2018-03-15 16:00:00	ES	Futures	3003.63	3011.81	3003.08	3011.27	69476.0
2018-03-15 18:00:00	ES	Futures	3010.18	3011.27	3008.54	3010.18	5352.0
2018-03-15 19:00:00	ES	Futures	3010.18	3012.36	3009.9	3011.54	3678.0
2018-03-15 20:00:00	ES	Futures	3011.81	3012.09	3006.9	3008.27	5275.0
2018-03-15 21:00:00	ES	Futures	3008.27	3008.54	3002.26	3004.99	12159.0
2018-03-15 22:00:00	ES	Futures	3005.26	3006.08	3003.63	3003.9	3555.0
2018-03-15 23:00:00	ES	Futures	3003.9	3007.17	3003.35	3003.63	3826.0
2018-03-15 00:00:00	NQ	Futures	8354.1	8355.88	8350.85	8352.92	927.0
2018-03-15 01:00:00	NQ	Futures	8352.62	8356.47	8340.21	8356.47	2281.0
2018-03-15 02:00:00	NQ	Futures	8356.47	8359.42	8353.22	8357.35	1348.0
2018-03-15 03:00:00	NQ	Futures	8356.76	8365.92	8355.58	8360.9	2995.0
2018-03-15 04:00:00	NQ	Futures	8360.9	8362.08	8347.31	8354.69	3941.0
2018-03-15 05:00:00	NQ	Futures	8354.69	8365.92	8347.9	8357.06	3109.0
2018-03-15 06:00:00	NQ	Futures	8357.06	8357.65	8334.3	8337.55	5441.0
2018-03-15 07:00:00	NQ	Futures	8336.96	8346.71	8332.23	8339.92	5228.0
2018-03-15 08:00:00	NQ	Futures	8339.33	8355.58	8333.71	8350.85	7676.0
2018-03-15 09:00:00	NQ	Futures	8350.56	8362.97	8320.41	8340.51	42644.0
2018-03-15 10:00:00	NQ	Futures	8340.8	8371.83	8340.51	8368.58	53287.0
2018-03-15 11:00:00	NQ	Futures	8368.29	8393.11	8364.45	8371.54	39057.0
2018-03-15 12:00:00	NQ	Futures	8371.83	8375.38	8348.49	8359.13	30167.0
2018-03-15 13:00:00	NQ	Futures	8359.13	8364.15	8318.05	8318.93	32874.0
2018-03-15 14:00:00	NQ	Futures	8318.93	8343.46	8313.32	8342.58	34906.0
2018-03-15 15:00:00	NQ	Futures	8342.28	8352.33	8329.87	8340.21	31685.0
2018-03-15 16:00:00	NQ	Futures	8340.21	8365.63	8339.92	8365.04	9667.0
2018-03-15 18:00:00	NQ	Futures	8360.9	8367.99	8360.01	8365.92	2608.0
2018-03-15 19:00:00	NQ	Futures	8365.63	8373.02	8365.04	8369.77	1542.0
2018-03-15 20:00:00	NQ	Futures	8369.47	8370.65	8355.58	8357.94	2945.0
2018-03-15 21:00:00	NQ	Futures	8357.65	8357.65	8340.21	8349.67	5160.0
2018-03-15 22:00:00	NQ	Futures	8349.67	8350.85	8342.58	8343.76	1709.0
2018-03-15 23:00:00	NQ	Futures	8343.46	8352.33	8342.58	8342.87	1498.0
2018-03-15 00:00:00	YM	Futures	26959.4	26980.1	26948.6	26971.4	1826.0
2018-03-15 01:00:00	YM	Futures	26969.2	27002.9	26948.6	27001.8	2562.0
2018-03-15 02:00:00	YM	Futures	27000.7	27042.0	26994.2	27030.0	2510.0
2018-03-15 03:00:00	YM	Futures	27031.1	27038.7	27011.6	27025.7	2963.0

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

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