PREVIEW / stock_1hour / 2004-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-19.parquet
  size:    476 KB
  rows:    23,039
  symbols: 1,823

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
2004-08-19 08:00:00	AAPL	Stock	0.567	0.567	0.565	0.565	386400.0
2004-08-19 09:00:00	AAPL	Stock	0.565	0.5689	0.5598	0.5668	25927552.0
2004-08-19 10:00:00	AAPL	Stock	0.5668	0.567	0.5552	0.5559	91036400.0
2004-08-19 11:00:00	AAPL	Stock	0.5563	0.5588	0.5559	0.5561	32387712.0
2004-08-19 12:00:00	AAPL	Stock	0.5563	0.5579	0.5539	0.5563	16482200.0
2004-08-19 13:00:00	AAPL	Stock	0.5561	0.5577	0.5538	0.5539	39379032.0
2004-08-19 14:00:00	AAPL	Stock	0.5538	0.5545	0.5427	0.5446	71016680.0
2004-08-19 15:00:00	AAPL	Stock	0.5443	0.55	0.5421	0.5475	79822176.0
2004-08-19 16:00:00	AAPL	Stock	0.5475	0.55	0.5473	0.5484	7464128.0
2004-08-19 17:00:00	AAPL	Stock	0.5491	0.5491	0.5491	0.5491	30800.0
2004-08-19 08:00:00	MSFT	Stock	27.47	27.47	27.36	27.36	23875.0
2004-08-19 09:00:00	MSFT	Stock	27.37	27.45	27.21	27.391	7559113.0
2004-08-19 10:00:00	MSFT	Stock	27.39	27.39	27.15	27.22	6942462.0
2004-08-19 11:00:00	MSFT	Stock	27.22	27.3	27.18	27.22	5275492.0
2004-08-19 12:00:00	MSFT	Stock	27.22	27.26	27.16	27.2	4524731.0
2004-08-19 13:00:00	MSFT	Stock	27.2	27.21	27.07	27.09	4249726.0
2004-08-19 14:00:00	MSFT	Stock	27.09	27.12	27.02	27.04	6183810.0
2004-08-19 15:00:00	MSFT	Stock	27.0493	27.25	27.01	27.08	9228999.0
2004-08-19 16:00:00	MSFT	Stock	27.08	27.14	27.0682	27.12	583158.0
2004-08-19 17:00:00	MSFT	Stock	27.11	27.12	27.08	27.12	83400.0
2004-08-19 18:00:00	MSFT	Stock	27.12	27.12	27.09	27.11	3647.0
2004-08-19 08:00:00	NVDA	Stock	0.0975	0.0975	0.0971	0.0971	156000.0
2004-08-19 09:00:00	NVDA	Stock	0.0968	0.0987	0.096	0.098	85250400.0
2004-08-19 10:00:00	NVDA	Stock	0.0979	0.0982	0.0957	0.0966	121266840.0
2004-08-19 11:00:00	NVDA	Stock	0.0966	0.0972	0.0961	0.0967	96541920.0
2004-08-19 12:00:00	NVDA	Stock	0.0967	0.0967	0.0958	0.0958	73554240.0
2004-08-19 13:00:00	NVDA	Stock	0.0958	0.0968	0.0957	0.0966	81899880.0
2004-08-19 14:00:00	NVDA	Stock	0.0966	0.0966	0.0957	0.0962	91257840.0
2004-08-19 15:00:00	NVDA	Stock	0.0963	0.0977	0.0962	0.0972	114046680.0
2004-08-19 16:00:00	NVDA	Stock	0.0972	0.0976	0.0967	0.0972	4753800.0
2004-08-19 08:00:00	AMZN	Stock	1.9675	2.0115	1.9505	1.9975	2133140.0
2004-08-19 09:00:00	AMZN	Stock	1.9975	2.024	1.9545	1.9615	42350140.0
2004-08-19 10:00:00	AMZN	Stock	1.9615	1.971	1.9425	1.971	26060380.0
2004-08-19 11:00:00	AMZN	Stock	1.971	1.9865	1.916	1.943	44383580.0
2004-08-19 12:00:00	AMZN	Stock	1.943	1.961	1.9275	1.937	35959720.0
2004-08-19 13:00:00	AMZN	Stock	1.937	1.9425	1.9125	1.9146	18340560.0
2004-08-19 14:00:00	AMZN	Stock	1.9155	1.9185	1.9035	1.9085	26903560.0
2004-08-19 15:00:00	AMZN	Stock	1.9085	1.9375	1.901	1.936	38347660.0
2004-08-19 16:00:00	AMZN	Stock	1.9335	1.935	1.9305	1.9315	1519400.0
2004-08-19 17:00:00	AMZN	Stock	1.9325	1.934	1.9325	1.9325	132000.0
2004-08-19 18:00:00	AMZN	Stock	1.932	1.932	1.925	1.925	49500.0
2004-08-19 09:00:00	CL	Stock	25.975	25.975	25.86	25.965	175000.0
2004-08-19 10:00:00	CL	Stock	25.96	25.995	25.825	25.88	550200.0
2004-08-19 11:00:00	CL	Stock	25.875	25.915	25.815	25.88	338200.0
2004-08-19 12:00:00	CL	Stock	25.88	25.905	25.835	25.84	298600.0
2004-08-19 13:00:00	CL	Stock	25.83	25.85	25.785	25.785	205000.0
2004-08-19 14:00:00	CL	Stock	25.785	25.805	25.705	25.73	311200.0
2004-08-19 15:00:00	CL	Stock	25.73	25.985	25.705	25.935	838000.0
2004-08-19 16:00:00	CL	Stock	25.925	25.925	25.925	25.925	400.0

> showing 49 of 23,039 rows — these rows as CSV

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