PREVIEW / futures_1hour / 2008-01-03

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-03.parquet
  size:    28 KB
  rows:    738

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-03 00:00:00	ES	Futures	1363.96	1364.43	1363.73	1363.96	2111.0
2008-01-03 01:00:00	ES	Futures	1364.2	1365.36	1363.96	1364.66	2355.0
2008-01-03 02:00:00	ES	Futures	1364.43	1364.9	1361.17	1362.33	4584.0
2008-01-03 03:00:00	ES	Futures	1362.1	1364.2	1360.23	1361.17	14481.0
2008-01-03 04:00:00	ES	Futures	1361.4	1362.1	1358.6	1359.3	9570.0
2008-01-03 05:00:00	ES	Futures	1359.3	1359.77	1357.2	1357.67	13943.0
2008-01-03 06:00:00	ES	Futures	1357.9	1359.07	1356.97	1357.9	8745.0
2008-01-03 07:00:00	ES	Futures	1357.67	1362.56	1357.44	1358.83	19092.0
2008-01-03 08:00:00	ES	Futures	1358.83	1364.9	1357.44	1362.8	50500.0
2008-01-03 09:00:00	ES	Futures	1362.56	1363.26	1356.5	1359.53	156404.0
2008-01-03 10:00:00	ES	Futures	1359.53	1365.13	1357.44	1359.3	238059.0
2008-01-03 11:00:00	ES	Futures	1359.3	1364.43	1359.07	1362.56	144309.0
2008-01-03 12:00:00	ES	Futures	1362.56	1366.06	1361.63	1363.03	107193.0
2008-01-03 13:00:00	ES	Futures	1363.26	1363.26	1359.07	1359.53	78030.0
2008-01-03 14:00:00	ES	Futures	1359.77	1361.63	1357.67	1359.3	103313.0
2008-01-03 15:00:00	ES	Futures	1359.3	1359.77	1353.24	1356.27	225335.0
2008-01-03 16:00:00	ES	Futures	1356.5	1360.7	1356.27	1360.0	61261.0
2008-01-03 17:00:00	ES	Futures	1360.0	1360.23	1359.77	1360.0	706.0
2008-01-03 18:00:00	ES	Futures	1360.0	1360.93	1359.53	1360.47	1575.0
2008-01-03 19:00:00	ES	Futures	1360.47	1361.17	1357.67	1357.9	3805.0
2008-01-03 20:00:00	ES	Futures	1357.9	1358.37	1356.97	1357.67	2857.0
2008-01-03 21:00:00	ES	Futures	1357.67	1358.37	1357.2	1358.37	1816.0
2008-01-03 22:00:00	ES	Futures	1358.37	1361.17	1357.9	1360.7	1980.0
2008-01-03 23:00:00	ES	Futures	1360.7	1364.43	1360.7	1363.5	4310.0
2008-01-03 00:00:00	NQ	Futures	2357.61	2359.02	2357.04	2358.17	102.0
2008-01-03 01:00:00	NQ	Futures	2358.46	2360.44	2358.17	2358.46	75.0
2008-01-03 02:00:00	NQ	Futures	2359.02	2359.02	2353.63	2355.05	269.0
2008-01-03 03:00:00	NQ	Futures	2355.62	2358.17	2351.08	2352.5	1329.0
2008-01-03 04:00:00	NQ	Futures	2352.5	2353.63	2346.25	2347.39	1272.0
2008-01-03 05:00:00	NQ	Futures	2347.67	2348.24	2342.28	2343.7	1090.0
2008-01-03 06:00:00	NQ	Futures	2343.13	2346.54	2341.99	2343.41	923.0
2008-01-03 07:00:00	NQ	Futures	2343.7	2351.36	2342.56	2343.41	1724.0
2008-01-03 08:00:00	NQ	Futures	2343.98	2355.62	2341.14	2351.08	7153.0
2008-01-03 09:00:00	NQ	Futures	2351.08	2352.21	2337.45	2341.14	41456.0
2008-01-03 10:00:00	NQ	Futures	2340.86	2358.17	2340.01	2345.68	60734.0
2008-01-03 11:00:00	NQ	Futures	2345.68	2354.77	2345.4	2351.36	33516.0
2008-01-03 12:00:00	NQ	Futures	2351.08	2363.85	2350.51	2356.47	38269.0
2008-01-03 13:00:00	NQ	Futures	2356.47	2357.04	2348.52	2350.23	21596.0
2008-01-03 14:00:00	NQ	Futures	2350.51	2351.93	2343.41	2348.24	22911.0
2008-01-03 15:00:00	NQ	Futures	2348.24	2349.09	2335.18	2348.81	48024.0
2008-01-03 16:00:00	NQ	Futures	2348.81	2357.89	2348.24	2354.2	10007.0
2008-01-03 17:00:00	NQ	Futures	2354.2	2354.48	2353.63	2353.92	106.0
2008-01-03 18:00:00	NQ	Futures	2354.48	2357.89	2354.48	2357.89	95.0
2008-01-03 19:00:00	NQ	Futures	2358.17	2358.74	2353.06	2353.06	91.0
2008-01-03 20:00:00	NQ	Futures	2353.92	2354.48	2351.93	2353.06	98.0
2008-01-03 21:00:00	NQ	Futures	2353.06	2354.77	2352.78	2354.48	49.0
2008-01-03 22:00:00	NQ	Futures	2354.48	2359.59	2354.48	2358.74	276.0
2008-01-03 23:00:00	NQ	Futures	2358.46	2364.7	2358.46	2362.15	318.0
2008-01-03 00:00:00	YM	Futures	11963.1	11964.9	11960.4	11963.1	101.0
2008-01-03 01:00:00	YM	Futures	11963.1	11972.2	11963.1	11966.7	228.0

> showing 50 of 738 rows — these rows as CSV

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