PREVIEW / stock_1hour / 2006-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-21.parquet
  size:    604 KB
  rows:    28,533
  symbols: 2,203

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
2006-02-21 06:00:00	AAPL	Stock	2.5214	2.5214	2.5214	2.5214	29820.0
2006-02-21 08:00:00	AAPL	Stock	2.5232	2.5339	2.5171	2.5232	1950760.0
2006-02-21 09:00:00	AAPL	Stock	2.5214	2.5286	2.4957	2.5032	101102428.0
2006-02-21 10:00:00	AAPL	Stock	2.5036	2.505	2.4539	2.4736	222404196.0
2006-02-21 11:00:00	AAPL	Stock	2.4739	2.4807	2.4643	2.4675	68373452.0
2006-02-21 12:00:00	AAPL	Stock	2.4679	2.4904	2.4529	2.4789	85964592.0
2006-02-21 13:00:00	AAPL	Stock	2.4793	2.4843	2.46	2.4761	69594056.0
2006-02-21 14:00:00	AAPL	Stock	2.4761	2.4821	2.4625	2.4771	84663880.0
2006-02-21 15:00:00	AAPL	Stock	2.4768	2.4846	2.465	2.4671	101857112.0
2006-02-21 16:00:00	AAPL	Stock	2.4679	2.4808	2.4668	2.4736	3075828.0
2006-02-21 17:00:00	AAPL	Stock	2.4739	2.475	2.4671	2.4718	6315680.0
2006-02-21 18:00:00	AAPL	Stock	2.4682	2.4736	2.4682	2.4736	162260.0
2006-02-21 07:00:00	MSFT	Stock	26.7	26.74	26.7	26.74	1927.0
2006-02-21 08:00:00	MSFT	Stock	26.75	26.75	26.71	26.72	13616.0
2006-02-21 09:00:00	MSFT	Stock	26.73	26.76	26.55	26.55	4179663.0
2006-02-21 10:00:00	MSFT	Stock	26.55	26.65	26.4	26.48	12541437.0
2006-02-21 11:00:00	MSFT	Stock	26.48	26.65	26.38	26.4	5843278.0
2006-02-21 12:00:00	MSFT	Stock	26.4	26.52	26.37	26.39	4373289.0
2006-02-21 13:00:00	MSFT	Stock	26.38	26.49	26.34	26.45	7040514.0
2006-02-21 14:00:00	MSFT	Stock	26.45	26.58	26.42	26.47	6849823.0
2006-02-21 15:00:00	MSFT	Stock	26.47	26.58	26.47	26.53	6087758.0
2006-02-21 16:00:00	MSFT	Stock	26.52	26.54	26.496	26.54	102369.0
2006-02-21 17:00:00	MSFT	Stock	26.5	26.54	26.35	26.45	9323.0
2006-02-21 08:00:00	NVDA	Stock	0.3975	0.4	0.3942	0.3946	2061600.0
2006-02-21 09:00:00	NVDA	Stock	0.3948	0.3958	0.3875	0.3897	147225840.0
2006-02-21 10:00:00	NVDA	Stock	0.3897	0.3912	0.3837	0.3852	171320640.0
2006-02-21 11:00:00	NVDA	Stock	0.3852	0.3879	0.3846	0.3852	69768840.0
2006-02-21 12:00:00	NVDA	Stock	0.3852	0.3879	0.3843	0.3856	47241000.0
2006-02-21 13:00:00	NVDA	Stock	0.3856	0.3867	0.3844	0.3854	42058680.0
2006-02-21 14:00:00	NVDA	Stock	0.3854	0.3872	0.3837	0.3857	62641560.0
2006-02-21 15:00:00	NVDA	Stock	0.3858	0.3879	0.3858	0.3871	127484280.0
2006-02-21 16:00:00	NVDA	Stock	0.387	0.387	0.3852	0.3859	802800.0
2006-02-21 17:00:00	NVDA	Stock	0.3852	0.3852	0.3842	0.3842	780000.0
2006-02-21 18:00:00	NVDA	Stock	0.3848	0.3848	0.3816	0.3838	819840.0
2006-02-21 04:00:00	AMZN	Stock	1.9595	1.9595	1.9595	1.9595	2000.0
2006-02-21 08:00:00	AMZN	Stock	1.9595	1.9595	1.9575	1.9575	5860.0
2006-02-21 09:00:00	AMZN	Stock	1.9575	1.9575	1.9305	1.9355	14754300.0
2006-02-21 10:00:00	AMZN	Stock	1.936	1.9365	1.9175	1.929	21259000.0
2006-02-21 11:00:00	AMZN	Stock	1.929	1.9465	1.929	1.9335	10015840.0
2006-02-21 12:00:00	AMZN	Stock	1.9335	1.9345	1.916	1.9195	9387500.0
2006-02-21 13:00:00	AMZN	Stock	1.9195	1.93	1.916	1.9225	9171100.0
2006-02-21 14:00:00	AMZN	Stock	1.922	1.927	1.916	1.925	9146760.0
2006-02-21 15:00:00	AMZN	Stock	1.926	1.9325	1.913	1.917	24678260.0
2006-02-21 16:00:00	AMZN	Stock	1.9145	1.916	1.914	1.914	60300.0
2006-02-21 17:00:00	AMZN	Stock	1.914	1.914	1.914	1.914	22200.0
2006-02-21 09:00:00	CL	Stock	27.25	27.255	27.125	27.13	496400.0
2006-02-21 10:00:00	CL	Stock	27.125	27.255	27.125	27.235	343600.0
2006-02-21 11:00:00	CL	Stock	27.235	27.295	27.1935	27.2	338200.0
2006-02-21 12:00:00	CL	Stock	27.2	27.205	27.15	27.17	215400.0
2006-02-21 13:00:00	CL	Stock	27.17	27.21	27.16	27.175	173600.0

> showing 50 of 28,533 rows — these rows as CSV

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