PREVIEW / stock_1hour / 2000-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-02-04.parquet
  size:    278 KB
  rows:    14,264
  symbols: 1,132

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-02-04 09:00:00	AAPL	Stock	0.928	0.9509	0.9252	0.9498	67144000.0
2000-02-04 10:00:00	AAPL	Stock	0.9501	0.9626	0.9414	0.9604	93531200.0
2000-02-04 11:00:00	AAPL	Stock	0.9593	0.9643	0.9487	0.9526	53009600.0
2000-02-04 12:00:00	AAPL	Stock	0.9531	0.9598	0.9509	0.9581	23273600.0
2000-02-04 13:00:00	AAPL	Stock	0.9587	0.9688	0.957	0.9621	42403200.0
2000-02-04 14:00:00	AAPL	Stock	0.9621	0.9777	0.9621	0.976	37889600.0
2000-02-04 15:00:00	AAPL	Stock	0.976	0.9821	0.9609	0.9637	82308800.0
2000-02-04 16:00:00	AAPL	Stock	0.9643	0.9643	0.9637	0.9643	470400.0
2000-02-04 09:00:00	MSFT	Stock	52.1875	52.9062	52.0625	52.7812	8648400.0
2000-02-04 10:00:00	MSFT	Stock	52.7812	53.0	52.5312	53.0	9485200.0
2000-02-04 11:00:00	MSFT	Stock	53.0	53.4062	52.875	53.2188	7180600.0
2000-02-04 12:00:00	MSFT	Stock	53.25	53.75	52.9688	53.5625	6108400.0
2000-02-04 13:00:00	MSFT	Stock	53.5625	53.75	53.0938	53.3438	4687200.0
2000-02-04 14:00:00	MSFT	Stock	53.3125	53.875	53.25	53.7812	5019600.0
2000-02-04 15:00:00	MSFT	Stock	53.7812	54.0	52.7812	53.25	11306400.0
2000-02-04 16:00:00	MSFT	Stock	53.25	53.2812	53.2188	53.2812	130200.0
2000-02-04 09:00:00	NVDA	Stock	0.0852	0.0852	0.084	0.0849	7008000.0
2000-02-04 10:00:00	NVDA	Stock	0.0844	0.0846	0.0828	0.0833	20016000.0
2000-02-04 11:00:00	NVDA	Stock	0.0833	0.0846	0.0829	0.0836	31968000.0
2000-02-04 12:00:00	NVDA	Stock	0.0836	0.0836	0.0831	0.0831	11808000.0
2000-02-04 13:00:00	NVDA	Stock	0.0831	0.0833	0.0831	0.0833	9120000.0
2000-02-04 14:00:00	NVDA	Stock	0.0833	0.0849	0.0831	0.0848	27888000.0
2000-02-04 15:00:00	NVDA	Stock	0.0844	0.0849	0.0833	0.0845	14352000.0
2000-02-04 09:00:00	AMZN	Stock	4.1375	4.1375	4.0125	4.0344	38520000.0
2000-02-04 10:00:00	AMZN	Stock	4.0344	4.125	4.0219	4.075	37968000.0
2000-02-04 11:00:00	AMZN	Stock	4.0781	4.0844	3.9969	4.0156	30946000.0
2000-02-04 12:00:00	AMZN	Stock	4.0156	4.0688	4.0	4.0594	19542000.0
2000-02-04 13:00:00	AMZN	Stock	4.0594	4.0625	4.0125	4.0188	16228000.0
2000-02-04 14:00:00	AMZN	Stock	4.0219	4.0375	3.975	3.9781	17946000.0
2000-02-04 15:00:00	AMZN	Stock	3.9781	3.9812	3.8938	3.9281	43872000.0
2000-02-04 16:00:00	AMZN	Stock	3.9281	3.9281	3.925	3.9281	184000.0
2000-02-04 09:00:00	CL	Stock	29.75	29.7812	29.5625	29.5625	388200.0
2000-02-04 10:00:00	CL	Stock	29.5625	29.5938	28.5312	28.6562	678000.0
2000-02-04 11:00:00	CL	Stock	28.625	29.0625	28.125	28.125	1031800.0
2000-02-04 12:00:00	CL	Stock	28.0	28.3125	27.8125	28.25	1533200.0
2000-02-04 13:00:00	CL	Stock	28.25	28.3125	28.0312	28.1875	618400.0
2000-02-04 14:00:00	CL	Stock	28.1875	28.4375	28.0938	28.0938	752000.0
2000-02-04 15:00:00	CL	Stock	28.0312	28.4375	27.5	28.25	1242600.0
2000-02-04 16:00:00	CL	Stock	28.2812	28.2812	28.125	28.125	130200.0

> showing 39 of 14,264 rows — these rows as CSV

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