PREVIEW / stock_1hour / 2007-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-09.parquet
  size:    675 KB
  rows:    31,790
  symbols: 2,582

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
2007-04-09 07:00:00	AAPL	Stock	3.3836	3.3925	3.3836	3.3925	16800.0
2007-04-09 08:00:00	AAPL	Stock	3.3836	3.41	3.3829	3.4071	3211320.0
2007-04-09 09:00:00	AAPL	Stock	3.4071	3.4089	3.3661	3.3721	83481244.0
2007-04-09 10:00:00	AAPL	Stock	3.3721	3.3754	3.3457	3.3614	94656520.0
2007-04-09 11:00:00	AAPL	Stock	3.3618	3.3727	3.3618	3.3664	44694244.0
2007-04-09 12:00:00	AAPL	Stock	3.3664	3.375	3.3643	3.3711	27639612.0
2007-04-09 13:00:00	AAPL	Stock	3.3707	3.3746	3.3557	3.3561	34299020.0
2007-04-09 14:00:00	AAPL	Stock	3.3561	3.3625	3.35	3.3596	49918848.0
2007-04-09 15:00:00	AAPL	Stock	3.3593	3.3654	3.3229	3.3429	66747100.0
2007-04-09 16:00:00	AAPL	Stock	3.3432	3.3454	3.3414	3.3443	3872344.0
2007-04-09 17:00:00	AAPL	Stock	3.3436	3.3446	3.3429	3.3446	157388.0
2007-04-09 18:00:00	AAPL	Stock	3.3454	3.3496	3.345	3.3496	67340.0
2007-04-09 19:00:00	AAPL	Stock	3.3479	3.3489	3.3446	3.3446	212044.0
2007-04-09 07:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	308.0
2007-04-09 08:00:00	MSFT	Stock	28.62	28.62	28.62	28.62	310.0
2007-04-09 09:00:00	MSFT	Stock	28.64	28.67	28.39	28.482	3604536.0
2007-04-09 10:00:00	MSFT	Stock	28.48	28.58	28.39	28.58	4263981.0
2007-04-09 11:00:00	MSFT	Stock	28.57	28.63	28.49	28.5	4212421.0
2007-04-09 12:00:00	MSFT	Stock	28.5	28.67	28.5	28.63	3682991.0
2007-04-09 13:00:00	MSFT	Stock	28.62	28.65	28.5	28.52	2991109.0
2007-04-09 14:00:00	MSFT	Stock	28.52	28.6	28.47	28.6	3119952.0
2007-04-09 15:00:00	MSFT	Stock	28.59	28.72	28.56	28.57	8959123.0
2007-04-09 16:00:00	MSFT	Stock	28.57	28.573	28.52	28.55	193290.0
2007-04-09 18:00:00	MSFT	Stock	28.52	28.72	28.52	28.72	700.0
2007-04-09 19:00:00	MSFT	Stock	28.61	28.62	28.6	28.62	3755.0
2007-04-09 08:00:00	NVDA	Stock	0.5163	0.5205	0.5163	0.5192	694680.0
2007-04-09 09:00:00	NVDA	Stock	0.5185	0.5208	0.5113	0.5155	140150400.0
2007-04-09 10:00:00	NVDA	Stock	0.5157	0.516	0.5058	0.5088	124120440.0
2007-04-09 11:00:00	NVDA	Stock	0.5088	0.5103	0.5062	0.5063	60013620.0
2007-04-09 12:00:00	NVDA	Stock	0.5065	0.5108	0.5052	0.51	53548200.0
2007-04-09 13:00:00	NVDA	Stock	0.51	0.51	0.506	0.5068	48805020.0
2007-04-09 14:00:00	NVDA	Stock	0.5068	0.507	0.5047	0.5063	64751160.0
2007-04-09 15:00:00	NVDA	Stock	0.5063	0.5077	0.5052	0.5052	109098480.0
2007-04-09 16:00:00	NVDA	Stock	0.5057	0.5065	0.5053	0.5053	489900.0
2007-04-09 17:00:00	NVDA	Stock	0.5062	0.5062	0.5052	0.5052	475020.0
2007-04-09 18:00:00	NVDA	Stock	0.5053	0.5053	0.5052	0.5052	36000.0
2007-04-09 19:00:00	NVDA	Stock	0.5053	0.506	0.5053	0.506	90000.0
2007-04-09 08:00:00	AMZN	Stock	2.085	2.085	2.085	2.085	40000.0
2007-04-09 09:00:00	AMZN	Stock	2.086	2.091	2.084	2.085	5351440.0
2007-04-09 10:00:00	AMZN	Stock	2.0855	2.0935	2.0805	2.092	11516020.0
2007-04-09 11:00:00	AMZN	Stock	2.092	2.107	2.091	2.105	11925700.0
2007-04-09 12:00:00	AMZN	Stock	2.1045	2.1045	2.0965	2.0975	7292440.0
2007-04-09 13:00:00	AMZN	Stock	2.097	2.1035	2.0945	2.0955	7563740.0
2007-04-09 14:00:00	AMZN	Stock	2.0955	2.096	2.083	2.0895	9730900.0
2007-04-09 15:00:00	AMZN	Stock	2.089	2.094	2.082	2.083	27941860.0
2007-04-09 16:00:00	AMZN	Stock	2.083	2.083	2.08	2.0825	757260.0
2007-04-09 17:00:00	AMZN	Stock	2.0825	2.0835	2.0825	2.0835	4400.0
2007-04-09 09:00:00	CL	Stock	33.325	33.35	33.24	33.275	174400.0
2007-04-09 10:00:00	CL	Stock	33.285	33.295	33.225	33.225	155800.0
2007-04-09 11:00:00	CL	Stock	33.24	33.25	33.205	33.225	217800.0

> showing 50 of 31,790 rows — these rows as CSV

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