PREVIEW / futures_1hour / 2008-05-27

all futures 1-hour files

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

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-27 00:00:00	ES	Futures	1281.34	1282.5	1281.34	1282.5	379.0
2008-05-27 01:00:00	ES	Futures	1282.5	1283.43	1282.27	1283.43	1664.0
2008-05-27 02:00:00	ES	Futures	1283.43	1284.6	1283.2	1284.13	4598.0
2008-05-27 03:00:00	ES	Futures	1284.37	1285.06	1280.64	1280.87	11332.0
2008-05-27 04:00:00	ES	Futures	1280.87	1281.11	1277.38	1277.85	12504.0
2008-05-27 05:00:00	ES	Futures	1278.08	1279.94	1277.85	1279.94	8936.0
2008-05-27 06:00:00	ES	Futures	1279.94	1280.41	1277.38	1278.08	6801.0
2008-05-27 07:00:00	ES	Futures	1278.31	1279.01	1276.45	1278.31	12976.0
2008-05-27 08:00:00	ES	Futures	1278.31	1279.48	1277.38	1279.48	26403.0
2008-05-27 09:00:00	ES	Futures	1279.24	1286.69	1278.78	1284.13	212925.0
2008-05-27 10:00:00	ES	Futures	1284.13	1289.26	1282.5	1286.23	281989.0
2008-05-27 11:00:00	ES	Futures	1286.23	1287.63	1279.48	1279.94	223296.0
2008-05-27 12:00:00	ES	Futures	1279.94	1283.9	1278.54	1283.67	127238.0
2008-05-27 13:00:00	ES	Futures	1283.67	1285.3	1281.11	1284.83	122390.0
2008-05-27 14:00:00	ES	Futures	1285.06	1290.65	1283.67	1289.95	207378.0
2008-05-27 15:00:00	ES	Futures	1289.95	1292.52	1288.79	1290.19	206448.0
2008-05-27 16:00:00	ES	Futures	1289.95	1290.65	1289.02	1289.95	69057.0
2008-05-27 17:00:00	ES	Futures	1289.72	1290.19	1288.79	1289.95	1990.0
2008-05-27 18:00:00	ES	Futures	1289.95	1290.19	1289.26	1289.49	990.0
2008-05-27 19:00:00	ES	Futures	1289.72	1290.19	1289.26	1289.49	547.0
2008-05-27 20:00:00	ES	Futures	1289.49	1289.95	1288.56	1288.79	1565.0
2008-05-27 21:00:00	ES	Futures	1288.56	1289.49	1287.16	1287.39	2446.0
2008-05-27 22:00:00	ES	Futures	1287.16	1288.32	1286.69	1287.86	1205.0
2008-05-27 23:00:00	ES	Futures	1287.63	1288.79	1286.93	1288.32	1242.0
2008-05-27 00:00:00	NQ	Futures	2221.9	2223.6	2220.77	2223.32	76.0
2008-05-27 01:00:00	NQ	Futures	2223.32	2225.01	2223.03	2225.01	131.0
2008-05-27 02:00:00	NQ	Futures	2225.3	2227.84	2225.3	2227.56	441.0
2008-05-27 03:00:00	NQ	Futures	2227.56	2228.12	2221.05	2221.62	1265.0
2008-05-27 04:00:00	NQ	Futures	2221.62	2221.9	2214.55	2215.68	1317.0
2008-05-27 05:00:00	NQ	Futures	2215.96	2221.34	2215.4	2221.34	1749.0
2008-05-27 06:00:00	NQ	Futures	2221.05	2222.75	2217.66	2219.07	805.0
2008-05-27 07:00:00	NQ	Futures	2218.79	2220.2	2213.42	2217.94	1100.0
2008-05-27 08:00:00	NQ	Futures	2218.22	2221.9	2215.96	2221.62	2412.0
2008-05-27 09:00:00	NQ	Futures	2221.62	2242.27	2220.77	2234.63	46464.0
2008-05-27 10:00:00	NQ	Futures	2234.63	2246.51	2232.37	2243.11	51328.0
2008-05-27 11:00:00	NQ	Futures	2242.83	2245.38	2226.43	2226.99	38768.0
2008-05-27 12:00:00	NQ	Futures	2226.99	2234.35	2223.88	2233.78	27740.0
2008-05-27 13:00:00	NQ	Futures	2233.78	2243.11	2231.52	2242.27	32309.0
2008-05-27 14:00:00	NQ	Futures	2242.27	2258.39	2239.72	2255.84	58439.0
2008-05-27 15:00:00	NQ	Futures	2255.56	2260.93	2253.58	2259.24	48601.0
2008-05-27 16:00:00	NQ	Futures	2258.95	2260.37	2254.14	2255.56	10715.0
2008-05-27 17:00:00	NQ	Futures	2255.84	2256.12	2254.71	2255.84	312.0
2008-05-27 18:00:00	NQ	Futures	2255.84	2257.26	2255.56	2255.56	137.0
2008-05-27 19:00:00	NQ	Futures	2255.84	2257.26	2255.56	2256.97	61.0
2008-05-27 20:00:00	NQ	Futures	2256.12	2256.12	2253.86	2253.86	104.0
2008-05-27 21:00:00	NQ	Futures	2253.86	2254.71	2251.32	2252.73	131.0
2008-05-27 22:00:00	NQ	Futures	2251.88	2252.73	2250.47	2252.73	67.0
2008-05-27 23:00:00	NQ	Futures	2252.45	2253.86	2251.32	2253.86	91.0
2008-05-27 00:00:00	YM	Futures	11349.1	11356.3	11346.3	11355.4	60.0
2008-05-27 01:00:00	YM	Futures	11356.3	11364.5	11355.4	11364.5	214.0

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

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