PREVIEW / stock_1hour / 2005-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-29.parquet
  size:    565 KB
  rows:    26,983
  symbols: 1,954

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
2005-03-29 08:00:00	AAPL	Stock	1.5125	1.5179	1.5107	1.5164	209468.0
2005-03-29 09:00:00	AAPL	Stock	1.5179	1.5232	1.5032	1.51	52742648.0
2005-03-29 10:00:00	AAPL	Stock	1.5104	1.5296	1.5079	1.5211	90099016.0
2005-03-29 11:00:00	AAPL	Stock	1.5211	1.5217	1.5157	1.5175	33531764.0
2005-03-29 12:00:00	AAPL	Stock	1.5175	1.5182	1.5032	1.5071	38117772.0
2005-03-29 13:00:00	AAPL	Stock	1.5068	1.5118	1.5032	1.51	40265344.0
2005-03-29 14:00:00	AAPL	Stock	1.51	1.51	1.4821	1.4982	105837172.0
2005-03-29 15:00:00	AAPL	Stock	1.4989	1.4993	1.4839	1.4911	85360324.0
2005-03-29 16:00:00	AAPL	Stock	1.4904	1.4986	1.49	1.4932	2426984.0
2005-03-29 17:00:00	AAPL	Stock	1.4932	1.4964	1.4911	1.4911	634956.0
2005-03-29 18:00:00	AAPL	Stock	1.4914	1.4964	1.4914	1.4946	42448.0
2005-03-29 08:00:00	MSFT	Stock	24.16	25.15	24.15	24.16	54651.0
2005-03-29 09:00:00	MSFT	Stock	24.16	24.2	24.11	24.14	8922320.0
2005-03-29 10:00:00	MSFT	Stock	24.13	24.24	24.11	24.19	9893169.0
2005-03-29 11:00:00	MSFT	Stock	24.19	24.22	24.13	24.15	5799102.0
2005-03-29 12:00:00	MSFT	Stock	24.15	24.21	24.1	24.16	6058813.0
2005-03-29 13:00:00	MSFT	Stock	24.16	24.18	24.05	24.14	8633628.0
2005-03-29 14:00:00	MSFT	Stock	24.14	24.17	24.03	24.12	12242450.0
2005-03-29 15:00:00	MSFT	Stock	24.12	24.15	23.82	23.91	19368345.0
2005-03-29 16:00:00	MSFT	Stock	23.91	23.98	23.9	23.96	862850.0
2005-03-29 17:00:00	MSFT	Stock	23.96	24.092	23.92	23.96	34744.0
2005-03-29 18:00:00	MSFT	Stock	23.96	23.96	23.96	23.96	2150.0
2005-03-29 09:00:00	NVDA	Stock	0.2066	0.2069	0.2048	0.2053	71209320.0
2005-03-29 10:00:00	NVDA	Stock	0.2053	0.2092	0.2053	0.2082	75188640.0
2005-03-29 11:00:00	NVDA	Stock	0.2082	0.2085	0.2077	0.2082	33664320.0
2005-03-29 12:00:00	NVDA	Stock	0.2082	0.2083	0.2059	0.2067	73675560.0
2005-03-29 13:00:00	NVDA	Stock	0.2067	0.2069	0.205	0.2055	47597400.0
2005-03-29 14:00:00	NVDA	Stock	0.2055	0.2056	0.2016	0.2035	113238840.0
2005-03-29 15:00:00	NVDA	Stock	0.2035	0.204	0.2017	0.2025	114982320.0
2005-03-29 16:00:00	NVDA	Stock	0.2023	0.2039	0.2017	0.2017	1950000.0
2005-03-29 17:00:00	NVDA	Stock	0.2019	0.2029	0.2016	0.2029	926040.0
2005-03-29 08:00:00	AMZN	Stock	1.6695	1.6695	1.667	1.667	17000.0
2005-03-29 09:00:00	AMZN	Stock	1.6655	1.69	1.6635	1.6775	15500980.0
2005-03-29 10:00:00	AMZN	Stock	1.678	1.7075	1.6775	1.6945	32991840.0
2005-03-29 11:00:00	AMZN	Stock	1.694	1.699	1.693	1.6975	9551300.0
2005-03-29 12:00:00	AMZN	Stock	1.6975	1.6985	1.685	1.6856	11821700.0
2005-03-29 13:00:00	AMZN	Stock	1.6855	1.686	1.6675	1.669	11977640.0
2005-03-29 14:00:00	AMZN	Stock	1.6685	1.684	1.6615	1.682	18982000.0
2005-03-29 15:00:00	AMZN	Stock	1.6825	1.6825	1.6655	1.6695	18306280.0
2005-03-29 16:00:00	AMZN	Stock	1.671	1.6775	1.6675	1.6765	644920.0
2005-03-29 17:00:00	AMZN	Stock	1.6775	1.6775	1.6715	1.6715	41900.0
2005-03-29 18:00:00	AMZN	Stock	1.6715	1.6715	1.6715	1.6715	25900.0
2005-03-29 09:00:00	CL	Stock	25.75	25.865	25.7	25.78	197200.0
2005-03-29 10:00:00	CL	Stock	25.76	25.99	25.75	25.925	313800.0
2005-03-29 11:00:00	CL	Stock	25.93	25.985	25.855	25.97	392200.0
2005-03-29 12:00:00	CL	Stock	25.965	25.97	25.905	25.935	216600.0
2005-03-29 13:00:00	CL	Stock	25.93	25.95	25.755	25.81	390400.0
2005-03-29 14:00:00	CL	Stock	25.805	25.805	25.68	25.745	483600.0
2005-03-29 15:00:00	CL	Stock	25.74	25.79	25.66	25.73	730800.0
2005-03-29 16:00:00	CL	Stock	25.715	25.715	25.715	25.715	6000.0

> showing 50 of 26,983 rows — these rows as CSV

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