PREVIEW / stock_1hour / 2005-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-27.parquet
  size:    574 KB
  rows:    27,483
  symbols: 2,106

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-10-27 08:00:00	AAPL	Stock	2.0339	2.0357	2.0214	2.0293	404320.0
2005-10-27 09:00:00	AAPL	Stock	2.0293	2.0361	2.0075	2.0139	61241936.0
2005-10-27 10:00:00	AAPL	Stock	2.0139	2.0214	1.9921	2.0054	84672980.0
2005-10-27 11:00:00	AAPL	Stock	2.0046	2.0139	1.9986	2.0021	52228232.0
2005-10-27 12:00:00	AAPL	Stock	2.0014	2.0114	2.0011	2.0075	27040132.0
2005-10-27 13:00:00	AAPL	Stock	2.0075	2.0107	1.9961	2.0089	39410308.0
2005-10-27 14:00:00	AAPL	Stock	2.0086	2.0089	1.9943	1.9968	39055352.0
2005-10-27 15:00:00	AAPL	Stock	1.9968	1.9996	1.9789	1.9789	102276412.0
2005-10-27 16:00:00	AAPL	Stock	1.9789	2.0143	1.9714	1.9757	2105964.0
2005-10-27 17:00:00	AAPL	Stock	1.9786	2.004	1.975	1.9789	401744.0
2005-10-27 18:00:00	AAPL	Stock	1.9793	1.9793	1.9757	1.9793	85400.0
2005-10-27 07:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	300.0
2005-10-27 08:00:00	MSFT	Stock	25.1	25.2	25.1	25.17	20946.0
2005-10-27 09:00:00	MSFT	Stock	25.17	25.27	25.1	25.2	4590373.0
2005-10-27 10:00:00	MSFT	Stock	25.2	25.25	25.13	25.18	7796945.0
2005-10-27 11:00:00	MSFT	Stock	25.18	25.24	25.11	25.19	6518890.0
2005-10-27 12:00:00	MSFT	Stock	25.2	25.25	25.17	25.171	3924514.0
2005-10-27 13:00:00	MSFT	Stock	25.17	25.18	25.02	25.1	6873950.0
2005-10-27 14:00:00	MSFT	Stock	25.1	25.11	24.92	24.94	6419156.0
2005-10-27 15:00:00	MSFT	Stock	24.93	25.25	24.88	24.88	15955193.0
2005-10-27 16:00:00	MSFT	Stock	24.85	25.24	24.01	24.42	7165580.0
2005-10-27 17:00:00	MSFT	Stock	24.43	25.078	24.3	24.51	1038191.0
2005-10-27 18:00:00	MSFT	Stock	24.51	24.6	24.4	24.45	279199.0
2005-10-27 08:00:00	NVDA	Stock	0.2667	0.2667	0.2667	0.2667	120000.0
2005-10-27 09:00:00	NVDA	Stock	0.2678	0.2689	0.266	0.2687	29276400.0
2005-10-27 10:00:00	NVDA	Stock	0.2688	0.269	0.2642	0.2654	44178600.0
2005-10-27 11:00:00	NVDA	Stock	0.2654	0.2665	0.2638	0.2647	23860080.0
2005-10-27 12:00:00	NVDA	Stock	0.2648	0.2654	0.2641	0.2649	15632400.0
2005-10-27 13:00:00	NVDA	Stock	0.2649	0.2653	0.2634	0.2642	18546360.0
2005-10-27 14:00:00	NVDA	Stock	0.2642	0.2648	0.2626	0.2629	14551800.0
2005-10-27 15:00:00	NVDA	Stock	0.263	0.2631	0.2612	0.2621	65870160.0
2005-10-27 16:00:00	NVDA	Stock	0.2621	0.2623	0.2617	0.2617	2639040.0
2005-10-27 17:00:00	NVDA	Stock	0.2647	0.2647	0.2621	0.2621	181440.0
2005-10-27 18:00:00	NVDA	Stock	0.2609	0.2609	0.2596	0.2596	240000.0
2005-10-27 08:00:00	AMZN	Stock	1.992	1.992	1.9675	1.98	340500.0
2005-10-27 09:00:00	AMZN	Stock	1.9795	1.995	1.9605	1.965	28738940.0
2005-10-27 10:00:00	AMZN	Stock	1.965	1.971	1.943	1.9615	40215440.0
2005-10-27 11:00:00	AMZN	Stock	1.9615	1.9755	1.9595	1.969	21732660.0
2005-10-27 12:00:00	AMZN	Stock	1.9685	1.9715	1.959	1.9625	14457860.0
2005-10-27 13:00:00	AMZN	Stock	1.963	1.9655	1.956	1.9635	18604440.0
2005-10-27 14:00:00	AMZN	Stock	1.9635	1.9645	1.9455	1.953	16523240.0
2005-10-27 15:00:00	AMZN	Stock	1.953	1.966	1.949	1.9545	32332400.0
2005-10-27 16:00:00	AMZN	Stock	1.9555	1.9555	1.951	1.951	162460.0
2005-10-27 17:00:00	AMZN	Stock	1.955	1.9633	1.9535	1.9535	56840.0
2005-10-27 18:00:00	AMZN	Stock	1.971	1.971	1.955	1.955	25500.0
2005-10-27 09:00:00	CL	Stock	26.05	26.14	25.95	26.105	227200.0
2005-10-27 10:00:00	CL	Stock	26.085	26.095	25.975	26.005	451800.0
2005-10-27 11:00:00	CL	Stock	26.005	26.115	25.975	26.08	258400.0
2005-10-27 12:00:00	CL	Stock	26.08	26.105	25.965	26.015	249600.0
2005-10-27 13:00:00	CL	Stock	26.015	26.045	25.9255	25.995	229600.0

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

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