PREVIEW / futures_1hour / 2009-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-19.parquet
  size:    44 KB
  rows:    1,296

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-11-19 00:00:00	ES	Futures	1071.1	1071.83	1070.14	1070.38	3428.0
2009-11-19 01:00:00	ES	Futures	1070.62	1072.32	1070.38	1071.83	3286.0
2009-11-19 02:00:00	ES	Futures	1071.83	1071.83	1068.44	1068.44	11194.0
2009-11-19 03:00:00	ES	Futures	1068.44	1069.65	1067.71	1067.96	19480.0
2009-11-19 04:00:00	ES	Futures	1068.2	1068.44	1066.26	1066.99	20229.0
2009-11-19 05:00:00	ES	Futures	1067.23	1068.68	1066.74	1068.2	13509.0
2009-11-19 06:00:00	ES	Futures	1068.2	1068.44	1063.6	1064.56	34199.0
2009-11-19 07:00:00	ES	Futures	1064.56	1066.02	1063.6	1065.78	33088.0
2009-11-19 08:00:00	ES	Futures	1065.78	1067.96	1064.08	1066.26	62236.0
2009-11-19 09:00:00	ES	Futures	1066.5	1067.23	1053.91	1056.09	425382.0
2009-11-19 10:00:00	ES	Futures	1056.33	1058.75	1053.18	1053.91	387076.0
2009-11-19 11:00:00	ES	Futures	1053.91	1056.57	1052.7	1056.57	182444.0
2009-11-19 12:00:00	ES	Futures	1056.57	1058.02	1055.36	1056.57	124760.0
2009-11-19 13:00:00	ES	Futures	1056.33	1057.78	1054.15	1056.81	109853.0
2009-11-19 14:00:00	ES	Futures	1056.81	1059.24	1054.39	1057.78	158240.0
2009-11-19 15:00:00	ES	Futures	1058.02	1061.17	1056.33	1058.99	276355.0
2009-11-19 16:00:00	ES	Futures	1059.24	1060.93	1058.27	1058.51	152979.0
2009-11-19 17:00:00	ES	Futures	1058.27	1058.99	1058.02	1058.51	2445.0
2009-11-19 18:00:00	ES	Futures	1058.51	1058.75	1057.06	1057.54	5861.0
2009-11-19 19:00:00	ES	Futures	1057.78	1060.2	1057.3	1059.48	4666.0
2009-11-19 20:00:00	ES	Futures	1059.48	1059.96	1057.54	1057.78	4467.0
2009-11-19 21:00:00	ES	Futures	1057.78	1058.02	1057.06	1057.3	3500.0
2009-11-19 22:00:00	ES	Futures	1057.54	1059.24	1057.3	1058.99	3512.0
2009-11-19 23:00:00	ES	Futures	1058.99	1060.93	1058.51	1060.69	4906.0
2009-11-19 00:00:00	NQ	Futures	2049.41	2050.26	2047.69	2048.26	269.0
2009-11-19 01:00:00	NQ	Futures	2047.98	2051.4	2047.98	2050.26	191.0
2009-11-19 02:00:00	NQ	Futures	2050.26	2050.55	2045.98	2046.27	840.0
2009-11-19 03:00:00	NQ	Futures	2045.98	2048.26	2044.56	2045.7	1772.0
2009-11-19 04:00:00	NQ	Futures	2045.98	2045.98	2042.28	2043.42	1740.0
2009-11-19 05:00:00	NQ	Futures	2043.42	2045.41	2042.56	2044.84	1378.0
2009-11-19 06:00:00	NQ	Futures	2044.84	2045.41	2036.86	2038.57	2912.0
2009-11-19 07:00:00	NQ	Futures	2038.0	2039.99	2036.29	2039.71	2589.0
2009-11-19 08:00:00	NQ	Futures	2039.99	2043.13	2037.43	2040.28	6039.0
2009-11-19 09:00:00	NQ	Futures	2040.28	2043.7	2012.33	2017.18	82938.0
2009-11-19 10:00:00	NQ	Futures	2017.18	2020.89	2010.05	2010.62	77475.0
2009-11-19 11:00:00	NQ	Futures	2010.62	2016.32	2007.48	2016.04	34837.0
2009-11-19 12:00:00	NQ	Futures	2016.04	2020.6	2013.19	2015.47	23393.0
2009-11-19 13:00:00	NQ	Futures	2015.18	2019.75	2012.33	2018.32	17911.0
2009-11-19 14:00:00	NQ	Futures	2018.32	2022.88	2014.04	2020.03	27805.0
2009-11-19 15:00:00	NQ	Futures	2020.03	2025.45	2018.03	2021.74	49388.0
2009-11-19 16:00:00	NQ	Futures	2022.31	2023.74	2017.46	2018.32	23461.0
2009-11-19 17:00:00	NQ	Futures	2018.32	2018.89	2017.75	2018.6	266.0
2009-11-19 18:00:00	NQ	Futures	2018.89	2018.89	2016.32	2016.89	420.0
2009-11-19 19:00:00	NQ	Futures	2016.89	2020.6	2016.61	2019.75	424.0
2009-11-19 20:00:00	NQ	Futures	2020.03	2020.32	2017.46	2017.46	471.0
2009-11-19 21:00:00	NQ	Futures	2017.75	2017.75	2014.61	2015.47	773.0
2009-11-19 22:00:00	NQ	Futures	2015.47	2020.03	2015.18	2018.6	243.0
2009-11-19 23:00:00	NQ	Futures	2019.17	2023.45	2019.17	2023.17	590.0
2009-11-19 00:00:00	YM	Futures	9658.1	9663.7	9651.6	9654.4	222.0
2009-11-19 01:00:00	YM	Futures	9654.4	9666.5	9654.4	9663.7	248.0

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

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