PREVIEW / stock_1hour / 2000-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-25.parquet
  size:    298 KB
  rows:    15,313
  symbols: 1,201

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-07-25 08:00:00	AAPL	Stock	0.8839	0.8929	0.8839	0.8873	392000.0
2000-07-25 09:00:00	AAPL	Stock	0.8884	0.9018	0.8862	0.8962	46704000.0
2000-07-25 10:00:00	AAPL	Stock	0.8962	0.8984	0.8761	0.8895	41602400.0
2000-07-25 11:00:00	AAPL	Stock	0.8901	0.8906	0.8772	0.885	16716000.0
2000-07-25 12:00:00	AAPL	Stock	0.8839	0.8906	0.8806	0.8895	11048800.0
2000-07-25 13:00:00	AAPL	Stock	0.8906	0.8984	0.8862	0.8973	15674400.0
2000-07-25 14:00:00	AAPL	Stock	0.8962	0.904	0.8884	0.8951	35140000.0
2000-07-25 15:00:00	AAPL	Stock	0.8951	0.904	0.8884	0.8929	35817600.0
2000-07-25 16:00:00	AAPL	Stock	0.8934	0.8951	0.8906	0.8923	3550400.0
2000-07-25 17:00:00	AAPL	Stock	0.8951	0.8951	0.8917	0.8917	72800.0
2000-07-25 08:00:00	MSFT	Stock	35.75	35.75	35.2969	35.5625	210000.0
2000-07-25 09:00:00	MSFT	Stock	35.625	35.75	34.9375	35.0781	8191600.0
2000-07-25 10:00:00	MSFT	Stock	35.0625	35.0938	34.75	34.9688	9578200.0
2000-07-25 11:00:00	MSFT	Stock	34.9688	35.0938	34.875	34.875	3558400.0
2000-07-25 12:00:00	MSFT	Stock	34.875	35.0312	34.75	34.9375	4626800.0
2000-07-25 13:00:00	MSFT	Stock	34.9375	34.9688	34.4375	34.5625	12198800.0
2000-07-25 14:00:00	MSFT	Stock	34.5312	34.5625	34.1875	34.2969	10430400.0
2000-07-25 15:00:00	MSFT	Stock	34.2969	34.5312	34.25	34.5	12432200.0
2000-07-25 16:00:00	MSFT	Stock	34.4688	34.7031	34.3125	34.5625	1235800.0
2000-07-25 17:00:00	MSFT	Stock	34.5469	34.6875	34.5	34.6875	12400.0
2000-07-25 18:00:00	MSFT	Stock	34.5312	35.0	34.5	34.75	43000.0
2000-07-25 08:00:00	NVDA	Stock	0.2688	0.2688	0.2688	0.2688	48000.0
2000-07-25 09:00:00	NVDA	Stock	0.2708	0.2719	0.2604	0.262	42288000.0
2000-07-25 10:00:00	NVDA	Stock	0.2625	0.2661	0.2563	0.2604	70152000.0
2000-07-25 11:00:00	NVDA	Stock	0.2604	0.2646	0.2563	0.2583	51720000.0
2000-07-25 12:00:00	NVDA	Stock	0.2583	0.2604	0.2568	0.2604	27048000.0
2000-07-25 13:00:00	NVDA	Stock	0.2599	0.2677	0.2599	0.2651	32136000.0
2000-07-25 14:00:00	NVDA	Stock	0.2654	0.2677	0.2604	0.2622	33744000.0
2000-07-25 15:00:00	NVDA	Stock	0.2622	0.2635	0.2552	0.2563	64152000.0
2000-07-25 16:00:00	NVDA	Stock	0.2568	0.2583	0.2542	0.2542	6528000.0
2000-07-25 08:00:00	AMZN	Stock	1.9375	1.9375	1.7812	1.85	2280000.0
2000-07-25 09:00:00	AMZN	Stock	1.85	1.8688	1.7469	1.7594	65938000.0
2000-07-25 10:00:00	AMZN	Stock	1.7594	1.8156	1.6625	1.8	119634000.0
2000-07-25 11:00:00	AMZN	Stock	1.7969	1.8188	1.7	1.7094	47182000.0
2000-07-25 12:00:00	AMZN	Stock	1.7125	1.75	1.6938	1.7094	53000000.0
2000-07-25 13:00:00	AMZN	Stock	1.7125	1.8938	1.7094	1.8531	94968000.0
2000-07-25 14:00:00	AMZN	Stock	1.8469	1.9375	1.775	1.9	97130000.0
2000-07-25 15:00:00	AMZN	Stock	1.9	1.9062	1.8609	1.8812	57646000.0
2000-07-25 16:00:00	AMZN	Stock	1.8812	1.8875	1.8625	1.8812	4312000.0
2000-07-25 17:00:00	AMZN	Stock	1.8906	1.8906	1.875	1.875	66000.0
2000-07-25 18:00:00	AMZN	Stock	1.8625	1.875	1.8562	1.8562	62000.0
2000-07-25 09:00:00	CL	Stock	28.375	28.4688	28.1562	28.1875	235400.0
2000-07-25 10:00:00	CL	Stock	28.1875	28.375	28.0938	28.0938	532200.0
2000-07-25 11:00:00	CL	Stock	28.0625	28.125	27.875	28.0625	683600.0
2000-07-25 12:00:00	CL	Stock	28.0625	28.25	28.0312	28.1875	267400.0
2000-07-25 13:00:00	CL	Stock	28.2188	28.4062	28.1875	28.1875	248800.0
2000-07-25 14:00:00	CL	Stock	28.1875	28.3438	28.0312	28.3125	467400.0
2000-07-25 15:00:00	CL	Stock	28.2812	28.5312	28.1562	28.1875	758200.0
2000-07-25 16:00:00	CL	Stock	28.1562	28.25	28.1562	28.2031	200200.0

> showing 49 of 15,313 rows — these rows as CSV

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