PREVIEW / stock_1hour / 2007-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-23.parquet
  size:    749 KB
  rows:    37,426
  symbols: 3,108

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
2007-08-23 09:00:00	AAPL	Stock	4.7532	4.7621	4.6921	4.7214	141933904.0
2007-08-23 10:00:00	AAPL	Stock	4.7207	4.7454	4.6732	4.6896	144531968.0
2007-08-23 11:00:00	AAPL	Stock	4.69	4.6954	4.6482	4.6486	105801892.0
2007-08-23 12:00:00	AAPL	Stock	4.6482	4.6929	4.6482	4.6554	97644316.0
2007-08-23 13:00:00	AAPL	Stock	4.6554	4.6711	4.6343	4.665	101810744.0
2007-08-23 14:00:00	AAPL	Stock	4.6646	4.6804	4.6546	4.6761	73442628.0
2007-08-23 15:00:00	AAPL	Stock	4.6761	4.7011	4.6486	4.6811	136536652.0
2007-08-23 16:00:00	AAPL	Stock	4.6793	4.6811	4.6789	4.6811	9391368.0
2007-08-23 09:00:00	MSFT	Stock	28.28	28.33	28.2	28.23	2710885.0
2007-08-23 10:00:00	MSFT	Stock	28.23	28.29	28.16	28.19	4152287.0
2007-08-23 11:00:00	MSFT	Stock	28.19	28.25	28.1	28.1	4431618.0
2007-08-23 12:00:00	MSFT	Stock	28.11	28.24	28.11	28.16	3654113.0
2007-08-23 13:00:00	MSFT	Stock	28.16	28.26	28.13	28.24	4211945.0
2007-08-23 14:00:00	MSFT	Stock	28.24	28.29	28.11	28.18	4346786.0
2007-08-23 15:00:00	MSFT	Stock	28.18	28.29	28.12	28.29	7175086.0
2007-08-23 16:00:00	MSFT	Stock	28.29	28.3	28.28	28.3	1129607.0
2007-08-23 08:00:00	NVDA	Stock	0.8217	0.8217	0.8133	0.8165	709980.0
2007-08-23 09:00:00	NVDA	Stock	0.812	0.8187	0.805	0.8098	83245440.0
2007-08-23 10:00:00	NVDA	Stock	0.81	0.8202	0.8087	0.8158	113641140.0
2007-08-23 11:00:00	NVDA	Stock	0.8158	0.8167	0.8033	0.8083	92239260.0
2007-08-23 12:00:00	NVDA	Stock	0.8088	0.8153	0.8083	0.8103	51373920.0
2007-08-23 13:00:00	NVDA	Stock	0.8105	0.8142	0.8103	0.8123	46867260.0
2007-08-23 14:00:00	NVDA	Stock	0.8124	0.813	0.8013	0.803	77970060.0
2007-08-23 15:00:00	NVDA	Stock	0.803	0.805	0.7965	0.8	95340840.0
2007-08-23 16:00:00	NVDA	Stock	0.7995	0.8	0.7963	0.7963	547860.0
2007-08-23 17:00:00	NVDA	Stock	0.8	0.8	0.7962	0.7962	36342060.0
2007-08-23 18:00:00	NVDA	Stock	0.7952	0.7975	0.7952	0.7975	30000.0
2007-08-23 19:00:00	NVDA	Stock	0.7973	0.7973	0.7933	0.7933	61380.0
2007-08-23 08:00:00	AMZN	Stock	3.955	3.965	3.945	3.9495	189300.0
2007-08-23 09:00:00	AMZN	Stock	3.9495	3.95	3.9005	3.923	15192500.0
2007-08-23 10:00:00	AMZN	Stock	3.923	3.93	3.8955	3.9055	14561160.0
2007-08-23 11:00:00	AMZN	Stock	3.905	3.9064	3.826	3.8295	21272120.0
2007-08-23 12:00:00	AMZN	Stock	3.8305	3.8645	3.8255	3.8425	13969500.0
2007-08-23 13:00:00	AMZN	Stock	3.8425	3.868	3.833	3.8635	11310740.0
2007-08-23 14:00:00	AMZN	Stock	3.8645	3.8735	3.829	3.845	12902220.0
2007-08-23 15:00:00	AMZN	Stock	3.8455	3.884	3.836	3.865	21079800.0
2007-08-23 16:00:00	AMZN	Stock	3.8615	3.865	3.8595	3.8625	2041560.0
2007-08-23 17:00:00	AMZN	Stock	3.864	3.864	3.8625	3.8625	14000.0
2007-08-23 18:00:00	AMZN	Stock	3.8575	3.8575	3.84	3.84	60980.0
2007-08-23 19:00:00	AMZN	Stock	3.8585	3.8585	3.857	3.857	11860.0
2007-08-23 09:00:00	TLT	Stock	87.09	87.15	87.03	87.13	355400.0
2007-08-23 10:00:00	TLT	Stock	87.13	87.2	87.07	87.17	185700.0
2007-08-23 11:00:00	TLT	Stock	87.17	87.27	87.14	87.23	341900.0
2007-08-23 12:00:00	TLT	Stock	87.22	87.46	87.14	87.45	303800.0
2007-08-23 13:00:00	TLT	Stock	87.46	87.65	87.46	87.49	168700.0
2007-08-23 14:00:00	TLT	Stock	87.5	87.68	87.46	87.68	71200.0
2007-08-23 15:00:00	TLT	Stock	87.65	87.68	87.47	87.47	140500.0
2007-08-23 16:00:00	TLT	Stock	87.42	87.42	87.42	87.42	3000.0
2007-08-23 09:00:00	CL	Stock	33.65	33.65	33.36	33.385	353000.0
2007-08-23 10:00:00	CL	Stock	33.395	33.465	33.35	33.385	394400.0

> showing 50 of 37,426 rows — these rows as CSV

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