PREVIEW / futures_1hour / 2008-05-20

all futures 1-hour files

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

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-05-20 00:00:00	ES	Futures	1329.3	1329.77	1328.84	1329.07	417.0
2008-05-20 01:00:00	ES	Futures	1329.07	1329.77	1329.07	1329.07	572.0
2008-05-20 02:00:00	ES	Futures	1329.3	1329.3	1326.51	1326.74	6202.0
2008-05-20 03:00:00	ES	Futures	1326.98	1328.37	1326.51	1327.44	11197.0
2008-05-20 04:00:00	ES	Futures	1327.21	1328.14	1326.28	1326.51	6422.0
2008-05-20 05:00:00	ES	Futures	1326.74	1326.74	1325.35	1325.35	11521.0
2008-05-20 06:00:00	ES	Futures	1325.35	1326.74	1325.11	1325.81	11028.0
2008-05-20 07:00:00	ES	Futures	1325.58	1326.28	1325.11	1325.81	10710.0
2008-05-20 08:00:00	ES	Futures	1325.58	1326.98	1321.39	1322.79	88372.0
2008-05-20 09:00:00	ES	Futures	1322.79	1324.41	1319.76	1319.99	210879.0
2008-05-20 10:00:00	ES	Futures	1319.76	1321.62	1317.66	1320.69	311650.0
2008-05-20 11:00:00	ES	Futures	1320.92	1321.39	1315.1	1316.27	260277.0
2008-05-20 12:00:00	ES	Futures	1316.27	1320.46	1315.57	1316.96	168172.0
2008-05-20 13:00:00	ES	Futures	1317.2	1319.53	1313.7	1314.17	183757.0
2008-05-20 14:00:00	ES	Futures	1314.4	1315.8	1312.31	1313.7	192775.0
2008-05-20 15:00:00	ES	Futures	1313.94	1318.36	1312.31	1317.9	286696.0
2008-05-20 16:00:00	ES	Futures	1317.9	1320.69	1317.66	1319.06	83424.0
2008-05-20 17:00:00	ES	Futures	1319.06	1319.29	1318.59	1319.06	790.0
2008-05-20 18:00:00	ES	Futures	1319.06	1319.29	1318.36	1318.83	1258.0
2008-05-20 19:00:00	ES	Futures	1318.83	1319.99	1318.36	1318.59	1174.0
2008-05-20 20:00:00	ES	Futures	1318.59	1319.76	1318.13	1319.76	1769.0
2008-05-20 21:00:00	ES	Futures	1319.76	1319.76	1318.59	1319.29	1226.0
2008-05-20 22:00:00	ES	Futures	1319.06	1320.22	1318.83	1319.53	1622.0
2008-05-20 23:00:00	ES	Futures	1319.76	1320.22	1319.29	1319.99	1669.0
2008-05-20 00:00:00	NQ	Futures	2287.8	2288.37	2287.24	2287.24	86.0
2008-05-20 01:00:00	NQ	Futures	2286.95	2288.08	2286.95	2287.8	31.0
2008-05-20 02:00:00	NQ	Futures	2287.8	2288.08	2283.56	2283.84	599.0
2008-05-20 03:00:00	NQ	Futures	2283.84	2286.1	2283.28	2284.41	500.0
2008-05-20 04:00:00	NQ	Futures	2284.41	2286.67	2282.71	2282.71	738.0
2008-05-20 05:00:00	NQ	Futures	2282.71	2283.84	2281.86	2282.14	529.0
2008-05-20 06:00:00	NQ	Futures	2281.86	2284.41	2281.58	2281.86	504.0
2008-05-20 07:00:00	NQ	Futures	2281.58	2283.28	2280.45	2282.71	901.0
2008-05-20 08:00:00	NQ	Futures	2282.14	2284.41	2273.94	2275.92	5887.0
2008-05-20 09:00:00	NQ	Futures	2276.2	2278.47	2264.89	2266.31	59973.0
2008-05-20 10:00:00	NQ	Futures	2266.02	2268.29	2256.41	2265.74	64869.0
2008-05-20 11:00:00	NQ	Futures	2265.74	2266.02	2252.73	2256.69	49032.0
2008-05-20 12:00:00	NQ	Futures	2256.97	2269.98	2255.56	2263.19	30215.0
2008-05-20 13:00:00	NQ	Futures	2263.19	2269.13	2255.28	2255.84	36892.0
2008-05-20 14:00:00	NQ	Futures	2255.56	2263.19	2251.6	2257.54	37090.0
2008-05-20 15:00:00	NQ	Futures	2257.82	2268.57	2255.56	2268.57	54777.0
2008-05-20 16:00:00	NQ	Futures	2268.57	2274.22	2268.0	2271.11	13068.0
2008-05-20 17:00:00	NQ	Futures	2271.11	2271.4	2269.7	2271.11	311.0
2008-05-20 18:00:00	NQ	Futures	2269.7	2271.11	2269.42	2270.55	168.0
2008-05-20 19:00:00	NQ	Futures	2270.83	2271.96	2269.7	2271.4	166.0
2008-05-20 20:00:00	NQ	Futures	2271.4	2272.25	2271.11	2271.68	53.0
2008-05-20 21:00:00	NQ	Futures	2271.96	2272.81	2269.7	2270.55	174.0
2008-05-20 22:00:00	NQ	Futures	2271.11	2272.53	2270.83	2270.83	74.0
2008-05-20 23:00:00	NQ	Futures	2270.83	2273.38	2270.83	2271.4	48.0
2008-05-20 00:00:00	YM	Futures	11839.7	11839.7	11835.2	11837.0	35.0
2008-05-20 01:00:00	YM	Futures	11837.9	11840.6	11835.2	11836.1	71.0

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

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