PREVIEW / stock_1hour / 2001-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-22.parquet
  size:    360 KB
  rows:    17,155
  symbols: 1,308

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
2001-06-22 08:00:00	AAPL	Stock	0.4007	0.4009	0.4007	0.4009	196000.0
2001-06-22 09:00:00	AAPL	Stock	0.4013	0.4014	0.3911	0.395	27434400.0
2001-06-22 10:00:00	AAPL	Stock	0.395	0.4071	0.3934	0.4039	56588000.0
2001-06-22 11:00:00	AAPL	Stock	0.4039	0.4068	0.4014	0.4036	40045600.0
2001-06-22 12:00:00	AAPL	Stock	0.4038	0.4107	0.4034	0.4071	31612000.0
2001-06-22 13:00:00	AAPL	Stock	0.4071	0.408	0.4025	0.4054	14884800.0
2001-06-22 14:00:00	AAPL	Stock	0.4057	0.4093	0.4045	0.4077	19908000.0
2001-06-22 15:00:00	AAPL	Stock	0.407	0.4073	0.3886	0.3973	70840000.0
2001-06-22 16:00:00	AAPL	Stock	0.3975	0.3979	0.3841	0.3975	5118400.0
2001-06-22 17:00:00	AAPL	Stock	0.3975	0.3975	0.3946	0.3946	509600.0
2001-06-22 08:00:00	MSFT	Stock	34.75	35.14	34.75	35.11	261400.0
2001-06-22 09:00:00	MSFT	Stock	35.11	35.25	34.75	35.17	7864600.0
2001-06-22 10:00:00	MSFT	Stock	35.155	35.305	34.925	35.175	8955400.0
2001-06-22 11:00:00	MSFT	Stock	35.175	35.25	34.94	34.94	5750000.0
2001-06-22 12:00:00	MSFT	Stock	34.945	35.0	34.725	34.8	4460600.0
2001-06-22 13:00:00	MSFT	Stock	34.8	34.9	34.535	34.635	3918200.0
2001-06-22 14:00:00	MSFT	Stock	34.64	34.945	34.61	34.675	3786200.0
2001-06-22 15:00:00	MSFT	Stock	34.67	34.675	34.29	34.42	10031400.0
2001-06-22 16:00:00	MSFT	Stock	34.415	34.995	34.38	34.415	3784400.0
2001-06-22 17:00:00	MSFT	Stock	34.415	34.625	34.415	34.495	76600.0
2001-06-22 18:00:00	MSFT	Stock	34.525	34.525	34.525	34.525	200.0
2001-06-22 08:00:00	NVDA	Stock	0.3813	0.3833	0.381	0.3821	672000.0
2001-06-22 09:00:00	NVDA	Stock	0.3823	0.3865	0.3784	0.3828	131616000.0
2001-06-22 10:00:00	NVDA	Stock	0.383	0.3904	0.3788	0.3858	172848000.0
2001-06-22 11:00:00	NVDA	Stock	0.3855	0.3858	0.3781	0.3786	97896000.0
2001-06-22 12:00:00	NVDA	Stock	0.3786	0.386	0.3773	0.3823	68016000.0
2001-06-22 13:00:00	NVDA	Stock	0.3827	0.3865	0.3825	0.3845	65376000.0
2001-06-22 14:00:00	NVDA	Stock	0.3844	0.3865	0.38	0.3819	66432000.0
2001-06-22 15:00:00	NVDA	Stock	0.3813	0.3821	0.3754	0.3802	123024000.0
2001-06-22 16:00:00	NVDA	Stock	0.38	0.3833	0.3796	0.381	9192000.0
2001-06-22 17:00:00	NVDA	Stock	0.381	0.3833	0.3804	0.3804	456000.0
2001-06-22 08:00:00	AMZN	Stock	0.6535	0.655	0.65	0.655	622000.0
2001-06-22 09:00:00	AMZN	Stock	0.655	0.6635	0.6505	0.6575	25152000.0
2001-06-22 10:00:00	AMZN	Stock	0.6575	0.6595	0.645	0.651	21942000.0
2001-06-22 11:00:00	AMZN	Stock	0.65	0.6535	0.641	0.6425	16492000.0
2001-06-22 12:00:00	AMZN	Stock	0.6425	0.6485	0.6395	0.6425	7230000.0
2001-06-22 13:00:00	AMZN	Stock	0.6425	0.645	0.6365	0.6425	14940000.0
2001-06-22 14:00:00	AMZN	Stock	0.638	0.6425	0.6355	0.6385	9470000.0
2001-06-22 15:00:00	AMZN	Stock	0.6385	0.6415	0.619	0.6205	20746000.0
2001-06-22 16:00:00	AMZN	Stock	0.6205	0.6235	0.6185	0.62	2994000.0
2001-06-22 17:00:00	AMZN	Stock	0.62	0.6245	0.62	0.6245	42000.0
2001-06-22 18:00:00	AMZN	Stock	0.6245	0.6245	0.6245	0.6245	6000.0
2001-06-22 09:00:00	CL	Stock	30.2	30.205	29.8	29.8	451200.0
2001-06-22 10:00:00	CL	Stock	29.8	29.99	29.75	29.81	706400.0
2001-06-22 11:00:00	CL	Stock	29.82	29.875	29.625	29.655	619000.0
2001-06-22 12:00:00	CL	Stock	29.67	29.675	29.5	29.505	337600.0
2001-06-22 13:00:00	CL	Stock	29.525	29.56	29.475	29.545	236400.0
2001-06-22 14:00:00	CL	Stock	29.555	29.87	29.55	29.835	485600.0
2001-06-22 15:00:00	CL	Stock	29.84	29.9	29.665	29.67	679400.0
2001-06-22 16:00:00	CL	Stock	29.675	29.79	29.675	29.675	48800.0

> showing 50 of 17,155 rows — these rows as CSV

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