PREVIEW / futures_1hour / 2008-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-29.parquet
  size:    36 KB
  rows:    971

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-08-29 00:00:00	ES	Futures	1203.91	1204.61	1203.68	1204.14	879.0
2008-08-29 01:00:00	ES	Futures	1204.14	1204.61	1203.91	1203.91	895.0
2008-08-29 02:00:00	ES	Futures	1203.91	1205.07	1203.68	1204.38	3248.0
2008-08-29 03:00:00	ES	Futures	1204.14	1204.84	1201.82	1202.52	13387.0
2008-08-29 04:00:00	ES	Futures	1202.52	1203.45	1201.59	1203.21	6251.0
2008-08-29 05:00:00	ES	Futures	1203.21	1206.0	1202.75	1205.54	8054.0
2008-08-29 06:00:00	ES	Futures	1205.54	1206.24	1203.91	1204.84	6479.0
2008-08-29 07:00:00	ES	Futures	1204.61	1206.7	1203.45	1206.0	10941.0
2008-08-29 08:00:00	ES	Futures	1206.0	1206.24	1202.98	1203.45	21971.0
2008-08-29 09:00:00	ES	Futures	1203.45	1206.47	1201.12	1204.38	192091.0
2008-08-29 10:00:00	ES	Futures	1204.38	1205.31	1196.24	1196.94	264082.0
2008-08-29 11:00:00	ES	Futures	1196.94	1199.26	1196.24	1197.64	144981.0
2008-08-29 12:00:00	ES	Futures	1197.4	1197.64	1193.69	1197.17	137666.0
2008-08-29 13:00:00	ES	Futures	1196.94	1200.89	1196.71	1198.1	107393.0
2008-08-29 14:00:00	ES	Futures	1197.87	1200.19	1197.64	1199.5	69369.0
2008-08-29 15:00:00	ES	Futures	1199.26	1199.73	1192.29	1193.22	237208.0
2008-08-29 16:00:00	ES	Futures	1193.22	1193.92	1191.36	1193.22	103853.0
2008-08-29 00:00:00	NQ	Futures	2141.17	2141.73	2140.89	2141.73	82.0
2008-08-29 01:00:00	NQ	Futures	2142.3	2142.3	2141.45	2141.73	35.0
2008-08-29 02:00:00	NQ	Futures	2141.73	2143.42	2140.89	2142.3	409.0
2008-08-29 03:00:00	NQ	Futures	2141.45	2143.14	2138.64	2139.48	1389.0
2008-08-29 04:00:00	NQ	Futures	2139.48	2140.61	2137.23	2139.48	1045.0
2008-08-29 05:00:00	NQ	Futures	2140.05	2144.83	2138.64	2143.42	663.0
2008-08-29 06:00:00	NQ	Futures	2143.42	2144.55	2139.76	2141.73	557.0
2008-08-29 07:00:00	NQ	Futures	2141.45	2145.39	2140.89	2143.7	1097.0
2008-08-29 08:00:00	NQ	Futures	2143.98	2145.39	2136.95	2138.08	4716.0
2008-08-29 09:00:00	NQ	Futures	2138.08	2142.58	2128.79	2135.83	48642.0
2008-08-29 10:00:00	NQ	Futures	2135.54	2137.79	2107.98	2109.38	89566.0
2008-08-29 11:00:00	NQ	Futures	2109.67	2115.29	2104.88	2106.29	52373.0
2008-08-29 12:00:00	NQ	Futures	2106.29	2111.63	2101.23	2110.51	40065.0
2008-08-29 13:00:00	NQ	Futures	2110.51	2121.48	2109.38	2113.04	38111.0
2008-08-29 14:00:00	NQ	Futures	2113.32	2118.95	2112.2	2117.82	21698.0
2008-08-29 15:00:00	NQ	Futures	2117.82	2118.1	2107.13	2111.63	49282.0
2008-08-29 16:00:00	NQ	Futures	2111.92	2112.48	2104.6	2110.51	14556.0
2008-08-29 00:00:00	YM	Futures	10611.1	10612.0	10608.4	10612.0	108.0
2008-08-29 01:00:00	YM	Futures	10612.0	10615.7	10607.5	10611.1	82.0
2008-08-29 02:00:00	YM	Futures	10612.9	10618.4	10606.6	10611.1	333.0
2008-08-29 03:00:00	YM	Futures	10609.3	10612.9	10591.1	10596.6	1031.0
2008-08-29 04:00:00	YM	Futures	10595.7	10603.8	10590.2	10600.2	719.0
2008-08-29 05:00:00	YM	Futures	10602.0	10626.6	10599.3	10620.2	642.0
2008-08-29 06:00:00	YM	Futures	10620.2	10626.6	10610.2	10614.7	330.0
2008-08-29 07:00:00	YM	Futures	10612.9	10629.3	10602.9	10622.9	1252.0
2008-08-29 08:00:00	YM	Futures	10624.7	10625.6	10591.1	10594.7	3335.0
2008-08-29 09:00:00	YM	Futures	10593.8	10631.1	10574.8	10602.9	21167.0
2008-08-29 10:00:00	YM	Futures	10602.9	10611.1	10535.7	10542.9	29637.0
2008-08-29 11:00:00	YM	Futures	10542.0	10558.4	10531.1	10539.3	18415.0
2008-08-29 12:00:00	YM	Futures	10539.3	10539.3	10487.5	10524.8	20616.0
2008-08-29 13:00:00	YM	Futures	10525.7	10562.0	10524.8	10535.7	15768.0
2008-08-29 14:00:00	YM	Futures	10535.7	10554.8	10531.1	10543.8	8026.0
2008-08-29 15:00:00	YM	Futures	10543.8	10544.8	10489.3	10498.4	19931.0

> showing 50 of 971 rows — these rows as CSV

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