PREVIEW / stock_1hour / 2005-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-25.parquet
  size:    570 KB
  rows:    27,291
  symbols: 2,100

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
2005-10-25 07:00:00	AAPL	Stock	2.0143	2.0143	2.0143	2.0143	7000.0
2005-10-25 08:00:00	AAPL	Stock	2.0143	2.0179	2.0107	2.0161	809200.0
2005-10-25 09:00:00	AAPL	Stock	2.0139	2.0207	2.0025	2.0121	65758924.0
2005-10-25 10:00:00	AAPL	Stock	2.0121	2.0304	2.0039	2.0079	115898328.0
2005-10-25 11:00:00	AAPL	Stock	2.0082	2.0129	1.9971	2.0014	63927864.0
2005-10-25 12:00:00	AAPL	Stock	2.0018	2.005	1.9925	2.0004	43230796.0
2005-10-25 13:00:00	AAPL	Stock	2.0004	2.0025	1.9889	1.9971	49734748.0
2005-10-25 14:00:00	AAPL	Stock	1.9968	2.0007	1.9914	1.9986	46456788.0
2005-10-25 15:00:00	AAPL	Stock	1.9986	2.0036	1.9914	2.0029	65937872.0
2005-10-25 16:00:00	AAPL	Stock	2.0036	2.0036	1.9986	1.9986	893060.0
2005-10-25 17:00:00	AAPL	Stock	2.0	2.0043	1.9982	2.0021	109200.0
2005-10-25 18:00:00	AAPL	Stock	2.0014	2.0036	2.0014	2.0021	75600.0
2005-10-25 08:00:00	MSFT	Stock	24.97	25.11	24.97	25.04	26116.0
2005-10-25 09:00:00	MSFT	Stock	25.0	25.08	24.93	25.07	4216631.0
2005-10-25 10:00:00	MSFT	Stock	25.07	25.13	25.02	25.06	6547175.0
2005-10-25 11:00:00	MSFT	Stock	25.06	25.08	24.98	25.01	5178293.0
2005-10-25 12:00:00	MSFT	Stock	25.01	25.08	24.96	24.988	3632391.0
2005-10-25 13:00:00	MSFT	Stock	24.988	25.01	24.92	24.95	4974727.0
2005-10-25 14:00:00	MSFT	Stock	24.95	24.97	24.84	24.93	5458217.0
2005-10-25 15:00:00	MSFT	Stock	24.93	25.04	24.83	25.03	9589381.0
2005-10-25 16:00:00	MSFT	Stock	25.03	25.076	25.0	25.01	387388.0
2005-10-25 17:00:00	MSFT	Stock	25.01	25.03	24.95	24.96	13172.0
2005-10-25 18:00:00	MSFT	Stock	25.03	25.04	25.03	25.04	703.0
2005-10-25 09:00:00	NVDA	Stock	0.2716	0.2733	0.2712	0.2722	22970520.0
2005-10-25 10:00:00	NVDA	Stock	0.2723	0.276	0.2704	0.2748	85013640.0
2005-10-25 11:00:00	NVDA	Stock	0.275	0.2757	0.2729	0.2741	36837840.0
2005-10-25 12:00:00	NVDA	Stock	0.2741	0.2752	0.2727	0.2732	48754080.0
2005-10-25 13:00:00	NVDA	Stock	0.2731	0.2751	0.2721	0.2721	22800120.0
2005-10-25 14:00:00	NVDA	Stock	0.2721	0.2739	0.2718	0.2733	22680720.0
2005-10-25 15:00:00	NVDA	Stock	0.2731	0.2752	0.2729	0.2752	77606880.0
2005-10-25 16:00:00	NVDA	Stock	0.2752	0.2754	0.2745	0.2745	4716000.0
2005-10-25 08:00:00	AMZN	Stock	2.3475	2.3475	2.3275	2.3275	44000.0
2005-10-25 09:00:00	AMZN	Stock	2.325	2.35	2.325	2.341	19509120.0
2005-10-25 10:00:00	AMZN	Stock	2.3405	2.345	2.3275	2.329	21606980.0
2005-10-25 11:00:00	AMZN	Stock	2.329	2.329	2.3035	2.323	19861700.0
2005-10-25 12:00:00	AMZN	Stock	2.323	2.325	2.313	2.324	14262140.0
2005-10-25 13:00:00	AMZN	Stock	2.324	2.325	2.3155	2.323	15298640.0
2005-10-25 14:00:00	AMZN	Stock	2.3225	2.3275	2.3025	2.315	29670900.0
2005-10-25 15:00:00	AMZN	Stock	2.315	2.3205	2.302	2.3105	36712840.0
2005-10-25 16:00:00	AMZN	Stock	2.309	2.3105	2.106	2.1455	68212960.0
2005-10-25 17:00:00	AMZN	Stock	2.1455	2.3085	2.125	2.129	14428220.0
2005-10-25 18:00:00	AMZN	Stock	2.129	2.1355	2.1215	2.1355	1991560.0
2005-10-25 09:00:00	CL	Stock	26.24	26.445	26.165	26.39	219000.0
2005-10-25 10:00:00	CL	Stock	26.385	26.445	26.2	26.211	357800.0
2005-10-25 11:00:00	CL	Stock	26.205	26.32	26.125	26.2175	326000.0
2005-10-25 12:00:00	CL	Stock	26.2	26.255	26.06	26.09	317600.0
2005-10-25 13:00:00	CL	Stock	26.09	26.13	26.0	26.04	335000.0
2005-10-25 14:00:00	CL	Stock	26.03	26.06	25.965	26.0	383000.0
2005-10-25 15:00:00	CL	Stock	26.0	26.27	25.97	26.215	690000.0

> showing 49 of 27,291 rows — these rows as CSV

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