PREVIEW / futures_1hour / 2008-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-05-21.parquet
  size:    43 KB
  rows:    1,233

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-21 00:00:00	ES	Futures	1320.22	1320.46	1318.83	1319.29	1728.0
2008-05-21 01:00:00	ES	Futures	1319.06	1319.76	1318.13	1318.13	1823.0
2008-05-21 02:00:00	ES	Futures	1318.13	1322.55	1318.13	1321.85	10336.0
2008-05-21 03:00:00	ES	Futures	1321.85	1322.55	1319.29	1321.62	12949.0
2008-05-21 04:00:00	ES	Futures	1321.39	1322.79	1321.16	1322.79	9426.0
2008-05-21 05:00:00	ES	Futures	1322.79	1323.48	1322.09	1322.09	5994.0
2008-05-21 06:00:00	ES	Futures	1322.09	1322.32	1316.96	1319.06	21170.0
2008-05-21 07:00:00	ES	Futures	1319.06	1320.22	1313.94	1317.66	31079.0
2008-05-21 08:00:00	ES	Futures	1317.66	1318.59	1316.03	1318.13	55529.0
2008-05-21 09:00:00	ES	Futures	1317.9	1321.85	1317.43	1317.9	222957.0
2008-05-21 10:00:00	ES	Futures	1317.9	1319.76	1311.84	1312.31	395401.0
2008-05-21 11:00:00	ES	Futures	1312.31	1316.5	1311.38	1315.8	227878.0
2008-05-21 12:00:00	ES	Futures	1315.57	1318.36	1314.17	1316.5	146886.0
2008-05-21 13:00:00	ES	Futures	1316.73	1316.96	1309.51	1310.68	189429.0
2008-05-21 14:00:00	ES	Futures	1310.44	1310.91	1295.31	1299.73	541819.0
2008-05-21 15:00:00	ES	Futures	1299.73	1301.6	1292.75	1295.31	395163.0
2008-05-21 16:00:00	ES	Futures	1295.31	1297.87	1294.61	1296.94	88249.0
2008-05-21 17:00:00	ES	Futures	1296.94	1299.04	1296.47	1298.57	1858.0
2008-05-21 18:00:00	ES	Futures	1298.8	1298.8	1296.94	1297.41	1715.0
2008-05-21 19:00:00	ES	Futures	1297.41	1297.64	1296.24	1296.47	1348.0
2008-05-21 20:00:00	ES	Futures	1296.94	1297.17	1296.01	1296.47	2355.0
2008-05-21 21:00:00	ES	Futures	1296.71	1299.73	1296.47	1299.04	3918.0
2008-05-21 22:00:00	ES	Futures	1299.04	1300.43	1297.87	1298.34	3690.0
2008-05-21 23:00:00	ES	Futures	1298.34	1299.5	1297.41	1299.04	1529.0
2008-05-21 00:00:00	NQ	Futures	2271.96	2273.09	2270.55	2271.11	187.0
2008-05-21 01:00:00	NQ	Futures	2271.11	2271.96	2269.7	2271.11	130.0
2008-05-21 02:00:00	NQ	Futures	2270.83	2276.77	2269.98	2275.36	668.0
2008-05-21 03:00:00	NQ	Futures	2275.36	2276.49	2271.4	2275.07	1275.0
2008-05-21 04:00:00	NQ	Futures	2274.79	2277.05	2273.09	2276.49	736.0
2008-05-21 05:00:00	NQ	Futures	2276.2	2278.18	2276.2	2276.49	551.0
2008-05-21 06:00:00	NQ	Futures	2276.49	2276.49	2266.87	2269.98	1754.0
2008-05-21 07:00:00	NQ	Futures	2269.98	2271.96	2260.37	2265.74	2905.0
2008-05-21 08:00:00	NQ	Futures	2265.74	2266.87	2262.35	2266.02	4950.0
2008-05-21 09:00:00	NQ	Futures	2266.31	2284.41	2264.61	2271.4	45642.0
2008-05-21 10:00:00	NQ	Futures	2271.4	2278.47	2256.12	2257.54	74415.0
2008-05-21 11:00:00	NQ	Futures	2257.82	2262.63	2252.16	2259.52	42333.0
2008-05-21 12:00:00	NQ	Futures	2259.52	2268.0	2256.41	2265.46	35574.0
2008-05-21 13:00:00	NQ	Futures	2265.46	2266.02	2246.79	2247.36	41754.0
2008-05-21 14:00:00	NQ	Futures	2247.07	2247.64	2215.11	2224.45	120189.0
2008-05-21 15:00:00	NQ	Futures	2224.45	2229.26	2210.59	2217.94	93551.0
2008-05-21 16:00:00	NQ	Futures	2217.94	2225.01	2215.96	2221.9	13862.0
2008-05-21 17:00:00	NQ	Futures	2221.9	2224.16	2221.9	2223.6	142.0
2008-05-21 18:00:00	NQ	Futures	2223.32	2223.32	2220.49	2222.75	230.0
2008-05-21 19:00:00	NQ	Futures	2222.75	2223.03	2219.07	2219.07	176.0
2008-05-21 20:00:00	NQ	Futures	2219.64	2221.62	2217.09	2219.07	215.0
2008-05-21 21:00:00	NQ	Futures	2220.49	2224.73	2220.49	2223.6	146.0
2008-05-21 22:00:00	NQ	Futures	2224.16	2226.43	2223.03	2223.32	100.0
2008-05-21 23:00:00	NQ	Futures	2223.03	2225.3	2220.49	2225.3	89.0
2008-05-21 00:00:00	YM	Futures	11669.8	11674.4	11662.5	11662.5	137.0
2008-05-21 01:00:00	YM	Futures	11664.4	11668.0	11659.8	11659.8	175.0

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

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