PREVIEW / stock_1hour / 2005-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-16.parquet
  size:    546 KB
  rows:    25,867
  symbols: 1,946

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-16 08:00:00	AAPL	Stock	1.4711	1.4711	1.4571	1.4596	1114456.0
2005-03-16 09:00:00	AAPL	Stock	1.4579	1.4821	1.4439	1.4786	99335432.0
2005-03-16 10:00:00	AAPL	Stock	1.4786	1.5111	1.4768	1.48	214049612.0
2005-03-16 11:00:00	AAPL	Stock	1.48	1.4875	1.4679	1.4786	85828288.0
2005-03-16 12:00:00	AAPL	Stock	1.4786	1.4832	1.4768	1.4818	32843048.0
2005-03-16 13:00:00	AAPL	Stock	1.4814	1.485	1.4675	1.4686	46872168.0
2005-03-16 14:00:00	AAPL	Stock	1.4682	1.4743	1.4564	1.4657	68980996.0
2005-03-16 15:00:00	AAPL	Stock	1.4675	1.4768	1.4646	1.4704	93309104.0
2005-03-16 16:00:00	AAPL	Stock	1.4711	1.4721	1.4679	1.47	7541072.0
2005-03-16 17:00:00	AAPL	Stock	1.4707	1.4733	1.4693	1.4707	2132088.0
2005-03-16 18:00:00	AAPL	Stock	1.47	1.4707	1.4689	1.4696	73500.0
2005-03-16 08:00:00	MSFT	Stock	24.97	24.97	24.91	24.93	23656.0
2005-03-16 09:00:00	MSFT	Stock	24.93	24.97	24.76	24.83	7308997.0
2005-03-16 10:00:00	MSFT	Stock	24.83	24.861	24.7	24.72	12696072.0
2005-03-16 11:00:00	MSFT	Stock	24.71	24.72	24.6	24.711	11000561.0
2005-03-16 12:00:00	MSFT	Stock	24.71	24.79	24.69	24.79	6586851.0
2005-03-16 13:00:00	MSFT	Stock	24.79	24.8	24.71	24.76	6769439.0
2005-03-16 14:00:00	MSFT	Stock	24.75	24.82	24.69	24.71	9819728.0
2005-03-16 15:00:00	MSFT	Stock	24.71	24.73	24.56	24.61	18435059.0
2005-03-16 16:00:00	MSFT	Stock	24.62	24.9	24.61	24.9	1324044.0
2005-03-16 17:00:00	MSFT	Stock	24.66	24.677	24.61	24.65	40320.0
2005-03-16 18:00:00	MSFT	Stock	24.66	24.66	24.65	24.65	3929.0
2005-03-16 08:00:00	NVDA	Stock	0.2112	0.2122	0.2112	0.2118	107400.0
2005-03-16 09:00:00	NVDA	Stock	0.2112	0.2137	0.209	0.2123	73353240.0
2005-03-16 10:00:00	NVDA	Stock	0.2123	0.2137	0.2105	0.211	73062720.0
2005-03-16 11:00:00	NVDA	Stock	0.2109	0.211	0.2089	0.2102	63407280.0
2005-03-16 12:00:00	NVDA	Stock	0.2103	0.2114	0.2101	0.2112	30926040.0
2005-03-16 13:00:00	NVDA	Stock	0.2112	0.2116	0.2092	0.2093	33967560.0
2005-03-16 14:00:00	NVDA	Stock	0.2092	0.2094	0.2077	0.2085	64659720.0
2005-03-16 15:00:00	NVDA	Stock	0.2086	0.2093	0.2076	0.2076	120050520.0
2005-03-16 16:00:00	NVDA	Stock	0.2077	0.2077	0.2069	0.2072	1645920.0
2005-03-16 17:00:00	NVDA	Stock	0.2074	0.2077	0.2074	0.2077	180000.0
2005-03-16 18:00:00	NVDA	Stock	0.2077	0.2077	0.2077	0.2077	18000.0
2005-03-16 08:00:00	AMZN	Stock	1.706	1.706	1.703	1.703	56780.0
2005-03-16 09:00:00	AMZN	Stock	1.701	1.712	1.6865	1.699	13078340.0
2005-03-16 10:00:00	AMZN	Stock	1.699	1.722	1.688	1.692	22390000.0
2005-03-16 11:00:00	AMZN	Stock	1.692	1.7005	1.68	1.695	22112720.0
2005-03-16 12:00:00	AMZN	Stock	1.695	1.7075	1.6915	1.704	10541700.0
2005-03-16 13:00:00	AMZN	Stock	1.704	1.706	1.696	1.697	8000120.0
2005-03-16 14:00:00	AMZN	Stock	1.6975	1.7015	1.6855	1.691	12407720.0
2005-03-16 15:00:00	AMZN	Stock	1.6905	1.697	1.684	1.694	16928880.0
2005-03-16 16:00:00	AMZN	Stock	1.6935	1.7015	1.6905	1.6945	648440.0
2005-03-16 17:00:00	AMZN	Stock	1.6945	1.695	1.6935	1.695	3263760.0
2005-03-16 09:00:00	CL	Stock	26.305	26.34	26.24	26.28	241800.0
2005-03-16 10:00:00	CL	Stock	26.285	26.32	26.08	26.08	491200.0
2005-03-16 11:00:00	CL	Stock	26.085	26.135	26.01	26.01	257600.0
2005-03-16 12:00:00	CL	Stock	26.005	26.195	26.005	26.195	267800.0
2005-03-16 13:00:00	CL	Stock	26.195	26.29	26.075	26.095	351400.0
2005-03-16 14:00:00	CL	Stock	26.09	26.12	26.0	26.045	298200.0
2005-03-16 15:00:00	CL	Stock	26.045	26.15	26.005	26.105	456200.0

> showing 50 of 25,867 rows — these rows as CSV

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