PREVIEW / futures_1hour / 2008-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-22.parquet
  size:    43 KB
  rows:    1,242

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-07-22 00:00:00	ES	Futures	1162.31	1163.94	1162.31	1163.47	1297.0
2008-07-22 01:00:00	ES	Futures	1163.47	1165.1	1163.01	1164.63	2584.0
2008-07-22 02:00:00	ES	Futures	1164.87	1165.56	1163.94	1165.1	8521.0
2008-07-22 03:00:00	ES	Futures	1165.1	1166.03	1163.7	1163.94	15657.0
2008-07-22 04:00:00	ES	Futures	1163.94	1164.17	1161.38	1163.47	10902.0
2008-07-22 05:00:00	ES	Futures	1163.47	1165.8	1163.01	1164.4	6469.0
2008-07-22 06:00:00	ES	Futures	1164.4	1165.33	1160.45	1162.31	16055.0
2008-07-22 07:00:00	ES	Futures	1162.54	1163.7	1159.52	1163.01	47449.0
2008-07-22 08:00:00	ES	Futures	1163.01	1165.33	1161.15	1164.4	38044.0
2008-07-22 09:00:00	ES	Futures	1164.63	1166.03	1160.91	1165.56	219877.0
2008-07-22 10:00:00	ES	Futures	1165.56	1171.61	1164.87	1168.12	358857.0
2008-07-22 11:00:00	ES	Futures	1167.89	1174.39	1167.89	1171.14	295932.0
2008-07-22 12:00:00	ES	Futures	1170.91	1174.39	1169.05	1171.61	165535.0
2008-07-22 13:00:00	ES	Futures	1171.61	1173.93	1169.98	1172.54	120868.0
2008-07-22 14:00:00	ES	Futures	1172.77	1176.02	1168.58	1175.09	232915.0
2008-07-22 15:00:00	ES	Futures	1174.86	1188.11	1174.39	1186.95	390049.0
2008-07-22 16:00:00	ES	Futures	1186.95	1187.41	1183.92	1184.39	117596.0
2008-07-22 17:00:00	ES	Futures	1184.16	1185.09	1183.23	1184.39	3607.0
2008-07-22 18:00:00	ES	Futures	1184.62	1185.09	1183.69	1184.39	2019.0
2008-07-22 19:00:00	ES	Futures	1184.39	1185.09	1184.16	1184.85	1476.0
2008-07-22 20:00:00	ES	Futures	1184.62	1185.55	1183.69	1185.55	2791.0
2008-07-22 21:00:00	ES	Futures	1185.32	1185.55	1184.62	1185.09	860.0
2008-07-22 22:00:00	ES	Futures	1185.09	1185.55	1183.69	1184.16	1411.0
2008-07-22 23:00:00	ES	Futures	1184.16	1185.55	1183.92	1185.32	1118.0
2008-07-22 00:00:00	NQ	Futures	2021.9	2024.15	2021.34	2023.87	43.0
2008-07-22 01:00:00	NQ	Futures	2023.59	2025.0	2022.47	2025.0	215.0
2008-07-22 02:00:00	NQ	Futures	2025.0	2025.56	2021.9	2023.03	1426.0
2008-07-22 03:00:00	NQ	Futures	2023.03	2024.15	2017.97	2018.25	3779.0
2008-07-22 04:00:00	NQ	Futures	2018.25	2021.62	2016.56	2020.78	1050.0
2008-07-22 05:00:00	NQ	Futures	2020.5	2024.15	2020.22	2021.34	702.0
2008-07-22 06:00:00	NQ	Futures	2021.62	2023.03	2015.43	2019.09	1206.0
2008-07-22 07:00:00	NQ	Futures	2019.65	2022.47	2014.59	2019.93	4299.0
2008-07-22 08:00:00	NQ	Futures	2020.22	2023.59	2015.72	2021.34	6837.0
2008-07-22 09:00:00	NQ	Futures	2021.62	2026.97	2011.5	2022.19	60679.0
2008-07-22 10:00:00	NQ	Futures	2022.47	2036.53	2017.97	2021.06	79552.0
2008-07-22 11:00:00	NQ	Futures	2021.06	2034.28	2020.22	2025.28	65607.0
2008-07-22 12:00:00	NQ	Futures	2025.0	2028.94	2022.75	2025.0	31776.0
2008-07-22 13:00:00	NQ	Futures	2025.28	2032.87	2022.19	2030.34	30177.0
2008-07-22 14:00:00	NQ	Futures	2030.06	2037.09	2020.78	2037.09	53517.0
2008-07-22 15:00:00	NQ	Futures	2037.09	2055.38	2032.03	2054.25	64771.0
2008-07-22 16:00:00	NQ	Futures	2053.97	2057.35	2048.63	2053.97	12159.0
2008-07-22 17:00:00	NQ	Futures	2053.97	2055.94	2050.88	2051.16	577.0
2008-07-22 18:00:00	NQ	Futures	2051.72	2053.41	2051.72	2052.85	88.0
2008-07-22 19:00:00	NQ	Futures	2052.28	2054.25	2051.72	2053.41	69.0
2008-07-22 20:00:00	NQ	Futures	2053.69	2053.97	2052.28	2053.41	86.0
2008-07-22 21:00:00	NQ	Futures	2053.97	2054.25	2052.85	2052.85	15.0
2008-07-22 22:00:00	NQ	Futures	2053.13	2053.13	2051.44	2052.56	187.0
2008-07-22 23:00:00	NQ	Futures	2052.56	2053.13	2052.0	2053.13	88.0
2008-07-22 00:00:00	YM	Futures	10331.2	10345.7	10331.2	10343.9	137.0
2008-07-22 01:00:00	YM	Futures	10341.2	10353.9	10339.4	10349.4	185.0

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

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