PREVIEW / futures_1hour / 2008-04-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	1299.04	1299.04	1297.41	1298.1	1299.0
2008-04-30 01:00:00	ES	Futures	1298.34	1298.57	1296.94	1297.17	877.0
2008-04-30 02:00:00	ES	Futures	1297.41	1297.41	1295.54	1297.41	2249.0
2008-04-30 03:00:00	ES	Futures	1297.41	1298.34	1296.01	1297.17	5049.0
2008-04-30 04:00:00	ES	Futures	1296.94	1297.17	1295.08	1295.54	3389.0
2008-04-30 05:00:00	ES	Futures	1295.31	1296.01	1293.91	1294.61	5247.0
2008-04-30 06:00:00	ES	Futures	1294.38	1294.61	1290.65	1293.68	20249.0
2008-04-30 07:00:00	ES	Futures	1293.45	1295.78	1292.28	1293.21	25247.0
2008-04-30 08:00:00	ES	Futures	1293.21	1301.6	1292.98	1299.5	105471.0
2008-04-30 09:00:00	ES	Futures	1299.73	1301.83	1297.41	1299.27	133327.0
2008-04-30 10:00:00	ES	Futures	1299.27	1301.6	1297.64	1300.2	158931.0
2008-04-30 11:00:00	ES	Futures	1300.2	1304.16	1300.2	1302.76	135309.0
2008-04-30 12:00:00	ES	Futures	1302.76	1303.46	1299.5	1300.2	77882.0
2008-04-30 13:00:00	ES	Futures	1300.43	1302.76	1299.97	1300.66	80005.0
2008-04-30 14:00:00	ES	Futures	1300.66	1310.44	1296.94	1296.94	476519.0
2008-04-30 15:00:00	ES	Futures	1296.94	1297.87	1289.02	1289.72	546719.0
2008-04-30 16:00:00	ES	Futures	1289.72	1291.82	1287.39	1289.26	127240.0
2008-04-30 17:00:00	ES	Futures	1289.02	1289.95	1289.02	1289.95	1263.0
2008-04-30 18:00:00	ES	Futures	1289.95	1291.58	1289.72	1290.65	2096.0
2008-04-30 19:00:00	ES	Futures	1290.65	1291.35	1290.19	1290.65	1113.0
2008-04-30 20:00:00	ES	Futures	1290.89	1291.82	1290.65	1291.35	1036.0
2008-04-30 21:00:00	ES	Futures	1291.12	1291.35	1289.95	1290.42	931.0
2008-04-30 22:00:00	ES	Futures	1290.42	1291.35	1290.19	1290.65	401.0
2008-04-30 23:00:00	ES	Futures	1290.65	1291.35	1290.65	1290.89	703.0
2008-04-30 00:00:00	NQ	Futures	2200.41	2200.69	2197.01	2198.71	239.0
2008-04-30 01:00:00	NQ	Futures	2198.71	2198.99	2196.45	2196.73	58.0
2008-04-30 02:00:00	NQ	Futures	2196.73	2197.01	2194.75	2196.45	108.0
2008-04-30 03:00:00	NQ	Futures	2195.88	2198.43	2194.47	2194.75	464.0
2008-04-30 04:00:00	NQ	Futures	2194.75	2197.3	2192.77	2193.05	784.0
2008-04-30 05:00:00	NQ	Futures	2193.05	2194.47	2191.64	2193.05	388.0
2008-04-30 06:00:00	NQ	Futures	2192.77	2193.34	2186.27	2191.36	1032.0
2008-04-30 07:00:00	NQ	Futures	2190.79	2194.47	2187.96	2189.38	1632.0
2008-04-30 08:00:00	NQ	Futures	2189.09	2204.65	2188.81	2199.84	7929.0
2008-04-30 09:00:00	NQ	Futures	2199.84	2203.52	2195.6	2199.84	31447.0
2008-04-30 10:00:00	NQ	Futures	2200.12	2207.76	2197.01	2205.21	37122.0
2008-04-30 11:00:00	NQ	Futures	2205.21	2211.72	2203.23	2207.48	32536.0
2008-04-30 12:00:00	NQ	Futures	2207.48	2208.33	2200.69	2204.65	22708.0
2008-04-30 13:00:00	NQ	Futures	2204.37	2208.04	2199.84	2201.26	16907.0
2008-04-30 14:00:00	NQ	Futures	2201.26	2217.94	2183.72	2183.72	80608.0
2008-04-30 15:00:00	NQ	Futures	2183.72	2184.29	2168.45	2177.21	115973.0
2008-04-30 16:00:00	NQ	Futures	2176.93	2181.17	2173.54	2177.21	18754.0
2008-04-30 17:00:00	NQ	Futures	2176.65	2178.63	2176.08	2178.06	289.0
2008-04-30 18:00:00	NQ	Futures	2177.78	2179.76	2177.78	2179.19	134.0
2008-04-30 19:00:00	NQ	Futures	2179.19	2180.04	2178.91	2179.48	102.0
2008-04-30 20:00:00	NQ	Futures	2179.76	2181.17	2178.06	2179.76	211.0
2008-04-30 21:00:00	NQ	Futures	2178.63	2179.76	2176.93	2177.21	196.0
2008-04-30 22:00:00	NQ	Futures	2178.63	2179.76	2177.78	2177.78	32.0
2008-04-30 23:00:00	NQ	Futures	2178.91	2179.48	2177.78	2178.35	33.0
2008-04-30 00:00:00	YM	Futures	11672.5	11673.4	11664.4	11668.9	70.0
2008-04-30 01:00:00	YM	Futures	11666.2	11668.9	11660.7	11661.6	77.0

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

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