PREVIEW / stock_1hour / 2001-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-12-19.parquet
  size:    387 KB
  rows:    18,697
  symbols: 1,370

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-12-19 08:00:00	AAPL	Stock	0.3756	0.3756	0.3738	0.3738	134400.0
2001-12-19 09:00:00	AAPL	Stock	0.3714	0.3714	0.3655	0.3713	17584000.0
2001-12-19 10:00:00	AAPL	Stock	0.3713	0.3763	0.3682	0.3732	45432800.0
2001-12-19 11:00:00	AAPL	Stock	0.3733	0.3871	0.373	0.3836	79066400.0
2001-12-19 12:00:00	AAPL	Stock	0.3829	0.3855	0.3816	0.3845	24740800.0
2001-12-19 13:00:00	AAPL	Stock	0.3846	0.3855	0.3813	0.3855	34994400.0
2001-12-19 14:00:00	AAPL	Stock	0.3855	0.3861	0.3834	0.385	22114400.0
2001-12-19 15:00:00	AAPL	Stock	0.385	0.3861	0.3818	0.3854	50506400.0
2001-12-19 16:00:00	AAPL	Stock	0.3845	0.3863	0.3671	0.3671	5829600.0
2001-12-19 17:00:00	AAPL	Stock	0.3868	0.3868	0.3861	0.3861	464800.0
2001-12-19 08:00:00	MSFT	Stock	34.4	34.449	34.165	34.389	50200.0
2001-12-19 09:00:00	MSFT	Stock	34.375	34.65	34.225	34.515	10696400.0
2001-12-19 10:00:00	MSFT	Stock	34.515	34.775	34.39	34.7253	12571000.0
2001-12-19 11:00:00	MSFT	Stock	34.74	34.93	34.68	34.735	6889600.0
2001-12-19 12:00:00	MSFT	Stock	34.7345	34.86	34.675	34.7055	4923200.0
2001-12-19 13:00:00	MSFT	Stock	34.7145	34.82	34.595	34.815	4922600.0
2001-12-19 14:00:00	MSFT	Stock	34.82	34.915	34.7395	34.85	4885600.0
2001-12-19 15:00:00	MSFT	Stock	34.855	34.9455	34.605	34.76	8804800.0
2001-12-19 16:00:00	MSFT	Stock	34.75	34.855	34.3178	34.68	1500600.0
2001-12-19 17:00:00	MSFT	Stock	34.68	34.745	34.68	34.7	70800.0
2001-12-19 18:00:00	MSFT	Stock	34.695	34.695	34.695	34.695	600.0
2001-12-19 08:00:00	NVDA	Stock	0.5497	0.5497	0.5433	0.5467	900000.0
2001-12-19 09:00:00	NVDA	Stock	0.5458	0.5483	0.5349	0.5399	128676000.0
2001-12-19 10:00:00	NVDA	Stock	0.54	0.5504	0.5381	0.541	189024000.0
2001-12-19 11:00:00	NVDA	Stock	0.5417	0.5541	0.5398	0.5514	151788000.0
2001-12-19 12:00:00	NVDA	Stock	0.5516	0.5533	0.547	0.5475	58584000.0
2001-12-19 13:00:00	NVDA	Stock	0.5472	0.5496	0.5439	0.5488	41256000.0
2001-12-19 14:00:00	NVDA	Stock	0.5487	0.5492	0.5392	0.5426	82968000.0
2001-12-19 15:00:00	NVDA	Stock	0.5428	0.5437	0.5358	0.5364	120852000.0
2001-12-19 16:00:00	NVDA	Stock	0.5369	0.5435	0.5354	0.5435	56064000.0
2001-12-19 17:00:00	NVDA	Stock	0.5435	0.5435	0.5358	0.5358	15600000.0
2001-12-19 18:00:00	NVDA	Stock	0.5358	0.5358	0.5357	0.5357	48000.0
2001-12-19 08:00:00	AMZN	Stock	0.5488	0.5488	0.5325	0.5325	182000.0
2001-12-19 09:00:00	AMZN	Stock	0.5335	0.5425	0.5255	0.541	17850000.0
2001-12-19 10:00:00	AMZN	Stock	0.541	0.5575	0.539	0.5515	34908000.0
2001-12-19 11:00:00	AMZN	Stock	0.5505	0.5545	0.546	0.5505	25750000.0
2001-12-19 12:00:00	AMZN	Stock	0.551	0.5525	0.5475	0.5481	9428000.0
2001-12-19 13:00:00	AMZN	Stock	0.5481	0.5524	0.54	0.5515	8390000.0
2001-12-19 14:00:00	AMZN	Stock	0.5505	0.5525	0.5495	0.5505	16064000.0
2001-12-19 15:00:00	AMZN	Stock	0.55	0.552	0.5355	0.5355	19492000.0
2001-12-19 16:00:00	AMZN	Stock	0.536	0.541	0.5345	0.5355	1716000.0
2001-12-19 17:00:00	AMZN	Stock	0.5355	0.54	0.5355	0.5375	384000.0
2001-12-19 18:00:00	AMZN	Stock	0.5375	0.5375	0.5315	0.535	56000.0
2001-12-19 09:00:00	CL	Stock	28.6	28.775	28.525	28.77	276600.0
2001-12-19 10:00:00	CL	Stock	28.785	29.015	28.78	28.85	565000.0
2001-12-19 11:00:00	CL	Stock	28.845	28.9	28.8	28.83	229800.0
2001-12-19 12:00:00	CL	Stock	28.835	28.87	28.8	28.825	251600.0
2001-12-19 13:00:00	CL	Stock	28.825	28.995	28.785	28.995	363400.0
2001-12-19 14:00:00	CL	Stock	28.995	29.125	28.995	29.125	389800.0
2001-12-19 15:00:00	CL	Stock	29.125	29.27	29.09	29.22	1109600.0

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

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