PREVIEW / futures_1hour / 2008-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-23.parquet
  size:    44 KB
  rows:    1,267

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-23 00:00:00	ES	Futures	1185.09	1185.78	1184.39	1184.62	1260.0
2008-07-23 01:00:00	ES	Futures	1184.62	1185.55	1183.92	1185.32	2141.0
2008-07-23 02:00:00	ES	Futures	1185.32	1188.11	1184.85	1187.41	11364.0
2008-07-23 03:00:00	ES	Futures	1187.18	1187.87	1186.25	1187.41	20685.0
2008-07-23 04:00:00	ES	Futures	1187.41	1194.15	1187.18	1192.06	33963.0
2008-07-23 05:00:00	ES	Futures	1192.06	1193.22	1190.66	1191.59	14903.0
2008-07-23 06:00:00	ES	Futures	1191.59	1192.52	1190.43	1190.66	9380.0
2008-07-23 07:00:00	ES	Futures	1190.43	1191.83	1188.8	1190.43	31964.0
2008-07-23 08:00:00	ES	Futures	1190.43	1192.29	1189.5	1189.97	48099.0
2008-07-23 09:00:00	ES	Futures	1189.97	1191.13	1185.78	1188.34	227837.0
2008-07-23 10:00:00	ES	Futures	1188.34	1200.43	1187.18	1195.08	485627.0
2008-07-23 11:00:00	ES	Futures	1194.85	1196.24	1189.97	1190.66	278373.0
2008-07-23 12:00:00	ES	Futures	1190.66	1192.29	1187.41	1191.36	212402.0
2008-07-23 13:00:00	ES	Futures	1191.36	1194.38	1186.48	1188.57	194571.0
2008-07-23 14:00:00	ES	Futures	1188.57	1196.01	1187.87	1191.13	245456.0
2008-07-23 15:00:00	ES	Futures	1191.36	1193.45	1188.34	1191.83	205606.0
2008-07-23 16:00:00	ES	Futures	1191.83	1193.92	1189.97	1190.66	80059.0
2008-07-23 17:00:00	ES	Futures	1190.66	1191.59	1190.66	1190.9	1840.0
2008-07-23 18:00:00	ES	Futures	1191.59	1193.22	1190.9	1192.52	2577.0
2008-07-23 19:00:00	ES	Futures	1192.29	1192.99	1191.13	1191.83	750.0
2008-07-23 20:00:00	ES	Futures	1191.83	1191.83	1190.9	1190.9	1617.0
2008-07-23 21:00:00	ES	Futures	1190.9	1191.83	1190.9	1191.13	1002.0
2008-07-23 22:00:00	ES	Futures	1190.9	1191.36	1190.43	1190.9	1298.0
2008-07-23 23:00:00	ES	Futures	1190.9	1191.36	1190.66	1191.13	809.0
2008-07-23 00:00:00	NQ	Futures	2052.85	2055.1	2052.85	2053.13	210.0
2008-07-23 01:00:00	NQ	Futures	2053.13	2054.25	2052.28	2053.13	108.0
2008-07-23 02:00:00	NQ	Futures	2052.85	2057.91	2052.85	2056.78	874.0
2008-07-23 03:00:00	NQ	Futures	2056.78	2057.35	2054.53	2055.94	991.0
2008-07-23 04:00:00	NQ	Futures	2055.94	2070.57	2055.66	2067.19	2918.0
2008-07-23 05:00:00	NQ	Futures	2067.19	2068.88	2066.07	2066.63	891.0
2008-07-23 06:00:00	NQ	Futures	2066.63	2068.04	2064.1	2064.1	461.0
2008-07-23 07:00:00	NQ	Futures	2064.1	2067.75	2061.28	2065.22	2682.0
2008-07-23 08:00:00	NQ	Futures	2064.94	2066.91	2060.16	2060.72	4425.0
2008-07-23 09:00:00	NQ	Futures	2061.0	2066.07	2050.31	2063.53	50598.0
2008-07-23 10:00:00	NQ	Futures	2063.53	2104.32	2060.72	2086.88	135268.0
2008-07-23 11:00:00	NQ	Futures	2087.16	2089.13	2069.44	2070.85	73232.0
2008-07-23 12:00:00	NQ	Futures	2070.57	2075.91	2056.5	2066.63	64685.0
2008-07-23 13:00:00	NQ	Futures	2066.63	2075.91	2059.88	2064.38	39849.0
2008-07-23 14:00:00	NQ	Futures	2064.38	2079.29	2063.25	2073.66	54039.0
2008-07-23 15:00:00	NQ	Futures	2073.66	2082.38	2068.6	2080.41	42707.0
2008-07-23 16:00:00	NQ	Futures	2080.69	2088.01	2072.25	2082.66	17312.0
2008-07-23 17:00:00	NQ	Futures	2083.22	2086.88	2081.82	2086.6	525.0
2008-07-23 18:00:00	NQ	Futures	2087.44	2090.54	2086.88	2089.69	391.0
2008-07-23 19:00:00	NQ	Futures	2089.41	2096.73	2089.41	2092.51	953.0
2008-07-23 20:00:00	NQ	Futures	2092.51	2092.51	2091.1	2092.23	520.0
2008-07-23 21:00:00	NQ	Futures	2091.66	2092.51	2091.66	2091.66	478.0
2008-07-23 22:00:00	NQ	Futures	2091.66	2091.66	2089.41	2089.41	269.0
2008-07-23 23:00:00	NQ	Futures	2089.41	2090.54	2088.57	2088.85	75.0
2008-07-23 00:00:00	YM	Futures	10514.8	10518.4	10511.1	10513.9	126.0
2008-07-23 01:00:00	YM	Futures	10512.9	10520.2	10508.4	10517.5	147.0

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

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