PREVIEW / stock_1hour / 2002-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-24.parquet
  size:    393 KB
  rows:    18,701
  symbols: 1,480

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-09-24 08:00:00	AAPL	Stock	0.2623	0.2623	0.2616	0.2616	218400.0
2002-09-24 09:00:00	AAPL	Stock	0.2616	0.2646	0.2571	0.258	39225200.0
2002-09-24 10:00:00	AAPL	Stock	0.2582	0.2634	0.2582	0.2613	45304168.0
2002-09-24 11:00:00	AAPL	Stock	0.2613	0.2621	0.2607	0.2614	25286912.0
2002-09-24 12:00:00	AAPL	Stock	0.2614	0.262	0.258	0.2588	18843832.0
2002-09-24 13:00:00	AAPL	Stock	0.2588	0.2609	0.2584	0.2596	19078248.0
2002-09-24 14:00:00	AAPL	Stock	0.2598	0.2613	0.2579	0.26	37352392.0
2002-09-24 15:00:00	AAPL	Stock	0.2599	0.2614	0.2579	0.2614	50262576.0
2002-09-24 16:00:00	AAPL	Stock	0.2605	0.2634	0.2564	0.2614	10500000.0
2002-09-24 17:00:00	AAPL	Stock	0.2614	0.2614	0.2614	0.2614	50400.0
2002-09-24 08:00:00	MSFT	Stock	22.35	22.6	22.05	22.425	457084.0
2002-09-24 09:00:00	MSFT	Stock	22.4195	22.75	22.315	22.57	14404618.0
2002-09-24 10:00:00	MSFT	Stock	22.57	23.06	22.56	22.69	17712642.0
2002-09-24 11:00:00	MSFT	Stock	22.69	22.82	22.575	22.695	7612116.0
2002-09-24 12:00:00	MSFT	Stock	22.6935	22.71	22.46	22.61	7577018.0
2002-09-24 13:00:00	MSFT	Stock	22.61	22.985	22.575	22.926	9770276.0
2002-09-24 14:00:00	MSFT	Stock	22.9225	23.045	22.49	22.985	20280916.0
2002-09-24 15:00:00	MSFT	Stock	22.9835	23.24	22.67	22.82	21047528.0
2002-09-24 16:00:00	MSFT	Stock	22.82	22.875	22.6749	22.805	3893072.0
2002-09-24 17:00:00	MSFT	Stock	22.83	22.84	22.7245	22.78	359430.0
2002-09-24 18:00:00	MSFT	Stock	22.755	22.8	22.355	22.75	18600.0
2002-09-24 08:00:00	NVDA	Stock	0.0727	0.0729	0.0717	0.0722	1358400.0
2002-09-24 09:00:00	NVDA	Stock	0.0726	0.0735	0.0712	0.0732	89354880.0
2002-09-24 10:00:00	NVDA	Stock	0.0732	0.0775	0.0732	0.0758	157694160.0
2002-09-24 11:00:00	NVDA	Stock	0.0758	0.0762	0.0743	0.0754	49125240.0
2002-09-24 12:00:00	NVDA	Stock	0.0754	0.0757	0.0734	0.0746	36089400.0
2002-09-24 13:00:00	NVDA	Stock	0.0747	0.0761	0.0742	0.0756	53368440.0
2002-09-24 14:00:00	NVDA	Stock	0.0756	0.0761	0.0733	0.0754	87903000.0
2002-09-24 15:00:00	NVDA	Stock	0.0754	0.0767	0.0726	0.0737	116693760.0
2002-09-24 16:00:00	NVDA	Stock	0.074	0.0779	0.0733	0.074	7488000.0
2002-09-24 17:00:00	NVDA	Stock	0.074	0.0755	0.0723	0.0723	13434000.0
2002-09-24 18:00:00	NVDA	Stock	0.0742	0.0747	0.0742	0.0747	912000.0
2002-09-24 08:00:00	AMZN	Stock	0.793	0.795	0.79	0.791	138500.0
2002-09-24 09:00:00	AMZN	Stock	0.79	0.8375	0.78	0.783	16419780.0
2002-09-24 10:00:00	AMZN	Stock	0.7826	0.811	0.7815	0.8065	29334180.0
2002-09-24 11:00:00	AMZN	Stock	0.8065	0.8135	0.8005	0.8055	13709100.0
2002-09-24 12:00:00	AMZN	Stock	0.8055	0.809	0.7975	0.8005	16276660.0
2002-09-24 13:00:00	AMZN	Stock	0.8025	0.8125	0.7995	0.811	23087600.0
2002-09-24 14:00:00	AMZN	Stock	0.8096	0.812	0.7955	0.812	17727700.0
2002-09-24 15:00:00	AMZN	Stock	0.812	0.8185	0.795	0.7965	17054420.0
2002-09-24 16:00:00	AMZN	Stock	0.7965	0.817	0.7955	0.817	1722000.0
2002-09-24 17:00:00	AMZN	Stock	0.7965	0.799	0.795	0.799	220280.0
2002-09-24 09:00:00	CL	Stock	26.75	26.75	26.45	26.45	284800.0
2002-09-24 10:00:00	CL	Stock	26.455	26.55	26.285	26.43	631000.0
2002-09-24 11:00:00	CL	Stock	26.425	26.55	26.425	26.535	506200.0
2002-09-24 12:00:00	CL	Stock	26.515	26.53	26.375	26.52	367800.0
2002-09-24 13:00:00	CL	Stock	26.525	26.81	26.48	26.735	570800.0
2002-09-24 14:00:00	CL	Stock	26.74	26.75	26.425	26.495	811400.0
2002-09-24 15:00:00	CL	Stock	26.5	26.595	26.275	26.275	1098200.0
2002-09-24 16:00:00	CL	Stock	26.275	26.275	26.25	26.25	277600.0

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

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