PREVIEW / stock_1hour / 2006-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-02-10.parquet
  size:    607 KB
  rows:    28,444
  symbols: 2,185

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
2006-02-10 07:00:00	AAPL	Stock	2.3143	2.3143	2.3114	2.3143	131600.0
2006-02-10 08:00:00	AAPL	Stock	2.3143	2.3264	2.3032	2.3257	7581896.0
2006-02-10 09:00:00	AAPL	Stock	2.3257	2.3571	2.2657	2.2943	273152432.0
2006-02-10 10:00:00	AAPL	Stock	2.2943	2.2989	2.2464	2.2582	302884540.0
2006-02-10 11:00:00	AAPL	Stock	2.2586	2.3214	2.25	2.2796	212263268.0
2006-02-10 12:00:00	AAPL	Stock	2.2797	2.3196	2.2768	2.3	149396856.0
2006-02-10 13:00:00	AAPL	Stock	2.2996	2.3411	2.2979	2.3396	194497828.0
2006-02-10 14:00:00	AAPL	Stock	2.3396	2.3961	2.3289	2.3843	281678124.0
2006-02-10 15:00:00	AAPL	Stock	2.3846	2.4168	2.3707	2.4054	315340256.0
2006-02-10 16:00:00	AAPL	Stock	2.4046	2.4057	2.3957	2.4043	4223212.0
2006-02-10 17:00:00	AAPL	Stock	2.4043	2.4057	2.3968	2.3971	1858388.0
2006-02-10 18:00:00	AAPL	Stock	2.3971	2.4007	2.3857	2.3893	852740.0
2006-02-10 08:00:00	MSFT	Stock	26.61	26.7	26.61	26.67	24970.0
2006-02-10 09:00:00	MSFT	Stock	26.7	26.89	26.62	26.78	7163539.0
2006-02-10 10:00:00	MSFT	Stock	26.78	26.8	26.6	26.612	7322136.0
2006-02-10 11:00:00	MSFT	Stock	26.61	26.72	26.57	26.63	7808338.0
2006-02-10 12:00:00	MSFT	Stock	26.62	26.69	26.54	26.55	4519414.0
2006-02-10 13:00:00	MSFT	Stock	26.55	26.58	26.51	26.56	4090284.0
2006-02-10 14:00:00	MSFT	Stock	26.55	26.74	26.54	26.698	7677032.0
2006-02-10 15:00:00	MSFT	Stock	26.69	26.81	26.66	26.68	7916215.0
2006-02-10 16:00:00	MSFT	Stock	26.69	26.7	26.66	26.7	302093.0
2006-02-10 17:00:00	MSFT	Stock	26.69	26.71	26.689	26.71	14857.0
2006-02-10 18:00:00	MSFT	Stock	26.7	26.71	26.7	26.71	1100.0
2006-02-10 09:00:00	NVDA	Stock	0.3683	0.3709	0.3652	0.3671	34913280.0
2006-02-10 10:00:00	NVDA	Stock	0.3668	0.3669	0.3572	0.3579	94396080.0
2006-02-10 11:00:00	NVDA	Stock	0.3577	0.3619	0.3572	0.3611	73264560.0
2006-02-10 12:00:00	NVDA	Stock	0.361	0.3632	0.3595	0.3598	50251800.0
2006-02-10 13:00:00	NVDA	Stock	0.3599	0.3621	0.3583	0.3612	34278600.0
2006-02-10 14:00:00	NVDA	Stock	0.3612	0.3668	0.3602	0.3656	50986080.0
2006-02-10 15:00:00	NVDA	Stock	0.3656	0.3679	0.3648	0.3652	58201800.0
2006-02-10 16:00:00	NVDA	Stock	0.3658	0.3658	0.3608	0.3653	1625880.0
2006-02-10 17:00:00	NVDA	Stock	0.3648	0.3664	0.3648	0.3664	72840.0
2006-02-10 04:00:00	AMZN	Stock	1.887	1.887	1.887	1.887	6000.0
2006-02-10 09:00:00	AMZN	Stock	1.8985	1.91	1.8815	1.883	10014860.0
2006-02-10 10:00:00	AMZN	Stock	1.883	1.888	1.8685	1.873	21458920.0
2006-02-10 11:00:00	AMZN	Stock	1.872	1.8955	1.8685	1.8895	11729180.0
2006-02-10 12:00:00	AMZN	Stock	1.888	1.895	1.8865	1.891	8276420.0
2006-02-10 13:00:00	AMZN	Stock	1.891	1.895	1.887	1.891	7159480.0
2006-02-10 14:00:00	AMZN	Stock	1.8905	1.9205	1.8905	1.915	13088940.0
2006-02-10 15:00:00	AMZN	Stock	1.915	1.925	1.9125	1.925	20523760.0
2006-02-10 16:00:00	AMZN	Stock	1.924	1.9275	1.9205	1.9275	429040.0
2006-02-10 17:00:00	AMZN	Stock	1.926	1.926	1.9245	1.9245	19000.0
2006-02-10 18:00:00	AMZN	Stock	1.92	1.92	1.9195	1.9195	157120.0
2006-02-10 09:00:00	CL	Stock	26.925	27.14	26.92	27.005	294200.0
2006-02-10 10:00:00	CL	Stock	27.005	27.06	26.88	27.02	531400.0
2006-02-10 11:00:00	CL	Stock	27.01	27.025	26.95	27.025	341000.0
2006-02-10 12:00:00	CL	Stock	27.025	27.075	27.0	27.055	384000.0
2006-02-10 13:00:00	CL	Stock	27.05	27.08	26.985	27.075	258000.0
2006-02-10 14:00:00	CL	Stock	27.08	27.13	26.975	27.025	509600.0
2006-02-10 15:00:00	CL	Stock	27.02	27.095	27.01	27.025	487800.0

> showing 50 of 28,444 rows — these rows as CSV

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