PREVIEW / stock_1hour / 2005-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-15.parquet
  size:    578 KB
  rows:    27,799
  symbols: 2,072

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
2005-09-15 08:00:00	AAPL	Stock	1.7789	1.7943	1.7779	1.7914	795816.0
2005-09-15 09:00:00	AAPL	Stock	1.7914	1.7921	1.7679	1.7729	71004836.0
2005-09-15 10:00:00	AAPL	Stock	1.7729	1.7804	1.7618	1.7789	95688908.0
2005-09-15 11:00:00	AAPL	Stock	1.7786	1.7893	1.7764	1.7786	38369632.0
2005-09-15 12:00:00	AAPL	Stock	1.7786	1.7793	1.77	1.7754	37535372.0
2005-09-15 13:00:00	AAPL	Stock	1.775	1.7846	1.7746	1.7775	37479512.0
2005-09-15 14:00:00	AAPL	Stock	1.7775	1.7807	1.7736	1.7789	49345996.0
2005-09-15 15:00:00	AAPL	Stock	1.7789	1.785	1.7768	1.7829	63145516.0
2005-09-15 16:00:00	AAPL	Stock	1.7811	1.7839	1.7732	1.7786	3210452.0
2005-09-15 17:00:00	AAPL	Stock	1.7786	1.7813	1.7767	1.7793	10712016.0
2005-09-15 18:00:00	AAPL	Stock	1.78	1.78	1.78	1.78	21000.0
2005-09-15 07:00:00	MSFT	Stock	26.25	26.25	26.25	26.25	1000.0
2005-09-15 08:00:00	MSFT	Stock	26.31	26.4	26.3	26.37	291339.0
2005-09-15 09:00:00	MSFT	Stock	26.38	26.43	26.3	26.322	6146646.0
2005-09-15 10:00:00	MSFT	Stock	26.33	26.35	26.22	26.31	9033409.0
2005-09-15 11:00:00	MSFT	Stock	26.31	26.37	26.24	26.35	8970377.0
2005-09-15 12:00:00	MSFT	Stock	26.35	26.38	26.28	26.33	4943586.0
2005-09-15 13:00:00	MSFT	Stock	26.33	26.43	26.31	26.34	5889341.0
2005-09-15 14:00:00	MSFT	Stock	26.34	26.35	26.27	26.28	7401706.0
2005-09-15 15:00:00	MSFT	Stock	26.28	26.31	26.23	26.27	11295570.0
2005-09-15 16:00:00	MSFT	Stock	26.27	26.32	26.25	26.28	2229150.0
2005-09-15 17:00:00	MSFT	Stock	26.31	26.31	26.27	26.29	14755.0
2005-09-15 18:00:00	MSFT	Stock	26.31	26.32	26.31	26.32	5325.0
2005-09-15 08:00:00	NVDA	Stock	0.2729	0.2764	0.2729	0.2764	853680.0
2005-09-15 09:00:00	NVDA	Stock	0.2767	0.2791	0.2747	0.2757	122550120.0
2005-09-15 10:00:00	NVDA	Stock	0.2757	0.2789	0.2746	0.2785	146235360.0
2005-09-15 11:00:00	NVDA	Stock	0.2785	0.2787	0.2762	0.2768	98030280.0
2005-09-15 12:00:00	NVDA	Stock	0.2768	0.2773	0.276	0.2768	44103000.0
2005-09-15 13:00:00	NVDA	Stock	0.2767	0.2783	0.2767	0.2782	58550160.0
2005-09-15 14:00:00	NVDA	Stock	0.2782	0.28	0.2777	0.2787	106223880.0
2005-09-15 15:00:00	NVDA	Stock	0.2787	0.2787	0.2766	0.2769	149197920.0
2005-09-15 16:00:00	NVDA	Stock	0.2769	0.2775	0.2769	0.2769	24174000.0
2005-09-15 17:00:00	NVDA	Stock	0.2769	0.2775	0.2769	0.2775	98160.0
2005-09-15 09:00:00	AMZN	Stock	2.1555	2.17	2.151	2.164	7436660.0
2005-09-15 10:00:00	AMZN	Stock	2.1645	2.166	2.1405	2.155	14658440.0
2005-09-15 11:00:00	AMZN	Stock	2.154	2.1795	2.15	2.17	14886400.0
2005-09-15 12:00:00	AMZN	Stock	2.17	2.1725	2.156	2.157	11854480.0
2005-09-15 13:00:00	AMZN	Stock	2.1565	2.175	2.151	2.151	11396160.0
2005-09-15 14:00:00	AMZN	Stock	2.151	2.16	2.1325	2.136	12320620.0
2005-09-15 15:00:00	AMZN	Stock	2.1365	2.147	2.134	2.136	16995500.0
2005-09-15 16:00:00	AMZN	Stock	2.1375	2.1396	2.132	2.135	850580.0
2005-09-15 17:00:00	AMZN	Stock	2.1345	2.1391	2.1345	2.1391	10000.0
2005-09-15 18:00:00	AMZN	Stock	2.1425	2.1425	2.1425	2.1425	6000.0
2005-09-15 09:00:00	CL	Stock	26.325	26.335	26.24	26.28	247800.0
2005-09-15 10:00:00	CL	Stock	26.275	26.305	26.195	26.29	276400.0
2005-09-15 11:00:00	CL	Stock	26.275	26.425	26.255	26.32	380800.0
2005-09-15 12:00:00	CL	Stock	26.32	26.34	26.255	26.335	291200.0
2005-09-15 13:00:00	CL	Stock	26.33	26.49	26.3205	26.425	355800.0
2005-09-15 14:00:00	CL	Stock	26.435	26.5	26.4	26.48	294000.0
2005-09-15 15:00:00	CL	Stock	26.48	26.565	26.445	26.48	870400.0

> showing 50 of 27,799 rows — these rows as CSV

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