PREVIEW / stock_1hour / 2000-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-25.parquet
  size:    291 KB
  rows:    15,162
  symbols: 1,210

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-25 08:00:00	AAPL	Stock	1.0022	1.0089	1.0	1.0045	1663200.0
2000-08-25 09:00:00	AAPL	Stock	1.0067	1.0234	1.0033	1.0167	45074400.0
2000-08-25 10:00:00	AAPL	Stock	1.0156	1.0179	1.0067	1.0156	62960800.0
2000-08-25 11:00:00	AAPL	Stock	1.0167	1.0268	1.0145	1.0246	49067200.0
2000-08-25 12:00:00	AAPL	Stock	1.0246	1.0246	1.0156	1.0223	32429600.0
2000-08-25 13:00:00	AAPL	Stock	1.0234	1.0257	1.0145	1.0145	31819200.0
2000-08-25 14:00:00	AAPL	Stock	1.0156	1.0179	1.0123	1.0167	40247200.0
2000-08-25 15:00:00	AAPL	Stock	1.0167	1.0179	1.0089	1.0145	56543200.0
2000-08-25 16:00:00	AAPL	Stock	1.0145	1.0162	1.0017	1.0017	11188800.0
2000-08-25 08:00:00	MSFT	Stock	35.625	35.625	35.125	35.375	74400.0
2000-08-25 09:00:00	MSFT	Stock	35.375	35.8438	35.2812	35.625	8360400.0
2000-08-25 10:00:00	MSFT	Stock	35.625	35.7188	35.4062	35.4062	7019600.0
2000-08-25 11:00:00	MSFT	Stock	35.4062	35.75	35.4062	35.6562	5564000.0
2000-08-25 12:00:00	MSFT	Stock	35.6562	35.75	35.5625	35.75	3672400.0
2000-08-25 13:00:00	MSFT	Stock	35.7188	35.7812	35.4062	35.4375	4828000.0
2000-08-25 14:00:00	MSFT	Stock	35.4375	35.5312	35.3438	35.4375	8605200.0
2000-08-25 15:00:00	MSFT	Stock	35.4375	35.4688	35.3125	35.4688	10578000.0
2000-08-25 16:00:00	MSFT	Stock	35.3281	35.5625	35.3125	35.5625	3457400.0
2000-08-25 17:00:00	MSFT	Stock	35.375	35.375	35.3125	35.3125	7200.0
2000-08-25 09:00:00	NVDA	Stock	0.3169	0.324	0.3146	0.3221	20712000.0
2000-08-25 10:00:00	NVDA	Stock	0.3214	0.3214	0.3156	0.3169	32544000.0
2000-08-25 11:00:00	NVDA	Stock	0.3164	0.3174	0.3151	0.3164	9696000.0
2000-08-25 12:00:00	NVDA	Stock	0.3164	0.3219	0.3156	0.3188	25032000.0
2000-08-25 13:00:00	NVDA	Stock	0.319	0.3193	0.3151	0.3151	8520000.0
2000-08-25 14:00:00	NVDA	Stock	0.3151	0.3156	0.312	0.3135	17592000.0
2000-08-25 15:00:00	NVDA	Stock	0.3135	0.3156	0.3109	0.3125	35856000.0
2000-08-25 16:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	1344000.0
2000-08-25 18:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	24000.0
2000-08-25 08:00:00	AMZN	Stock	1.975	1.975	1.95	1.95	28000.0
2000-08-25 09:00:00	AMZN	Stock	1.9594	1.9812	1.9438	1.9562	9442000.0
2000-08-25 10:00:00	AMZN	Stock	1.9562	1.9625	1.9281	1.95	9606000.0
2000-08-25 11:00:00	AMZN	Stock	1.9469	1.9594	1.9438	1.95	5516000.0
2000-08-25 12:00:00	AMZN	Stock	1.95	1.9562	1.9438	1.95	3556000.0
2000-08-25 13:00:00	AMZN	Stock	1.9469	1.9562	1.9438	1.9469	4686000.0
2000-08-25 14:00:00	AMZN	Stock	1.9469	1.9531	1.9438	1.9469	2922000.0
2000-08-25 15:00:00	AMZN	Stock	1.9438	2.0031	1.9312	1.9969	13798000.0
2000-08-25 16:00:00	AMZN	Stock	1.9969	2.0	1.95	1.975	3664000.0
2000-08-25 17:00:00	AMZN	Stock	1.975	1.975	1.975	1.975	16000.0
2000-08-25 09:00:00	CL	Stock	26.0	26.0312	25.875	25.9062	390200.0
2000-08-25 10:00:00	CL	Stock	25.9062	25.9062	25.5312	25.5938	657600.0
2000-08-25 11:00:00	CL	Stock	25.5938	26.0938	25.5625	26.0938	469200.0
2000-08-25 12:00:00	CL	Stock	26.1562	26.1875	25.9375	26.0938	221600.0
2000-08-25 13:00:00	CL	Stock	26.0625	26.2188	26.0625	26.1875	101600.0
2000-08-25 14:00:00	CL	Stock	26.2188	26.5	26.1875	26.5	230600.0
2000-08-25 15:00:00	CL	Stock	26.5	26.625	26.375	26.5	482200.0
2000-08-25 16:00:00	CL	Stock	26.5	26.5	26.5	26.5	52200.0

> showing 46 of 15,162 rows — these rows as CSV

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