PREVIEW / futures_1hour / 2008-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-05-01.parquet
  size:    39 KB
  rows:    1,113

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-05-01 00:00:00	ES	Futures	1290.89	1290.89	1289.95	1289.95	383.0
2008-05-01 01:00:00	ES	Futures	1290.19	1292.05	1289.95	1292.05	805.0
2008-05-01 02:00:00	ES	Futures	1292.05	1292.98	1291.12	1291.35	1652.0
2008-05-01 03:00:00	ES	Futures	1291.58	1293.68	1290.89	1293.21	4966.0
2008-05-01 04:00:00	ES	Futures	1293.21	1293.68	1291.35	1291.82	2368.0
2008-05-01 05:00:00	ES	Futures	1291.82	1293.91	1291.35	1293.68	2260.0
2008-05-01 06:00:00	ES	Futures	1293.68	1294.38	1292.52	1294.15	4270.0
2008-05-01 07:00:00	ES	Futures	1294.15	1294.38	1292.98	1293.91	7383.0
2008-05-01 08:00:00	ES	Futures	1293.68	1294.38	1289.49	1289.95	46651.0
2008-05-01 09:00:00	ES	Futures	1290.19	1294.61	1288.09	1292.52	188703.0
2008-05-01 10:00:00	ES	Futures	1292.52	1296.94	1291.82	1296.01	341157.0
2008-05-01 11:00:00	ES	Futures	1295.78	1299.97	1294.61	1297.64	191721.0
2008-05-01 12:00:00	ES	Futures	1297.87	1310.21	1297.64	1308.58	265595.0
2008-05-01 13:00:00	ES	Futures	1308.81	1313.94	1306.95	1307.88	242498.0
2008-05-01 14:00:00	ES	Futures	1307.88	1314.17	1306.72	1310.68	248876.0
2008-05-01 15:00:00	ES	Futures	1310.44	1314.4	1307.88	1313.47	250469.0
2008-05-01 16:00:00	ES	Futures	1313.24	1315.33	1312.54	1314.4	91048.0
2008-05-01 17:00:00	ES	Futures	1314.4	1314.87	1314.4	1314.87	798.0
2008-05-01 18:00:00	ES	Futures	1314.4	1315.1	1313.7	1314.87	1381.0
2008-05-01 19:00:00	ES	Futures	1315.1	1315.33	1314.17	1314.87	1787.0
2008-05-01 20:00:00	ES	Futures	1314.87	1317.9	1314.64	1316.27	3572.0
2008-05-01 21:00:00	ES	Futures	1316.27	1316.96	1315.57	1316.73	1140.0
2008-05-01 22:00:00	ES	Futures	1316.73	1316.73	1315.8	1316.27	1230.0
2008-05-01 23:00:00	ES	Futures	1316.03	1316.96	1315.8	1316.73	1110.0
2008-05-01 00:00:00	NQ	Futures	2178.91	2179.48	2178.06	2178.63	27.0
2008-05-01 01:00:00	NQ	Futures	2178.63	2180.33	2178.35	2180.04	177.0
2008-05-01 02:00:00	NQ	Futures	2180.04	2183.15	2179.76	2179.76	263.0
2008-05-01 03:00:00	NQ	Futures	2179.76	2183.72	2179.19	2183.44	242.0
2008-05-01 04:00:00	NQ	Futures	2183.44	2183.44	2179.19	2180.04	212.0
2008-05-01 05:00:00	NQ	Futures	2179.76	2182.02	2177.5	2182.02	294.0
2008-05-01 06:00:00	NQ	Futures	2181.74	2182.02	2180.33	2180.89	76.0
2008-05-01 07:00:00	NQ	Futures	2180.89	2184.57	2177.5	2182.31	756.0
2008-05-01 08:00:00	NQ	Futures	2182.02	2184.0	2178.06	2180.04	3536.0
2008-05-01 09:00:00	NQ	Futures	2180.04	2197.01	2173.82	2195.88	41068.0
2008-05-01 10:00:00	NQ	Futures	2195.6	2214.27	2195.32	2213.98	86069.0
2008-05-01 11:00:00	NQ	Futures	2214.27	2224.73	2212.85	2219.64	60584.0
2008-05-01 12:00:00	NQ	Futures	2219.64	2237.74	2219.64	2234.06	52463.0
2008-05-01 13:00:00	NQ	Futures	2233.78	2239.44	2227.84	2230.39	49896.0
2008-05-01 14:00:00	NQ	Futures	2230.39	2240.29	2227.28	2234.63	62344.0
2008-05-01 15:00:00	NQ	Futures	2234.63	2246.51	2230.39	2245.09	60799.0
2008-05-01 16:00:00	NQ	Futures	2245.09	2246.22	2242.55	2244.53	16290.0
2008-05-01 17:00:00	NQ	Futures	2244.25	2245.09	2243.96	2244.53	210.0
2008-05-01 18:00:00	NQ	Futures	2244.25	2244.81	2243.4	2243.68	131.0
2008-05-01 19:00:00	NQ	Futures	2244.53	2244.81	2243.11	2243.96	400.0
2008-05-01 20:00:00	NQ	Futures	2243.4	2246.22	2243.4	2245.09	113.0
2008-05-01 21:00:00	NQ	Futures	2245.66	2247.36	2245.66	2246.79	98.0
2008-05-01 22:00:00	NQ	Futures	2246.79	2247.36	2245.38	2246.51	96.0
2008-05-01 23:00:00	NQ	Futures	2245.94	2247.36	2245.66	2247.36	56.0
2008-05-01 00:00:00	YM	Futures	11648.9	11648.9	11638.0	11638.0	67.0
2008-05-01 01:00:00	YM	Futures	11638.9	11653.5	11638.9	11653.5	104.0

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

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