PREVIEW / futures_1hour / 2008-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-21.parquet
  size:    41 KB
  rows:    1,206

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-21 00:00:00	ES	Futures	1173.0	1173.23	1172.3	1172.54	584.0
2008-07-21 01:00:00	ES	Futures	1172.3	1173.7	1171.84	1173.47	1661.0
2008-07-21 02:00:00	ES	Futures	1173.47	1174.16	1171.61	1171.84	5151.0
2008-07-21 03:00:00	ES	Futures	1171.84	1171.84	1167.89	1167.89	14694.0
2008-07-21 04:00:00	ES	Futures	1167.89	1170.21	1167.65	1169.75	8402.0
2008-07-21 05:00:00	ES	Futures	1169.51	1174.63	1169.05	1173.47	12272.0
2008-07-21 06:00:00	ES	Futures	1173.47	1176.49	1173.23	1175.32	17942.0
2008-07-21 07:00:00	ES	Futures	1175.32	1179.74	1174.39	1174.86	58367.0
2008-07-21 08:00:00	ES	Futures	1174.86	1178.11	1174.39	1177.88	40495.0
2008-07-21 09:00:00	ES	Futures	1177.88	1178.35	1174.86	1177.42	194886.0
2008-07-21 10:00:00	ES	Futures	1177.18	1179.04	1172.07	1174.16	282610.0
2008-07-21 11:00:00	ES	Futures	1173.93	1175.79	1168.35	1168.58	199512.0
2008-07-21 12:00:00	ES	Futures	1168.58	1173.93	1167.65	1171.37	150194.0
2008-07-21 13:00:00	ES	Futures	1171.14	1174.86	1171.14	1172.07	100900.0
2008-07-21 14:00:00	ES	Futures	1172.07	1173.23	1168.12	1169.28	152911.0
2008-07-21 15:00:00	ES	Futures	1169.05	1171.61	1166.73	1171.14	209554.0
2008-07-21 16:00:00	ES	Futures	1171.14	1173.47	1161.84	1162.08	108303.0
2008-07-21 17:00:00	ES	Futures	1162.08	1162.77	1161.15	1161.15	5356.0
2008-07-21 18:00:00	ES	Futures	1161.15	1161.61	1160.68	1160.91	4426.0
2008-07-21 19:00:00	ES	Futures	1160.68	1162.08	1160.45	1161.84	2170.0
2008-07-21 20:00:00	ES	Futures	1161.84	1162.31	1161.38	1161.84	1923.0
2008-07-21 21:00:00	ES	Futures	1162.08	1162.08	1161.38	1161.84	813.0
2008-07-21 22:00:00	ES	Futures	1161.84	1162.77	1161.84	1162.77	2003.0
2008-07-21 23:00:00	ES	Futures	1162.77	1163.01	1161.38	1162.08	1305.0
2008-07-21 00:00:00	NQ	Futures	2058.47	2059.03	2056.5	2057.91	26.0
2008-07-21 01:00:00	NQ	Futures	2058.19	2059.32	2058.19	2059.03	180.0
2008-07-21 02:00:00	NQ	Futures	2059.03	2059.88	2055.66	2057.63	250.0
2008-07-21 03:00:00	NQ	Futures	2057.35	2057.35	2050.31	2050.88	1061.0
2008-07-21 04:00:00	NQ	Futures	2050.6	2057.06	2049.47	2055.66	1548.0
2008-07-21 05:00:00	NQ	Futures	2055.66	2066.91	2055.66	2066.07	1735.0
2008-07-21 06:00:00	NQ	Futures	2065.78	2070.29	2065.5	2068.04	1032.0
2008-07-21 07:00:00	NQ	Futures	2067.75	2075.91	2066.35	2066.63	3535.0
2008-07-21 08:00:00	NQ	Futures	2066.63	2070.29	2063.53	2069.72	6312.0
2008-07-21 09:00:00	NQ	Futures	2069.72	2071.97	2062.69	2070.0	41229.0
2008-07-21 10:00:00	NQ	Futures	2070.0	2073.66	2056.78	2059.32	61094.0
2008-07-21 11:00:00	NQ	Futures	2059.32	2062.13	2040.75	2042.44	55303.0
2008-07-21 12:00:00	NQ	Futures	2042.72	2050.31	2040.19	2044.41	37469.0
2008-07-21 13:00:00	NQ	Futures	2044.41	2057.63	2044.41	2051.72	28274.0
2008-07-21 14:00:00	NQ	Futures	2052.28	2054.53	2044.13	2048.34	30597.0
2008-07-21 15:00:00	NQ	Futures	2048.63	2055.1	2044.13	2053.41	51304.0
2008-07-21 16:00:00	NQ	Futures	2053.97	2061.0	2025.56	2027.53	22707.0
2008-07-21 17:00:00	NQ	Futures	2027.53	2027.81	2021.06	2021.9	2419.0
2008-07-21 18:00:00	NQ	Futures	2020.78	2021.06	2014.87	2018.81	2793.0
2008-07-21 19:00:00	NQ	Futures	2018.25	2021.9	2017.97	2021.62	588.0
2008-07-21 20:00:00	NQ	Futures	2021.34	2021.34	2019.93	2021.06	167.0
2008-07-21 21:00:00	NQ	Futures	2021.06	2021.34	2019.65	2021.34	134.0
2008-07-21 22:00:00	NQ	Futures	2021.34	2023.31	2020.78	2022.75	145.0
2008-07-21 23:00:00	NQ	Futures	2022.47	2024.15	2021.06	2022.47	60.0
2008-07-21 00:00:00	YM	Futures	10463.9	10467.5	10461.1	10462.1	67.0
2008-07-21 01:00:00	YM	Futures	10462.1	10470.2	10455.7	10462.1	300.0

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

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