PREVIEW / stock_1hour / 2000-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-21.parquet
  size:    294 KB
  rows:    15,087
  symbols: 1,180

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
2000-06-21 08:00:00	AAPL	Stock	0.942	0.942	0.8895	0.8973	61600.0
2000-06-21 09:00:00	AAPL	Stock	0.8973	0.9263	0.8929	0.9236	57797600.0
2000-06-21 10:00:00	AAPL	Stock	0.9241	0.952	0.9196	0.942	107598400.0
2000-06-21 11:00:00	AAPL	Stock	0.942	0.9431	0.9286	0.9353	41955200.0
2000-06-21 12:00:00	AAPL	Stock	0.9353	0.9431	0.9342	0.9397	28397600.0
2000-06-21 13:00:00	AAPL	Stock	0.9397	0.9554	0.9342	0.9531	32670400.0
2000-06-21 14:00:00	AAPL	Stock	0.9509	0.9766	0.9487	0.9688	72318400.0
2000-06-21 15:00:00	AAPL	Stock	0.9693	1.0167	0.9621	0.9922	141982400.0
2000-06-21 16:00:00	AAPL	Stock	0.9922	1.0067	0.9866	0.9888	4989600.0
2000-06-21 17:00:00	AAPL	Stock	0.9944	0.9944	0.9944	0.9944	5600.0
2000-06-21 18:00:00	AAPL	Stock	0.9911	0.9911	0.9911	0.9911	5600.0
2000-06-21 08:00:00	MSFT	Stock	37.5625	38.375	37.3125	38.375	1022000.0
2000-06-21 09:00:00	MSFT	Stock	38.3125	39.1562	38.0	38.9688	31708400.0
2000-06-21 10:00:00	MSFT	Stock	38.9688	39.9062	38.9531	39.375	31919200.0
2000-06-21 11:00:00	MSFT	Stock	39.375	39.6562	39.25	39.5938	13829400.0
2000-06-21 12:00:00	MSFT	Stock	39.5625	39.7812	39.5	39.625	8286000.0
2000-06-21 13:00:00	MSFT	Stock	39.5938	40.0625	39.5	40.0	15872200.0
2000-06-21 14:00:00	MSFT	Stock	40.0156	41.0938	40.0	40.8438	26457400.0
2000-06-21 15:00:00	MSFT	Stock	40.8438	41.0	40.2812	40.3125	25849600.0
2000-06-21 16:00:00	MSFT	Stock	40.3125	40.875	39.625	40.1875	3563400.0
2000-06-21 17:00:00	MSFT	Stock	40.1875	40.375	40.1875	40.2812	99000.0
2000-06-21 18:00:00	MSFT	Stock	40.3125	40.4688	40.25	40.25	25400.0
2000-06-21 09:00:00	NVDA	Stock	0.3161	0.3396	0.3161	0.3375	53952000.0
2000-06-21 10:00:00	NVDA	Stock	0.3384	0.3458	0.3333	0.3354	130944000.0
2000-06-21 11:00:00	NVDA	Stock	0.3362	0.3432	0.3353	0.3415	37872000.0
2000-06-21 12:00:00	NVDA	Stock	0.3405	0.3424	0.3378	0.3383	16032000.0
2000-06-21 13:00:00	NVDA	Stock	0.3383	0.3479	0.3355	0.3474	38784000.0
2000-06-21 14:00:00	NVDA	Stock	0.3479	0.3594	0.3424	0.3557	105456000.0
2000-06-21 15:00:00	NVDA	Stock	0.3552	0.3667	0.3508	0.3603	218016000.0
2000-06-21 16:00:00	NVDA	Stock	0.3604	0.3622	0.3578	0.3603	6336000.0
2000-06-21 17:00:00	NVDA	Stock	0.3604	0.3604	0.3604	0.3604	48000.0
2000-06-21 08:00:00	AMZN	Stock	2.275	2.2812	2.2438	2.2625	170000.0
2000-06-21 09:00:00	AMZN	Stock	2.2625	2.2875	2.2531	2.2844	12722000.0
2000-06-21 10:00:00	AMZN	Stock	2.2875	2.3219	2.2625	2.2969	15570000.0
2000-06-21 11:00:00	AMZN	Stock	2.2906	2.3188	2.2875	2.3125	5392000.0
2000-06-21 12:00:00	AMZN	Stock	2.3125	2.3469	2.3094	2.3188	5560000.0
2000-06-21 13:00:00	AMZN	Stock	2.325	2.3375	2.3031	2.3344	6436000.0
2000-06-21 14:00:00	AMZN	Stock	2.3344	2.3438	2.3188	2.3281	6632000.0
2000-06-21 15:00:00	AMZN	Stock	2.3281	2.3406	2.2938	2.3031	16788000.0
2000-06-21 16:00:00	AMZN	Stock	2.3031	2.3031	2.2969	2.3031	1696000.0
2000-06-21 17:00:00	AMZN	Stock	2.3031	2.3219	2.3031	2.3219	10000.0
2000-06-21 18:00:00	AMZN	Stock	2.3125	2.3125	2.3062	2.3062	6000.0
2000-06-21 09:00:00	CL	Stock	28.625	28.7812	28.5625	28.625	298600.0
2000-06-21 10:00:00	CL	Stock	28.6562	28.6562	28.0625	28.125	329800.0
2000-06-21 11:00:00	CL	Stock	28.125	28.125	27.7812	27.8438	353600.0
2000-06-21 12:00:00	CL	Stock	27.875	28.1562	27.875	27.9062	212200.0
2000-06-21 13:00:00	CL	Stock	27.9062	28.1875	27.875	28.125	131800.0
2000-06-21 14:00:00	CL	Stock	28.125	28.2812	27.8438	28.2812	298800.0
2000-06-21 15:00:00	CL	Stock	28.2812	28.5625	28.2812	28.5	547000.0
2000-06-21 16:00:00	CL	Stock	28.5	28.5	28.5	28.5	197800.0

> showing 50 of 15,087 rows — these rows as CSV

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