PREVIEW / futures_1hour / 2008-04-03

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-03.parquet
  size:    42 KB
  rows:    1,229

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-04-03 00:00:00	ES	Futures	1275.98	1276.22	1274.12	1275.52	1601.0
2008-04-03 01:00:00	ES	Futures	1275.52	1277.85	1275.05	1277.61	1765.0
2008-04-03 02:00:00	ES	Futures	1277.85	1279.01	1276.45	1278.54	5653.0
2008-04-03 03:00:00	ES	Futures	1278.31	1279.71	1272.72	1272.96	16285.0
2008-04-03 04:00:00	ES	Futures	1273.19	1277.38	1272.96	1276.68	10764.0
2008-04-03 05:00:00	ES	Futures	1276.68	1276.68	1273.89	1275.52	7311.0
2008-04-03 06:00:00	ES	Futures	1275.75	1275.75	1271.79	1273.42	14019.0
2008-04-03 07:00:00	ES	Futures	1273.42	1275.75	1271.56	1274.59	17693.0
2008-04-03 08:00:00	ES	Futures	1274.59	1275.52	1266.9	1267.37	87756.0
2008-04-03 09:00:00	ES	Futures	1267.37	1272.26	1266.2	1271.79	190308.0
2008-04-03 10:00:00	ES	Futures	1271.56	1275.98	1268.3	1268.53	273280.0
2008-04-03 11:00:00	ES	Futures	1268.53	1276.22	1267.6	1274.82	200944.0
2008-04-03 12:00:00	ES	Futures	1274.82	1280.87	1272.96	1279.24	167528.0
2008-04-03 13:00:00	ES	Futures	1279.24	1283.2	1277.61	1277.61	179776.0
2008-04-03 14:00:00	ES	Futures	1277.61	1281.57	1276.22	1281.11	150912.0
2008-04-03 15:00:00	ES	Futures	1281.11	1281.34	1272.96	1276.68	198500.0
2008-04-03 16:00:00	ES	Futures	1276.91	1280.17	1276.22	1278.78	59508.0
2008-04-03 17:00:00	ES	Futures	1278.78	1279.71	1278.54	1279.48	968.0
2008-04-03 18:00:00	ES	Futures	1279.01	1279.48	1278.54	1278.78	767.0
2008-04-03 19:00:00	ES	Futures	1278.54	1278.78	1278.31	1278.54	692.0
2008-04-03 20:00:00	ES	Futures	1278.54	1279.24	1278.08	1278.54	794.0
2008-04-03 21:00:00	ES	Futures	1278.54	1279.48	1278.08	1279.01	750.0
2008-04-03 22:00:00	ES	Futures	1279.01	1279.48	1278.54	1279.01	408.0
2008-04-03 23:00:00	ES	Futures	1279.01	1279.48	1278.54	1278.54	475.0
2008-04-03 00:00:00	NQ	Futures	2107.64	2108.49	2105.94	2108.2	331.0
2008-04-03 01:00:00	NQ	Futures	2107.36	2111.6	2107.36	2111.32	175.0
2008-04-03 02:00:00	NQ	Futures	2111.32	2112.73	2108.2	2112.16	346.0
2008-04-03 03:00:00	NQ	Futures	2111.88	2113.3	2102.55	2103.4	740.0
2008-04-03 04:00:00	NQ	Futures	2103.4	2109.34	2102.27	2108.77	873.0
2008-04-03 05:00:00	NQ	Futures	2107.92	2108.49	2103.68	2107.07	797.0
2008-04-03 06:00:00	NQ	Futures	2106.79	2106.79	2098.31	2099.72	2137.0
2008-04-03 07:00:00	NQ	Futures	2100.0	2105.38	2096.04	2101.7	2625.0
2008-04-03 08:00:00	NQ	Futures	2101.42	2102.55	2085.58	2088.12	12372.0
2008-04-03 09:00:00	NQ	Futures	2088.41	2096.89	2085.58	2096.04	40661.0
2008-04-03 10:00:00	NQ	Futures	2096.04	2104.24	2084.45	2086.43	56494.0
2008-04-03 11:00:00	NQ	Futures	2086.43	2102.83	2085.01	2100.85	31831.0
2008-04-03 12:00:00	NQ	Futures	2100.85	2117.82	2099.44	2113.58	35853.0
2008-04-03 13:00:00	NQ	Futures	2113.3	2119.8	2106.79	2107.64	38636.0
2008-04-03 14:00:00	NQ	Futures	2107.64	2116.41	2103.4	2115.56	23905.0
2008-04-03 15:00:00	NQ	Futures	2115.56	2115.56	2100.85	2105.38	35381.0
2008-04-03 16:00:00	NQ	Futures	2105.38	2116.12	2103.96	2113.3	10778.0
2008-04-03 17:00:00	NQ	Futures	2113.3	2114.43	2113.3	2113.58	52.0
2008-04-03 18:00:00	NQ	Futures	2113.3	2114.14	2112.45	2112.45	275.0
2008-04-03 19:00:00	NQ	Futures	2112.45	2113.58	2111.6	2113.3	48.0
2008-04-03 20:00:00	NQ	Futures	2113.01	2113.3	2112.45	2113.01	30.0
2008-04-03 21:00:00	NQ	Futures	2112.73	2114.99	2112.45	2113.58	29.0
2008-04-03 22:00:00	NQ	Futures	2113.3	2114.43	2113.3	2113.86	22.0
2008-04-03 23:00:00	NQ	Futures	2114.14	2115.28	2113.58	2114.14	64.0
2008-04-03 00:00:00	YM	Futures	11462.6	11464.5	11445.4	11453.6	126.0
2008-04-03 01:00:00	YM	Futures	11455.4	11477.2	11454.5	11477.2	337.0

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

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