PREVIEW / stock_1hour / 2003-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-24.parquet
  size:    416 KB
  rows:    19,900
  symbols: 1,534

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
2003-01-24 08:00:00	AAPL	Stock	0.2538	0.2552	0.2538	0.255	106400.0
2003-01-24 09:00:00	AAPL	Stock	0.2543	0.2543	0.2484	0.2484	34468784.0
2003-01-24 10:00:00	AAPL	Stock	0.2484	0.2491	0.2421	0.245	73044552.0
2003-01-24 11:00:00	AAPL	Stock	0.245	0.2488	0.245	0.2466	51613128.0
2003-01-24 12:00:00	AAPL	Stock	0.2466	0.2482	0.2454	0.2475	20006504.0
2003-01-24 13:00:00	AAPL	Stock	0.2473	0.2497	0.2468	0.2488	27285048.0
2003-01-24 14:00:00	AAPL	Stock	0.2488	0.2493	0.2471	0.2475	22783432.0
2003-01-24 15:00:00	AAPL	Stock	0.2475	0.2484	0.2457	0.2463	43903944.0
2003-01-24 16:00:00	AAPL	Stock	0.2461	0.248	0.244	0.2464	11642512.0
2003-01-24 17:00:00	AAPL	Stock	0.2484	0.2484	0.2484	0.2484	5600.0
2003-01-24 18:00:00	AAPL	Stock	0.2466	0.2466	0.2464	0.2464	117600.0
2003-01-24 08:00:00	MSFT	Stock	26.1	26.145	26.0465	26.075	68456.0
2003-01-24 09:00:00	MSFT	Stock	26.09	26.14	25.625	25.7095	9436050.0
2003-01-24 10:00:00	MSFT	Stock	25.705	25.74	25.46	25.56	18753118.0
2003-01-24 11:00:00	MSFT	Stock	25.565	25.65	25.2545	25.3	13695286.0
2003-01-24 12:00:00	MSFT	Stock	25.305	25.315	25.08	25.1345	10930272.0
2003-01-24 13:00:00	MSFT	Stock	25.1305	25.225	25.04	25.19	8500756.0
2003-01-24 14:00:00	MSFT	Stock	25.19	25.24	25.0	25.005	9830344.0
2003-01-24 15:00:00	MSFT	Stock	25.0	25.1245	24.8505	24.925	21034552.0
2003-01-24 16:00:00	MSFT	Stock	24.9	25.0	24.9	24.995	2849502.0
2003-01-24 17:00:00	MSFT	Stock	24.995	25.0	24.95	24.975	33104.0
2003-01-24 18:00:00	MSFT	Stock	24.985	24.985	24.93	24.955	12800.0
2003-01-24 08:00:00	NVDA	Stock	0.0892	0.0892	0.089	0.0891	1296000.0
2003-01-24 09:00:00	NVDA	Stock	0.0891	0.0895	0.0876	0.0882	70660800.0
2003-01-24 10:00:00	NVDA	Stock	0.0882	0.0883	0.0871	0.0877	107727240.0
2003-01-24 11:00:00	NVDA	Stock	0.0876	0.0881	0.0854	0.0856	152359800.0
2003-01-24 12:00:00	NVDA	Stock	0.0856	0.0862	0.0846	0.0848	134792400.0
2003-01-24 13:00:00	NVDA	Stock	0.0849	0.0853	0.0844	0.0852	86362800.0
2003-01-24 14:00:00	NVDA	Stock	0.0853	0.0853	0.084	0.084	73995000.0
2003-01-24 15:00:00	NVDA	Stock	0.084	0.0848	0.0832	0.0847	208881360.0
2003-01-24 16:00:00	NVDA	Stock	0.0847	0.0847	0.0842	0.0842	20968680.0
2003-01-24 17:00:00	NVDA	Stock	0.0846	0.0849	0.0844	0.0849	2243160.0
2003-01-24 18:00:00	NVDA	Stock	0.0848	0.0849	0.0848	0.0849	252000.0
2003-01-24 08:00:00	AMZN	Stock	1.1135	1.125	1.0895	1.119	6804180.0
2003-01-24 09:00:00	AMZN	Stock	1.119	1.164	1.0875	1.1625	99042440.0
2003-01-24 10:00:00	AMZN	Stock	1.1615	1.163	1.12	1.123	100480260.0
2003-01-24 11:00:00	AMZN	Stock	1.123	1.132	1.112	1.126	49490840.0
2003-01-24 12:00:00	AMZN	Stock	1.1255	1.127	1.1005	1.1045	46262340.0
2003-01-24 13:00:00	AMZN	Stock	1.1045	1.114	1.095	1.113	33437700.0
2003-01-24 14:00:00	AMZN	Stock	1.113	1.1134	1.103	1.1081	23125360.0
2003-01-24 15:00:00	AMZN	Stock	1.108	1.1245	1.1035	1.1045	44126440.0
2003-01-24 16:00:00	AMZN	Stock	1.1065	1.114	1.1025	1.106	6291000.0
2003-01-24 17:00:00	AMZN	Stock	1.1055	1.108	1.1055	1.108	792000.0
2003-01-24 18:00:00	AMZN	Stock	1.108	1.108	1.106	1.106	146000.0
2003-01-24 09:00:00	CL	Stock	26.19	26.2	25.875	25.925	238000.0
2003-01-24 10:00:00	CL	Stock	25.925	25.96	25.745	25.925	668200.0
2003-01-24 11:00:00	CL	Stock	25.92	25.92	25.735	25.75	245600.0
2003-01-24 12:00:00	CL	Stock	25.75	25.835	25.71	25.715	339400.0
2003-01-24 13:00:00	CL	Stock	25.7	25.775	25.62	25.765	610600.0
2003-01-24 14:00:00	CL	Stock	25.77	25.82	25.75	25.79	239600.0

> showing 50 of 19,900 rows — these rows as CSV

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