PREVIEW / futures_1hour / 2008-07-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	1163.24	1163.47	1160.68	1161.15	2525.0
2008-07-14 01:00:00	ES	Futures	1161.15	1164.17	1160.68	1163.01	2237.0
2008-07-14 02:00:00	ES	Futures	1163.01	1164.87	1160.68	1164.4	7270.0
2008-07-14 03:00:00	ES	Futures	1164.4	1166.26	1162.31	1164.17	15575.0
2008-07-14 04:00:00	ES	Futures	1164.4	1165.1	1160.91	1160.91	15570.0
2008-07-14 05:00:00	ES	Futures	1161.15	1163.47	1159.06	1163.24	11128.0
2008-07-14 06:00:00	ES	Futures	1163.01	1167.65	1162.31	1167.19	20787.0
2008-07-14 07:00:00	ES	Futures	1167.42	1171.84	1166.73	1167.65	42075.0
2008-07-14 08:00:00	ES	Futures	1167.65	1169.05	1166.73	1166.96	28440.0
2008-07-14 09:00:00	ES	Futures	1166.96	1167.65	1155.57	1155.8	360193.0
2008-07-14 10:00:00	ES	Futures	1156.03	1159.52	1150.46	1156.27	514756.0
2008-07-14 11:00:00	ES	Futures	1156.27	1157.2	1139.53	1144.41	384131.0
2008-07-14 12:00:00	ES	Futures	1144.41	1146.04	1140.46	1143.02	273264.0
2008-07-14 13:00:00	ES	Futures	1143.02	1147.67	1138.6	1145.11	250962.0
2008-07-14 14:00:00	ES	Futures	1145.11	1147.9	1141.16	1143.02	199498.0
2008-07-14 15:00:00	ES	Futures	1143.02	1151.62	1140.0	1142.55	396654.0
2008-07-14 16:00:00	ES	Futures	1142.79	1143.25	1140.69	1142.32	94194.0
2008-07-14 17:00:00	ES	Futures	1142.32	1142.79	1140.93	1141.62	2741.0
2008-07-14 18:00:00	ES	Futures	1141.62	1143.02	1141.62	1142.09	2409.0
2008-07-14 19:00:00	ES	Futures	1142.09	1142.79	1141.16	1142.55	1219.0
2008-07-14 20:00:00	ES	Futures	1142.32	1142.79	1141.16	1141.39	1398.0
2008-07-14 21:00:00	ES	Futures	1141.39	1141.62	1140.46	1141.16	2119.0
2008-07-14 22:00:00	ES	Futures	1141.16	1141.62	1134.65	1136.28	9619.0
2008-07-14 23:00:00	ES	Futures	1136.28	1137.91	1135.12	1136.51	2906.0
2008-07-14 00:00:00	NQ	Futures	2066.35	2066.35	2062.69	2062.69	202.0
2008-07-14 01:00:00	NQ	Futures	2064.38	2068.32	2062.41	2067.47	131.0
2008-07-14 02:00:00	NQ	Futures	2067.47	2069.16	2061.85	2068.6	339.0
2008-07-14 03:00:00	NQ	Futures	2068.6	2073.38	2065.22	2069.44	1500.0
2008-07-14 04:00:00	NQ	Futures	2069.72	2070.29	2062.13	2062.41	1105.0
2008-07-14 05:00:00	NQ	Futures	2062.41	2067.47	2059.6	2066.91	676.0
2008-07-14 06:00:00	NQ	Futures	2066.91	2076.47	2066.07	2075.35	1594.0
2008-07-14 07:00:00	NQ	Futures	2075.07	2082.1	2072.54	2073.94	3019.0
2008-07-14 08:00:00	NQ	Futures	2073.94	2076.19	2065.78	2072.54	5592.0
2008-07-14 09:00:00	NQ	Futures	2072.54	2073.38	2049.19	2050.03	67764.0
2008-07-14 10:00:00	NQ	Futures	2050.03	2057.35	2034.84	2050.6	91978.0
2008-07-14 11:00:00	NQ	Futures	2050.6	2052.56	2023.59	2034.0	63400.0
2008-07-14 12:00:00	NQ	Futures	2034.0	2035.69	2024.44	2030.06	51631.0
2008-07-14 13:00:00	NQ	Futures	2029.78	2042.44	2021.62	2037.37	51802.0
2008-07-14 14:00:00	NQ	Futures	2037.37	2042.44	2025.28	2028.65	44649.0
2008-07-14 15:00:00	NQ	Futures	2028.37	2046.94	2022.19	2028.94	80428.0
2008-07-14 16:00:00	NQ	Futures	2029.22	2030.62	2024.72	2028.09	11128.0
2008-07-14 17:00:00	NQ	Futures	2027.81	2028.65	2026.12	2026.69	206.0
2008-07-14 18:00:00	NQ	Futures	2027.25	2028.37	2026.69	2027.53	210.0
2008-07-14 19:00:00	NQ	Futures	2027.53	2028.09	2026.4	2026.97	120.0
2008-07-14 20:00:00	NQ	Futures	2026.69	2026.97	2025.0	2026.4	81.0
2008-07-14 21:00:00	NQ	Futures	2025.84	2027.25	2025.56	2025.84	85.0
2008-07-14 22:00:00	NQ	Futures	2025.84	2026.69	2016.84	2017.4	736.0
2008-07-14 23:00:00	NQ	Futures	2019.37	2021.06	2016.84	2020.22	310.0
2008-07-14 00:00:00	YM	Futures	10155.8	10157.6	10141.2	10145.8	250.0
2008-07-14 01:00:00	YM	Futures	10144.9	10168.5	10138.5	10162.1	227.0

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

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