PREVIEW / futures_1hour / 2008-08-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	1182.76	1182.76	1182.06	1182.53	1199.0
2008-08-20 01:00:00	ES	Futures	1182.53	1182.76	1181.6	1182.3	1015.0
2008-08-20 02:00:00	ES	Futures	1182.3	1183.46	1181.6	1181.83	6144.0
2008-08-20 03:00:00	ES	Futures	1181.83	1183.69	1180.67	1183.23	9717.0
2008-08-20 04:00:00	ES	Futures	1183.23	1184.39	1182.76	1184.16	9054.0
2008-08-20 05:00:00	ES	Futures	1184.16	1185.32	1183.23	1183.92	12993.0
2008-08-20 06:00:00	ES	Futures	1183.92	1184.39	1181.13	1183.23	9227.0
2008-08-20 07:00:00	ES	Futures	1183.46	1183.92	1182.06	1182.53	9847.0
2008-08-20 08:00:00	ES	Futures	1182.76	1182.99	1178.81	1179.04	35576.0
2008-08-20 09:00:00	ES	Futures	1179.04	1182.3	1172.3	1174.63	272668.0
2008-08-20 10:00:00	ES	Futures	1174.86	1186.02	1171.84	1185.78	417237.0
2008-08-20 11:00:00	ES	Futures	1185.78	1186.95	1179.51	1181.6	222392.0
2008-08-20 12:00:00	ES	Futures	1181.6	1182.53	1175.56	1177.88	150757.0
2008-08-20 13:00:00	ES	Futures	1177.65	1180.9	1177.18	1179.74	108551.0
2008-08-20 14:00:00	ES	Futures	1179.74	1180.21	1174.16	1180.21	167379.0
2008-08-20 15:00:00	ES	Futures	1180.21	1185.55	1176.72	1185.09	242252.0
2008-08-20 16:00:00	ES	Futures	1185.09	1185.32	1183.46	1184.39	77701.0
2008-08-20 17:00:00	ES	Futures	1184.62	1185.78	1184.39	1185.78	1372.0
2008-08-20 18:00:00	ES	Futures	1185.55	1185.55	1183.92	1184.16	872.0
2008-08-20 19:00:00	ES	Futures	1183.92	1184.39	1183.69	1184.16	480.0
2008-08-20 20:00:00	ES	Futures	1183.92	1184.16	1182.3	1182.53	2476.0
2008-08-20 21:00:00	ES	Futures	1182.53	1182.76	1181.6	1182.3	2153.0
2008-08-20 22:00:00	ES	Futures	1182.3	1182.53	1180.67	1181.6	1983.0
2008-08-20 23:00:00	ES	Futures	1181.6	1181.83	1180.21	1180.21	1413.0
2008-08-20 00:00:00	NQ	Futures	2167.05	2167.89	2166.49	2167.33	133.0
2008-08-20 01:00:00	NQ	Futures	2167.33	2168.17	2166.77	2167.61	271.0
2008-08-20 02:00:00	NQ	Futures	2167.33	2169.3	2167.05	2168.17	815.0
2008-08-20 03:00:00	NQ	Futures	2167.89	2171.27	2165.08	2170.14	1672.0
2008-08-20 04:00:00	NQ	Futures	2170.42	2171.55	2169.02	2171.55	986.0
2008-08-20 05:00:00	NQ	Futures	2171.55	2173.52	2169.86	2171.27	898.0
2008-08-20 06:00:00	NQ	Futures	2171.27	2172.67	2165.92	2169.02	1242.0
2008-08-20 07:00:00	NQ	Futures	2168.74	2170.71	2167.61	2169.02	1492.0
2008-08-20 08:00:00	NQ	Futures	2168.74	2169.58	2161.14	2161.7	6868.0
2008-08-20 09:00:00	NQ	Futures	2161.42	2169.86	2149.05	2155.8	48501.0
2008-08-20 10:00:00	NQ	Futures	2156.08	2177.74	2149.05	2175.49	73515.0
2008-08-20 11:00:00	NQ	Futures	2175.49	2178.3	2158.05	2163.67	50404.0
2008-08-20 12:00:00	NQ	Futures	2163.39	2166.49	2147.36	2151.3	37070.0
2008-08-20 13:00:00	NQ	Futures	2151.3	2159.45	2149.89	2156.08	22797.0
2008-08-20 14:00:00	NQ	Futures	2156.08	2156.08	2140.33	2153.27	41042.0
2008-08-20 15:00:00	NQ	Futures	2152.98	2157.2	2142.3	2156.64	45863.0
2008-08-20 16:00:00	NQ	Futures	2156.36	2156.92	2152.98	2153.83	6464.0
2008-08-20 17:00:00	NQ	Futures	2153.83	2156.36	2152.98	2156.36	693.0
2008-08-20 18:00:00	NQ	Futures	2156.08	2156.08	2152.42	2152.7	119.0
2008-08-20 19:00:00	NQ	Futures	2152.7	2152.98	2152.42	2152.42	122.0
2008-08-20 20:00:00	NQ	Futures	2152.42	2152.42	2150.45	2150.45	148.0
2008-08-20 21:00:00	NQ	Futures	2150.45	2150.73	2148.77	2150.45	181.0
2008-08-20 22:00:00	NQ	Futures	2150.73	2150.73	2147.64	2148.2	184.0
2008-08-20 23:00:00	NQ	Futures	2148.2	2149.33	2147.64	2147.92	108.0
2008-08-20 00:00:00	YM	Futures	10348.4	10350.3	10344.8	10346.6	64.0
2008-08-20 01:00:00	YM	Futures	10345.7	10353.9	10343.9	10349.4	147.0

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

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