PREVIEW / futures_1hour / 2008-01-02

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-02.parquet
  size:    25 KB
  rows:    646

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-02 06:00:00	ES	Futures	1379.12	1382.85	1378.89	1382.62	16442.0
2008-01-02 07:00:00	ES	Futures	1382.38	1382.62	1378.65	1379.12	13692.0
2008-01-02 08:00:00	ES	Futures	1379.12	1379.59	1376.55	1379.12	16357.0
2008-01-02 09:00:00	ES	Futures	1379.35	1380.75	1375.62	1377.95	129622.0
2008-01-02 10:00:00	ES	Futures	1377.95	1378.19	1365.6	1366.3	284224.0
2008-01-02 11:00:00	ES	Futures	1366.3	1367.69	1358.13	1362.1	242664.0
2008-01-02 12:00:00	ES	Futures	1362.1	1362.1	1355.1	1357.44	140808.0
2008-01-02 13:00:00	ES	Futures	1357.44	1359.77	1353.47	1358.13	131835.0
2008-01-02 14:00:00	ES	Futures	1358.37	1366.76	1355.8	1356.04	279587.0
2008-01-02 15:00:00	ES	Futures	1356.04	1358.37	1351.37	1356.97	274703.0
2008-01-02 16:00:00	ES	Futures	1357.2	1361.87	1356.97	1360.93	81462.0
2008-01-02 17:00:00	ES	Futures	1360.93	1362.1	1360.93	1361.63	2122.0
2008-01-02 18:00:00	ES	Futures	1361.87	1363.26	1361.4	1361.63	7631.0
2008-01-02 19:00:00	ES	Futures	1361.63	1363.03	1361.4	1363.03	1230.0
2008-01-02 20:00:00	ES	Futures	1363.03	1363.03	1362.1	1362.33	1463.0
2008-01-02 21:00:00	ES	Futures	1362.56	1363.26	1362.33	1363.03	890.0
2008-01-02 22:00:00	ES	Futures	1363.26	1363.73	1362.8	1363.26	1538.0
2008-01-02 23:00:00	ES	Futures	1363.5	1363.96	1363.03	1363.96	2052.0
2008-01-02 06:00:00	NQ	Futures	2397.06	2403.59	2396.21	2402.74	1437.0
2008-01-02 07:00:00	NQ	Futures	2402.45	2402.74	2396.21	2396.78	1006.0
2008-01-02 08:00:00	NQ	Futures	2396.78	2397.91	2392.23	2393.09	1944.0
2008-01-02 09:00:00	NQ	Futures	2393.09	2398.76	2387.41	2394.51	28083.0
2008-01-02 10:00:00	NQ	Futures	2394.51	2394.51	2372.65	2373.22	64675.0
2008-01-02 11:00:00	NQ	Futures	2373.22	2378.33	2341.71	2351.36	71664.0
2008-01-02 12:00:00	NQ	Futures	2351.36	2351.36	2335.18	2343.41	45320.0
2008-01-02 13:00:00	NQ	Futures	2343.7	2349.37	2334.9	2345.4	36927.0
2008-01-02 14:00:00	NQ	Futures	2346.25	2366.4	2340.86	2341.43	72497.0
2008-01-02 15:00:00	NQ	Futures	2341.43	2349.94	2336.03	2347.95	56385.0
2008-01-02 16:00:00	NQ	Futures	2347.67	2355.33	2345.4	2351.36	10823.0
2008-01-02 17:00:00	NQ	Futures	2352.21	2354.48	2351.93	2354.48	164.0
2008-01-02 18:00:00	NQ	Futures	2353.63	2356.19	2353.63	2354.48	190.0
2008-01-02 19:00:00	NQ	Futures	2354.2	2355.9	2353.06	2355.33	73.0
2008-01-02 20:00:00	NQ	Futures	2356.47	2356.75	2353.92	2355.33	26.0
2008-01-02 21:00:00	NQ	Futures	2355.62	2357.04	2354.77	2357.04	29.0
2008-01-02 22:00:00	NQ	Futures	2356.75	2357.89	2355.62	2357.61	41.0
2008-01-02 23:00:00	NQ	Futures	2357.04	2357.89	2356.75	2357.32	60.0
2008-01-02 00:00:00	YM	Futures	12097.6	12097.6	12088.5	12088.5	50.0
2008-01-02 01:00:00	YM	Futures	12086.7	12086.7	12023.1	12063.0	268.0
2008-01-02 02:00:00	YM	Futures	12062.1	12065.8	12042.1	12062.1	203.0
2008-01-02 03:00:00	YM	Futures	12062.1	12126.6	12061.2	12118.5	710.0
2008-01-02 04:00:00	YM	Futures	12118.5	12119.4	12108.5	12108.5	216.0
2008-01-02 05:00:00	YM	Futures	12108.5	12120.3	12099.4	12119.4	276.0
2008-01-02 06:00:00	YM	Futures	12119.4	12152.1	12118.5	12148.4	996.0
2008-01-02 07:00:00	YM	Futures	12149.3	12149.3	12119.4	12123.9	487.0
2008-01-02 08:00:00	YM	Futures	12123.9	12129.4	12105.7	12124.8	1782.0
2008-01-02 09:00:00	YM	Futures	12123.9	12127.5	12094.8	12106.6	12184.0
2008-01-02 10:00:00	YM	Futures	12106.6	12107.6	11992.2	12001.3	32061.0
2008-01-02 11:00:00	YM	Futures	12000.4	12013.1	11943.1	11969.5	23865.0
2008-01-02 12:00:00	YM	Futures	11968.6	11970.4	11903.1	11921.3	17239.0
2008-01-02 13:00:00	YM	Futures	11920.4	11929.5	11879.5	11909.5	17464.0

> showing 50 of 646 rows — these rows as CSV

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