PREVIEW / futures_1hour / 2008-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-03-31.parquet
  size:    41 KB
  rows:    1,202

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
2008-03-31 00:00:00	ES	Futures	1228.25	1228.25	1226.15	1226.62	2623.0
2008-03-31 01:00:00	ES	Futures	1226.62	1229.41	1226.62	1229.18	1608.0
2008-03-31 02:00:00	ES	Futures	1228.95	1229.41	1224.53	1224.76	6983.0
2008-03-31 03:00:00	ES	Futures	1224.99	1225.69	1221.5	1222.2	15604.0
2008-03-31 04:00:00	ES	Futures	1222.2	1222.9	1219.64	1222.9	17533.0
2008-03-31 05:00:00	ES	Futures	1222.9	1224.99	1221.96	1223.83	10625.0
2008-03-31 06:00:00	ES	Futures	1224.06	1227.55	1223.83	1227.09	12428.0
2008-03-31 07:00:00	ES	Futures	1227.09	1229.41	1225.22	1229.41	22091.0
2008-03-31 08:00:00	ES	Futures	1229.41	1230.11	1224.53	1225.46	37664.0
2008-03-31 09:00:00	ES	Futures	1225.69	1232.67	1223.36	1230.81	206194.0
2008-03-31 10:00:00	ES	Futures	1230.81	1231.28	1226.15	1230.81	195966.0
2008-03-31 11:00:00	ES	Futures	1230.58	1235.47	1228.48	1234.07	186421.0
2008-03-31 12:00:00	ES	Futures	1233.84	1236.17	1231.28	1235.7	99535.0
2008-03-31 13:00:00	ES	Futures	1235.7	1239.19	1235.24	1235.47	148607.0
2008-03-31 14:00:00	ES	Futures	1235.47	1236.4	1229.88	1232.67	172688.0
2008-03-31 15:00:00	ES	Futures	1232.67	1237.56	1230.58	1231.74	325525.0
2008-03-31 16:00:00	ES	Futures	1231.51	1233.14	1228.72	1231.98	148182.0
2008-03-31 17:00:00	ES	Futures	1231.98	1232.21	1231.04	1231.28	1843.0
2008-03-31 18:00:00	ES	Futures	1231.28	1232.67	1230.58	1232.44	2667.0
2008-03-31 19:00:00	ES	Futures	1232.44	1232.67	1230.58	1230.81	1301.0
2008-03-31 20:00:00	ES	Futures	1230.81	1232.91	1230.58	1232.67	1758.0
2008-03-31 21:00:00	ES	Futures	1232.67	1235.24	1231.98	1233.84	4219.0
2008-03-31 22:00:00	ES	Futures	1234.07	1235.24	1233.61	1235.0	937.0
2008-03-31 23:00:00	ES	Futures	1235.24	1235.47	1233.37	1233.37	1384.0
2008-03-31 00:00:00	NQ	Futures	2013.74	2015.15	2011.76	2013.17	263.0
2008-03-31 01:00:00	NQ	Futures	2013.17	2018.27	2012.89	2017.98	169.0
2008-03-31 02:00:00	NQ	Futures	2017.98	2018.27	2008.93	2009.21	472.0
2008-03-31 03:00:00	NQ	Futures	2009.78	2010.06	2003.84	2004.41	799.0
2008-03-31 04:00:00	NQ	Futures	2004.41	2006.95	1999.6	2006.67	1056.0
2008-03-31 05:00:00	NQ	Futures	2007.23	2011.19	2004.97	2007.23	664.0
2008-03-31 06:00:00	NQ	Futures	2007.52	2014.59	2006.95	2013.74	993.0
2008-03-31 07:00:00	NQ	Futures	2013.74	2021.94	2011.48	2021.66	1987.0
2008-03-31 08:00:00	NQ	Futures	2021.38	2021.94	2011.48	2014.59	5110.0
2008-03-31 09:00:00	NQ	Futures	2014.31	2028.73	2009.5	2026.18	49454.0
2008-03-31 10:00:00	NQ	Futures	2025.9	2025.9	2006.1	2015.44	56450.0
2008-03-31 11:00:00	NQ	Futures	2015.44	2024.77	2009.78	2019.96	40135.0
2008-03-31 12:00:00	NQ	Futures	2019.96	2025.05	2014.59	2024.49	22019.0
2008-03-31 13:00:00	NQ	Futures	2024.2	2032.41	2023.36	2026.47	30221.0
2008-03-31 14:00:00	NQ	Futures	2026.18	2027.88	2014.59	2019.68	29488.0
2008-03-31 15:00:00	NQ	Futures	2019.4	2028.73	2015.44	2020.24	49422.0
2008-03-31 16:00:00	NQ	Futures	2020.24	2021.66	2017.42	2020.81	12498.0
2008-03-31 17:00:00	NQ	Futures	2019.68	2021.09	2018.83	2019.96	95.0
2008-03-31 18:00:00	NQ	Futures	2019.96	2021.66	2017.42	2021.66	136.0
2008-03-31 19:00:00	NQ	Futures	2020.53	2022.22	2018.27	2019.11	427.0
2008-03-31 20:00:00	NQ	Futures	2019.11	2022.22	2017.7	2021.66	15.0
2008-03-31 21:00:00	NQ	Futures	2020.81	2025.34	2020.81	2023.36	191.0
2008-03-31 22:00:00	NQ	Futures	2023.36	2025.62	2023.07	2025.62	150.0
2008-03-31 23:00:00	NQ	Futures	2025.62	2026.18	2019.68	2022.22	196.0
2008-03-31 00:00:00	YM	Futures	11118.3	11120.1	11101.9	11106.4	220.0
2008-03-31 01:00:00	YM	Futures	11108.3	11126.4	11103.7	11120.1	178.0

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

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