PREVIEW / futures_1hour / 2018-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-16.parquet
  size:    45 KB
  rows:    1,342

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-16 00:00:00	ES	Futures	3003.63	3005.81	3003.35	3005.54	3091.0
2018-03-16 01:00:00	ES	Futures	3005.54	3010.18	3005.54	3008.27	5089.0
2018-03-16 02:00:00	ES	Futures	3008.27	3008.27	3005.54	3005.81	2823.0
2018-03-16 03:00:00	ES	Futures	3005.54	3006.36	3002.26	3002.81	6567.0
2018-03-16 04:00:00	ES	Futures	3002.81	3009.9	3002.53	3009.08	13107.0
2018-03-16 05:00:00	ES	Futures	3009.08	3010.72	3008.27	3009.36	7687.0
2018-03-16 06:00:00	ES	Futures	3009.63	3010.72	3006.9	3010.18	7983.0
2018-03-16 07:00:00	ES	Futures	3010.18	3011.27	3005.81	3006.08	10853.0
2018-03-16 08:00:00	ES	Futures	3006.08	3013.45	3005.54	3010.99	30673.0
2018-03-16 09:00:00	ES	Futures	3010.99	3016.45	3007.17	3013.72	211803.0
2018-03-16 10:00:00	ES	Futures	3013.45	3018.36	3010.72	3017.0	134283.0
2018-03-16 11:00:00	ES	Futures	3016.73	3019.73	3010.72	3011.54	103406.0
2018-03-16 12:00:00	ES	Futures	3011.54	3016.73	3009.9	3015.36	89828.0
2018-03-16 13:00:00	ES	Futures	3015.36	3016.73	3006.9	3008.54	73907.0
2018-03-16 14:00:00	ES	Futures	3008.81	3011.81	3006.08	3010.99	56007.0
2018-03-16 15:00:00	ES	Futures	3010.99	3015.09	3005.81	3006.08	211718.0
2018-03-16 16:00:00	ES	Futures	3006.08	3010.72	3004.99	3007.99	76735.0
2018-03-16 00:00:00	NQ	Futures	8343.17	8349.08	8343.17	8347.01	1510.0
2018-03-16 01:00:00	NQ	Futures	8347.01	8361.79	8347.01	8357.94	2779.0
2018-03-16 02:00:00	NQ	Futures	8358.24	8358.24	8347.01	8348.19	1400.0
2018-03-16 03:00:00	NQ	Futures	8347.9	8349.67	8335.78	8338.73	2812.0
2018-03-16 04:00:00	NQ	Futures	8339.33	8358.83	8337.85	8356.47	4198.0
2018-03-16 05:00:00	NQ	Futures	8355.88	8360.9	8353.22	8357.35	2236.0
2018-03-16 06:00:00	NQ	Futures	8357.65	8360.01	8350.85	8357.94	2254.0
2018-03-16 07:00:00	NQ	Futures	8358.54	8362.97	8347.9	8348.49	3332.0
2018-03-16 08:00:00	NQ	Futures	8348.49	8366.22	8344.94	8359.72	6308.0
2018-03-16 09:00:00	NQ	Futures	8359.72	8374.79	8347.6	8366.22	44254.0
2018-03-16 10:00:00	NQ	Futures	8365.92	8375.09	8350.26	8363.86	42306.0
2018-03-16 11:00:00	NQ	Futures	8363.26	8368.88	8313.91	8318.05	39511.0
2018-03-16 12:00:00	NQ	Futures	8317.75	8339.33	8315.98	8338.14	33498.0
2018-03-16 13:00:00	NQ	Futures	8337.85	8343.17	8318.05	8324.25	22560.0
2018-03-16 14:00:00	NQ	Futures	8324.25	8334.6	8318.93	8326.03	14339.0
2018-03-16 15:00:00	NQ	Futures	8326.03	8343.46	8319.82	8320.41	36784.0
2018-03-16 16:00:00	NQ	Futures	8320.41	8329.28	8318.64	8328.69	8579.0
2018-03-16 00:00:00	YM	Futures	26995.3	27021.3	26995.3	27021.3	1625.0
2018-03-16 01:00:00	YM	Futures	27020.3	27075.6	27020.3	27056.1	2602.0
2018-03-16 02:00:00	YM	Futures	27056.1	27057.2	27026.8	27030.0	1340.0
2018-03-16 03:00:00	YM	Futures	27028.9	27035.5	27001.8	27006.1	1928.0
2018-03-16 04:00:00	YM	Futures	27005.1	27073.5	27004.0	27064.8	3171.0
2018-03-16 05:00:00	YM	Futures	27064.8	27071.3	27044.2	27053.9	2113.0
2018-03-16 06:00:00	YM	Futures	27055.0	27067.0	27023.5	27058.3	2279.0
2018-03-16 07:00:00	YM	Futures	27057.2	27071.3	27020.3	27023.5	2195.0
2018-03-16 08:00:00	YM	Futures	27021.3	27101.7	27014.8	27074.6	5675.0
2018-03-16 09:00:00	YM	Futures	27075.6	27150.6	27010.5	27113.7	28726.0
2018-03-16 10:00:00	YM	Futures	27113.7	27173.4	27077.8	27148.4	21363.0
2018-03-16 11:00:00	YM	Futures	27147.3	27204.9	27095.2	27125.6	22698.0
2018-03-16 12:00:00	YM	Futures	27126.7	27202.7	27119.1	27183.2	16472.0
2018-03-16 13:00:00	YM	Futures	27183.2	27195.1	27121.3	27132.1	14492.0
2018-03-16 14:00:00	YM	Futures	27133.2	27161.4	27102.8	27151.7	8906.0
2018-03-16 15:00:00	YM	Futures	27151.7	27182.1	27091.9	27094.1	19031.0

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

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