PREVIEW / futures_1hour / 2008-08-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1180.44	1180.9	1180.21	1180.67	1003.0
2008-08-21 01:00:00	ES	Futures	1180.9	1181.37	1179.04	1179.74	3355.0
2008-08-21 02:00:00	ES	Futures	1179.74	1180.44	1178.11	1179.28	6192.0
2008-08-21 03:00:00	ES	Futures	1179.51	1180.67	1175.32	1177.18	20847.0
2008-08-21 04:00:00	ES	Futures	1177.18	1180.21	1176.02	1179.04	12323.0
2008-08-21 05:00:00	ES	Futures	1179.28	1179.74	1175.56	1176.95	8987.0
2008-08-21 06:00:00	ES	Futures	1176.95	1179.74	1176.72	1178.58	10250.0
2008-08-21 07:00:00	ES	Futures	1178.81	1180.67	1176.72	1176.95	23296.0
2008-08-21 08:00:00	ES	Futures	1177.18	1180.44	1175.09	1176.02	41711.0
2008-08-21 09:00:00	ES	Futures	1176.02	1181.6	1174.39	1180.67	209561.0
2008-08-21 10:00:00	ES	Futures	1180.67	1183.92	1176.49	1179.51	315066.0
2008-08-21 11:00:00	ES	Futures	1179.51	1183.92	1176.49	1181.83	217189.0
2008-08-21 12:00:00	ES	Futures	1181.83	1184.62	1180.44	1182.06	121244.0
2008-08-21 13:00:00	ES	Futures	1181.83	1186.25	1181.83	1183.92	130397.0
2008-08-21 14:00:00	ES	Futures	1183.69	1190.9	1182.76	1189.04	192798.0
2008-08-21 15:00:00	ES	Futures	1189.04	1191.59	1186.71	1187.18	196953.0
2008-08-21 16:00:00	ES	Futures	1187.41	1187.41	1185.32	1185.78	69704.0
2008-08-21 17:00:00	ES	Futures	1186.02	1186.25	1185.09	1185.32	1437.0
2008-08-21 18:00:00	ES	Futures	1185.32	1186.48	1185.09	1185.09	1303.0
2008-08-21 19:00:00	ES	Futures	1185.09	1185.78	1184.85	1185.55	843.0
2008-08-21 20:00:00	ES	Futures	1185.32	1185.32	1182.06	1183.23	4421.0
2008-08-21 21:00:00	ES	Futures	1183.23	1184.39	1182.53	1183.92	1698.0
2008-08-21 22:00:00	ES	Futures	1184.16	1184.62	1183.23	1183.69	1197.0
2008-08-21 23:00:00	ES	Futures	1183.69	1185.78	1183.46	1185.09	1820.0
2008-08-21 00:00:00	NQ	Futures	2147.92	2148.77	2146.8	2148.2	151.0
2008-08-21 01:00:00	NQ	Futures	2147.64	2151.02	2146.8	2147.92	461.0
2008-08-21 02:00:00	NQ	Futures	2147.92	2149.33	2144.55	2146.8	501.0
2008-08-21 03:00:00	NQ	Futures	2146.8	2148.77	2138.64	2142.3	2789.0
2008-08-21 04:00:00	NQ	Futures	2142.58	2148.48	2140.05	2146.23	1534.0
2008-08-21 05:00:00	NQ	Futures	2146.23	2146.8	2139.2	2141.45	678.0
2008-08-21 06:00:00	NQ	Futures	2141.17	2145.95	2140.89	2143.98	702.0
2008-08-21 07:00:00	NQ	Futures	2143.98	2150.17	2141.45	2142.58	2033.0
2008-08-21 08:00:00	NQ	Futures	2142.86	2148.77	2139.76	2140.61	4149.0
2008-08-21 09:00:00	NQ	Futures	2140.89	2148.48	2135.26	2146.8	38472.0
2008-08-21 10:00:00	NQ	Futures	2146.51	2151.3	2125.14	2131.04	69268.0
2008-08-21 11:00:00	NQ	Futures	2131.04	2140.05	2124.57	2136.95	43323.0
2008-08-21 12:00:00	NQ	Futures	2136.67	2142.01	2131.61	2132.73	27375.0
2008-08-21 13:00:00	NQ	Futures	2133.01	2146.23	2132.45	2142.3	27909.0
2008-08-21 14:00:00	NQ	Futures	2142.3	2156.92	2140.89	2148.77	37381.0
2008-08-21 15:00:00	NQ	Futures	2149.05	2154.67	2145.67	2146.23	35454.0
2008-08-21 16:00:00	NQ	Futures	2146.23	2147.64	2144.26	2147.08	9372.0
2008-08-21 17:00:00	NQ	Futures	2146.8	2147.08	2145.39	2145.39	29.0
2008-08-21 18:00:00	NQ	Futures	2145.95	2146.8	2144.55	2144.55	38.0
2008-08-21 19:00:00	NQ	Futures	2144.55	2145.67	2143.98	2145.39	18.0
2008-08-21 20:00:00	NQ	Futures	2145.67	2145.67	2139.2	2141.73	135.0
2008-08-21 21:00:00	NQ	Futures	2141.73	2142.3	2140.33	2142.3	232.0
2008-08-21 22:00:00	NQ	Futures	2141.45	2143.14	2140.61	2140.89	56.0
2008-08-21 23:00:00	NQ	Futures	2141.45	2145.11	2141.17	2145.11	169.0
2008-08-21 00:00:00	YM	Futures	10333.9	10335.7	10327.5	10334.8	205.0
2008-08-21 01:00:00	YM	Futures	10333.0	10336.6	10321.2	10329.4	502.0

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

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