PREVIEW / futures_1hour / 2008-04-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	1279.71	1279.94	1279.24	1279.48	879.0
2008-04-24 01:00:00	ES	Futures	1279.48	1280.87	1279.24	1279.94	1719.0
2008-04-24 02:00:00	ES	Futures	1279.71	1283.43	1279.48	1282.74	3841.0
2008-04-24 03:00:00	ES	Futures	1282.74	1284.83	1280.87	1281.8	12534.0
2008-04-24 04:00:00	ES	Futures	1281.8	1281.8	1277.61	1280.87	18805.0
2008-04-24 05:00:00	ES	Futures	1280.64	1282.04	1279.01	1280.17	8407.0
2008-04-24 06:00:00	ES	Futures	1279.94	1280.17	1274.12	1275.05	23168.0
2008-04-24 07:00:00	ES	Futures	1275.05	1279.24	1274.59	1277.38	18033.0
2008-04-24 08:00:00	ES	Futures	1277.38	1284.37	1275.52	1282.5	94403.0
2008-04-24 09:00:00	ES	Futures	1282.5	1290.65	1281.8	1285.76	231081.0
2008-04-24 10:00:00	ES	Futures	1285.53	1285.53	1277.85	1280.64	333306.0
2008-04-24 11:00:00	ES	Futures	1280.64	1293.45	1280.17	1291.12	337839.0
2008-04-24 12:00:00	ES	Futures	1291.12	1299.73	1290.89	1297.41	271873.0
2008-04-24 13:00:00	ES	Futures	1297.17	1300.2	1293.91	1298.34	158179.0
2008-04-24 14:00:00	ES	Futures	1298.57	1303.23	1297.64	1300.66	197236.0
2008-04-24 15:00:00	ES	Futures	1300.43	1303.23	1293.45	1294.38	271018.0
2008-04-24 16:00:00	ES	Futures	1294.38	1294.84	1288.09	1288.56	122538.0
2008-04-24 17:00:00	ES	Futures	1288.56	1290.42	1288.32	1289.02	2562.0
2008-04-24 18:00:00	ES	Futures	1289.26	1290.65	1289.26	1289.95	1041.0
2008-04-24 19:00:00	ES	Futures	1289.72	1290.19	1288.56	1289.49	912.0
2008-04-24 20:00:00	ES	Futures	1289.49	1291.82	1288.56	1290.65	1783.0
2008-04-24 21:00:00	ES	Futures	1290.65	1291.12	1289.72	1290.89	794.0
2008-04-24 22:00:00	ES	Futures	1290.65	1291.12	1289.72	1290.19	426.0
2008-04-24 23:00:00	ES	Futures	1290.19	1292.75	1288.32	1292.52	2395.0
2008-04-24 00:00:00	NQ	Futures	2141.58	2142.71	2140.45	2142.71	140.0
2008-04-24 01:00:00	NQ	Futures	2142.71	2144.97	2141.3	2143.84	109.0
2008-04-24 02:00:00	NQ	Futures	2143.84	2148.37	2143.28	2146.39	317.0
2008-04-24 03:00:00	NQ	Futures	2146.95	2152.61	2146.1	2147.23	1307.0
2008-04-24 04:00:00	NQ	Futures	2146.95	2146.95	2140.16	2145.82	1732.0
2008-04-24 05:00:00	NQ	Futures	2145.82	2147.23	2143.28	2145.82	838.0
2008-04-24 06:00:00	NQ	Futures	2145.54	2146.1	2138.75	2138.75	1095.0
2008-04-24 07:00:00	NQ	Futures	2138.75	2147.8	2138.47	2145.26	2278.0
2008-04-24 08:00:00	NQ	Futures	2145.26	2156.57	2145.26	2153.17	12210.0
2008-04-24 09:00:00	NQ	Futures	2152.89	2167.03	2146.1	2152.04	44507.0
2008-04-24 10:00:00	NQ	Futures	2151.76	2151.76	2140.16	2147.23	52007.0
2008-04-24 11:00:00	NQ	Futures	2147.52	2184.29	2146.95	2177.78	73272.0
2008-04-24 12:00:00	NQ	Futures	2178.06	2192.2	2178.06	2185.7	51650.0
2008-04-24 13:00:00	NQ	Futures	2185.7	2194.18	2180.89	2193.05	31918.0
2008-04-24 14:00:00	NQ	Futures	2193.05	2203.8	2191.36	2201.26	46348.0
2008-04-24 15:00:00	NQ	Futures	2201.26	2205.5	2180.89	2182.02	64244.0
2008-04-24 16:00:00	NQ	Futures	2182.59	2184.29	2164.2	2165.34	26147.0
2008-04-24 17:00:00	NQ	Futures	2165.34	2169.86	2165.05	2167.03	801.0
2008-04-24 18:00:00	NQ	Futures	2167.6	2170.43	2167.6	2168.16	224.0
2008-04-24 19:00:00	NQ	Futures	2167.88	2168.16	2165.9	2168.16	148.0
2008-04-24 20:00:00	NQ	Futures	2168.16	2169.86	2167.6	2167.88	145.0
2008-04-24 21:00:00	NQ	Futures	2168.16	2168.45	2166.75	2168.16	94.0
2008-04-24 22:00:00	NQ	Futures	2168.45	2168.45	2166.47	2167.03	30.0
2008-04-24 23:00:00	NQ	Futures	2167.6	2169.58	2165.34	2169.58	334.0
2008-04-24 00:00:00	YM	Futures	11553.5	11553.5	11549.0	11551.7	82.0
2008-04-24 01:00:00	YM	Futures	11551.7	11560.8	11547.1	11552.6	113.0

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

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