PREVIEW / stock_1hour / 2007-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-08.parquet
  size:    633 KB
  rows:    30,060
  symbols: 2,496

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-02-08 04:00:00	AAPL	Stock	3.0786	3.0786	3.0764	3.0764	23044.0
2007-02-08 06:00:00	AAPL	Stock	3.0889	3.0889	3.0604	3.0661	144704.0
2007-02-08 07:00:00	AAPL	Stock	3.0661	3.0679	3.0536	3.0554	544600.0
2007-02-08 08:00:00	AAPL	Stock	3.0571	3.0689	3.0539	3.0564	5498864.0
2007-02-08 09:00:00	AAPL	Stock	3.0586	3.0896	3.0489	3.0618	155111320.0
2007-02-08 10:00:00	AAPL	Stock	3.0618	3.0818	3.0536	3.0603	128222192.0
2007-02-08 11:00:00	AAPL	Stock	3.06	3.0757	3.0539	3.0718	81059272.0
2007-02-08 12:00:00	AAPL	Stock	3.0718	3.085	3.0614	3.0771	75916540.0
2007-02-08 13:00:00	AAPL	Stock	3.0771	3.0886	3.0714	3.0761	61301884.0
2007-02-08 14:00:00	AAPL	Stock	3.0757	3.0825	3.0679	3.0811	61154520.0
2007-02-08 15:00:00	AAPL	Stock	3.0811	3.0893	3.075	3.0768	90095936.0
2007-02-08 16:00:00	AAPL	Stock	3.0771	3.0793	3.0754	3.0786	1220912.0
2007-02-08 17:00:00	AAPL	Stock	3.0793	3.0814	3.0786	3.0811	331324.0
2007-02-08 18:00:00	AAPL	Stock	3.0789	3.0811	3.0779	3.0793	208208.0
2007-02-08 19:00:00	AAPL	Stock	3.0786	3.0793	3.0779	3.0779	172256.0
2007-02-08 08:00:00	MSFT	Stock	29.35	29.38	29.29	29.29	397857.0
2007-02-08 09:00:00	MSFT	Stock	29.29	29.8	29.2	29.31	7978079.0
2007-02-08 10:00:00	MSFT	Stock	29.31	29.8	29.27	29.293	6270631.0
2007-02-08 11:00:00	MSFT	Stock	29.29	29.36	29.2	29.26	4975740.0
2007-02-08 12:00:00	MSFT	Stock	29.26	29.37	29.2	29.31	4409443.0
2007-02-08 13:00:00	MSFT	Stock	29.32	29.36	29.2	29.27	5211639.0
2007-02-08 14:00:00	MSFT	Stock	29.26	29.3	29.23	29.29	8582575.0
2007-02-08 15:00:00	MSFT	Stock	29.29	29.33	29.24	29.26	8981807.0
2007-02-08 16:00:00	MSFT	Stock	29.26	29.286	29.24	29.25	222771.0
2007-02-08 17:00:00	MSFT	Stock	29.26	29.28	29.25	29.26	6090.0
2007-02-08 18:00:00	MSFT	Stock	29.27	29.29	29.27	29.29	6402.0
2007-02-08 19:00:00	MSFT	Stock	29.29	29.29	29.28	29.28	5676.0
2007-02-08 08:00:00	NVDA	Stock	0.58	0.58	0.575	0.575	126000.0
2007-02-08 09:00:00	NVDA	Stock	0.5743	0.575	0.5667	0.5685	86650380.0
2007-02-08 10:00:00	NVDA	Stock	0.5685	0.571	0.5677	0.5688	110209320.0
2007-02-08 11:00:00	NVDA	Stock	0.5688	0.5772	0.5672	0.5765	123971520.0
2007-02-08 12:00:00	NVDA	Stock	0.5765	0.5812	0.5743	0.5782	143562540.0
2007-02-08 13:00:00	NVDA	Stock	0.5782	0.5783	0.572	0.574	60623760.0
2007-02-08 14:00:00	NVDA	Stock	0.574	0.5758	0.5705	0.5753	85570320.0
2007-02-08 15:00:00	NVDA	Stock	0.5752	0.5752	0.5715	0.5727	84765420.0
2007-02-08 16:00:00	NVDA	Stock	0.5727	0.5735	0.5717	0.5727	373740.0
2007-02-08 17:00:00	NVDA	Stock	0.5727	0.575	0.5727	0.575	194340.0
2007-02-08 18:00:00	NVDA	Stock	0.575	0.575	0.5723	0.5723	36000.0
2007-02-08 08:00:00	AMZN	Stock	1.95	1.95	1.945	1.945	20000.0
2007-02-08 09:00:00	AMZN	Stock	1.9445	1.95	1.9335	1.9435	11146340.0
2007-02-08 10:00:00	AMZN	Stock	1.9435	1.9755	1.9435	1.9635	28433900.0
2007-02-08 11:00:00	AMZN	Stock	1.963	1.966	1.9541	1.961	14267780.0
2007-02-08 12:00:00	AMZN	Stock	1.961	1.97	1.955	1.9665	9101120.0
2007-02-08 13:00:00	AMZN	Stock	1.966	1.97	1.9625	1.9645	7335400.0
2007-02-08 14:00:00	AMZN	Stock	1.964	1.968	1.957	1.964	15326120.0
2007-02-08 15:00:00	AMZN	Stock	1.964	1.969	1.9525	1.9565	20375040.0
2007-02-08 16:00:00	AMZN	Stock	1.9565	1.96	1.954	1.9575	86160.0
2007-02-08 17:00:00	AMZN	Stock	1.96	1.96	1.96	1.96	106000.0
2007-02-08 18:00:00	AMZN	Stock	1.961	1.9625	1.961	1.9625	32000.0
2007-02-08 09:00:00	CL	Stock	33.575	33.685	33.385	33.495	283200.0

> showing 50 of 30,060 rows — these rows as CSV

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