PREVIEW / futures_1hour / 2009-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-23.parquet
  size:    37 KB
  rows:    1,054

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
2009-10-23 00:00:00	ES	Futures	1060.2	1060.93	1059.72	1060.45	3150.0
2009-10-23 01:00:00	ES	Futures	1060.45	1060.69	1057.78	1058.51	3956.0
2009-10-23 02:00:00	ES	Futures	1058.51	1058.99	1057.06	1057.54	9202.0
2009-10-23 03:00:00	ES	Futures	1057.78	1060.69	1057.06	1060.2	27468.0
2009-10-23 04:00:00	ES	Futures	1059.96	1060.45	1056.57	1056.81	26805.0
2009-10-23 05:00:00	ES	Futures	1057.06	1058.75	1055.36	1057.06	14241.0
2009-10-23 06:00:00	ES	Futures	1057.3	1057.78	1055.6	1056.33	12460.0
2009-10-23 07:00:00	ES	Futures	1056.57	1059.24	1055.84	1058.02	15541.0
2009-10-23 08:00:00	ES	Futures	1058.02	1060.93	1057.3	1060.45	63857.0
2009-10-23 09:00:00	ES	Futures	1060.45	1061.17	1053.42	1055.6	267620.0
2009-10-23 10:00:00	ES	Futures	1055.6	1058.51	1046.88	1047.61	486590.0
2009-10-23 11:00:00	ES	Futures	1047.37	1049.06	1042.28	1046.16	353819.0
2009-10-23 12:00:00	ES	Futures	1046.16	1048.82	1044.94	1046.16	119000.0
2009-10-23 13:00:00	ES	Futures	1046.16	1047.12	1039.62	1041.8	244516.0
2009-10-23 14:00:00	ES	Futures	1042.04	1044.7	1039.37	1041.31	200040.0
2009-10-23 15:00:00	ES	Futures	1041.55	1043.98	1038.16	1042.76	373075.0
2009-10-23 16:00:00	ES	Futures	1043.01	1043.98	1042.28	1043.25	87957.0
2009-10-23 00:00:00	NQ	Futures	2016.04	2017.46	2016.04	2017.18	269.0
2009-10-23 01:00:00	NQ	Futures	2016.89	2017.46	2012.9	2013.76	746.0
2009-10-23 02:00:00	NQ	Futures	2014.04	2014.33	2012.04	2012.62	801.0
2009-10-23 03:00:00	NQ	Futures	2012.62	2017.46	2012.04	2016.61	2311.0
2009-10-23 04:00:00	NQ	Futures	2016.32	2016.89	2011.47	2011.47	2723.0
2009-10-23 05:00:00	NQ	Futures	2012.04	2016.89	2010.05	2014.33	1476.0
2009-10-23 06:00:00	NQ	Futures	2014.33	2015.18	2011.47	2012.62	1104.0
2009-10-23 07:00:00	NQ	Futures	2012.62	2016.89	2011.76	2015.47	1552.0
2009-10-23 08:00:00	NQ	Futures	2015.18	2028.02	2013.76	2027.45	14558.0
2009-10-23 09:00:00	NQ	Futures	2027.73	2028.59	2014.04	2020.6	56468.0
2009-10-23 10:00:00	NQ	Futures	2020.6	2024.31	2000.35	2001.78	75314.0
2009-10-23 11:00:00	NQ	Futures	2002.06	2006.91	1996.93	2005.2	51226.0
2009-10-23 12:00:00	NQ	Futures	2005.2	2008.62	2002.35	2003.49	20857.0
2009-10-23 13:00:00	NQ	Futures	2003.49	2005.77	1992.94	1997.21	34982.0
2009-10-23 14:00:00	NQ	Futures	1997.5	2004.34	1993.51	1998.36	34205.0
2009-10-23 15:00:00	NQ	Futures	1998.36	2002.92	1992.65	1998.36	48604.0
2009-10-23 16:00:00	NQ	Futures	1998.36	2000.92	1997.5	1999.21	7533.0
2009-10-23 00:00:00	YM	Futures	9357.7	9365.1	9356.7	9361.4	216.0
2009-10-23 01:00:00	YM	Futures	9361.4	9361.4	9339.1	9342.8	619.0
2009-10-23 02:00:00	YM	Futures	9344.6	9351.1	9338.1	9341.8	924.0
2009-10-23 03:00:00	YM	Futures	9343.7	9362.3	9338.1	9358.6	1692.0
2009-10-23 04:00:00	YM	Futures	9358.6	9360.4	9334.4	9335.3	1805.0
2009-10-23 05:00:00	YM	Futures	9335.3	9353.0	9326.0	9339.1	1492.0
2009-10-23 06:00:00	YM	Futures	9340.0	9343.7	9326.0	9335.3	788.0
2009-10-23 07:00:00	YM	Futures	9333.5	9353.9	9330.7	9343.7	1261.0
2009-10-23 08:00:00	YM	Futures	9344.6	9360.4	9338.1	9357.7	3134.0
2009-10-23 09:00:00	YM	Futures	9356.7	9365.1	9307.4	9324.2	27662.0
2009-10-23 10:00:00	YM	Futures	9323.2	9346.5	9259.1	9263.7	41440.0
2009-10-23 11:00:00	YM	Futures	9263.7	9281.4	9227.4	9258.1	29851.0
2009-10-23 12:00:00	YM	Futures	9258.1	9284.2	9249.8	9264.6	9446.0
2009-10-23 13:00:00	YM	Futures	9264.6	9268.4	9202.3	9222.8	21632.0
2009-10-23 14:00:00	YM	Futures	9221.9	9242.3	9203.2	9218.1	16354.0
2009-10-23 15:00:00	YM	Futures	9217.2	9238.6	9192.1	9233.9	28758.0

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

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