PREVIEW / stock_1hour / 2006-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-15.parquet
  size:    697 KB
  rows:    32,733
  symbols: 2,478

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
2006-12-15 06:00:00	AAPL	Stock	3.1686	3.1686	3.1607	3.1607	16800.0
2006-12-15 07:00:00	AAPL	Stock	3.1743	3.1789	3.1639	3.1661	94080.0
2006-12-15 08:00:00	AAPL	Stock	3.1679	3.1889	3.1611	3.1857	5204388.0
2006-12-15 09:00:00	AAPL	Stock	3.1857	3.1882	3.1382	3.1564	242126668.0
2006-12-15 10:00:00	AAPL	Stock	3.1564	3.1829	3.1504	3.1664	91005068.0
2006-12-15 11:00:00	AAPL	Stock	3.1668	3.1821	3.1561	3.1589	54031460.0
2006-12-15 12:00:00	AAPL	Stock	3.1586	3.1804	3.1304	3.1329	81589760.0
2006-12-15 13:00:00	AAPL	Stock	3.1329	3.1811	3.1271	3.1389	57795416.0
2006-12-15 14:00:00	AAPL	Stock	3.1386	3.1814	3.1339	3.1421	46604460.0
2006-12-15 15:00:00	AAPL	Stock	3.1418	3.145	3.1189	3.1339	111385624.0
2006-12-15 16:00:00	AAPL	Stock	3.1279	3.147	3.1264	3.1343	8582364.0
2006-12-15 17:00:00	AAPL	Stock	3.1327	3.1343	3.1321	3.1339	413952.0
2006-12-15 18:00:00	AAPL	Stock	3.1339	3.1357	3.1321	3.1339	178052.0
2006-12-15 19:00:00	AAPL	Stock	3.1332	3.1357	3.1325	3.1325	123620.0
2006-12-15 07:00:00	MSFT	Stock	30.07	30.08	30.07	30.07	3300.0
2006-12-15 08:00:00	MSFT	Stock	30.06	30.21	30.03	30.14	93241.0
2006-12-15 09:00:00	MSFT	Stock	30.18	30.24	30.07	30.15	25527593.0
2006-12-15 10:00:00	MSFT	Stock	30.14	30.23	30.07	30.11	9725023.0
2006-12-15 11:00:00	MSFT	Stock	30.11	30.22	30.08	30.13	6571723.0
2006-12-15 12:00:00	MSFT	Stock	30.13	30.15	30.07	30.09	6488483.0
2006-12-15 13:00:00	MSFT	Stock	30.091	30.16	30.03	30.09	7139894.0
2006-12-15 14:00:00	MSFT	Stock	30.1	30.2	30.09	30.14	6744064.0
2006-12-15 15:00:00	MSFT	Stock	30.13	30.2	30.05	30.19	15437760.0
2006-12-15 16:00:00	MSFT	Stock	30.18	30.2	30.05	30.185	9566091.0
2006-12-15 17:00:00	MSFT	Stock	30.185	30.19	30.18	30.187	242779.0
2006-12-15 18:00:00	MSFT	Stock	30.18	30.23	30.16	30.182	147380.0
2006-12-15 19:00:00	MSFT	Stock	30.19	30.19	30.16	30.16	1937.0
2006-12-15 08:00:00	NVDA	Stock	0.6167	0.6172	0.615	0.6152	586500.0
2006-12-15 09:00:00	NVDA	Stock	0.6182	0.6215	0.6142	0.6202	156845880.0
2006-12-15 10:00:00	NVDA	Stock	0.62	0.6202	0.6165	0.6192	61470000.0
2006-12-15 11:00:00	NVDA	Stock	0.6192	0.6208	0.6188	0.62	52011480.0
2006-12-15 12:00:00	NVDA	Stock	0.6198	0.6207	0.6182	0.6198	50841420.0
2006-12-15 13:00:00	NVDA	Stock	0.62	0.6212	0.6193	0.621	49448100.0
2006-12-15 14:00:00	NVDA	Stock	0.621	0.6218	0.6183	0.6198	55392360.0
2006-12-15 15:00:00	NVDA	Stock	0.6198	0.625	0.6187	0.6247	155481720.0
2006-12-15 16:00:00	NVDA	Stock	0.6245	0.6257	0.6233	0.6247	8123460.0
2006-12-15 17:00:00	NVDA	Stock	0.6247	0.6257	0.6237	0.6237	634320.0
2006-12-15 18:00:00	NVDA	Stock	0.625	0.625	0.6235	0.6249	2531340.0
2006-12-15 19:00:00	NVDA	Stock	0.6248	0.6248	0.6248	0.6248	6000.0
2006-12-15 08:00:00	AMZN	Stock	1.95	1.964	1.9485	1.964	74000.0
2006-12-15 09:00:00	AMZN	Stock	1.965	2.0045	1.9545	1.9965	43858040.0
2006-12-15 10:00:00	AMZN	Stock	1.9965	2.007	1.9925	2.005	23525340.0
2006-12-15 11:00:00	AMZN	Stock	2.0055	2.0095	2.002	2.0045	12911100.0
2006-12-15 12:00:00	AMZN	Stock	2.0045	2.0075	1.9975	2.0015	12649100.0
2006-12-15 13:00:00	AMZN	Stock	2.0015	2.005	1.999	2.0045	11359340.0
2006-12-15 14:00:00	AMZN	Stock	2.0045	2.007	2.0005	2.0045	14118400.0
2006-12-15 15:00:00	AMZN	Stock	2.004	2.007	1.9985	2.0015	30840520.0
2006-12-15 16:00:00	AMZN	Stock	2.0005	2.004	2.0	2.0005	787740.0
2006-12-15 17:00:00	AMZN	Stock	2.0008	2.0008	2.0006	2.0006	66720.0
2006-12-15 18:00:00	AMZN	Stock	1.999	2.0009	1.9985	2.0009	868740.0

> showing 50 of 32,733 rows — these rows as CSV

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