PREVIEW / stock_1hour / 2006-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-25.parquet
  size:    597 KB
  rows:    28,229
  symbols: 2,249

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-04-25 08:00:00	AAPL	Stock	2.35	2.36	2.35	2.3554	431480.0
2006-04-25 09:00:00	AAPL	Stock	2.3568	2.3782	2.3529	2.3746	80672760.0
2006-04-25 10:00:00	AAPL	Stock	2.3746	2.3768	2.3507	2.3643	112557648.0
2006-04-25 11:00:00	AAPL	Stock	2.3646	2.3704	2.3539	2.3589	63293356.0
2006-04-25 12:00:00	AAPL	Stock	2.3582	2.36	2.3443	2.3464	60625096.0
2006-04-25 13:00:00	AAPL	Stock	2.3464	2.3607	2.3414	2.3604	63206640.0
2006-04-25 14:00:00	AAPL	Stock	2.3605	2.3686	2.3579	2.3607	61296256.0
2006-04-25 15:00:00	AAPL	Stock	2.3604	2.3682	2.3571	2.3614	76144320.0
2006-04-25 16:00:00	AAPL	Stock	2.3632	2.3643	2.3614	2.3618	705068.0
2006-04-25 17:00:00	AAPL	Stock	2.3632	2.3657	2.3607	2.3632	588028.0
2006-04-25 18:00:00	AAPL	Stock	2.3614	2.3632	2.3614	2.3614	107856.0
2006-04-25 07:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	100.0
2006-04-25 08:00:00	MSFT	Stock	27.12	27.12	27.1	27.11	3400.0
2006-04-25 09:00:00	MSFT	Stock	27.11	27.18	27.05	27.16	3223251.0
2006-04-25 10:00:00	MSFT	Stock	27.16	27.2	27.02	27.15	8347478.0
2006-04-25 11:00:00	MSFT	Stock	27.15	27.21	27.06	27.083	7016139.0
2006-04-25 12:00:00	MSFT	Stock	27.08	27.13	27.06	27.07	2998616.0
2006-04-25 13:00:00	MSFT	Stock	27.07	27.13	27.04	27.1	6051624.0
2006-04-25 14:00:00	MSFT	Stock	27.09	27.11	27.04	27.05	8572711.0
2006-04-25 15:00:00	MSFT	Stock	27.05	27.18	27.02	27.12	11624445.0
2006-04-25 16:00:00	MSFT	Stock	27.13	27.18	27.11	27.16	45889.0
2006-04-25 17:00:00	MSFT	Stock	27.16	27.16	27.11	27.11	53783.0
2006-04-25 18:00:00	MSFT	Stock	27.16	27.16	27.16	27.16	600.0
2006-04-25 08:00:00	NVDA	Stock	0.4758	0.4792	0.4758	0.4777	248760.0
2006-04-25 09:00:00	NVDA	Stock	0.478	0.4818	0.4708	0.4817	79126440.0
2006-04-25 10:00:00	NVDA	Stock	0.4815	0.4822	0.4725	0.4768	110817300.0
2006-04-25 11:00:00	NVDA	Stock	0.477	0.479	0.4683	0.4758	134977080.0
2006-04-25 12:00:00	NVDA	Stock	0.476	0.4775	0.474	0.4772	87265200.0
2006-04-25 13:00:00	NVDA	Stock	0.4772	0.48	0.4748	0.4782	86558580.0
2006-04-25 14:00:00	NVDA	Stock	0.4782	0.483	0.4767	0.4793	91654740.0
2006-04-25 15:00:00	NVDA	Stock	0.4795	0.4825	0.4783	0.4815	103574820.0
2006-04-25 16:00:00	NVDA	Stock	0.4818	0.483	0.4813	0.483	2231220.0
2006-04-25 17:00:00	NVDA	Stock	0.483	0.4833	0.483	0.4833	63000.0
2006-04-25 18:00:00	NVDA	Stock	0.4837	0.4837	0.4822	0.4837	220380.0
2006-04-25 08:00:00	AMZN	Stock	1.7925	1.7925	1.785	1.785	36000.0
2006-04-25 09:00:00	AMZN	Stock	1.7845	1.788	1.77	1.7825	9545560.0
2006-04-25 10:00:00	AMZN	Stock	1.783	1.7845	1.771	1.7715	17421160.0
2006-04-25 11:00:00	AMZN	Stock	1.771	1.7775	1.7536	1.754	13736400.0
2006-04-25 12:00:00	AMZN	Stock	1.7535	1.7615	1.7535	1.7575	9289920.0
2006-04-25 13:00:00	AMZN	Stock	1.7575	1.7585	1.7505	1.755	17704800.0
2006-04-25 14:00:00	AMZN	Stock	1.755	1.7725	1.7525	1.7675	24932980.0
2006-04-25 15:00:00	AMZN	Stock	1.7675	1.7885	1.765	1.779	53305200.0
2006-04-25 16:00:00	AMZN	Stock	1.779	1.9125	1.756	1.7975	86330100.0
2006-04-25 17:00:00	AMZN	Stock	1.7995	1.814	1.78	1.8025	17105140.0
2006-04-25 18:00:00	AMZN	Stock	1.8	1.803	1.7875	1.7875	2106180.0
2006-04-25 08:00:00	CL	Stock	28.67	28.67	28.67	28.67	139600.0
2006-04-25 09:00:00	CL	Stock	28.8	28.83	28.705	28.705	504600.0
2006-04-25 10:00:00	CL	Stock	28.72	28.85	28.625	28.815	600200.0
2006-04-25 11:00:00	CL	Stock	28.815	28.865	28.745	28.835	431600.0
2006-04-25 12:00:00	CL	Stock	28.84	28.905	28.825	28.89	337000.0

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

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