PREVIEW / stock_1hour / 2007-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-04.parquet
  size:    677 KB
  rows:    31,971
  symbols: 2,551

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-04-04 07:00:00	AAPL	Stock	3.3854	3.4014	3.3839	3.3893	485800.0
2007-04-04 08:00:00	AAPL	Stock	3.3893	3.3964	3.3839	3.3846	1563464.0
2007-04-04 09:00:00	AAPL	Stock	3.3846	3.3929	3.3696	3.3757	64223488.0
2007-04-04 10:00:00	AAPL	Stock	3.3754	3.3979	3.3661	3.3836	133582456.0
2007-04-04 11:00:00	AAPL	Stock	3.3832	3.3911	3.3725	3.38	57847468.0
2007-04-04 12:00:00	AAPL	Stock	3.38	3.3875	3.3779	3.3857	42883792.0
2007-04-04 13:00:00	AAPL	Stock	3.3857	3.3875	3.3732	3.3761	39981816.0
2007-04-04 14:00:00	AAPL	Stock	3.3761	3.3818	3.3668	3.3701	46309256.0
2007-04-04 15:00:00	AAPL	Stock	3.3701	3.3907	3.3618	3.3675	72933560.0
2007-04-04 16:00:00	AAPL	Stock	3.3675	3.3746	3.3639	3.3686	9992612.0
2007-04-04 17:00:00	AAPL	Stock	3.3707	3.3707	3.3696	3.3704	113400.0
2007-04-04 18:00:00	AAPL	Stock	3.3704	3.3707	3.3696	3.3707	130200.0
2007-04-04 19:00:00	AAPL	Stock	3.3718	3.3729	3.3696	3.3696	134232.0
2007-04-04 07:00:00	MSFT	Stock	27.83	27.85	27.83	27.85	3500.0
2007-04-04 08:00:00	MSFT	Stock	27.87	27.92	27.87	27.91	11562.0
2007-04-04 09:00:00	MSFT	Stock	27.92	28.27	27.87	28.21	7782982.0
2007-04-04 10:00:00	MSFT	Stock	28.21	28.38	28.12	28.35	8955974.0
2007-04-04 11:00:00	MSFT	Stock	28.34	28.55	28.27	28.53	8202019.0
2007-04-04 12:00:00	MSFT	Stock	28.52	28.78	28.5	28.6	8269571.0
2007-04-04 13:00:00	MSFT	Stock	28.6	28.62	28.43	28.53	5132017.0
2007-04-04 14:00:00	MSFT	Stock	28.54	28.63	28.51	28.53	4601956.0
2007-04-04 15:00:00	MSFT	Stock	28.532	28.62	28.45	28.5	11506395.0
2007-04-04 16:00:00	MSFT	Stock	28.5	28.52	28.5	28.52	379286.0
2007-04-04 17:00:00	MSFT	Stock	28.52	28.53	28.51	28.53	1345.0
2007-04-04 18:00:00	MSFT	Stock	28.52	28.52	28.52	28.52	1654.0
2007-04-04 19:00:00	MSFT	Stock	28.52	28.52	28.51	28.51	4065.0
2007-04-04 08:00:00	NVDA	Stock	0.4805	0.4805	0.4793	0.4793	60000.0
2007-04-04 09:00:00	NVDA	Stock	0.4773	0.4803	0.4767	0.4795	28517280.0
2007-04-04 10:00:00	NVDA	Stock	0.4795	0.4805	0.4775	0.4777	60951600.0
2007-04-04 11:00:00	NVDA	Stock	0.4777	0.4783	0.4758	0.4768	43195980.0
2007-04-04 12:00:00	NVDA	Stock	0.4768	0.4795	0.4767	0.479	46518420.0
2007-04-04 13:00:00	NVDA	Stock	0.479	0.479	0.4757	0.4765	38444700.0
2007-04-04 14:00:00	NVDA	Stock	0.4763	0.4775	0.476	0.4763	34764180.0
2007-04-04 15:00:00	NVDA	Stock	0.4763	0.4773	0.475	0.4763	91871040.0
2007-04-04 16:00:00	NVDA	Stock	0.4762	0.4792	0.4762	0.4792	2615760.0
2007-04-04 17:00:00	NVDA	Stock	0.479	0.4805	0.4783	0.4792	585000.0
2007-04-04 18:00:00	NVDA	Stock	0.4803	0.4805	0.4803	0.4805	36000.0
2007-04-04 19:00:00	NVDA	Stock	0.4805	0.4805	0.4805	0.4805	6000.0
2007-04-04 08:00:00	AMZN	Stock	2.055	2.0595	2.0545	2.0595	26000.0
2007-04-04 09:00:00	AMZN	Stock	2.0595	2.0625	2.0525	2.056	6738380.0
2007-04-04 10:00:00	AMZN	Stock	2.056	2.0625	2.046	2.059	10438440.0
2007-04-04 11:00:00	AMZN	Stock	2.0585	2.069	2.0561	2.067	10309440.0
2007-04-04 12:00:00	AMZN	Stock	2.0675	2.071	2.0645	2.068	10839120.0
2007-04-04 13:00:00	AMZN	Stock	2.068	2.0685	2.0625	2.068	5955040.0
2007-04-04 14:00:00	AMZN	Stock	2.068	2.0745	2.068	2.073	9303900.0
2007-04-04 15:00:00	AMZN	Stock	2.073	2.0775	2.0705	2.0765	23028840.0
2007-04-04 16:00:00	AMZN	Stock	2.076	2.0845	2.073	2.077	979960.0
2007-04-04 17:00:00	AMZN	Stock	2.0765	2.0765	2.073	2.073	81660.0
2007-04-04 19:00:00	AMZN	Stock	2.073	2.073	2.071	2.071	16000.0
2007-04-04 09:00:00	CL	Stock	33.11	33.15	33.03	33.125	251752.0

> showing 50 of 31,971 rows — these rows as CSV

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