PREVIEW / futures_1hour / 2008-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-28.parquet
  size:    43 KB
  rows:    1,219

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-28 00:00:00	ES	Futures	1189.97	1189.97	1189.04	1189.5	1354.0
2008-08-28 01:00:00	ES	Futures	1189.5	1189.73	1189.04	1189.27	815.0
2008-08-28 02:00:00	ES	Futures	1189.27	1189.5	1187.18	1187.41	4345.0
2008-08-28 03:00:00	ES	Futures	1187.41	1188.34	1185.78	1186.95	11899.0
2008-08-28 04:00:00	ES	Futures	1186.71	1189.04	1186.02	1188.34	9052.0
2008-08-28 05:00:00	ES	Futures	1188.11	1191.36	1188.11	1191.13	9672.0
2008-08-28 06:00:00	ES	Futures	1191.36	1193.22	1190.66	1191.13	10293.0
2008-08-28 07:00:00	ES	Futures	1191.13	1192.76	1190.66	1191.59	7847.0
2008-08-28 08:00:00	ES	Futures	1191.59	1201.12	1190.66	1200.19	86876.0
2008-08-28 09:00:00	ES	Futures	1200.19	1201.12	1197.4	1199.5	208901.0
2008-08-28 10:00:00	ES	Futures	1199.5	1202.52	1197.64	1201.35	264707.0
2008-08-28 11:00:00	ES	Futures	1201.59	1205.54	1198.1	1204.84	232434.0
2008-08-28 12:00:00	ES	Futures	1204.61	1205.77	1202.28	1203.91	135389.0
2008-08-28 13:00:00	ES	Futures	1204.14	1206.7	1202.75	1205.31	95833.0
2008-08-28 14:00:00	ES	Futures	1205.07	1207.63	1202.52	1206.0	124090.0
2008-08-28 15:00:00	ES	Futures	1206.0	1208.56	1204.38	1208.1	176515.0
2008-08-28 16:00:00	ES	Futures	1207.86	1208.33	1205.54	1206.47	114282.0
2008-08-28 17:00:00	ES	Futures	1206.47	1206.7	1206.0	1206.0	1049.0
2008-08-28 18:00:00	ES	Futures	1206.24	1206.7	1205.77	1205.77	1110.0
2008-08-28 19:00:00	ES	Futures	1206.0	1206.0	1205.07	1205.31	885.0
2008-08-28 20:00:00	ES	Futures	1205.07	1205.31	1204.14	1204.38	3045.0
2008-08-28 21:00:00	ES	Futures	1204.38	1204.84	1203.91	1204.38	3749.0
2008-08-28 22:00:00	ES	Futures	1204.38	1204.84	1203.45	1203.68	2671.0
2008-08-28 23:00:00	ES	Futures	1203.68	1204.38	1203.68	1203.91	698.0
2008-08-28 00:00:00	NQ	Futures	2136.39	2136.39	2133.86	2133.86	78.0
2008-08-28 01:00:00	NQ	Futures	2134.42	2136.11	2134.14	2135.54	74.0
2008-08-28 02:00:00	NQ	Futures	2134.42	2134.98	2130.2	2132.17	474.0
2008-08-28 03:00:00	NQ	Futures	2131.89	2133.29	2127.67	2129.36	1150.0
2008-08-28 04:00:00	NQ	Futures	2129.64	2132.73	2129.07	2131.89	1110.0
2008-08-28 05:00:00	NQ	Futures	2131.61	2137.23	2131.33	2136.95	1498.0
2008-08-28 06:00:00	NQ	Futures	2137.23	2140.33	2135.54	2136.39	661.0
2008-08-28 07:00:00	NQ	Futures	2136.67	2138.36	2134.98	2136.95	1582.0
2008-08-28 08:00:00	NQ	Futures	2136.95	2155.23	2135.26	2154.95	15087.0
2008-08-28 09:00:00	NQ	Futures	2154.67	2155.8	2144.55	2153.27	41325.0
2008-08-28 10:00:00	NQ	Futures	2153.27	2161.7	2149.33	2158.89	45776.0
2008-08-28 11:00:00	NQ	Futures	2158.89	2164.8	2152.7	2162.27	39242.0
2008-08-28 12:00:00	NQ	Futures	2161.99	2163.11	2153.55	2158.05	28813.0
2008-08-28 13:00:00	NQ	Futures	2157.77	2163.11	2155.23	2158.89	18265.0
2008-08-28 14:00:00	NQ	Futures	2158.89	2161.99	2151.02	2159.45	24723.0
2008-08-28 15:00:00	NQ	Futures	2159.45	2161.42	2152.98	2155.8	41644.0
2008-08-28 16:00:00	NQ	Futures	2155.52	2158.33	2141.17	2146.23	24074.0
2008-08-28 17:00:00	NQ	Futures	2145.95	2145.95	2144.26	2144.83	147.0
2008-08-28 18:00:00	NQ	Futures	2145.11	2146.8	2144.26	2145.67	341.0
2008-08-28 19:00:00	NQ	Futures	2145.67	2145.67	2144.26	2144.83	118.0
2008-08-28 20:00:00	NQ	Futures	2144.55	2144.55	2142.01	2142.58	362.0
2008-08-28 21:00:00	NQ	Futures	2142.3	2143.14	2141.73	2141.73	88.0
2008-08-28 22:00:00	NQ	Futures	2142.3	2143.7	2141.17	2141.45	160.0
2008-08-28 23:00:00	NQ	Futures	2141.45	2142.3	2140.89	2141.73	76.0
2008-08-28 00:00:00	YM	Futures	10434.8	10435.7	10429.3	10432.1	112.0
2008-08-28 01:00:00	YM	Futures	10432.1	10433.9	10428.4	10430.2	49.0

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

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