PREVIEW / stock_1hour / 2009-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-29.parquet
  size:    836 KB
  rows:    40,853
  symbols: 3,324

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
2009-04-29 07:00:00	AAPL	Stock	4.4636	4.4732	4.4636	4.4732	61544.0
2009-04-29 08:00:00	AAPL	Stock	4.4732	4.4761	4.4571	4.4607	1691704.0
2009-04-29 09:00:00	AAPL	Stock	4.4593	4.47	4.4225	4.4632	53165056.0
2009-04-29 10:00:00	AAPL	Stock	4.4625	4.4679	4.4343	4.463	68806836.0
2009-04-29 11:00:00	AAPL	Stock	4.4625	4.4864	4.4436	4.4771	52702664.0
2009-04-29 12:00:00	AAPL	Stock	4.4771	4.4875	4.4664	4.4821	33885432.0
2009-04-29 13:00:00	AAPL	Stock	4.4818	4.4946	4.4768	4.4893	38518956.0
2009-04-29 14:00:00	AAPL	Stock	4.4882	4.5304	4.4695	4.5089	86396548.0
2009-04-29 15:00:00	AAPL	Stock	4.5089	4.5168	4.4543	4.4789	104838776.0
2009-04-29 16:00:00	AAPL	Stock	4.475	4.4821	4.4601	4.4768	12902344.0
2009-04-29 17:00:00	AAPL	Stock	4.475	4.4761	4.4643	4.4732	244860.0
2009-04-29 18:00:00	AAPL	Stock	4.4689	4.4757	4.4689	4.4757	303492.0
2009-04-29 19:00:00	AAPL	Stock	4.475	4.4768	4.4736	4.4736	113960.0
2009-04-29 06:00:00	MSFT	Stock	20.14	20.2	20.03	20.03	1300.0
2009-04-29 07:00:00	MSFT	Stock	20.23	20.23	20.11	20.15	6400.0
2009-04-29 08:00:00	MSFT	Stock	20.1	20.16	20.03	20.14	62781.0
2009-04-29 09:00:00	MSFT	Stock	20.14	20.71	20.05	20.71	10105768.0
2009-04-29 10:00:00	MSFT	Stock	20.7	20.89	20.55	20.83	12395558.0
2009-04-29 11:00:00	MSFT	Stock	20.83	20.87	20.61	20.62	5761973.0
2009-04-29 12:00:00	MSFT	Stock	20.61	20.64	20.27	20.29	8589786.0
2009-04-29 13:00:00	MSFT	Stock	20.29	20.39	20.17	20.17	11102409.0
2009-04-29 14:00:00	MSFT	Stock	20.16	20.41	20.09	20.27	11019049.0
2009-04-29 15:00:00	MSFT	Stock	20.27	20.3	20.1	20.25	13172813.0
2009-04-29 16:00:00	MSFT	Stock	20.23	20.64	20.101	20.21	2507861.0
2009-04-29 17:00:00	MSFT	Stock	20.2	20.22	20.18	20.18	30305.0
2009-04-29 18:00:00	MSFT	Stock	20.2	20.321	20.18	20.2	2450949.0
2009-04-29 19:00:00	MSFT	Stock	20.2	20.25	20.2	20.25	1990.0
2009-04-29 08:00:00	NVDA	Stock	0.2788	0.2795	0.2772	0.2772	274600.0
2009-04-29 09:00:00	NVDA	Stock	0.2772	0.2798	0.2688	0.2716	157937080.0
2009-04-29 10:00:00	NVDA	Stock	0.272	0.2752	0.271	0.273	197345120.0
2009-04-29 11:00:00	NVDA	Stock	0.273	0.2748	0.27	0.2735	110724520.0
2009-04-29 12:00:00	NVDA	Stock	0.2735	0.2745	0.2718	0.2725	43645440.0
2009-04-29 13:00:00	NVDA	Stock	0.2725	0.2772	0.272	0.2745	66931400.0
2009-04-29 14:00:00	NVDA	Stock	0.2745	0.2772	0.2728	0.2755	92660800.0
2009-04-29 15:00:00	NVDA	Stock	0.2752	0.2763	0.27	0.2723	175360800.0
2009-04-29 16:00:00	NVDA	Stock	0.2723	0.2732	0.2697	0.2718	9479920.0
2009-04-29 17:00:00	NVDA	Stock	0.2725	0.2725	0.2725	0.2725	8000.0
2009-04-29 18:00:00	NVDA	Stock	0.2732	0.2732	0.2712	0.2712	260000.0
2009-04-29 19:00:00	NVDA	Stock	0.2735	0.2738	0.2712	0.2738	172000.0
2009-04-29 05:00:00	AMZN	Stock	4.1495	4.1495	4.1495	4.1495	4000.0
2009-04-29 07:00:00	AMZN	Stock	4.1495	4.1495	4.1495	4.1495	4000.0
2009-04-29 08:00:00	AMZN	Stock	4.169	4.172	4.145	4.172	217300.0
2009-04-29 09:00:00	AMZN	Stock	4.175	4.175	4.0635	4.0705	24275960.0
2009-04-29 10:00:00	AMZN	Stock	4.0685	4.101	4.0575	4.0836	30897280.0
2009-04-29 11:00:00	AMZN	Stock	4.0845	4.113	4.069	4.071	17110080.0
2009-04-29 12:00:00	AMZN	Stock	4.0705	4.074	4.0415	4.054	17050860.0
2009-04-29 13:00:00	AMZN	Stock	4.0555	4.076	4.048	4.051	15601360.0
2009-04-29 14:00:00	AMZN	Stock	4.0495	4.098	4.0325	4.0495	34978660.0
2009-04-29 15:00:00	AMZN	Stock	4.0495	4.0495	3.963	3.993	48652960.0
2009-04-29 16:00:00	AMZN	Stock	3.9935	4.0547	3.9765	3.9935	3540580.0

> showing 50 of 40,853 rows — these rows as CSV

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