PREVIEW / futures_1hour / 2008-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-25.parquet
  size:    41 KB
  rows:    1,201

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-06-25 00:00:00	ES	Futures	1223.43	1224.36	1222.74	1224.13	891.0
2008-06-25 01:00:00	ES	Futures	1224.13	1225.29	1223.9	1224.6	1950.0
2008-06-25 02:00:00	ES	Futures	1225.06	1227.15	1223.67	1226.69	6016.0
2008-06-25 03:00:00	ES	Futures	1226.69	1228.78	1226.46	1228.08	10752.0
2008-06-25 04:00:00	ES	Futures	1228.08	1229.48	1227.15	1228.08	9080.0
2008-06-25 05:00:00	ES	Futures	1228.08	1230.64	1227.39	1230.17	8307.0
2008-06-25 06:00:00	ES	Futures	1229.94	1230.64	1229.01	1229.24	8504.0
2008-06-25 07:00:00	ES	Futures	1229.48	1231.1	1228.32	1228.78	17933.0
2008-06-25 08:00:00	ES	Futures	1228.78	1230.41	1227.85	1229.01	34295.0
2008-06-25 09:00:00	ES	Futures	1229.24	1233.43	1226.46	1231.8	223520.0
2008-06-25 10:00:00	ES	Futures	1231.8	1236.91	1229.48	1235.52	293990.0
2008-06-25 11:00:00	ES	Futures	1235.29	1236.45	1233.43	1234.82	153110.0
2008-06-25 12:00:00	ES	Futures	1234.82	1235.52	1232.73	1233.66	75562.0
2008-06-25 13:00:00	ES	Futures	1233.43	1235.52	1232.73	1233.43	52217.0
2008-06-25 14:00:00	ES	Futures	1233.2	1240.63	1231.34	1238.08	527789.0
2008-06-25 15:00:00	ES	Futures	1237.84	1243.65	1227.62	1230.17	518877.0
2008-06-25 16:00:00	ES	Futures	1230.17	1231.8	1225.76	1226.69	123559.0
2008-06-25 17:00:00	ES	Futures	1226.69	1226.69	1222.74	1223.2	6573.0
2008-06-25 18:00:00	ES	Futures	1223.9	1225.06	1223.43	1224.36	1806.0
2008-06-25 19:00:00	ES	Futures	1224.13	1225.99	1223.9	1225.99	1206.0
2008-06-25 20:00:00	ES	Futures	1226.22	1227.39	1225.76	1226.69	2087.0
2008-06-25 21:00:00	ES	Futures	1226.69	1227.15	1226.22	1226.92	727.0
2008-06-25 22:00:00	ES	Futures	1226.92	1227.15	1226.69	1226.69	1757.0
2008-06-25 23:00:00	ES	Futures	1226.69	1227.62	1226.69	1226.69	946.0
2008-06-25 00:00:00	NQ	Futures	2153.27	2153.83	2152.42	2153.55	67.0
2008-06-25 01:00:00	NQ	Futures	2154.11	2157.2	2153.83	2155.8	171.0
2008-06-25 02:00:00	NQ	Futures	2154.67	2158.61	2153.83	2157.49	302.0
2008-06-25 03:00:00	NQ	Futures	2157.77	2161.7	2157.77	2160.58	1118.0
2008-06-25 04:00:00	NQ	Futures	2160.86	2163.11	2158.89	2159.74	1309.0
2008-06-25 05:00:00	NQ	Futures	2159.74	2164.24	2158.89	2163.11	1057.0
2008-06-25 06:00:00	NQ	Futures	2163.11	2166.2	2161.7	2164.24	888.0
2008-06-25 07:00:00	NQ	Futures	2164.24	2170.42	2163.67	2164.8	2894.0
2008-06-25 08:00:00	NQ	Futures	2164.8	2169.02	2162.83	2166.77	6434.0
2008-06-25 09:00:00	NQ	Futures	2167.05	2174.92	2156.08	2170.14	45090.0
2008-06-25 10:00:00	NQ	Futures	2170.42	2189.55	2165.36	2186.18	61337.0
2008-06-25 11:00:00	NQ	Futures	2186.18	2189.55	2180.83	2186.18	34825.0
2008-06-25 12:00:00	NQ	Futures	2186.18	2189.27	2182.8	2185.9	16988.0
2008-06-25 13:00:00	NQ	Futures	2185.9	2188.15	2180.27	2181.11	13660.0
2008-06-25 14:00:00	NQ	Futures	2180.83	2196.87	2176.05	2193.21	97449.0
2008-06-25 15:00:00	NQ	Futures	2193.21	2206.15	2174.36	2185.61	88121.0
2008-06-25 16:00:00	NQ	Futures	2185.33	2190.96	2165.08	2168.17	24656.0
2008-06-25 17:00:00	NQ	Futures	2168.46	2168.74	2156.64	2159.45	1555.0
2008-06-25 18:00:00	NQ	Futures	2160.3	2163.11	2159.74	2161.7	546.0
2008-06-25 19:00:00	NQ	Futures	2161.99	2164.24	2161.99	2163.39	126.0
2008-06-25 20:00:00	NQ	Futures	2164.24	2165.92	2163.95	2165.92	61.0
2008-06-25 21:00:00	NQ	Futures	2165.64	2165.92	2165.08	2165.64	39.0
2008-06-25 22:00:00	NQ	Futures	2165.92	2166.49	2165.92	2165.92	91.0
2008-06-25 23:00:00	NQ	Futures	2165.64	2166.49	2165.08	2166.49	26.0
2008-06-25 00:00:00	YM	Futures	10737.4	10742.9	10732.9	10742.9	100.0
2008-06-25 01:00:00	YM	Futures	10742.0	10750.2	10739.3	10743.8	171.0

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

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