PREVIEW / futures_1hour / 2008-04-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	1301.6	1302.06	1301.36	1301.36	345.0
2008-04-29 01:00:00	ES	Futures	1301.36	1302.53	1301.36	1302.53	615.0
2008-04-29 02:00:00	ES	Futures	1302.53	1302.99	1298.57	1299.27	5843.0
2008-04-29 03:00:00	ES	Futures	1299.27	1301.36	1299.27	1300.9	13455.0
2008-04-29 04:00:00	ES	Futures	1300.9	1302.29	1299.27	1299.5	10397.0
2008-04-29 05:00:00	ES	Futures	1299.27	1300.2	1298.57	1298.57	6630.0
2008-04-29 06:00:00	ES	Futures	1298.57	1299.5	1297.87	1298.57	9247.0
2008-04-29 07:00:00	ES	Futures	1298.57	1300.43	1298.1	1298.57	16872.0
2008-04-29 08:00:00	ES	Futures	1298.57	1301.6	1298.1	1300.2	36653.0
2008-04-29 09:00:00	ES	Futures	1299.97	1302.29	1297.64	1299.04	171209.0
2008-04-29 10:00:00	ES	Futures	1298.8	1300.9	1291.82	1293.45	316262.0
2008-04-29 11:00:00	ES	Futures	1293.45	1296.24	1292.52	1294.61	146634.0
2008-04-29 12:00:00	ES	Futures	1294.38	1297.41	1293.45	1295.54	129088.0
2008-04-29 13:00:00	ES	Futures	1295.78	1299.73	1294.84	1297.87	167720.0
2008-04-29 14:00:00	ES	Futures	1297.87	1301.36	1296.24	1300.66	153209.0
2008-04-29 15:00:00	ES	Futures	1300.9	1301.36	1295.31	1296.24	195887.0
2008-04-29 16:00:00	ES	Futures	1296.24	1296.94	1292.52	1294.38	59549.0
2008-04-29 17:00:00	ES	Futures	1294.15	1294.38	1293.68	1294.15	1357.0
2008-04-29 18:00:00	ES	Futures	1294.38	1296.01	1293.91	1295.54	1816.0
2008-04-29 19:00:00	ES	Futures	1295.54	1295.78	1294.38	1295.08	986.0
2008-04-29 20:00:00	ES	Futures	1295.08	1297.41	1295.08	1297.41	1945.0
2008-04-29 21:00:00	ES	Futures	1297.41	1298.1	1296.71	1297.87	2109.0
2008-04-29 22:00:00	ES	Futures	1298.1	1298.8	1297.87	1298.34	1655.0
2008-04-29 23:00:00	ES	Futures	1298.57	1299.04	1298.1	1298.8	1138.0
2008-04-29 00:00:00	NQ	Futures	2180.04	2180.04	2178.63	2180.04	9.0
2008-04-29 01:00:00	NQ	Futures	2179.19	2181.46	2178.91	2181.17	50.0
2008-04-29 02:00:00	NQ	Futures	2181.74	2181.74	2174.67	2175.52	344.0
2008-04-29 03:00:00	NQ	Futures	2175.8	2177.78	2174.1	2176.37	773.0
2008-04-29 04:00:00	NQ	Futures	2176.37	2179.19	2174.1	2174.39	433.0
2008-04-29 05:00:00	NQ	Futures	2174.39	2175.8	2172.69	2172.97	352.0
2008-04-29 06:00:00	NQ	Futures	2172.69	2174.1	2170.71	2172.69	508.0
2008-04-29 07:00:00	NQ	Futures	2172.41	2175.8	2172.41	2172.97	546.0
2008-04-29 08:00:00	NQ	Futures	2172.97	2177.21	2172.41	2174.67	3074.0
2008-04-29 09:00:00	NQ	Futures	2174.39	2183.72	2172.41	2182.59	33032.0
2008-04-29 10:00:00	NQ	Futures	2182.59	2185.98	2170.99	2176.37	56059.0
2008-04-29 11:00:00	NQ	Futures	2176.65	2185.42	2175.23	2180.89	28014.0
2008-04-29 12:00:00	NQ	Futures	2180.89	2184.57	2175.8	2180.89	22880.0
2008-04-29 13:00:00	NQ	Futures	2180.89	2194.18	2179.76	2188.25	40148.0
2008-04-29 14:00:00	NQ	Futures	2188.53	2201.82	2187.11	2201.26	42416.0
2008-04-29 15:00:00	NQ	Futures	2201.26	2203.52	2191.92	2195.6	45619.0
2008-04-29 16:00:00	NQ	Futures	2195.6	2196.45	2190.51	2193.62	9311.0
2008-04-29 17:00:00	NQ	Futures	2193.05	2193.62	2192.77	2192.77	57.0
2008-04-29 18:00:00	NQ	Futures	2192.77	2195.32	2191.92	2193.34	155.0
2008-04-29 19:00:00	NQ	Futures	2193.34	2195.03	2193.34	2193.62	62.0
2008-04-29 20:00:00	NQ	Futures	2193.9	2198.43	2193.9	2197.86	112.0
2008-04-29 21:00:00	NQ	Futures	2197.86	2199.84	2197.01	2199.56	116.0
2008-04-29 22:00:00	NQ	Futures	2200.41	2200.41	2199.28	2199.56	61.0
2008-04-29 23:00:00	NQ	Futures	2199.56	2200.41	2198.71	2200.41	86.0
2008-04-29 00:00:00	YM	Futures	11692.5	11696.2	11688.9	11688.9	32.0
2008-04-29 01:00:00	YM	Futures	11688.9	11698.9	11688.9	11697.1	166.0

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

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