PREVIEW / stock_1hour / 2005-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-02.parquet
  size:    578 KB
  rows:    27,333
  symbols: 2,051

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-08-02 08:00:00	AAPL	Stock	1.525	1.5286	1.525	1.5261	98784.0
2005-08-02 09:00:00	AAPL	Stock	1.5268	1.5368	1.5218	1.5307	26944400.0
2005-08-02 10:00:00	AAPL	Stock	1.5304	1.5536	1.5286	1.5461	65377564.0
2005-08-02 11:00:00	AAPL	Stock	1.5461	1.5471	1.5382	1.5457	44796528.0
2005-08-02 12:00:00	AAPL	Stock	1.5461	1.5529	1.5432	1.5443	23172212.0
2005-08-02 13:00:00	AAPL	Stock	1.5443	1.5504	1.5414	1.545	42400092.0
2005-08-02 14:00:00	AAPL	Stock	1.5454	1.5486	1.5407	1.5429	34934676.0
2005-08-02 15:00:00	AAPL	Stock	1.5425	1.5454	1.5407	1.5425	52386208.0
2005-08-02 16:00:00	AAPL	Stock	1.5443	1.5457	1.5396	1.54	579068.0
2005-08-02 17:00:00	AAPL	Stock	1.5472	1.5472	1.5404	1.5423	217168.0
2005-08-02 18:00:00	AAPL	Stock	1.54	1.54	1.54	1.54	45528.0
2005-08-02 07:00:00	MSFT	Stock	25.95	25.95	25.95	25.95	1400.0
2005-08-02 08:00:00	MSFT	Stock	25.95	25.96	25.93	25.93	22274.0
2005-08-02 09:00:00	MSFT	Stock	25.94	26.15	25.87	26.13	12343993.0
2005-08-02 10:00:00	MSFT	Stock	26.12	26.36	26.09	26.36	19593903.0
2005-08-02 11:00:00	MSFT	Stock	26.36	26.6	26.25	26.57	22223635.0
2005-08-02 12:00:00	MSFT	Stock	26.57	26.59	26.45	26.51	13878643.0
2005-08-02 13:00:00	MSFT	Stock	26.51	26.57	26.38	26.52	15972805.0
2005-08-02 14:00:00	MSFT	Stock	26.52	26.65	26.45	26.64	17975321.0
2005-08-02 15:00:00	MSFT	Stock	26.63	26.901	26.59	26.81	33020848.0
2005-08-02 16:00:00	MSFT	Stock	26.81	26.86	26.78	26.84	777248.0
2005-08-02 17:00:00	MSFT	Stock	26.83	26.87	26.516	26.87	77372.0
2005-08-02 18:00:00	MSFT	Stock	26.86	26.86	26.72	26.78	104710.0
2005-08-02 08:00:00	NVDA	Stock	0.2272	0.228	0.2267	0.2275	1032000.0
2005-08-02 09:00:00	NVDA	Stock	0.2271	0.2307	0.2267	0.23	63392520.0
2005-08-02 10:00:00	NVDA	Stock	0.23	0.2318	0.2298	0.2301	65292600.0
2005-08-02 11:00:00	NVDA	Stock	0.2301	0.2309	0.2294	0.23	49712040.0
2005-08-02 12:00:00	NVDA	Stock	0.23	0.2307	0.2296	0.2298	32882760.0
2005-08-02 13:00:00	NVDA	Stock	0.2298	0.2303	0.2297	0.2298	19644840.0
2005-08-02 14:00:00	NVDA	Stock	0.2298	0.2302	0.2292	0.2292	42001800.0
2005-08-02 15:00:00	NVDA	Stock	0.2293	0.2327	0.2293	0.232	140010480.0
2005-08-02 16:00:00	NVDA	Stock	0.2322	0.235	0.2305	0.2329	3208080.0
2005-08-02 17:00:00	NVDA	Stock	0.2327	0.2343	0.2315	0.2343	5484000.0
2005-08-02 18:00:00	NVDA	Stock	0.2346	0.235	0.2342	0.2342	324000.0
2005-08-02 08:00:00	AMZN	Stock	2.245	2.252	2.243	2.252	255360.0
2005-08-02 09:00:00	AMZN	Stock	2.2515	2.2815	2.244	2.279	20989760.0
2005-08-02 10:00:00	AMZN	Stock	2.2785	2.3315	2.274	2.319	69948940.0
2005-08-02 11:00:00	AMZN	Stock	2.319	2.3485	2.317	2.3415	31236040.0
2005-08-02 12:00:00	AMZN	Stock	2.342	2.343	2.3245	2.34	24950060.0
2005-08-02 13:00:00	AMZN	Stock	2.34	2.3415	2.321	2.3225	17201540.0
2005-08-02 14:00:00	AMZN	Stock	2.322	2.3335	2.322	2.3305	18274380.0
2005-08-02 15:00:00	AMZN	Stock	2.3305	2.3305	2.323	2.3245	30771400.0
2005-08-02 16:00:00	AMZN	Stock	2.325	2.3285	2.317	2.326	1487660.0
2005-08-02 17:00:00	AMZN	Stock	2.326	2.3275	2.325	2.3275	145860.0
2005-08-02 18:00:00	AMZN	Stock	2.3285	2.3285	2.3275	2.3275	86000.0
2005-08-02 08:00:00	CL	Stock	26.525	26.525	26.525	26.525	200.0
2005-08-02 09:00:00	CL	Stock	26.515	26.565	26.46	26.501	259000.0
2005-08-02 10:00:00	CL	Stock	26.505	26.575	26.425	26.43	486200.0
2005-08-02 11:00:00	CL	Stock	26.43	26.515	26.395	26.395	344800.0
2005-08-02 12:00:00	CL	Stock	26.395	26.445	26.31	26.3185	385200.0

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

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