PREVIEW / stock_1hour / 2007-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-24.parquet
  size:    788 KB
  rows:    39,002
  symbols: 3,124

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-09-24 05:00:00	AAPL	Stock	5.1493	5.1582	5.1493	5.1582	27776.0
2007-09-24 07:00:00	AAPL	Stock	5.1729	5.2196	5.1696	5.2125	5521124.0
2007-09-24 08:00:00	AAPL	Stock	5.2136	5.2575	5.2071	5.2479	16684220.0
2007-09-24 09:00:00	AAPL	Stock	5.2464	5.3304	5.235	5.2961	259144480.0
2007-09-24 10:00:00	AAPL	Stock	5.2964	5.3518	5.2821	5.343	211189300.0
2007-09-24 11:00:00	AAPL	Stock	5.3432	5.3443	5.3057	5.3129	105981400.0
2007-09-24 12:00:00	AAPL	Stock	5.3132	5.3268	5.3093	5.3121	55100780.0
2007-09-24 13:00:00	AAPL	Stock	5.3121	5.3161	5.2625	5.2722	121023756.0
2007-09-24 14:00:00	AAPL	Stock	5.2721	5.2911	5.2496	5.2814	118384336.0
2007-09-24 15:00:00	AAPL	Stock	5.2804	5.3068	5.2636	5.3014	126152152.0
2007-09-24 16:00:00	AAPL	Stock	5.3014	5.3198	5.2818	5.2932	28913780.0
2007-09-24 17:00:00	AAPL	Stock	5.2929	5.2961	5.2871	5.2929	1082928.0
2007-09-24 18:00:00	AAPL	Stock	5.2929	5.2929	5.2639	5.2646	2188480.0
2007-09-24 19:00:00	AAPL	Stock	5.2661	5.2725	5.2646	5.2696	777784.0
2007-09-24 06:00:00	MSFT	Stock	28.67	28.67	28.67	28.67	2000.0
2007-09-24 07:00:00	MSFT	Stock	28.7	28.87	28.7	28.87	46640.0
2007-09-24 08:00:00	MSFT	Stock	28.86	28.92	28.65	28.9	216645.0
2007-09-24 09:00:00	MSFT	Stock	28.9	29.13	28.8	29.01	12863161.0
2007-09-24 10:00:00	MSFT	Stock	29.02	29.5	29.0	29.45	21532495.0
2007-09-24 11:00:00	MSFT	Stock	29.45	29.61	29.421	29.6	13290046.0
2007-09-24 12:00:00	MSFT	Stock	29.6	29.6	29.45	29.53	8239466.0
2007-09-24 13:00:00	MSFT	Stock	29.53	29.53	29.3	29.34	8975395.0
2007-09-24 14:00:00	MSFT	Stock	29.34	29.47	29.32	29.38	11216613.0
2007-09-24 15:00:00	MSFT	Stock	29.38	29.4	29.05	29.08	20587242.0
2007-09-24 16:00:00	MSFT	Stock	29.084	29.52	29.01	29.08	8213054.0
2007-09-24 17:00:00	MSFT	Stock	29.08	29.207	29.07	29.15	68833.0
2007-09-24 18:00:00	MSFT	Stock	29.08	29.14	29.06	29.1	11655.0
2007-09-24 19:00:00	MSFT	Stock	29.1	29.24	29.1	29.23	23850.0
2007-09-24 08:00:00	NVDA	Stock	0.865	0.8705	0.8622	0.87	493160.0
2007-09-24 09:00:00	NVDA	Stock	0.87	0.875	0.8612	0.8695	44900240.0
2007-09-24 10:00:00	NVDA	Stock	0.8695	0.8943	0.8695	0.8898	109960640.0
2007-09-24 11:00:00	NVDA	Stock	0.8898	0.8935	0.888	0.8908	56267800.0
2007-09-24 12:00:00	NVDA	Stock	0.8908	0.8975	0.8902	0.8912	47463720.0
2007-09-24 13:00:00	NVDA	Stock	0.891	0.8915	0.8808	0.8838	51191840.0
2007-09-24 14:00:00	NVDA	Stock	0.8838	0.8895	0.878	0.882	56730280.0
2007-09-24 15:00:00	NVDA	Stock	0.882	0.885	0.8795	0.8845	78030120.0
2007-09-24 16:00:00	NVDA	Stock	0.8845	0.8868	0.883	0.885	10784000.0
2007-09-24 17:00:00	NVDA	Stock	0.885	0.885	0.8815	0.8838	499400.0
2007-09-24 18:00:00	NVDA	Stock	0.8838	0.885	0.8775	0.885	102120.0
2007-09-24 19:00:00	NVDA	Stock	0.88	0.8812	0.8782	0.8782	124800.0
2007-09-24 04:00:00	AMZN	Stock	4.5375	4.5375	4.525	4.525	6200.0
2007-09-24 06:00:00	AMZN	Stock	4.5495	4.55	4.5495	4.55	16100.0
2007-09-24 07:00:00	AMZN	Stock	4.55	4.56	4.55	4.56	44000.0
2007-09-24 08:00:00	AMZN	Stock	4.56	4.575	4.5575	4.565	359360.0
2007-09-24 09:00:00	AMZN	Stock	4.567	4.5795	4.5405	4.576	16292780.0
2007-09-24 10:00:00	AMZN	Stock	4.5755	4.6875	4.5682	4.662	28646360.0
2007-09-24 11:00:00	AMZN	Stock	4.6605	4.683	4.6538	4.6555	12043420.0
2007-09-24 12:00:00	AMZN	Stock	4.6554	4.665	4.643	4.6495	11907940.0
2007-09-24 13:00:00	AMZN	Stock	4.649	4.6525	4.6025	4.6103	10957040.0
2007-09-24 14:00:00	AMZN	Stock	4.6103	4.622	4.597	4.6035	7692740.0

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

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