PREVIEW / stock_1hour / 2000-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-01.parquet
  size:    297 KB
  rows:    15,344
  symbols: 1,196

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-08-01 08:00:00	AAPL	Stock	0.9063	0.9063	0.8929	0.8929	380800.0
2000-08-01 09:00:00	AAPL	Stock	0.8996	0.9129	0.8884	0.904	15769600.0
2000-08-01 10:00:00	AAPL	Stock	0.904	0.9074	0.8839	0.8973	24488800.0
2000-08-01 11:00:00	AAPL	Stock	0.8973	0.904	0.8906	0.8956	11222400.0
2000-08-01 12:00:00	AAPL	Stock	0.8951	0.904	0.8929	0.8962	17399200.0
2000-08-01 13:00:00	AAPL	Stock	0.8951	0.8996	0.8929	0.8951	18295200.0
2000-08-01 14:00:00	AAPL	Stock	0.8973	0.9085	0.8884	0.8884	11844000.0
2000-08-01 15:00:00	AAPL	Stock	0.8884	0.8923	0.8806	0.8806	23189600.0
2000-08-01 16:00:00	AAPL	Stock	0.8817	0.8873	0.8772	0.8795	6899200.0
2000-08-01 17:00:00	AAPL	Stock	0.8806	0.8806	0.8789	0.8795	2032800.0
2000-08-01 18:00:00	AAPL	Stock	0.8806	0.8806	0.8806	0.8806	632800.0
2000-08-01 08:00:00	MSFT	Stock	35.25	35.25	34.8125	34.8125	105000.0
2000-08-01 09:00:00	MSFT	Stock	34.8125	35.0625	34.5625	34.6562	6001600.0
2000-08-01 10:00:00	MSFT	Stock	34.625	34.75	34.5625	34.6875	6212600.0
2000-08-01 11:00:00	MSFT	Stock	34.7188	34.7812	34.5938	34.5938	3075000.0
2000-08-01 12:00:00	MSFT	Stock	34.625	34.75	34.5	34.5	3501600.0
2000-08-01 13:00:00	MSFT	Stock	34.5	34.5938	34.2812	34.5938	4811000.0
2000-08-01 14:00:00	MSFT	Stock	34.5938	34.6562	34.3125	34.3125	4401200.0
2000-08-01 15:00:00	MSFT	Stock	34.3125	34.4062	34.0938	34.375	8704000.0
2000-08-01 16:00:00	MSFT	Stock	34.375	34.4844	34.3125	34.4062	7434000.0
2000-08-01 17:00:00	MSFT	Stock	34.375	34.4062	34.2812	34.375	976400.0
2000-08-01 18:00:00	MSFT	Stock	34.3438	34.3438	34.3438	34.3438	90200.0
2000-08-01 09:00:00	NVDA	Stock	0.25	0.2521	0.2453	0.2479	46080000.0
2000-08-01 10:00:00	NVDA	Stock	0.248	0.249	0.2458	0.2474	44568000.0
2000-08-01 11:00:00	NVDA	Stock	0.247	0.2497	0.2443	0.2469	32856000.0
2000-08-01 12:00:00	NVDA	Stock	0.2469	0.2477	0.2443	0.2469	24840000.0
2000-08-01 13:00:00	NVDA	Stock	0.2471	0.2474	0.2438	0.244	33672000.0
2000-08-01 14:00:00	NVDA	Stock	0.244	0.2461	0.2432	0.2435	34272000.0
2000-08-01 15:00:00	NVDA	Stock	0.2435	0.2461	0.2432	0.2451	114168000.0
2000-08-01 16:00:00	NVDA	Stock	0.2451	0.2453	0.2448	0.2448	14472000.0
2000-08-01 17:00:00	NVDA	Stock	0.2466	0.2466	0.2466	0.2466	24000.0
2000-08-01 08:00:00	AMZN	Stock	1.525	1.55	1.5125	1.5156	310000.0
2000-08-01 09:00:00	AMZN	Stock	1.5188	1.6125	1.5156	1.5594	36414000.0
2000-08-01 10:00:00	AMZN	Stock	1.5625	1.5812	1.5375	1.5438	29234000.0
2000-08-01 11:00:00	AMZN	Stock	1.5438	1.5594	1.5375	1.55	14364000.0
2000-08-01 12:00:00	AMZN	Stock	1.55	1.5625	1.5469	1.55	12314000.0
2000-08-01 13:00:00	AMZN	Stock	1.5531	1.5594	1.5469	1.5531	9528000.0
2000-08-01 14:00:00	AMZN	Stock	1.55	1.5719	1.5438	1.5438	17080000.0
2000-08-01 15:00:00	AMZN	Stock	1.5438	1.55	1.5125	1.5156	32190000.0
2000-08-01 16:00:00	AMZN	Stock	1.5156	1.5469	1.5094	1.5391	3334000.0
2000-08-01 17:00:00	AMZN	Stock	1.5062	1.5125	1.5062	1.5125	126000.0
2000-08-01 18:00:00	AMZN	Stock	1.5156	1.5156	1.5125	1.5156	134000.0
2000-08-01 09:00:00	CL	Stock	27.8125	28.0625	27.6562	28.0	318400.0
2000-08-01 10:00:00	CL	Stock	27.9688	28.4062	27.9375	28.375	624000.0
2000-08-01 11:00:00	CL	Stock	28.375	28.5	28.0312	28.1562	591200.0
2000-08-01 12:00:00	CL	Stock	28.1562	28.3438	28.1562	28.3125	564400.0
2000-08-01 13:00:00	CL	Stock	28.3438	28.7188	28.3125	28.5938	604600.0
2000-08-01 14:00:00	CL	Stock	28.625	28.875	28.625	28.7188	631600.0
2000-08-01 15:00:00	CL	Stock	28.7188	28.7188	28.375	28.4688	630800.0
2000-08-01 16:00:00	CL	Stock	28.5	28.5	28.4375	28.4375	236800.0

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

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