PREVIEW / futures_1hour / 2008-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-08.parquet
  size:    42 KB
  rows:    1,226

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-04-08 00:00:00	ES	Futures	1273.89	1275.52	1272.72	1272.72	2295.0
2008-04-08 01:00:00	ES	Futures	1272.96	1273.89	1272.49	1273.89	1093.0
2008-04-08 02:00:00	ES	Futures	1274.12	1275.52	1273.42	1273.66	5797.0
2008-04-08 03:00:00	ES	Futures	1273.66	1274.82	1270.63	1272.03	18750.0
2008-04-08 04:00:00	ES	Futures	1272.03	1273.89	1271.09	1273.42	9837.0
2008-04-08 05:00:00	ES	Futures	1273.42	1273.66	1270.86	1272.72	9126.0
2008-04-08 06:00:00	ES	Futures	1272.96	1273.66	1270.16	1272.03	11319.0
2008-04-08 07:00:00	ES	Futures	1271.79	1273.89	1271.33	1273.66	13028.0
2008-04-08 08:00:00	ES	Futures	1273.66	1273.66	1271.33	1272.72	21305.0
2008-04-08 09:00:00	ES	Futures	1272.72	1274.82	1270.16	1274.12	157741.0
2008-04-08 10:00:00	ES	Futures	1274.12	1277.61	1271.56	1275.98	253567.0
2008-04-08 11:00:00	ES	Futures	1275.75	1278.08	1273.42	1274.12	156698.0
2008-04-08 12:00:00	ES	Futures	1274.35	1275.98	1272.72	1274.12	92988.0
2008-04-08 13:00:00	ES	Futures	1274.12	1275.05	1271.79	1273.66	86425.0
2008-04-08 14:00:00	ES	Futures	1273.66	1275.52	1268.77	1275.05	250579.0
2008-04-08 15:00:00	ES	Futures	1274.82	1276.22	1270.63	1273.66	222928.0
2008-04-08 16:00:00	ES	Futures	1273.42	1277.85	1273.42	1276.45	72221.0
2008-04-08 17:00:00	ES	Futures	1276.45	1277.38	1273.66	1275.98	5710.0
2008-04-08 18:00:00	ES	Futures	1278.78	1280.64	1276.91	1279.48	11140.0
2008-04-08 19:00:00	ES	Futures	1279.48	1281.57	1278.54	1280.41	5309.0
2008-04-08 20:00:00	ES	Futures	1280.41	1282.97	1279.94	1280.64	4809.0
2008-04-08 21:00:00	ES	Futures	1280.64	1280.87	1276.68	1276.91	4671.0
2008-04-08 22:00:00	ES	Futures	1276.91	1277.15	1273.19	1276.68	6060.0
2008-04-08 23:00:00	ES	Futures	1276.68	1277.85	1274.12	1274.35	2616.0
2008-04-08 00:00:00	NQ	Futures	2104.81	2107.36	2103.4	2103.4	310.0
2008-04-08 01:00:00	NQ	Futures	2103.4	2105.66	2103.4	2105.66	71.0
2008-04-08 02:00:00	NQ	Futures	2105.66	2106.51	2102.83	2103.4	654.0
2008-04-08 03:00:00	NQ	Futures	2103.4	2106.51	2100.0	2101.7	2182.0
2008-04-08 04:00:00	NQ	Futures	2101.98	2104.24	2100.85	2102.83	970.0
2008-04-08 05:00:00	NQ	Futures	2102.55	2103.68	2099.44	2103.68	816.0
2008-04-08 06:00:00	NQ	Futures	2103.68	2103.68	2098.59	2100.85	619.0
2008-04-08 07:00:00	NQ	Futures	2100.85	2101.7	2098.31	2100.57	1112.0
2008-04-08 08:00:00	NQ	Futures	2100.57	2101.13	2094.91	2098.31	4614.0
2008-04-08 09:00:00	NQ	Futures	2098.02	2100.29	2092.65	2098.02	33653.0
2008-04-08 10:00:00	NQ	Futures	2098.02	2109.9	2092.93	2106.22	42826.0
2008-04-08 11:00:00	NQ	Futures	2106.22	2111.03	2100.29	2101.13	25742.0
2008-04-08 12:00:00	NQ	Futures	2101.42	2105.66	2099.72	2102.27	16927.0
2008-04-08 13:00:00	NQ	Futures	2101.98	2103.68	2096.04	2100.0	17807.0
2008-04-08 14:00:00	NQ	Futures	2100.29	2100.29	2085.58	2097.74	49718.0
2008-04-08 15:00:00	NQ	Futures	2097.74	2100.57	2089.82	2095.76	43759.0
2008-04-08 16:00:00	NQ	Futures	2095.76	2101.42	2095.19	2099.15	10415.0
2008-04-08 17:00:00	NQ	Futures	2098.87	2100.0	2094.91	2096.89	398.0
2008-04-08 18:00:00	NQ	Futures	2098.31	2105.38	2094.91	2103.68	585.0
2008-04-08 19:00:00	NQ	Futures	2103.96	2107.64	2102.55	2104.81	393.0
2008-04-08 20:00:00	NQ	Futures	2105.09	2111.32	2104.24	2105.94	369.0
2008-04-08 21:00:00	NQ	Futures	2105.94	2105.94	2099.44	2100.57	157.0
2008-04-08 22:00:00	NQ	Futures	2100.0	2101.42	2093.78	2100.0	387.0
2008-04-08 23:00:00	NQ	Futures	2100.85	2102.55	2096.61	2096.89	86.0
2008-04-08 00:00:00	YM	Futures	11420.8	11435.4	11411.8	11411.8	191.0
2008-04-08 01:00:00	YM	Futures	11411.8	11419.9	11411.8	11419.0	84.0

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

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