PREVIEW / futures_1hour / 2008-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-02.parquet
  size:    44 KB
  rows:    1,244

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-02 00:00:00	ES	Futures	1275.05	1276.91	1275.05	1276.68	1028.0
2008-04-02 01:00:00	ES	Futures	1276.45	1276.68	1274.82	1275.52	2319.0
2008-04-02 02:00:00	ES	Futures	1275.75	1275.75	1272.72	1273.66	8836.0
2008-04-02 03:00:00	ES	Futures	1273.66	1273.66	1270.4	1270.63	19173.0
2008-04-02 04:00:00	ES	Futures	1270.86	1273.42	1270.16	1271.79	17094.0
2008-04-02 05:00:00	ES	Futures	1271.56	1271.56	1269.46	1270.86	14617.0
2008-04-02 06:00:00	ES	Futures	1270.63	1274.59	1270.63	1274.12	13559.0
2008-04-02 07:00:00	ES	Futures	1274.12	1278.54	1273.66	1278.31	28144.0
2008-04-02 08:00:00	ES	Futures	1278.08	1282.74	1277.15	1279.48	83769.0
2008-04-02 09:00:00	ES	Futures	1279.48	1279.94	1272.49	1274.35	214889.0
2008-04-02 10:00:00	ES	Futures	1274.35	1285.3	1271.79	1283.9	327000.0
2008-04-02 11:00:00	ES	Futures	1284.13	1284.83	1278.78	1283.67	226247.0
2008-04-02 12:00:00	ES	Futures	1283.9	1285.06	1278.08	1279.71	137278.0
2008-04-02 13:00:00	ES	Futures	1279.71	1282.5	1275.98	1280.64	152699.0
2008-04-02 14:00:00	ES	Futures	1280.87	1283.9	1272.26	1274.12	246948.0
2008-04-02 15:00:00	ES	Futures	1274.12	1275.98	1269.46	1275.98	245246.0
2008-04-02 16:00:00	ES	Futures	1275.98	1278.08	1273.89	1273.89	69452.0
2008-04-02 17:00:00	ES	Futures	1273.89	1275.28	1273.89	1275.05	2164.0
2008-04-02 18:00:00	ES	Futures	1274.82	1275.05	1273.66	1273.66	1317.0
2008-04-02 19:00:00	ES	Futures	1273.42	1274.12	1272.72	1274.12	1221.0
2008-04-02 20:00:00	ES	Futures	1273.89	1275.52	1273.19	1274.59	1708.0
2008-04-02 21:00:00	ES	Futures	1274.59	1274.82	1273.42	1273.66	1154.0
2008-04-02 22:00:00	ES	Futures	1273.66	1275.52	1273.19	1275.05	1568.0
2008-04-02 23:00:00	ES	Futures	1275.28	1276.22	1275.05	1275.98	1348.0
2008-04-02 00:00:00	NQ	Futures	2097.17	2102.55	2096.89	2100.57	165.0
2008-04-02 01:00:00	NQ	Futures	2100.85	2102.27	2098.87	2098.87	420.0
2008-04-02 02:00:00	NQ	Futures	2100.0	2100.0	2094.06	2095.19	790.0
2008-04-02 03:00:00	NQ	Futures	2094.91	2097.46	2090.39	2092.08	1482.0
2008-04-02 04:00:00	NQ	Futures	2092.08	2098.02	2091.52	2095.76	1573.0
2008-04-02 05:00:00	NQ	Futures	2095.48	2096.61	2092.08	2095.76	1224.0
2008-04-02 06:00:00	NQ	Futures	2096.33	2102.83	2096.04	2102.83	1321.0
2008-04-02 07:00:00	NQ	Futures	2102.55	2108.77	2101.7	2108.2	2810.0
2008-04-02 08:00:00	NQ	Futures	2108.2	2114.71	2106.51	2110.75	9228.0
2008-04-02 09:00:00	NQ	Futures	2110.47	2110.47	2098.31	2101.98	47637.0
2008-04-02 10:00:00	NQ	Futures	2102.27	2124.89	2098.02	2120.08	74744.0
2008-04-02 11:00:00	NQ	Futures	2120.08	2121.21	2112.45	2118.95	37529.0
2008-04-02 12:00:00	NQ	Futures	2118.67	2122.06	2105.94	2108.77	31544.0
2008-04-02 13:00:00	NQ	Futures	2109.05	2112.45	2100.85	2108.49	30888.0
2008-04-02 14:00:00	NQ	Futures	2108.49	2113.58	2090.39	2094.35	49488.0
2008-04-02 15:00:00	NQ	Futures	2094.06	2100.85	2085.3	2100.57	57339.0
2008-04-02 16:00:00	NQ	Futures	2100.29	2110.75	2096.89	2103.96	16163.0
2008-04-02 17:00:00	NQ	Futures	2103.68	2109.34	2103.68	2108.49	547.0
2008-04-02 18:00:00	NQ	Futures	2107.07	2107.36	2104.24	2104.24	175.0
2008-04-02 19:00:00	NQ	Futures	2104.53	2105.66	2103.11	2105.09	97.0
2008-04-02 20:00:00	NQ	Futures	2104.81	2106.79	2103.96	2105.94	42.0
2008-04-02 21:00:00	NQ	Futures	2104.81	2105.66	2103.68	2103.68	94.0
2008-04-02 22:00:00	NQ	Futures	2103.68	2105.94	2103.11	2104.81	196.0
2008-04-02 23:00:00	NQ	Futures	2104.53	2107.36	2104.53	2107.36	101.0
2008-04-02 00:00:00	YM	Futures	11467.2	11482.6	11463.5	11481.7	101.0
2008-04-02 01:00:00	YM	Futures	11479.9	11480.8	11466.3	11471.7	128.0

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

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