PREVIEW / stock_1hour / 2002-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-09.parquet
  size:    382 KB
  rows:    18,275
  symbols: 1,361

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
2002-01-09 08:00:00	AAPL	Stock	0.4048	0.408	0.4048	0.408	50400.0
2002-01-09 09:00:00	AAPL	Stock	0.4055	0.4075	0.4004	0.4034	34137600.0
2002-01-09 10:00:00	AAPL	Stock	0.4034	0.408	0.4023	0.4055	33012000.0
2002-01-09 11:00:00	AAPL	Stock	0.405	0.4095	0.4048	0.4054	41960800.0
2002-01-09 12:00:00	AAPL	Stock	0.4057	0.4068	0.4025	0.4034	24264800.0
2002-01-09 13:00:00	AAPL	Stock	0.4032	0.4036	0.4004	0.4018	23021600.0
2002-01-09 14:00:00	AAPL	Stock	0.4016	0.4034	0.3984	0.4009	29332800.0
2002-01-09 15:00:00	AAPL	Stock	0.4009	0.4014	0.38	0.3868	104809600.0
2002-01-09 16:00:00	AAPL	Stock	0.3868	0.4045	0.3838	0.3868	16161600.0
2002-01-09 17:00:00	AAPL	Stock	0.3875	0.3884	0.3866	0.3884	168000.0
2002-01-09 18:00:00	AAPL	Stock	0.3884	0.3884	0.3884	0.3884	112000.0
2002-01-09 08:00:00	MSFT	Stock	34.835	34.97	34.835	34.9	61200.0
2002-01-09 09:00:00	MSFT	Stock	34.9	34.995	34.825	34.9645	6679000.0
2002-01-09 10:00:00	MSFT	Stock	34.97	35.205	34.94	35.12	16662200.0
2002-01-09 11:00:00	MSFT	Stock	35.12	35.31	35.095	35.11	9630400.0
2002-01-09 12:00:00	MSFT	Stock	35.115	35.145	34.86	35.06	8391600.0
2002-01-09 13:00:00	MSFT	Stock	35.05	35.17	34.885	35.025	4028600.0
2002-01-09 14:00:00	MSFT	Stock	35.025	35.05	34.6235	34.9595	8737600.0
2002-01-09 15:00:00	MSFT	Stock	34.96	35.005	34.235	34.35	15081800.0
2002-01-09 16:00:00	MSFT	Stock	34.325	35.14	34.25	34.305	4638600.0
2002-01-09 17:00:00	MSFT	Stock	34.315	34.86	34.305	34.33	8800.0
2002-01-09 18:00:00	MSFT	Stock	34.31	34.33	34.31	34.33	5000.0
2002-01-09 08:00:00	NVDA	Stock	0.575	0.5779	0.575	0.5758	948000.0
2002-01-09 09:00:00	NVDA	Stock	0.5762	0.5811	0.5678	0.5723	142428000.0
2002-01-09 10:00:00	NVDA	Stock	0.5721	0.5762	0.5696	0.575	188136000.0
2002-01-09 11:00:00	NVDA	Stock	0.5761	0.5821	0.5746	0.5747	117876000.0
2002-01-09 12:00:00	NVDA	Stock	0.575	0.5846	0.5738	0.5829	65640000.0
2002-01-09 13:00:00	NVDA	Stock	0.5829	0.5896	0.5813	0.5839	107904000.0
2002-01-09 14:00:00	NVDA	Stock	0.5838	0.5839	0.5759	0.5779	108024000.0
2002-01-09 15:00:00	NVDA	Stock	0.5775	0.5783	0.5557	0.5633	303180000.0
2002-01-09 16:00:00	NVDA	Stock	0.563	0.5811	0.5604	0.5633	19200000.0
2002-01-09 17:00:00	NVDA	Stock	0.5625	0.5625	0.5625	0.5625	120000.0
2002-01-09 18:00:00	NVDA	Stock	0.5633	0.5633	0.5633	0.5633	12000.0
2002-01-09 08:00:00	AMZN	Stock	0.599	0.6	0.599	0.5995	132000.0
2002-01-09 09:00:00	AMZN	Stock	0.6	0.6085	0.5966	0.5985	13390000.0
2002-01-09 10:00:00	AMZN	Stock	0.599	0.6055	0.598	0.603	23688000.0
2002-01-09 11:00:00	AMZN	Stock	0.6025	0.606	0.5875	0.5875	26980000.0
2002-01-09 12:00:00	AMZN	Stock	0.588	0.5912	0.5785	0.5795	31276000.0
2002-01-09 13:00:00	AMZN	Stock	0.5795	0.58	0.565	0.5721	37816000.0
2002-01-09 14:00:00	AMZN	Stock	0.5725	0.589	0.5715	0.584	19608000.0
2002-01-09 15:00:00	AMZN	Stock	0.584	0.588	0.575	0.577	26802000.0
2002-01-09 16:00:00	AMZN	Stock	0.577	0.58	0.57	0.5765	9604000.0
2002-01-09 17:00:00	AMZN	Stock	0.574	0.574	0.573	0.573	30000.0
2002-01-09 18:00:00	AMZN	Stock	0.573	0.575	0.573	0.575	32000.0
2002-01-09 09:00:00	CL	Stock	28.275	28.275	28.125	28.14	326000.0
2002-01-09 10:00:00	CL	Stock	28.145	28.245	28.135	28.205	613000.0
2002-01-09 11:00:00	CL	Stock	28.21	28.225	28.17	28.215	312400.0
2002-01-09 12:00:00	CL	Stock	28.205	28.25	28.175	28.23	289600.0
2002-01-09 13:00:00	CL	Stock	28.24	28.24	28.175	28.19	619800.0
2002-01-09 14:00:00	CL	Stock	28.19	28.215	28.165	28.185	382000.0

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

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