PREVIEW / stock_1hour / 2005-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-25.parquet
  size:    574 KB
  rows:    27,439
  symbols: 2,042

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-07-25 08:00:00	AAPL	Stock	1.5718	1.5811	1.5714	1.5714	578340.0
2005-07-25 09:00:00	AAPL	Stock	1.5714	1.5814	1.5646	1.5661	68146148.0
2005-07-25 10:00:00	AAPL	Stock	1.5657	1.5796	1.5646	1.5686	61986820.0
2005-07-25 11:00:00	AAPL	Stock	1.5682	1.5704	1.5621	1.5657	39349884.0
2005-07-25 12:00:00	AAPL	Stock	1.5654	1.5693	1.5621	1.5689	39134312.0
2005-07-25 13:00:00	AAPL	Stock	1.5693	1.5714	1.5664	1.5675	16657788.0
2005-07-25 14:00:00	AAPL	Stock	1.5675	1.57	1.5618	1.5636	26935244.0
2005-07-25 15:00:00	AAPL	Stock	1.5636	1.5671	1.5618	1.565	36866676.0
2005-07-25 16:00:00	AAPL	Stock	1.5654	1.5696	1.5607	1.5696	1321180.0
2005-07-25 17:00:00	AAPL	Stock	1.57	1.575	1.5645	1.5686	815892.0
2005-07-25 18:00:00	AAPL	Stock	1.5729	1.5729	1.5696	1.5696	91700.0
2005-07-25 07:00:00	MSFT	Stock	25.75	25.75	25.75	25.75	250.0
2005-07-25 08:00:00	MSFT	Stock	25.7	25.72	25.68	25.7	18872.0
2005-07-25 09:00:00	MSFT	Stock	25.7	25.86	25.68	25.81	9196412.0
2005-07-25 10:00:00	MSFT	Stock	25.81	25.9	25.74	25.81	7562616.0
2005-07-25 11:00:00	MSFT	Stock	25.8	25.89	25.78	25.79	5834853.0
2005-07-25 12:00:00	MSFT	Stock	25.79	25.825	25.71	25.72	3909933.0
2005-07-25 13:00:00	MSFT	Stock	25.72	25.8	25.67	25.72	5425016.0
2005-07-25 14:00:00	MSFT	Stock	25.72	25.76	25.65	25.68	4855069.0
2005-07-25 15:00:00	MSFT	Stock	25.68	25.71	25.65	25.67	6825394.0
2005-07-25 16:00:00	MSFT	Stock	25.67	25.77	25.66	25.69	276542.0
2005-07-25 17:00:00	MSFT	Stock	25.69	25.7	25.67	25.67	38512.0
2005-07-25 18:00:00	MSFT	Stock	25.67	25.7	25.67	25.7	13325.0
2005-07-25 09:00:00	NVDA	Stock	0.2128	0.2232	0.2118	0.2212	324289680.0
2005-07-25 10:00:00	NVDA	Stock	0.2212	0.2216	0.2195	0.2208	163410600.0
2005-07-25 11:00:00	NVDA	Stock	0.2208	0.2208	0.2177	0.2178	85133520.0
2005-07-25 12:00:00	NVDA	Stock	0.2178	0.2183	0.2169	0.217	56929920.0
2005-07-25 13:00:00	NVDA	Stock	0.217	0.2173	0.2158	0.2167	63550200.0
2005-07-25 14:00:00	NVDA	Stock	0.2166	0.2172	0.2158	0.2162	73582200.0
2005-07-25 15:00:00	NVDA	Stock	0.2163	0.2167	0.215	0.2164	157426080.0
2005-07-25 16:00:00	NVDA	Stock	0.2166	0.2173	0.2159	0.2173	16183920.0
2005-07-25 17:00:00	NVDA	Stock	0.2162	0.2202	0.2162	0.2183	4537200.0
2005-07-25 18:00:00	NVDA	Stock	0.2168	0.2192	0.2158	0.2158	3159000.0
2005-07-25 09:00:00	AMZN	Stock	1.8925	1.93	1.8915	1.919	16296920.0
2005-07-25 10:00:00	AMZN	Stock	1.919	1.952	1.91	1.9365	24822840.0
2005-07-25 11:00:00	AMZN	Stock	1.937	1.938	1.9225	1.9285	14224560.0
2005-07-25 12:00:00	AMZN	Stock	1.9285	1.931	1.9125	1.9135	10355000.0
2005-07-25 13:00:00	AMZN	Stock	1.913	1.915	1.908	1.915	7792820.0
2005-07-25 14:00:00	AMZN	Stock	1.9145	1.918	1.9075	1.9085	7721800.0
2005-07-25 15:00:00	AMZN	Stock	1.908	1.909	1.8945	1.8975	26460840.0
2005-07-25 16:00:00	AMZN	Stock	1.893	1.9144	1.893	1.9065	916740.0
2005-07-25 18:00:00	AMZN	Stock	1.917	1.917	1.905	1.905	15000.0
2005-07-25 09:00:00	CL	Stock	25.995	25.995	25.88	25.88	250000.0
2005-07-25 10:00:00	CL	Stock	25.88	25.935	25.83	25.9	415200.0
2005-07-25 11:00:00	CL	Stock	25.9	25.92	25.855	25.92	427200.0
2005-07-25 12:00:00	CL	Stock	25.92	25.94	25.885	25.895	225800.0
2005-07-25 13:00:00	CL	Stock	25.9	25.91	25.885	25.89	195400.0
2005-07-25 14:00:00	CL	Stock	25.885	25.96	25.88	25.9	609200.0
2005-07-25 15:00:00	CL	Stock	25.905	25.97	25.895	25.915	559800.0
2005-07-25 17:00:00	CL	Stock	25.91	25.93	25.91	25.93	1000.0

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

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