PREVIEW / futures_1hour / 2008-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-20.parquet
  size:    45 KB
  rows:    1,247

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-11-20 00:00:00	ES	Futures	760.36	761.54	757.99	759.41	7769.0
2008-11-20 01:00:00	ES	Futures	759.65	760.36	752.78	757.28	9649.0
2008-11-20 02:00:00	ES	Futures	757.28	760.36	753.97	757.52	14560.0
2008-11-20 03:00:00	ES	Futures	757.52	764.38	754.44	755.86	34117.0
2008-11-20 04:00:00	ES	Futures	755.86	760.12	753.49	756.1	21355.0
2008-11-20 05:00:00	ES	Futures	756.1	758.7	752.78	755.62	21424.0
2008-11-20 06:00:00	ES	Futures	755.39	760.36	753.97	759.88	16722.0
2008-11-20 07:00:00	ES	Futures	759.88	768.64	758.7	762.49	51811.0
2008-11-20 08:00:00	ES	Futures	762.72	765.09	748.76	751.13	82417.0
2008-11-20 09:00:00	ES	Futures	750.89	759.65	741.9	743.08	432086.0
2008-11-20 10:00:00	ES	Futures	742.84	760.36	732.9	758.46	755903.0
2008-11-20 11:00:00	ES	Futures	758.46	764.85	748.05	749.0	443791.0
2008-11-20 12:00:00	ES	Futures	749.0	776.92	743.08	765.09	519911.0
2008-11-20 13:00:00	ES	Futures	764.85	766.51	748.29	760.36	427438.0
2008-11-20 14:00:00	ES	Futures	760.59	762.49	736.93	740.71	369577.0
2008-11-20 15:00:00	ES	Futures	740.71	746.63	705.69	712.55	1041777.0
2008-11-20 16:00:00	ES	Futures	712.79	713.5	705.22	712.79	175550.0
2008-11-20 17:00:00	ES	Futures	712.79	714.21	710.42	711.13	7393.0
2008-11-20 18:00:00	ES	Futures	710.66	716.58	710.19	715.39	9854.0
2008-11-20 19:00:00	ES	Futures	715.39	718.7	711.61	714.45	8737.0
2008-11-20 20:00:00	ES	Futures	714.45	715.87	711.13	713.74	6816.0
2008-11-20 21:00:00	ES	Futures	713.97	715.16	712.79	712.79	4820.0
2008-11-20 22:00:00	ES	Futures	712.79	716.81	712.79	716.58	9300.0
2008-11-20 23:00:00	ES	Futures	716.58	724.38	716.1	722.96	14437.0
2008-11-20 00:00:00	NQ	Futures	1224.67	1226.93	1220.99	1222.68	219.0
2008-11-20 01:00:00	NQ	Futures	1224.1	1224.1	1211.37	1214.76	906.0
2008-11-20 02:00:00	NQ	Futures	1216.46	1222.12	1212.22	1217.59	647.0
2008-11-20 03:00:00	NQ	Futures	1218.72	1228.63	1211.08	1215.33	2562.0
2008-11-20 04:00:00	NQ	Futures	1215.61	1221.55	1211.65	1212.78	777.0
2008-11-20 05:00:00	NQ	Futures	1215.04	1219.01	1209.67	1214.76	1011.0
2008-11-20 06:00:00	NQ	Futures	1213.91	1223.25	1212.78	1223.25	934.0
2008-11-20 07:00:00	NQ	Futures	1222.97	1235.42	1220.99	1226.36	3225.0
2008-11-20 08:00:00	NQ	Futures	1226.36	1231.46	1207.12	1209.95	6376.0
2008-11-20 09:00:00	NQ	Futures	1209.67	1227.78	1205.42	1212.5	57967.0
2008-11-20 10:00:00	NQ	Futures	1211.93	1247.02	1195.24	1241.64	105464.0
2008-11-20 11:00:00	NQ	Futures	1241.93	1256.07	1232.31	1233.44	72068.0
2008-11-20 12:00:00	NQ	Futures	1233.44	1262.02	1221.55	1247.59	71311.0
2008-11-20 13:00:00	NQ	Futures	1247.3	1249.0	1224.1	1246.17	64122.0
2008-11-20 14:00:00	NQ	Futures	1245.89	1248.72	1206.27	1211.65	49308.0
2008-11-20 15:00:00	NQ	Futures	1211.37	1219.57	1170.34	1174.3	121386.0
2008-11-20 16:00:00	NQ	Futures	1176.56	1187.88	1167.22	1185.33	24537.0
2008-11-20 17:00:00	NQ	Futures	1185.05	1186.47	1181.37	1181.37	272.0
2008-11-20 18:00:00	NQ	Futures	1182.5	1186.75	1181.09	1185.9	275.0
2008-11-20 19:00:00	NQ	Futures	1185.9	1191.28	1182.22	1187.31	248.0
2008-11-20 20:00:00	NQ	Futures	1187.31	1189.01	1183.92	1189.01	328.0
2008-11-20 21:00:00	NQ	Futures	1189.58	1190.14	1187.31	1189.3	154.0
2008-11-20 22:00:00	NQ	Futures	1189.01	1191.56	1186.75	1191.56	193.0
2008-11-20 23:00:00	NQ	Futures	1191.56	1200.33	1191.56	1196.65	338.0
2008-11-20 00:00:00	YM	Futures	7230.7	7249.8	7212.5	7230.7	357.0
2008-11-20 01:00:00	YM	Futures	7238.0	7238.9	7174.3	7203.4	1146.0

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

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