PREVIEW / stock_1hour / 2002-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-05.parquet
  size:    385 KB
  rows:    18,418
  symbols: 1,393

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-05 08:00:00	AAPL	Stock	0.4453	0.4459	0.4429	0.4455	420000.0
2002-04-05 09:00:00	AAPL	Stock	0.4457	0.4498	0.4386	0.4388	38981600.0
2002-04-05 10:00:00	AAPL	Stock	0.4387	0.4418	0.4304	0.4316	40874400.0
2002-04-05 11:00:00	AAPL	Stock	0.4318	0.4423	0.4316	0.4421	33952800.0
2002-04-05 12:00:00	AAPL	Stock	0.442	0.4445	0.438	0.4436	26297600.0
2002-04-05 13:00:00	AAPL	Stock	0.4436	0.4464	0.4396	0.4464	22618400.0
2002-04-05 14:00:00	AAPL	Stock	0.4463	0.4473	0.4413	0.4423	27244000.0
2002-04-05 15:00:00	AAPL	Stock	0.4423	0.4434	0.4382	0.4411	42688800.0
2002-04-05 16:00:00	AAPL	Stock	0.4414	0.4463	0.4398	0.4413	34356000.0
2002-04-05 17:00:00	AAPL	Stock	0.4411	0.4418	0.4411	0.4418	1304800.0
2002-04-05 08:00:00	MSFT	Stock	28.325	28.499	28.18	28.425	252800.0
2002-04-05 09:00:00	MSFT	Stock	28.425	28.58	28.33	28.41	7782800.0
2002-04-05 10:00:00	MSFT	Stock	28.4055	28.515	28.215	28.275	9496800.0
2002-04-05 11:00:00	MSFT	Stock	28.275	28.32	28.02	28.25	5832600.0
2002-04-05 12:00:00	MSFT	Stock	28.235	28.25	27.975	28.155	5216000.0
2002-04-05 13:00:00	MSFT	Stock	28.155	28.415	27.9755	28.355	5820400.0
2002-04-05 14:00:00	MSFT	Stock	28.355	28.425	28.175	28.1905	4870600.0
2002-04-05 15:00:00	MSFT	Stock	28.19	28.25	27.92	27.94	7642400.0
2002-04-05 16:00:00	MSFT	Stock	27.94	28.2818	27.8	27.88	1490000.0
2002-04-05 17:00:00	MSFT	Stock	27.919	28.2591	27.919	27.93	230400.0
2002-04-05 18:00:00	MSFT	Stock	27.925	28.045	27.925	28.0	10600.0
2002-04-05 08:00:00	NVDA	Stock	0.37	0.37	0.359	0.3617	4740000.0
2002-04-05 09:00:00	NVDA	Stock	0.3612	0.3672	0.3532	0.3578	238368000.0
2002-04-05 10:00:00	NVDA	Stock	0.3578	0.3579	0.35	0.3512	192000000.0
2002-04-05 11:00:00	NVDA	Stock	0.3512	0.3532	0.3472	0.3511	116232000.0
2002-04-05 12:00:00	NVDA	Stock	0.351	0.3527	0.3483	0.3522	50784000.0
2002-04-05 13:00:00	NVDA	Stock	0.3525	0.3573	0.3513	0.3565	101184000.0
2002-04-05 14:00:00	NVDA	Stock	0.3565	0.3613	0.3537	0.3558	136704000.0
2002-04-05 15:00:00	NVDA	Stock	0.3558	0.3564	0.3504	0.3508	142752000.0
2002-04-05 16:00:00	NVDA	Stock	0.3509	0.3545	0.3492	0.3492	14724000.0
2002-04-05 17:00:00	NVDA	Stock	0.3499	0.3542	0.3492	0.3492	3972000.0
2002-04-05 18:00:00	NVDA	Stock	0.3499	0.3499	0.3492	0.3492	168000.0
2002-04-05 08:00:00	AMZN	Stock	0.675	0.6795	0.675	0.6795	18000.0
2002-04-05 09:00:00	AMZN	Stock	0.6785	0.702	0.676	0.6925	18174000.0
2002-04-05 10:00:00	AMZN	Stock	0.692	0.6945	0.6675	0.669	16456000.0
2002-04-05 11:00:00	AMZN	Stock	0.669	0.675	0.6655	0.67	11152000.0
2002-04-05 12:00:00	AMZN	Stock	0.67	0.677	0.6685	0.6765	5276000.0
2002-04-05 13:00:00	AMZN	Stock	0.6765	0.691	0.6725	0.69	9798000.0
2002-04-05 14:00:00	AMZN	Stock	0.69	0.693	0.687	0.6885	10504000.0
2002-04-05 15:00:00	AMZN	Stock	0.688	0.6886	0.6735	0.675	12726000.0
2002-04-05 16:00:00	AMZN	Stock	0.6745	0.68	0.67	0.67	2818000.0
2002-04-05 17:00:00	AMZN	Stock	0.6735	0.675	0.6735	0.675	280000.0
2002-04-05 09:00:00	CL	Stock	28.74	28.75	28.575	28.58	236600.0
2002-04-05 10:00:00	CL	Stock	28.585	28.695	28.525	28.655	384800.0
2002-04-05 11:00:00	CL	Stock	28.66	28.695	28.62	28.635	258800.0
2002-04-05 12:00:00	CL	Stock	28.64	28.695	28.595	28.695	227000.0
2002-04-05 13:00:00	CL	Stock	28.69	28.71	28.66	28.69	244400.0
2002-04-05 14:00:00	CL	Stock	28.685	28.765	28.64	28.64	351600.0
2002-04-05 15:00:00	CL	Stock	28.635	28.75	28.63	28.695	294400.0
2002-04-05 16:00:00	CL	Stock	28.68	28.72	28.675	28.675	40000.0

> showing 50 of 18,418 rows — these rows as CSV

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