PREVIEW / stock_1hour / 2001-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-07.parquet
  size:    356 KB
  rows:    17,280
  symbols: 1,337

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
2001-08-07 08:00:00	AAPL	Stock	0.3407	0.3455	0.3407	0.3455	168000.0
2001-08-07 09:00:00	AAPL	Stock	0.3455	0.3464	0.3389	0.3455	22736000.0
2001-08-07 10:00:00	AAPL	Stock	0.3455	0.3491	0.3439	0.348	23262400.0
2001-08-07 11:00:00	AAPL	Stock	0.348	0.3513	0.3477	0.3496	26174400.0
2001-08-07 12:00:00	AAPL	Stock	0.3498	0.3504	0.3436	0.345	23307200.0
2001-08-07 13:00:00	AAPL	Stock	0.345	0.3505	0.345	0.3489	16004800.0
2001-08-07 14:00:00	AAPL	Stock	0.3489	0.35	0.3471	0.3471	14616000.0
2001-08-07 15:00:00	AAPL	Stock	0.3473	0.3479	0.3436	0.3438	26443200.0
2001-08-07 16:00:00	AAPL	Stock	0.3439	0.3466	0.3434	0.3438	3920000.0
2001-08-07 17:00:00	AAPL	Stock	0.3454	0.3454	0.3454	0.3454	11200.0
2001-08-07 08:00:00	MSFT	Stock	32.94	33.15	32.94	33.035	73000.0
2001-08-07 09:00:00	MSFT	Stock	33.04	33.25	32.995	33.22	4242400.0
2001-08-07 10:00:00	MSFT	Stock	33.24	33.5	33.125	33.435	6667600.0
2001-08-07 11:00:00	MSFT	Stock	33.45	33.525	33.355	33.46	3734200.0
2001-08-07 12:00:00	MSFT	Stock	33.455	33.485	33.145	33.2	3210000.0
2001-08-07 13:00:00	MSFT	Stock	33.2	33.295	33.125	33.235	3053200.0
2001-08-07 14:00:00	MSFT	Stock	33.23	33.25	33.1	33.13	2261800.0
2001-08-07 15:00:00	MSFT	Stock	33.13	33.21	33.02	33.185	4543200.0
2001-08-07 16:00:00	MSFT	Stock	33.185	33.4	33.105	33.175	2412800.0
2001-08-07 17:00:00	MSFT	Stock	33.175	33.255	33.045	33.05	138200.0
2001-08-07 18:00:00	MSFT	Stock	33.1	33.1	33.1	33.1	400.0
2001-08-07 08:00:00	NVDA	Stock	0.3727	0.3779	0.3692	0.3729	2880000.0
2001-08-07 09:00:00	NVDA	Stock	0.3729	0.3769	0.365	0.3702	234240000.0
2001-08-07 10:00:00	NVDA	Stock	0.3693	0.376	0.3683	0.3737	278160000.0
2001-08-07 11:00:00	NVDA	Stock	0.3742	0.3749	0.3692	0.37	83208000.0
2001-08-07 12:00:00	NVDA	Stock	0.37	0.3725	0.3692	0.3698	73728000.0
2001-08-07 13:00:00	NVDA	Stock	0.37	0.3716	0.3683	0.3686	98208000.0
2001-08-07 14:00:00	NVDA	Stock	0.3686	0.3688	0.3644	0.3665	123480000.0
2001-08-07 15:00:00	NVDA	Stock	0.3665	0.3708	0.3656	0.369	154944000.0
2001-08-07 16:00:00	NVDA	Stock	0.3691	0.3698	0.3657	0.3698	5448000.0
2001-08-07 17:00:00	NVDA	Stock	0.3698	0.37	0.3679	0.3679	1392000.0
2001-08-07 18:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	48000.0
2001-08-07 08:00:00	AMZN	Stock	0.597	0.6	0.597	0.599	46000.0
2001-08-07 09:00:00	AMZN	Stock	0.597	0.599	0.586	0.59	8732000.0
2001-08-07 10:00:00	AMZN	Stock	0.59	0.5925	0.5875	0.592	13842000.0
2001-08-07 11:00:00	AMZN	Stock	0.592	0.5925	0.5885	0.5915	4412000.0
2001-08-07 12:00:00	AMZN	Stock	0.5915	0.5915	0.5795	0.5805	3628000.0
2001-08-07 13:00:00	AMZN	Stock	0.5805	0.5825	0.576	0.5805	4072000.0
2001-08-07 14:00:00	AMZN	Stock	0.581	0.5815	0.577	0.5785	5896000.0
2001-08-07 15:00:00	AMZN	Stock	0.5785	0.5835	0.5775	0.58	6316000.0
2001-08-07 16:00:00	AMZN	Stock	0.581	0.585	0.5775	0.5835	1088000.0
2001-08-07 17:00:00	AMZN	Stock	0.5825	0.5845	0.58	0.58	32000.0
2001-08-07 18:00:00	AMZN	Stock	0.58	0.58	0.579	0.579	18000.0
2001-08-07 09:00:00	CL	Stock	26.675	26.68	26.5	26.625	386200.0
2001-08-07 10:00:00	CL	Stock	26.635	26.925	26.635	26.8	432600.0
2001-08-07 11:00:00	CL	Stock	26.79	26.8	26.5	26.59	394400.0
2001-08-07 12:00:00	CL	Stock	26.575	26.59	26.375	26.425	313400.0
2001-08-07 13:00:00	CL	Stock	26.44	26.48	26.4	26.415	125400.0
2001-08-07 14:00:00	CL	Stock	26.42	26.47	26.29	26.43	226800.0
2001-08-07 15:00:00	CL	Stock	26.43	26.525	26.38	26.505	317400.0

> showing 50 of 17,280 rows — these rows as CSV

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