PREVIEW / stock_1hour / 2001-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-06.parquet
  size:    356 KB
  rows:    16,870
  symbols: 1,299

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-07-06 08:00:00	AAPL	Stock	0.4109	0.4113	0.4107	0.4107	257600.0
2001-07-06 09:00:00	AAPL	Stock	0.4107	0.4107	0.4011	0.4018	39715200.0
2001-07-06 10:00:00	AAPL	Stock	0.4018	0.4036	0.393	0.3945	55339200.0
2001-07-06 11:00:00	AAPL	Stock	0.3945	0.3963	0.3879	0.3886	33331200.0
2001-07-06 12:00:00	AAPL	Stock	0.3891	0.3998	0.3886	0.3961	26017600.0
2001-07-06 13:00:00	AAPL	Stock	0.3961	0.3984	0.3932	0.3941	31119200.0
2001-07-06 14:00:00	AAPL	Stock	0.395	0.3998	0.3913	0.3925	25345600.0
2001-07-06 15:00:00	AAPL	Stock	0.392	0.3973	0.3896	0.3936	50232000.0
2001-07-06 16:00:00	AAPL	Stock	0.3927	0.3982	0.3911	0.3934	17998400.0
2001-07-06 17:00:00	AAPL	Stock	0.3934	0.3934	0.3914	0.3934	1685600.0
2001-07-06 18:00:00	AAPL	Stock	0.3934	0.3934	0.3934	0.3934	39200.0
2001-07-06 08:00:00	MSFT	Stock	34.0	34.195	33.905	34.075	35800.0
2001-07-06 09:00:00	MSFT	Stock	34.075	34.2	33.6	33.605	9620000.0
2001-07-06 10:00:00	MSFT	Stock	33.605	33.67	33.4	33.6	16720400.0
2001-07-06 11:00:00	MSFT	Stock	33.575	33.65	33.24	33.365	7036800.0
2001-07-06 12:00:00	MSFT	Stock	33.37	33.525	33.325	33.4	4678400.0
2001-07-06 13:00:00	MSFT	Stock	33.41	33.53	33.19	33.245	4487400.0
2001-07-06 14:00:00	MSFT	Stock	33.245	33.31	32.835	32.89	8330200.0
2001-07-06 15:00:00	MSFT	Stock	32.89	33.285	32.88	33.015	10483800.0
2001-07-06 16:00:00	MSFT	Stock	33.03	34.15	32.755	33.03	3194000.0
2001-07-06 17:00:00	MSFT	Stock	33.03	33.05	33.0	33.05	224200.0
2001-07-06 18:00:00	MSFT	Stock	33.05	33.24	33.03	33.165	84600.0
2001-07-06 08:00:00	NVDA	Stock	0.3429	0.3463	0.3417	0.3429	2376000.0
2001-07-06 09:00:00	NVDA	Stock	0.3438	0.3458	0.3335	0.339	165144000.0
2001-07-06 10:00:00	NVDA	Stock	0.3387	0.339	0.3296	0.335	187320000.0
2001-07-06 11:00:00	NVDA	Stock	0.334	0.3392	0.3306	0.3333	81936000.0
2001-07-06 12:00:00	NVDA	Stock	0.3333	0.3375	0.3333	0.3363	55584000.0
2001-07-06 13:00:00	NVDA	Stock	0.3364	0.3372	0.3332	0.3332	33768000.0
2001-07-06 14:00:00	NVDA	Stock	0.3335	0.3352	0.3315	0.3329	51312000.0
2001-07-06 15:00:00	NVDA	Stock	0.333	0.3415	0.3329	0.337	176568000.0
2001-07-06 16:00:00	NVDA	Stock	0.3363	0.3414	0.3358	0.3385	14280000.0
2001-07-06 17:00:00	NVDA	Stock	0.3363	0.3378	0.3358	0.3358	1176000.0
2001-07-06 18:00:00	NVDA	Stock	0.3363	0.3363	0.3363	0.3363	48000.0
2001-07-06 08:00:00	AMZN	Stock	0.745	0.755	0.745	0.755	330000.0
2001-07-06 09:00:00	AMZN	Stock	0.7475	0.7675	0.743	0.7575	28238000.0
2001-07-06 10:00:00	AMZN	Stock	0.7595	0.76	0.74	0.744	30680000.0
2001-07-06 11:00:00	AMZN	Stock	0.744	0.755	0.743	0.748	17396000.0
2001-07-06 12:00:00	AMZN	Stock	0.749	0.764	0.7475	0.76	15130000.0
2001-07-06 13:00:00	AMZN	Stock	0.76	0.7845	0.759	0.7795	30412000.0
2001-07-06 14:00:00	AMZN	Stock	0.7795	0.786	0.7675	0.7705	21246000.0
2001-07-06 15:00:00	AMZN	Stock	0.7705	0.7845	0.761	0.763	21038000.0
2001-07-06 16:00:00	AMZN	Stock	0.7635	0.7705	0.7555	0.77	4234000.0
2001-07-06 17:00:00	AMZN	Stock	0.7635	0.765	0.7625	0.765	290000.0
2001-07-06 18:00:00	AMZN	Stock	0.765	0.765	0.76	0.763	62000.0
2001-07-06 09:00:00	CL	Stock	29.815	29.85	29.625	29.75	142800.0
2001-07-06 10:00:00	CL	Stock	29.705	29.72	29.53	29.53	218600.0
2001-07-06 11:00:00	CL	Stock	29.53	29.65	29.475	29.58	309000.0
2001-07-06 12:00:00	CL	Stock	29.6	29.625	29.525	29.595	116600.0
2001-07-06 13:00:00	CL	Stock	29.555	29.62	29.535	29.55	124000.0
2001-07-06 14:00:00	CL	Stock	29.55	29.6	29.4	29.55	362600.0

> showing 50 of 16,870 rows — these rows as CSV

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