PREVIEW / stock_1hour / 2008-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-23.parquet
  size:    823 KB
  rows:    39,959
  symbols: 3,297

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
2008-04-23 06:00:00	AAPL	Stock	5.79	5.79	5.7836	5.7836	49560.0
2008-04-23 07:00:00	AAPL	Stock	5.7739	5.8014	5.7643	5.7821	707504.0
2008-04-23 08:00:00	AAPL	Stock	5.7821	5.85	5.7768	5.8471	10096128.0
2008-04-23 09:00:00	AAPL	Stock	5.8482	5.8632	5.8054	5.8454	173381880.0
2008-04-23 10:00:00	AAPL	Stock	5.8454	5.8871	5.8361	5.8532	207175052.0
2008-04-23 11:00:00	AAPL	Stock	5.8529	5.8821	5.8507	5.8539	105851900.0
2008-04-23 12:00:00	AAPL	Stock	5.8536	5.8704	5.7529	5.7929	166727428.0
2008-04-23 13:00:00	AAPL	Stock	5.7925	5.8214	5.7682	5.8132	109382280.0
2008-04-23 14:00:00	AAPL	Stock	5.8132	5.8371	5.8	5.8046	128234036.0
2008-04-23 15:00:00	AAPL	Stock	5.805	5.8329	5.7825	5.81	202013532.0
2008-04-23 16:00:00	AAPL	Stock	5.8107	6.125	5.5314	5.6429	240591064.0
2008-04-23 17:00:00	AAPL	Stock	5.6375	6.0407	5.5475	5.8407	115059140.0
2008-04-23 18:00:00	AAPL	Stock	5.8407	5.8411	5.75	5.8111	18623752.0
2008-04-23 19:00:00	AAPL	Stock	5.8107	5.8179	5.7918	5.7968	3517808.0
2008-04-23 05:00:00	MSFT	Stock	30.48	30.48	30.48	30.48	300.0
2008-04-23 07:00:00	MSFT	Stock	30.25	30.32	30.25	30.32	9300.0
2008-04-23 08:00:00	MSFT	Stock	30.4	30.52	30.36	30.5	50804.0
2008-04-23 09:00:00	MSFT	Stock	30.49	30.73	30.3	30.68	6788666.0
2008-04-23 10:00:00	MSFT	Stock	30.678	31.25	30.6	31.13	18414269.0
2008-04-23 11:00:00	MSFT	Stock	31.14	31.25	30.935	31.22	13399940.0
2008-04-23 12:00:00	MSFT	Stock	31.22	31.25	31.06	31.11	11967963.0
2008-04-23 13:00:00	MSFT	Stock	31.11	31.45	31.11	31.37	9992286.0
2008-04-23 14:00:00	MSFT	Stock	31.37	31.41	31.2	31.248	7497678.0
2008-04-23 15:00:00	MSFT	Stock	31.24	31.46	31.22	31.46	18895258.0
2008-04-23 16:00:00	MSFT	Stock	31.45	31.58	30.414	31.15	5219040.0
2008-04-23 17:00:00	MSFT	Stock	31.2	31.5	31.123	31.48	436289.0
2008-04-23 18:00:00	MSFT	Stock	31.48	31.5	31.42	31.47	92832.0
2008-04-23 19:00:00	MSFT	Stock	31.48	31.64	31.48	31.62	54074.0
2008-04-23 07:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	16000.0
2008-04-23 08:00:00	NVDA	Stock	0.49	0.4942	0.49	0.4942	268000.0
2008-04-23 09:00:00	NVDA	Stock	0.4928	0.502	0.4878	0.498	81824800.0
2008-04-23 10:00:00	NVDA	Stock	0.4982	0.5165	0.496	0.512	144214000.0
2008-04-23 11:00:00	NVDA	Stock	0.5118	0.5135	0.5075	0.5093	119553400.0
2008-04-23 12:00:00	NVDA	Stock	0.5093	0.5095	0.5028	0.5073	124870000.0
2008-04-23 13:00:00	NVDA	Stock	0.5072	0.515	0.5053	0.513	145804440.0
2008-04-23 14:00:00	NVDA	Stock	0.513	0.515	0.51	0.5105	131370560.0
2008-04-23 15:00:00	NVDA	Stock	0.5105	0.5142	0.51	0.511	200979320.0
2008-04-23 16:00:00	NVDA	Stock	0.511	0.513	0.4912	0.5035	13726880.0
2008-04-23 17:00:00	NVDA	Stock	0.5055	0.5086	0.5025	0.5055	53898960.0
2008-04-23 18:00:00	NVDA	Stock	0.507	0.5098	0.5032	0.5032	204000.0
2008-04-23 19:00:00	NVDA	Stock	0.5093	0.5093	0.5093	0.5093	4000.0
2008-04-23 08:00:00	AMZN	Stock	4.01	4.01	3.995	4.0	66600.0
2008-04-23 09:00:00	AMZN	Stock	4.0	4.0155	3.937	3.956	22579940.0
2008-04-23 10:00:00	AMZN	Stock	3.956	4.045	3.946	4.0252	40581940.0
2008-04-23 11:00:00	AMZN	Stock	4.0265	4.058	4.0155	4.0185	27754940.0
2008-04-23 12:00:00	AMZN	Stock	4.018	4.035	3.983	4.0035	23463060.0
2008-04-23 13:00:00	AMZN	Stock	4.0045	4.0195	3.994	4.005	20567020.0
2008-04-23 14:00:00	AMZN	Stock	4.007	4.0455	3.997	4.0448	33872480.0
2008-04-23 15:00:00	AMZN	Stock	4.0435	4.132	4.0425	4.0495	86001280.0
2008-04-23 16:00:00	AMZN	Stock	4.0508	4.1215	3.6605	3.845	117395060.0

> showing 50 of 39,959 rows — these rows as CSV

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