PREVIEW / futures_1hour / 2008-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-07.parquet
  size:    42 KB
  rows:    1,205

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-07 00:00:00	ES	Futures	1173.93	1174.63	1173.47	1173.7	1004.0
2008-07-07 01:00:00	ES	Futures	1173.7	1174.63	1173.23	1173.7	1178.0
2008-07-07 02:00:00	ES	Futures	1173.47	1176.02	1173.0	1176.02	3768.0
2008-07-07 03:00:00	ES	Futures	1176.02	1177.65	1174.39	1174.63	13029.0
2008-07-07 04:00:00	ES	Futures	1174.86	1176.95	1172.77	1173.0	10010.0
2008-07-07 05:00:00	ES	Futures	1173.23	1175.32	1171.84	1175.32	8776.0
2008-07-07 06:00:00	ES	Futures	1175.32	1177.42	1173.7	1174.86	8721.0
2008-07-07 07:00:00	ES	Futures	1174.86	1177.65	1172.77	1177.42	18098.0
2008-07-07 08:00:00	ES	Futures	1177.18	1178.81	1175.32	1176.02	34531.0
2008-07-07 09:00:00	ES	Futures	1175.79	1185.32	1175.79	1184.85	270409.0
2008-07-07 10:00:00	ES	Futures	1184.85	1185.09	1178.81	1180.44	316964.0
2008-07-07 11:00:00	ES	Futures	1180.21	1182.99	1176.49	1177.42	241112.0
2008-07-07 12:00:00	ES	Futures	1177.65	1178.81	1159.06	1159.52	401159.0
2008-07-07 13:00:00	ES	Futures	1159.75	1160.91	1154.64	1157.2	293797.0
2008-07-07 14:00:00	ES	Futures	1157.2	1160.22	1153.48	1158.13	274178.0
2008-07-07 15:00:00	ES	Futures	1158.36	1176.02	1158.13	1164.17	526491.0
2008-07-07 16:00:00	ES	Futures	1164.4	1167.65	1163.24	1164.4	90095.0
2008-07-07 17:00:00	ES	Futures	1164.4	1164.87	1164.17	1164.87	708.0
2008-07-07 18:00:00	ES	Futures	1164.63	1165.56	1164.4	1165.33	1637.0
2008-07-07 19:00:00	ES	Futures	1165.33	1165.33	1163.94	1164.4	1419.0
2008-07-07 20:00:00	ES	Futures	1164.17	1164.4	1161.38	1161.61	3718.0
2008-07-07 21:00:00	ES	Futures	1161.38	1161.38	1160.22	1161.15	4001.0
2008-07-07 22:00:00	ES	Futures	1160.91	1161.38	1158.59	1158.59	3025.0
2008-07-07 23:00:00	ES	Futures	1158.82	1159.29	1155.57	1156.03	3992.0
2008-07-07 00:00:00	NQ	Futures	2050.88	2053.97	2050.6	2050.88	231.0
2008-07-07 01:00:00	NQ	Futures	2050.88	2052.85	2050.31	2050.88	103.0
2008-07-07 02:00:00	NQ	Futures	2051.16	2053.69	2049.47	2053.69	280.0
2008-07-07 03:00:00	NQ	Futures	2053.13	2057.63	2052.56	2055.1	1437.0
2008-07-07 04:00:00	NQ	Futures	2055.1	2057.35	2050.31	2050.88	746.0
2008-07-07 05:00:00	NQ	Futures	2050.88	2055.66	2049.19	2055.66	639.0
2008-07-07 06:00:00	NQ	Futures	2055.38	2057.91	2053.13	2053.41	598.0
2008-07-07 07:00:00	NQ	Futures	2053.97	2061.85	2050.31	2061.0	2366.0
2008-07-07 08:00:00	NQ	Futures	2061.0	2064.66	2057.06	2058.19	4379.0
2008-07-07 09:00:00	NQ	Futures	2058.19	2086.04	2057.63	2085.19	64256.0
2008-07-07 10:00:00	NQ	Futures	2085.48	2086.6	2072.82	2078.44	57238.0
2008-07-07 11:00:00	NQ	Futures	2078.44	2082.66	2069.16	2073.38	46106.0
2008-07-07 12:00:00	NQ	Futures	2073.38	2076.19	2040.75	2041.59	80016.0
2008-07-07 13:00:00	NQ	Futures	2041.88	2046.94	2033.16	2037.37	54017.0
2008-07-07 14:00:00	NQ	Futures	2037.37	2046.94	2029.78	2040.75	57051.0
2008-07-07 15:00:00	NQ	Futures	2040.47	2081.82	2040.47	2061.28	116686.0
2008-07-07 16:00:00	NQ	Futures	2061.0	2065.78	2059.03	2063.82	14755.0
2008-07-07 17:00:00	NQ	Futures	2063.82	2064.38	2063.25	2063.82	199.0
2008-07-07 18:00:00	NQ	Futures	2063.25	2064.94	2062.69	2064.66	111.0
2008-07-07 19:00:00	NQ	Futures	2063.53	2064.66	2063.25	2064.66	66.0
2008-07-07 20:00:00	NQ	Futures	2063.82	2063.82	2058.75	2059.03	102.0
2008-07-07 21:00:00	NQ	Futures	2058.75	2058.75	2056.22	2058.47	238.0
2008-07-07 22:00:00	NQ	Futures	2057.91	2058.47	2052.56	2052.56	254.0
2008-07-07 23:00:00	NQ	Futures	2052.28	2053.13	2048.34	2048.63	241.0
2008-07-07 00:00:00	YM	Futures	10252.1	10257.6	10250.3	10253.9	86.0
2008-07-07 01:00:00	YM	Futures	10251.2	10255.7	10245.7	10245.7	238.0

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

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