PREVIEW / stock_1hour / 2002-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-08.parquet
  size:    391 KB
  rows:    18,500
  symbols: 1,363

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-08 08:00:00	AAPL	Stock	0.4092	0.4098	0.408	0.4089	543200.0
2002-01-08 09:00:00	AAPL	Stock	0.4089	0.4116	0.4027	0.4073	80634400.0
2002-01-08 10:00:00	AAPL	Stock	0.4073	0.4107	0.4011	0.4034	99590400.0
2002-01-08 11:00:00	AAPL	Stock	0.4034	0.4104	0.4034	0.4064	44682400.0
2002-01-08 12:00:00	AAPL	Stock	0.4066	0.4107	0.4059	0.4095	27440000.0
2002-01-08 13:00:00	AAPL	Stock	0.4091	0.4116	0.408	0.4096	27137600.0
2002-01-08 14:00:00	AAPL	Stock	0.4097	0.4102	0.403	0.4048	65900800.0
2002-01-08 15:00:00	AAPL	Stock	0.4048	0.408	0.403	0.4043	64842400.0
2002-01-08 16:00:00	AAPL	Stock	0.4038	0.4077	0.3932	0.4038	19090400.0
2002-01-08 17:00:00	AAPL	Stock	0.4038	0.4054	0.4038	0.4054	67200.0
2002-01-08 18:00:00	AAPL	Stock	0.4045	0.4054	0.4045	0.4054	11200.0
2002-01-08 08:00:00	MSFT	Stock	34.425	34.455	34.28	34.35	181000.0
2002-01-08 09:00:00	MSFT	Stock	34.35	34.6765	34.005	34.6055	6116400.0
2002-01-08 10:00:00	MSFT	Stock	34.605	34.93	34.46	34.75	10917400.0
2002-01-08 11:00:00	MSFT	Stock	34.76	34.87	34.595	34.615	6946200.0
2002-01-08 12:00:00	MSFT	Stock	34.6	34.78	34.565	34.665	3155800.0
2002-01-08 13:00:00	MSFT	Stock	34.665	34.865	34.605	34.62	4554000.0
2002-01-08 14:00:00	MSFT	Stock	34.62	34.7445	34.54	34.685	5095600.0
2002-01-08 15:00:00	MSFT	Stock	34.685	34.765	34.4045	34.675	6803200.0
2002-01-08 16:00:00	MSFT	Stock	34.69	35.0	34.5852	34.7	2578200.0
2002-01-08 17:00:00	MSFT	Stock	34.69	34.8	34.69	34.8	57000.0
2002-01-08 18:00:00	MSFT	Stock	34.725	34.725	34.725	34.725	200.0
2002-01-08 08:00:00	NVDA	Stock	0.565	0.5652	0.5642	0.5647	96000.0
2002-01-08 09:00:00	NVDA	Stock	0.5633	0.5781	0.5615	0.5764	122748000.0
2002-01-08 10:00:00	NVDA	Stock	0.5771	0.5792	0.5726	0.5735	141840000.0
2002-01-08 11:00:00	NVDA	Stock	0.5737	0.5788	0.5734	0.5755	114852000.0
2002-01-08 12:00:00	NVDA	Stock	0.5756	0.5768	0.5715	0.5761	46800000.0
2002-01-08 13:00:00	NVDA	Stock	0.5758	0.5848	0.5747	0.5808	97620000.0
2002-01-08 14:00:00	NVDA	Stock	0.5808	0.5829	0.5738	0.5778	78288000.0
2002-01-08 15:00:00	NVDA	Stock	0.5778	0.5796	0.5662	0.5712	138264000.0
2002-01-08 16:00:00	NVDA	Stock	0.5712	0.5712	0.57	0.5712	11940000.0
2002-01-08 17:00:00	NVDA	Stock	0.5712	0.5712	0.5698	0.5698	180000.0
2002-01-08 18:00:00	NVDA	Stock	0.5698	0.5711	0.5698	0.5711	240000.0
2002-01-08 08:00:00	AMZN	Stock	0.6185	0.62	0.6185	0.6195	134000.0
2002-01-08 09:00:00	AMZN	Stock	0.6175	0.6185	0.6075	0.609	12682000.0
2002-01-08 10:00:00	AMZN	Stock	0.6095	0.6125	0.5875	0.598	26036000.0
2002-01-08 11:00:00	AMZN	Stock	0.597	0.605	0.5955	0.601	10566000.0
2002-01-08 12:00:00	AMZN	Stock	0.601	0.6025	0.6	0.6	7848000.0
2002-01-08 13:00:00	AMZN	Stock	0.6	0.6075	0.6	0.605	15252000.0
2002-01-08 14:00:00	AMZN	Stock	0.6055	0.607	0.5995	0.6015	11300000.0
2002-01-08 15:00:00	AMZN	Stock	0.6015	0.603	0.591	0.5925	25124000.0
2002-01-08 16:00:00	AMZN	Stock	0.5925	0.6046	0.59	0.5925	6780000.0
2002-01-08 17:00:00	AMZN	Stock	0.5935	0.595	0.5925	0.595	48000.0
2002-01-08 18:00:00	AMZN	Stock	0.5935	0.5935	0.5935	0.5935	18000.0
2002-01-08 09:00:00	CL	Stock	27.95	28.025	27.93	27.99	244400.0
2002-01-08 10:00:00	CL	Stock	28.0	28.105	27.9	27.9	708400.0
2002-01-08 11:00:00	CL	Stock	27.905	27.975	27.9	27.95	1160200.0
2002-01-08 12:00:00	CL	Stock	27.955	28.07	27.94	28.065	632600.0
2002-01-08 13:00:00	CL	Stock	28.065	28.12	28.025	28.05	326200.0
2002-01-08 14:00:00	CL	Stock	28.025	28.05	27.95	28.01	1001600.0

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

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