PREVIEW / futures_1hour / 2008-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-19.parquet
  size:    41 KB
  rows:    1,204

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-19 00:00:00	ES	Futures	1192.06	1192.29	1191.59	1191.83	486.0
2008-08-19 01:00:00	ES	Futures	1191.83	1191.83	1190.43	1190.43	1222.0
2008-08-19 02:00:00	ES	Futures	1190.43	1190.66	1188.34	1188.8	6770.0
2008-08-19 03:00:00	ES	Futures	1188.8	1188.8	1185.78	1186.25	18222.0
2008-08-19 04:00:00	ES	Futures	1186.25	1189.5	1186.25	1189.04	9062.0
2008-08-19 05:00:00	ES	Futures	1189.04	1190.2	1188.11	1188.8	7955.0
2008-08-19 06:00:00	ES	Futures	1188.8	1190.9	1186.48	1187.41	9345.0
2008-08-19 07:00:00	ES	Futures	1187.41	1188.11	1184.62	1184.85	19608.0
2008-08-19 08:00:00	ES	Futures	1184.85	1185.78	1178.81	1180.21	86605.0
2008-08-19 09:00:00	ES	Futures	1179.97	1184.85	1178.11	1180.9	289234.0
2008-08-19 10:00:00	ES	Futures	1180.67	1181.6	1176.49	1178.35	274734.0
2008-08-19 11:00:00	ES	Futures	1178.35	1178.58	1174.16	1174.86	208536.0
2008-08-19 12:00:00	ES	Futures	1174.86	1179.97	1174.39	1178.58	156131.0
2008-08-19 13:00:00	ES	Futures	1178.58	1182.3	1177.65	1177.88	135240.0
2008-08-19 14:00:00	ES	Futures	1177.88	1179.51	1174.86	1177.65	153960.0
2008-08-19 15:00:00	ES	Futures	1177.65	1179.97	1173.93	1178.58	244457.0
2008-08-19 16:00:00	ES	Futures	1178.58	1180.21	1177.42	1178.35	85421.0
2008-08-19 17:00:00	ES	Futures	1178.58	1179.51	1178.35	1179.04	954.0
2008-08-19 18:00:00	ES	Futures	1179.04	1179.51	1178.35	1179.28	884.0
2008-08-19 19:00:00	ES	Futures	1179.28	1179.97	1178.58	1179.97	1144.0
2008-08-19 20:00:00	ES	Futures	1179.97	1180.9	1179.74	1180.21	1849.0
2008-08-19 21:00:00	ES	Futures	1180.21	1180.44	1179.28	1180.21	840.0
2008-08-19 22:00:00	ES	Futures	1180.21	1182.99	1179.97	1182.53	2705.0
2008-08-19 23:00:00	ES	Futures	1182.53	1182.99	1182.3	1182.53	1724.0
2008-08-19 00:00:00	NQ	Futures	2187.3	2187.58	2186.74	2186.74	10.0
2008-08-19 01:00:00	NQ	Futures	2187.02	2187.3	2185.05	2185.05	140.0
2008-08-19 02:00:00	NQ	Futures	2184.77	2185.33	2181.68	2182.52	753.0
2008-08-19 03:00:00	NQ	Futures	2182.24	2182.24	2176.61	2177.46	2146.0
2008-08-19 04:00:00	NQ	Futures	2177.18	2183.08	2177.18	2180.83	1427.0
2008-08-19 05:00:00	NQ	Futures	2181.68	2183.08	2179.14	2180.55	748.0
2008-08-19 06:00:00	NQ	Futures	2180.27	2183.08	2176.33	2179.43	1229.0
2008-08-19 07:00:00	NQ	Futures	2179.14	2180.55	2171.27	2172.96	2941.0
2008-08-19 08:00:00	NQ	Futures	2173.24	2175.77	2165.92	2168.74	11060.0
2008-08-19 09:00:00	NQ	Futures	2168.74	2180.55	2164.52	2170.14	70211.0
2008-08-19 10:00:00	NQ	Futures	2169.86	2170.42	2159.17	2161.7	50945.0
2008-08-19 11:00:00	NQ	Futures	2161.42	2167.89	2158.33	2158.89	40539.0
2008-08-19 12:00:00	NQ	Futures	2158.61	2162.27	2150.17	2158.05	42873.0
2008-08-19 13:00:00	NQ	Futures	2158.05	2170.71	2156.08	2158.05	32492.0
2008-08-19 14:00:00	NQ	Futures	2157.77	2162.55	2149.33	2153.27	40344.0
2008-08-19 15:00:00	NQ	Futures	2152.98	2153.55	2141.17	2152.98	71631.0
2008-08-19 16:00:00	NQ	Futures	2152.98	2161.14	2151.3	2158.89	14525.0
2008-08-19 17:00:00	NQ	Futures	2158.05	2161.14	2158.05	2159.74	192.0
2008-08-19 18:00:00	NQ	Futures	2160.02	2160.58	2158.89	2160.02	50.0
2008-08-19 19:00:00	NQ	Futures	2160.3	2160.3	2159.74	2160.02	74.0
2008-08-19 20:00:00	NQ	Futures	2161.14	2162.27	2160.86	2161.42	120.0
2008-08-19 21:00:00	NQ	Futures	2161.7	2161.99	2160.86	2161.7	63.0
2008-08-19 22:00:00	NQ	Futures	2161.99	2167.33	2161.99	2167.05	477.0
2008-08-19 23:00:00	NQ	Futures	2167.05	2167.33	2166.2	2167.05	80.0
2008-08-19 00:00:00	YM	Futures	10453.9	10455.7	10447.5	10448.4	72.0
2008-08-19 01:00:00	YM	Futures	10448.4	10449.3	10441.1	10441.1	38.0

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

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