PREVIEW / futures_1hour / 2010-01-28

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-28.parquet
  size:    48 KB
  rows:    1,416

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
2010-01-28 00:00:00	ES	Futures	1073.5	1073.5	1072.04	1072.53	2845.0
2010-01-28 01:00:00	ES	Futures	1072.77	1073.01	1071.55	1071.8	7038.0
2010-01-28 02:00:00	ES	Futures	1071.55	1072.28	1068.88	1071.31	24283.0
2010-01-28 03:00:00	ES	Futures	1071.07	1071.31	1068.88	1070.34	32167.0
2010-01-28 04:00:00	ES	Futures	1070.34	1071.07	1068.88	1069.85	19928.0
2010-01-28 05:00:00	ES	Futures	1069.85	1070.83	1065.47	1067.42	38473.0
2010-01-28 06:00:00	ES	Futures	1067.42	1068.64	1065.47	1066.93	37053.0
2010-01-28 07:00:00	ES	Futures	1067.18	1072.04	1066.93	1069.61	51998.0
2010-01-28 08:00:00	ES	Futures	1069.37	1071.07	1067.42	1067.91	89420.0
2010-01-28 09:00:00	ES	Futures	1067.66	1069.61	1060.37	1063.04	333055.0
2010-01-28 10:00:00	ES	Futures	1063.04	1063.04	1054.53	1056.23	465608.0
2010-01-28 11:00:00	ES	Futures	1056.23	1056.72	1045.28	1049.66	515370.0
2010-01-28 12:00:00	ES	Futures	1049.42	1051.61	1046.74	1051.36	218375.0
2010-01-28 13:00:00	ES	Futures	1051.61	1056.23	1050.39	1053.31	256783.0
2010-01-28 14:00:00	ES	Futures	1053.31	1055.74	1049.42	1054.04	239524.0
2010-01-28 15:00:00	ES	Futures	1054.04	1059.39	1051.36	1051.61	461935.0
2010-01-28 16:00:00	ES	Futures	1051.61	1054.53	1049.18	1053.07	183676.0
2010-01-28 17:00:00	ES	Futures	1052.82	1053.31	1050.63	1051.85	4332.0
2010-01-28 18:00:00	ES	Futures	1051.61	1051.61	1047.23	1048.69	14044.0
2010-01-28 19:00:00	ES	Futures	1048.69	1049.18	1046.01	1047.47	24882.0
2010-01-28 20:00:00	ES	Futures	1047.23	1048.45	1046.99	1048.45	5572.0
2010-01-28 21:00:00	ES	Futures	1048.45	1050.63	1048.45	1050.15	9652.0
2010-01-28 22:00:00	ES	Futures	1050.15	1051.12	1049.18	1050.63	7953.0
2010-01-28 23:00:00	ES	Futures	1050.39	1050.39	1046.26	1046.26	7638.0
2010-01-28 00:00:00	NQ	Futures	2079.09	2079.09	2077.67	2078.24	322.0
2010-01-28 01:00:00	NQ	Futures	2078.52	2078.81	2076.52	2077.1	545.0
2010-01-28 02:00:00	NQ	Futures	2077.1	2078.24	2072.81	2077.95	2255.0
2010-01-28 03:00:00	NQ	Futures	2077.67	2077.67	2072.81	2075.38	3187.0
2010-01-28 04:00:00	NQ	Futures	2075.1	2076.24	2071.95	2075.67	1913.0
2010-01-28 05:00:00	NQ	Futures	2075.67	2077.1	2066.53	2068.81	2962.0
2010-01-28 06:00:00	NQ	Futures	2069.1	2070.53	2065.38	2067.1	2972.0
2010-01-28 07:00:00	NQ	Futures	2067.1	2076.24	2067.1	2072.53	5043.0
2010-01-28 08:00:00	NQ	Futures	2072.53	2074.81	2063.67	2064.24	11439.0
2010-01-28 09:00:00	NQ	Futures	2064.24	2065.96	2042.53	2049.39	70883.0
2010-01-28 10:00:00	NQ	Futures	2049.39	2049.67	2023.68	2026.54	131853.0
2010-01-28 11:00:00	NQ	Futures	2026.54	2027.68	2011.11	2017.11	88175.0
2010-01-28 12:00:00	NQ	Futures	2017.11	2019.68	2009.97	2018.26	41422.0
2010-01-28 13:00:00	NQ	Futures	2018.54	2025.97	2014.83	2020.54	40165.0
2010-01-28 14:00:00	NQ	Futures	2020.54	2029.68	2011.97	2025.68	44309.0
2010-01-28 15:00:00	NQ	Futures	2025.97	2034.54	2020.54	2021.68	80763.0
2010-01-28 16:00:00	NQ	Futures	2021.68	2035.96	2020.25	2031.68	37024.0
2010-01-28 17:00:00	NQ	Futures	2032.82	2033.39	2028.25	2029.68	480.0
2010-01-28 18:00:00	NQ	Futures	2028.82	2030.25	2018.54	2019.11	1741.0
2010-01-28 19:00:00	NQ	Futures	2019.4	2020.25	2013.97	2016.26	1365.0
2010-01-28 20:00:00	NQ	Futures	2016.54	2018.26	2015.11	2018.26	656.0
2010-01-28 21:00:00	NQ	Futures	2018.26	2023.11	2018.26	2021.4	1229.0
2010-01-28 22:00:00	NQ	Futures	2021.68	2026.25	2021.68	2025.4	914.0
2010-01-28 23:00:00	NQ	Futures	2025.11	2025.11	2017.97	2017.97	718.0
2010-01-28 00:00:00	YM	Futures	9602.4	9603.3	9593.9	9597.7	623.0
2010-01-28 01:00:00	YM	Futures	9597.7	9601.4	9590.2	9591.1	414.0

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

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