PREVIEW / stock_1hour / 2001-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-18.parquet
  size:    354 KB
  rows:    16,702
  symbols: 1,300

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-18 08:00:00	AAPL	Stock	0.3648	0.3661	0.3648	0.3661	459200.0
2001-06-18 09:00:00	AAPL	Stock	0.367	0.3723	0.358	0.3618	53446400.0
2001-06-18 10:00:00	AAPL	Stock	0.3616	0.3677	0.3571	0.3661	66696000.0
2001-06-18 11:00:00	AAPL	Stock	0.3661	0.367	0.3575	0.3588	23094400.0
2001-06-18 12:00:00	AAPL	Stock	0.3595	0.3641	0.3575	0.3629	28789600.0
2001-06-18 13:00:00	AAPL	Stock	0.3629	0.3652	0.3604	0.3648	29444800.0
2001-06-18 14:00:00	AAPL	Stock	0.3638	0.3696	0.3638	0.3673	59360000.0
2001-06-18 15:00:00	AAPL	Stock	0.3673	0.3679	0.3621	0.363	52864000.0
2001-06-18 16:00:00	AAPL	Stock	0.363	0.3679	0.362	0.3661	5006400.0
2001-06-18 17:00:00	AAPL	Stock	0.363	0.363	0.363	0.363	11200.0
2001-06-18 18:00:00	AAPL	Stock	0.3661	0.3661	0.3661	0.3661	5600.0
2001-06-18 08:00:00	MSFT	Stock	33.7	34.12	33.61	33.9	434200.0
2001-06-18 09:00:00	MSFT	Stock	34.015	34.05	33.38	33.5	10715800.0
2001-06-18 10:00:00	MSFT	Stock	33.495	33.705	33.26	33.665	12947000.0
2001-06-18 11:00:00	MSFT	Stock	33.65	33.7	33.4	33.525	6031800.0
2001-06-18 12:00:00	MSFT	Stock	33.52	33.605	33.385	33.45	3247000.0
2001-06-18 13:00:00	MSFT	Stock	33.46	33.65	33.34	33.565	4417600.0
2001-06-18 14:00:00	MSFT	Stock	33.565	33.65	33.17	33.22	4363600.0
2001-06-18 15:00:00	MSFT	Stock	33.215	33.5	33.085	33.475	9219800.0
2001-06-18 16:00:00	MSFT	Stock	33.44	33.9	33.215	33.9	1823000.0
2001-06-18 17:00:00	MSFT	Stock	33.44	34.0	33.44	34.0	1556200.0
2001-06-18 18:00:00	MSFT	Stock	34.0	34.15	34.0	34.07	10600.0
2001-06-18 08:00:00	NVDA	Stock	0.3964	0.3969	0.3958	0.3958	456000.0
2001-06-18 09:00:00	NVDA	Stock	0.3958	0.4015	0.3917	0.3919	119544000.0
2001-06-18 10:00:00	NVDA	Stock	0.3919	0.3954	0.3873	0.3938	181056000.0
2001-06-18 11:00:00	NVDA	Stock	0.3938	0.3938	0.3919	0.3921	68640000.0
2001-06-18 12:00:00	NVDA	Stock	0.3921	0.3931	0.3889	0.3901	64104000.0
2001-06-18 13:00:00	NVDA	Stock	0.3902	0.3931	0.3886	0.3891	46392000.0
2001-06-18 14:00:00	NVDA	Stock	0.389	0.3896	0.3785	0.3791	136416000.0
2001-06-18 15:00:00	NVDA	Stock	0.3791	0.3828	0.376	0.3804	185544000.0
2001-06-18 16:00:00	NVDA	Stock	0.3804	0.3848	0.3804	0.3833	7368000.0
2001-06-18 17:00:00	NVDA	Stock	0.3833	0.3862	0.3804	0.3862	264000.0
2001-06-18 18:00:00	NVDA	Stock	0.3858	0.3875	0.3858	0.3875	216000.0
2001-06-18 08:00:00	AMZN	Stock	0.6245	0.625	0.6245	0.6245	200000.0
2001-06-18 09:00:00	AMZN	Stock	0.6245	0.6345	0.6145	0.615	14108000.0
2001-06-18 10:00:00	AMZN	Stock	0.615	0.6345	0.6145	0.6345	14398000.0
2001-06-18 11:00:00	AMZN	Stock	0.632	0.635	0.619	0.625	12384000.0
2001-06-18 12:00:00	AMZN	Stock	0.6255	0.6255	0.6125	0.618	9618000.0
2001-06-18 13:00:00	AMZN	Stock	0.618	0.622	0.6	0.607	13216000.0
2001-06-18 14:00:00	AMZN	Stock	0.607	0.6155	0.595	0.6035	14602000.0
2001-06-18 15:00:00	AMZN	Stock	0.6035	0.604	0.5835	0.595	24660000.0
2001-06-18 16:00:00	AMZN	Stock	0.5925	0.6	0.59	0.6	5284000.0
2001-06-18 17:00:00	AMZN	Stock	0.5915	0.6025	0.5915	0.6025	8000.0
2001-06-18 18:00:00	AMZN	Stock	0.6025	0.603	0.6025	0.603	18000.0
2001-06-18 09:00:00	CL	Stock	28.95	28.95	28.7	28.825	225000.0
2001-06-18 10:00:00	CL	Stock	28.825	28.935	28.805	28.885	546600.0
2001-06-18 11:00:00	CL	Stock	28.885	29.0	28.875	28.9	463000.0
2001-06-18 12:00:00	CL	Stock	28.9	29.05	28.805	29.0	280800.0
2001-06-18 13:00:00	CL	Stock	29.005	29.1	29.0	29.02	201400.0
2001-06-18 14:00:00	CL	Stock	29.015	29.025	28.925	28.95	217600.0

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

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