PREVIEW / stock_1hour / 2002-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-02-01.parquet
  size:    383 KB
  rows:    18,237
  symbols: 1,335

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-02-01 08:00:00	AAPL	Stock	0.4418	0.442	0.4402	0.4402	235200.0
2002-02-01 09:00:00	AAPL	Stock	0.437	0.4409	0.4339	0.4396	43842400.0
2002-02-01 10:00:00	AAPL	Stock	0.4396	0.4457	0.4377	0.4439	61756800.0
2002-02-01 11:00:00	AAPL	Stock	0.4438	0.4454	0.442	0.4441	56380800.0
2002-02-01 12:00:00	AAPL	Stock	0.4443	0.4452	0.4396	0.4409	68376000.0
2002-02-01 13:00:00	AAPL	Stock	0.4411	0.4427	0.4393	0.4407	30772000.0
2002-02-01 14:00:00	AAPL	Stock	0.4407	0.4416	0.4359	0.4375	53956000.0
2002-02-01 15:00:00	AAPL	Stock	0.4375	0.4411	0.4357	0.4375	72508800.0
2002-02-01 16:00:00	AAPL	Stock	0.4359	0.4379	0.4359	0.4379	6294400.0
2002-02-01 17:00:00	AAPL	Stock	0.4379	0.4464	0.4366	0.4366	50400.0
2002-02-01 08:00:00	MSFT	Stock	31.98	32.125	31.845	32.085	503400.0
2002-02-01 09:00:00	MSFT	Stock	32.05	32.195	31.855	32.145	9826200.0
2002-02-01 10:00:00	MSFT	Stock	32.145	32.2505	31.92	31.95	10177400.0
2002-02-01 11:00:00	MSFT	Stock	31.945	32.03	31.625	31.75	6780800.0
2002-02-01 12:00:00	MSFT	Stock	31.75	31.775	31.315	31.435	8532800.0
2002-02-01 13:00:00	MSFT	Stock	31.4455	31.51	31.25	31.33	5223000.0
2002-02-01 14:00:00	MSFT	Stock	31.33	31.53	31.295	31.355	7356200.0
2002-02-01 15:00:00	MSFT	Stock	31.355	31.5	31.235	31.33	10891200.0
2002-02-01 16:00:00	MSFT	Stock	31.33	31.6788	31.21	31.21	2490600.0
2002-02-01 17:00:00	MSFT	Stock	31.315	31.325	31.305	31.325	6000.0
2002-02-01 08:00:00	NVDA	Stock	0.5487	0.55	0.5428	0.5433	1308000.0
2002-02-01 09:00:00	NVDA	Stock	0.5433	0.5522	0.5431	0.5482	86976000.0
2002-02-01 10:00:00	NVDA	Stock	0.5485	0.5527	0.5416	0.5421	140400000.0
2002-02-01 11:00:00	NVDA	Stock	0.5416	0.545	0.5342	0.5342	88836000.0
2002-02-01 12:00:00	NVDA	Stock	0.5342	0.5357	0.5313	0.5343	104832000.0
2002-02-01 13:00:00	NVDA	Stock	0.5343	0.5382	0.5333	0.5347	61380000.0
2002-02-01 14:00:00	NVDA	Stock	0.5347	0.5407	0.5342	0.5376	65076000.0
2002-02-01 15:00:00	NVDA	Stock	0.5377	0.5392	0.5342	0.5342	114420000.0
2002-02-01 16:00:00	NVDA	Stock	0.5342	0.5353	0.532	0.535	20640000.0
2002-02-01 18:00:00	NVDA	Stock	0.5354	0.5375	0.5354	0.5375	228000.0
2002-02-01 08:00:00	AMZN	Stock	0.7025	0.709	0.7025	0.7025	52000.0
2002-02-01 09:00:00	AMZN	Stock	0.7025	0.705	0.6822	0.6915	26564000.0
2002-02-01 10:00:00	AMZN	Stock	0.6915	0.696	0.6825	0.6895	22886000.0
2002-02-01 11:00:00	AMZN	Stock	0.689	0.6895	0.67	0.67	21402000.0
2002-02-01 12:00:00	AMZN	Stock	0.6705	0.68	0.668	0.6795	15900000.0
2002-02-01 13:00:00	AMZN	Stock	0.679	0.685	0.673	0.682	15454000.0
2002-02-01 14:00:00	AMZN	Stock	0.6815	0.6835	0.676	0.682	9560000.0
2002-02-01 15:00:00	AMZN	Stock	0.682	0.69	0.6795	0.6865	31142000.0
2002-02-01 16:00:00	AMZN	Stock	0.686	0.6875	0.6795	0.6795	4014000.0
2002-02-01 17:00:00	AMZN	Stock	0.6865	0.6865	0.681	0.6865	128000.0
2002-02-01 09:00:00	CL	Stock	28.575	28.575	28.355	28.475	261800.0
2002-02-01 10:00:00	CL	Stock	28.475	28.49	28.15	28.2	270400.0
2002-02-01 11:00:00	CL	Stock	28.2	28.52	28.2	28.365	474000.0
2002-02-01 12:00:00	CL	Stock	28.35	28.38	28.2	28.355	269200.0
2002-02-01 13:00:00	CL	Stock	28.355	28.455	28.26	28.4	251400.0
2002-02-01 14:00:00	CL	Stock	28.4	28.615	28.4	28.555	439400.0
2002-02-01 15:00:00	CL	Stock	28.565	28.675	28.515	28.58	510200.0
2002-02-01 16:00:00	CL	Stock	28.585	28.585	28.48	28.48	99600.0

> showing 48 of 18,237 rows — these rows as CSV

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