PREVIEW / stock_1hour / 2005-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-22.parquet
  size:    576 KB
  rows:    27,136
  symbols: 2,125

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-11-22 08:00:00	AAPL	Stock	2.3107	2.3125	2.305	2.3107	609588.0
2005-11-22 09:00:00	AAPL	Stock	2.31	2.3229	2.3043	2.3093	46931780.0
2005-11-22 10:00:00	AAPL	Stock	2.3086	2.3586	2.3054	2.3464	115243884.0
2005-11-22 11:00:00	AAPL	Stock	2.3464	2.3554	2.3382	2.3461	56987252.0
2005-11-22 12:00:00	AAPL	Stock	2.3464	2.3557	2.3443	2.3514	32996964.0
2005-11-22 13:00:00	AAPL	Stock	2.3514	2.3575	2.3411	2.3439	47692288.0
2005-11-22 14:00:00	AAPL	Stock	2.3436	2.3625	2.3436	2.3582	83609960.0
2005-11-22 15:00:00	AAPL	Stock	2.3582	2.3843	2.3582	2.3843	141688036.0
2005-11-22 16:00:00	AAPL	Stock	2.3825	2.3857	2.3757	2.3821	3366944.0
2005-11-22 17:00:00	AAPL	Stock	2.3821	2.3846	2.3796	2.3814	178920.0
2005-11-22 18:00:00	AAPL	Stock	2.3821	2.3821	2.3814	2.3821	132608.0
2005-11-22 08:00:00	MSFT	Stock	28.14	28.22	28.03	28.06	79257.0
2005-11-22 09:00:00	MSFT	Stock	28.06	28.08	27.95	27.99	11612235.0
2005-11-22 10:00:00	MSFT	Stock	27.99	28.045	27.92	28.02	17334919.0
2005-11-22 11:00:00	MSFT	Stock	28.03	28.05	27.98	28.01	13092916.0
2005-11-22 12:00:00	MSFT	Stock	28.01	28.03	27.97	28.0	11123515.0
2005-11-22 13:00:00	MSFT	Stock	28.0	28.051	27.89	27.89	10268662.0
2005-11-22 14:00:00	MSFT	Stock	27.9	28.02	27.89	27.99	9760717.0
2005-11-22 15:00:00	MSFT	Stock	27.988	28.01	27.86	27.88	21451539.0
2005-11-22 16:00:00	MSFT	Stock	27.91	28.05	27.85	27.96	5656044.0
2005-11-22 17:00:00	MSFT	Stock	27.94	27.98	27.91	27.94	16000.0
2005-11-22 18:00:00	MSFT	Stock	27.91	27.91	27.76	27.85	39554.0
2005-11-22 08:00:00	NVDA	Stock	0.3083	0.3125	0.3062	0.3062	1018800.0
2005-11-22 09:00:00	NVDA	Stock	0.3062	0.3123	0.3061	0.3116	117339720.0
2005-11-22 10:00:00	NVDA	Stock	0.3113	0.3121	0.3081	0.3092	120114360.0
2005-11-22 11:00:00	NVDA	Stock	0.3096	0.3117	0.3089	0.3107	45762600.0
2005-11-22 12:00:00	NVDA	Stock	0.3107	0.3137	0.3106	0.3135	65861280.0
2005-11-22 13:00:00	NVDA	Stock	0.3135	0.3149	0.3122	0.3127	52913880.0
2005-11-22 14:00:00	NVDA	Stock	0.3127	0.3164	0.3127	0.3162	118535400.0
2005-11-22 15:00:00	NVDA	Stock	0.3162	0.3181	0.3142	0.3148	190687800.0
2005-11-22 16:00:00	NVDA	Stock	0.3146	0.3148	0.3133	0.3146	839040.0
2005-11-22 17:00:00	NVDA	Stock	0.3148	0.3158	0.3148	0.3151	324000.0
2005-11-22 18:00:00	NVDA	Stock	0.3151	0.3151	0.3151	0.3151	12000.0
2005-11-22 07:00:00	AMZN	Stock	2.3875	2.3875	2.3875	2.3875	4000.0
2005-11-22 08:00:00	AMZN	Stock	2.385	2.387	2.375	2.3775	1452460.0
2005-11-22 09:00:00	AMZN	Stock	2.3765	2.388	2.37	2.3755	35204920.0
2005-11-22 10:00:00	AMZN	Stock	2.3755	2.3855	2.367	2.371	39903260.0
2005-11-22 11:00:00	AMZN	Stock	2.3705	2.379	2.367	2.376	17968120.0
2005-11-22 12:00:00	AMZN	Stock	2.376	2.3965	2.375	2.3925	21290640.0
2005-11-22 13:00:00	AMZN	Stock	2.3925	2.406	2.392	2.3935	35259540.0
2005-11-22 14:00:00	AMZN	Stock	2.3935	2.421	2.3915	2.4105	39466980.0
2005-11-22 15:00:00	AMZN	Stock	2.4105	2.4505	2.409	2.4415	65521540.0
2005-11-22 16:00:00	AMZN	Stock	2.4425	2.4455	2.4415	2.4445	1152740.0
2005-11-22 17:00:00	AMZN	Stock	2.4445	2.4445	2.4425	2.4425	175060.0
2005-11-22 18:00:00	AMZN	Stock	2.442	2.442	2.442	2.442	8000.0
2005-11-22 09:00:00	CL	Stock	27.14	27.2	26.975	27.025	297600.0
2005-11-22 10:00:00	CL	Stock	27.025	27.07	26.895	26.895	349200.0
2005-11-22 11:00:00	CL	Stock	26.895	26.945	26.855	26.86	360800.0
2005-11-22 12:00:00	CL	Stock	26.855	26.88	26.82	26.83	371400.0
2005-11-22 13:00:00	CL	Stock	26.83	26.965	26.825	26.9	399600.0

> showing 50 of 27,136 rows — these rows as CSV

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