PREVIEW / futures_1hour / 2008-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-17.parquet
  size:    30 KB
  rows:    773

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-01-17 00:00:00	ES	Futures	1288.42	1290.99	1288.19	1290.75	4651.0
2008-01-17 01:00:00	ES	Futures	1290.75	1291.69	1290.29	1291.45	3083.0
2008-01-17 02:00:00	ES	Futures	1291.45	1294.48	1291.22	1294.02	11161.0
2008-01-17 03:00:00	ES	Futures	1294.25	1295.65	1290.52	1290.99	17408.0
2008-01-17 04:00:00	ES	Futures	1290.99	1293.32	1288.89	1290.05	16289.0
2008-01-17 05:00:00	ES	Futures	1290.05	1290.75	1287.49	1288.89	11169.0
2008-01-17 06:00:00	ES	Futures	1288.65	1289.82	1287.02	1287.95	13417.0
2008-01-17 07:00:00	ES	Futures	1287.95	1289.35	1276.76	1281.89	82171.0
2008-01-17 08:00:00	ES	Futures	1282.13	1291.69	1277.93	1290.99	118631.0
2008-01-17 09:00:00	ES	Futures	1290.99	1292.38	1283.52	1287.72	229559.0
2008-01-17 10:00:00	ES	Futures	1287.72	1288.19	1266.97	1273.27	685515.0
2008-01-17 11:00:00	ES	Futures	1273.27	1277.23	1263.71	1264.41	336251.0
2008-01-17 12:00:00	ES	Futures	1264.41	1267.67	1259.28	1264.64	331174.0
2008-01-17 13:00:00	ES	Futures	1264.64	1270.93	1261.37	1265.34	237684.0
2008-01-17 14:00:00	ES	Futures	1265.34	1266.74	1253.91	1259.74	415694.0
2008-01-17 15:00:00	ES	Futures	1259.51	1264.17	1244.12	1246.92	671794.0
2008-01-17 16:00:00	ES	Futures	1246.92	1252.28	1246.45	1252.05	174342.0
2008-01-17 17:00:00	ES	Futures	1252.05	1252.51	1251.82	1251.82	3559.0
2008-01-17 18:00:00	ES	Futures	1251.82	1255.78	1251.35	1254.61	12652.0
2008-01-17 19:00:00	ES	Futures	1254.61	1255.78	1253.21	1254.85	5858.0
2008-01-17 20:00:00	ES	Futures	1254.85	1255.08	1253.91	1254.61	2008.0
2008-01-17 21:00:00	ES	Futures	1254.61	1255.78	1253.91	1254.85	3446.0
2008-01-17 22:00:00	ES	Futures	1254.85	1257.18	1254.61	1256.71	3339.0
2008-01-17 23:00:00	ES	Futures	1256.71	1258.11	1256.71	1257.88	3404.0
2008-01-17 00:00:00	NQ	Futures	2141.88	2146.71	2141.88	2146.43	237.0
2008-01-17 01:00:00	NQ	Futures	2146.14	2149.26	2146.14	2148.7	173.0
2008-01-17 02:00:00	NQ	Futures	2148.7	2153.24	2147.56	2152.95	641.0
2008-01-17 03:00:00	NQ	Futures	2152.95	2155.79	2146.71	2146.71	1131.0
2008-01-17 04:00:00	NQ	Futures	2147.28	2151.82	2145.86	2147.28	1161.0
2008-01-17 05:00:00	NQ	Futures	2147.28	2152.39	2147.28	2150.68	1373.0
2008-01-17 06:00:00	NQ	Futures	2150.4	2151.82	2147.28	2147.85	852.0
2008-01-17 07:00:00	NQ	Futures	2147.85	2150.4	2132.23	2143.02	5521.0
2008-01-17 08:00:00	NQ	Futures	2142.74	2158.91	2133.94	2156.36	13714.0
2008-01-17 09:00:00	NQ	Futures	2156.36	2162.89	2145.86	2158.63	62686.0
2008-01-17 10:00:00	NQ	Futures	2158.35	2158.91	2119.18	2135.36	129487.0
2008-01-17 11:00:00	NQ	Futures	2135.64	2146.99	2123.15	2124.0	74034.0
2008-01-17 12:00:00	NQ	Futures	2124.0	2137.34	2112.36	2128.54	68932.0
2008-01-17 13:00:00	NQ	Futures	2128.26	2143.87	2120.31	2131.1	60042.0
2008-01-17 14:00:00	NQ	Futures	2130.81	2134.5	2110.95	2121.16	90147.0
2008-01-17 15:00:00	NQ	Futures	2121.16	2128.26	2099.02	2106.12	112097.0
2008-01-17 16:00:00	NQ	Futures	2105.84	2123.43	2101.01	2118.33	22208.0
2008-01-17 17:00:00	NQ	Futures	2118.61	2121.16	2118.04	2118.61	1415.0
2008-01-17 18:00:00	NQ	Futures	2117.47	2122.58	2112.36	2118.89	656.0
2008-01-17 19:00:00	NQ	Futures	2118.61	2122.58	2117.47	2121.16	295.0
2008-01-17 20:00:00	NQ	Futures	2121.45	2122.3	2120.03	2120.6	147.0
2008-01-17 21:00:00	NQ	Futures	2120.6	2121.73	2120.03	2121.16	120.0
2008-01-17 22:00:00	NQ	Futures	2120.88	2122.58	2120.31	2122.02	72.0
2008-01-17 23:00:00	NQ	Futures	2122.02	2125.42	2122.02	2123.43	437.0
2008-01-17 00:00:00	YM	Futures	11379.8	11401.7	11376.2	11396.2	197.0
2008-01-17 01:00:00	YM	Futures	11397.1	11408.9	11395.3	11408.0	165.0

> showing 50 of 773 rows — these rows as CSV

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