PREVIEW / stock_1hour / 2002-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-15.parquet
  size:    409 KB
  rows:    19,065
  symbols: 1,407

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
2002-04-15 08:00:00	AAPL	Stock	0.4482	0.4505	0.4454	0.4486	184800.0
2002-04-15 09:00:00	AAPL	Stock	0.4479	0.448	0.4448	0.4464	27406400.0
2002-04-15 10:00:00	AAPL	Stock	0.4464	0.4491	0.4459	0.448	63056000.0
2002-04-15 11:00:00	AAPL	Stock	0.4479	0.4484	0.4429	0.4464	41361600.0
2002-04-15 12:00:00	AAPL	Stock	0.4464	0.448	0.4455	0.4475	28756000.0
2002-04-15 13:00:00	AAPL	Stock	0.4471	0.4475	0.4464	0.4473	15680000.0
2002-04-15 14:00:00	AAPL	Stock	0.4473	0.4482	0.4466	0.4473	21974400.0
2002-04-15 15:00:00	AAPL	Stock	0.4471	0.4479	0.4461	0.4461	46267200.0
2002-04-15 16:00:00	AAPL	Stock	0.4457	0.4475	0.4446	0.4464	22646400.0
2002-04-15 17:00:00	AAPL	Stock	0.4473	0.4477	0.4473	0.4477	56000.0
2002-04-15 08:00:00	MSFT	Stock	27.965	28.15	27.965	28.03	17000.0
2002-04-15 09:00:00	MSFT	Stock	28.01	28.23	27.955	28.161	5515000.0
2002-04-15 10:00:00	MSFT	Stock	28.161	28.385	28.015	28.02	7832400.0
2002-04-15 11:00:00	MSFT	Stock	28.02	28.11	27.7	27.83	6976000.0
2002-04-15 12:00:00	MSFT	Stock	27.8205	27.95	27.735	27.87	3588600.0
2002-04-15 13:00:00	MSFT	Stock	27.865	28.141	27.85	28.135	4113800.0
2002-04-15 14:00:00	MSFT	Stock	28.13	28.16	27.9	27.986	5067000.0
2002-04-15 15:00:00	MSFT	Stock	27.985	28.075	27.805	27.845	8285600.0
2002-04-15 16:00:00	MSFT	Stock	27.84	28.07	27.755	27.96	1748000.0
2002-04-15 17:00:00	MSFT	Stock	27.995	28.15	27.9902	28.15	64200.0
2002-04-15 18:00:00	MSFT	Stock	28.08	28.2	28.08	28.2	4600.0
2002-04-15 08:00:00	NVDA	Stock	0.3051	0.3104	0.305	0.31	1128000.0
2002-04-15 09:00:00	NVDA	Stock	0.3095	0.3185	0.3076	0.3174	204096000.0
2002-04-15 10:00:00	NVDA	Stock	0.3173	0.3232	0.3156	0.3167	320916000.0
2002-04-15 11:00:00	NVDA	Stock	0.3168	0.3182	0.3126	0.3162	137784000.0
2002-04-15 12:00:00	NVDA	Stock	0.3162	0.3193	0.3148	0.3185	77832000.0
2002-04-15 13:00:00	NVDA	Stock	0.318	0.3196	0.3146	0.3155	66792000.0
2002-04-15 14:00:00	NVDA	Stock	0.316	0.3201	0.3151	0.3181	123000000.0
2002-04-15 15:00:00	NVDA	Stock	0.3177	0.32	0.3155	0.3187	146124000.0
2002-04-15 16:00:00	NVDA	Stock	0.3177	0.3227	0.3154	0.3226	17808000.0
2002-04-15 17:00:00	NVDA	Stock	0.3184	0.3292	0.3184	0.3271	3348000.0
2002-04-15 18:00:00	NVDA	Stock	0.3271	0.3275	0.3267	0.3275	300000.0
2002-04-15 08:00:00	AMZN	Stock	0.653	0.6535	0.6525	0.6525	20000.0
2002-04-15 09:00:00	AMZN	Stock	0.669	0.678	0.6675	0.675	8318000.0
2002-04-15 10:00:00	AMZN	Stock	0.675	0.687	0.672	0.6855	14524000.0
2002-04-15 11:00:00	AMZN	Stock	0.6855	0.689	0.6715	0.6755	16684000.0
2002-04-15 12:00:00	AMZN	Stock	0.6755	0.6925	0.6735	0.69	7024000.0
2002-04-15 13:00:00	AMZN	Stock	0.69	0.701	0.69	0.6984	12724000.0
2002-04-15 14:00:00	AMZN	Stock	0.698	0.705	0.697	0.701	13046000.0
2002-04-15 15:00:00	AMZN	Stock	0.701	0.7025	0.691	0.6965	15172000.0
2002-04-15 16:00:00	AMZN	Stock	0.6965	0.6975	0.6915	0.6965	1306000.0
2002-04-15 17:00:00	AMZN	Stock	0.6965	0.698	0.6945	0.698	64000.0
2002-04-15 18:00:00	AMZN	Stock	0.6945	0.698	0.6945	0.698	64000.0
2002-04-15 09:00:00	CL	Stock	29.425	29.425	29.14	29.175	221400.0
2002-04-15 10:00:00	CL	Stock	29.17	29.215	29.0	29.025	981800.0
2002-04-15 11:00:00	CL	Stock	29.0	29.09	28.825	28.915	345200.0
2002-04-15 12:00:00	CL	Stock	28.925	29.05	28.925	28.98	167800.0
2002-04-15 13:00:00	CL	Stock	29.02	29.06	28.93	28.96	171200.0
2002-04-15 14:00:00	CL	Stock	28.98	29.05	28.94	28.95	265600.0
2002-04-15 15:00:00	CL	Stock	28.95	29.05	28.89	28.93	508600.0

> showing 50 of 19,065 rows — these rows as CSV

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