PREVIEW / stock_1hour / 2005-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-21.parquet
  size:    578 KB
  rows:    27,515
  symbols: 2,071

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
2005-09-21 08:00:00	AAPL	Stock	1.9	1.9004	1.8871	1.8911	729344.0
2005-09-21 09:00:00	AAPL	Stock	1.8893	1.8946	1.8707	1.8879	74021780.0
2005-09-21 10:00:00	AAPL	Stock	1.8875	1.8939	1.88	1.8886	68975368.0
2005-09-21 11:00:00	AAPL	Stock	1.8886	1.8893	1.8546	1.8557	74681852.0
2005-09-21 12:00:00	AAPL	Stock	1.856	1.8718	1.8521	1.8718	45886120.0
2005-09-21 13:00:00	AAPL	Stock	1.8717	1.875	1.8571	1.8629	47322828.0
2005-09-21 14:00:00	AAPL	Stock	1.8625	1.8886	1.8586	1.8668	53038888.0
2005-09-21 15:00:00	AAPL	Stock	1.8671	1.8875	1.8571	1.8607	60685352.0
2005-09-21 16:00:00	AAPL	Stock	1.8611	1.8921	1.86	1.8625	2504432.0
2005-09-21 17:00:00	AAPL	Stock	1.8705	1.8717	1.8621	1.8636	2287796.0
2005-09-21 18:00:00	AAPL	Stock	1.8639	1.8639	1.8614	1.8614	19936.0
2005-09-21 08:00:00	MSFT	Stock	25.82	25.82	25.77	25.79	13686.0
2005-09-21 09:00:00	MSFT	Stock	25.78	25.81	25.56	25.63	12562287.0
2005-09-21 10:00:00	MSFT	Stock	25.63	25.67	25.55	25.62	11003195.0
2005-09-21 11:00:00	MSFT	Stock	25.61	25.64	25.519	25.532	9201642.0
2005-09-21 12:00:00	MSFT	Stock	25.54	25.61	25.51	25.57	4719373.0
2005-09-21 13:00:00	MSFT	Stock	25.58	25.66	25.499	25.52	6274230.0
2005-09-21 14:00:00	MSFT	Stock	25.51	25.9	25.499	25.61	8063578.0
2005-09-21 15:00:00	MSFT	Stock	25.61	25.67	25.43	25.48	14311708.0
2005-09-21 16:00:00	MSFT	Stock	25.49	25.54	25.48	25.53	607913.0
2005-09-21 17:00:00	MSFT	Stock	25.53	25.572	25.49	25.52	193298.0
2005-09-21 18:00:00	MSFT	Stock	25.52	25.53	25.51	25.53	3410.0
2005-09-21 09:00:00	NVDA	Stock	0.2758	0.2786	0.2735	0.2771	54215640.0
2005-09-21 10:00:00	NVDA	Stock	0.2771	0.2829	0.2767	0.2825	124212600.0
2005-09-21 11:00:00	NVDA	Stock	0.2826	0.2829	0.2756	0.2767	121132200.0
2005-09-21 12:00:00	NVDA	Stock	0.2767	0.2767	0.2737	0.2755	103768080.0
2005-09-21 13:00:00	NVDA	Stock	0.2752	0.2779	0.2737	0.2751	48291720.0
2005-09-21 14:00:00	NVDA	Stock	0.2752	0.2778	0.2747	0.2769	48437760.0
2005-09-21 15:00:00	NVDA	Stock	0.2769	0.2772	0.2747	0.276	81494640.0
2005-09-21 16:00:00	NVDA	Stock	0.2761	0.2772	0.276	0.2762	5016360.0
2005-09-21 17:00:00	NVDA	Stock	0.2758	0.2772	0.2758	0.2772	497520.0
2005-09-21 09:00:00	AMZN	Stock	2.095	2.1135	2.0855	2.1065	13037500.0
2005-09-21 10:00:00	AMZN	Stock	2.1065	2.1265	2.0955	2.124	16044240.0
2005-09-21 11:00:00	AMZN	Stock	2.125	2.132	2.076	2.082	17219900.0
2005-09-21 12:00:00	AMZN	Stock	2.082	2.095	2.075	2.0925	8933900.0
2005-09-21 13:00:00	AMZN	Stock	2.0925	2.0925	2.074	2.077	7506220.0
2005-09-21 14:00:00	AMZN	Stock	2.0775	2.101	2.0705	2.075	16778900.0
2005-09-21 15:00:00	AMZN	Stock	2.075	2.1055	2.0625	2.0635	24039780.0
2005-09-21 16:00:00	AMZN	Stock	2.067	2.067	2.0615	2.0625	1277200.0
2005-09-21 17:00:00	AMZN	Stock	2.0645	2.0645	2.0625	2.0625	11000.0
2005-09-21 09:00:00	CL	Stock	26.12	26.145	25.87	25.96	862000.0
2005-09-21 10:00:00	CL	Stock	25.96	26.12	25.91	26.02	583800.0
2005-09-21 11:00:00	CL	Stock	26.025	26.05	25.945	26.0	408600.0
2005-09-21 12:00:00	CL	Stock	25.995	26.04	25.995	26.005	545400.0
2005-09-21 13:00:00	CL	Stock	26.005	26.01	25.9	25.935	393800.0
2005-09-21 14:00:00	CL	Stock	25.93	26.075	25.915	26.01	547400.0
2005-09-21 15:00:00	CL	Stock	26.01	26.045	25.97	25.97	1199600.0
2005-09-21 16:00:00	CL	Stock	25.975	25.975	25.975	25.975	2600.0

> showing 48 of 27,515 rows — these rows as CSV

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