PREVIEW / stock_1hour / 2004-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-22.parquet
  size:    522 KB
  rows:    24,842
  symbols: 1,793

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
2004-06-22 08:00:00	AAPL	Stock	0.5777	0.5786	0.5773	0.5775	241584.0
2004-06-22 09:00:00	AAPL	Stock	0.5777	0.587	0.5766	0.583	40138952.0
2004-06-22 10:00:00	AAPL	Stock	0.583	0.5909	0.583	0.5839	106494976.0
2004-06-22 11:00:00	AAPL	Stock	0.5839	0.5848	0.5802	0.5832	41623456.0
2004-06-22 12:00:00	AAPL	Stock	0.5832	0.5848	0.5827	0.5839	22183952.0
2004-06-22 13:00:00	AAPL	Stock	0.5839	0.5848	0.5809	0.583	19924296.0
2004-06-22 14:00:00	AAPL	Stock	0.583	0.5889	0.5829	0.5889	44964864.0
2004-06-22 15:00:00	AAPL	Stock	0.5888	0.5893	0.5857	0.5893	55023024.0
2004-06-22 16:00:00	AAPL	Stock	0.5893	0.5896	0.5886	0.5893	13700176.0
2004-06-22 17:00:00	AAPL	Stock	0.5893	0.5893	0.5893	0.5893	403200.0
2004-06-22 18:00:00	AAPL	Stock	0.5891	0.5891	0.5891	0.5891	4319280.0
2004-06-22 08:00:00	MSFT	Stock	28.35	28.39	28.24	28.26	22310.0
2004-06-22 09:00:00	MSFT	Stock	28.25	28.29	28.12	28.17	13778290.0
2004-06-22 10:00:00	MSFT	Stock	28.17	28.2193	27.81	27.89	22310106.0
2004-06-22 11:00:00	MSFT	Stock	27.89	28.09	27.85	27.99	10474070.0
2004-06-22 12:00:00	MSFT	Stock	27.99	28.11	27.97	28.02	7726425.0
2004-06-22 13:00:00	MSFT	Stock	28.02	28.16	27.99	28.09	5940487.0
2004-06-22 14:00:00	MSFT	Stock	28.1	28.35	28.07	28.26	12937822.0
2004-06-22 15:00:00	MSFT	Stock	28.26	28.3	28.11	28.29	14303606.0
2004-06-22 16:00:00	MSFT	Stock	28.28	28.34	28.11	28.27	7469612.0
2004-06-22 17:00:00	MSFT	Stock	28.26	28.3	28.25	28.3	220150.0
2004-06-22 18:00:00	MSFT	Stock	28.2415	28.3	28.2415	28.3	544854.0
2004-06-22 09:00:00	NVDA	Stock	0.1622	0.1653	0.1621	0.1637	52226880.0
2004-06-22 10:00:00	NVDA	Stock	0.1637	0.1654	0.1621	0.1628	66090960.0
2004-06-22 11:00:00	NVDA	Stock	0.1629	0.1631	0.1616	0.1631	51144480.0
2004-06-22 12:00:00	NVDA	Stock	0.1631	0.1653	0.1631	0.1642	47726400.0
2004-06-22 13:00:00	NVDA	Stock	0.1642	0.1652	0.1635	0.1652	36882480.0
2004-06-22 14:00:00	NVDA	Stock	0.1651	0.1669	0.1649	0.1664	68130240.0
2004-06-22 15:00:00	NVDA	Stock	0.1665	0.1671	0.1654	0.1667	95359080.0
2004-06-22 16:00:00	NVDA	Stock	0.1667	0.1669	0.1663	0.1667	7885800.0
2004-06-22 17:00:00	NVDA	Stock	0.1663	0.1663	0.1663	0.1663	372000.0
2004-06-22 18:00:00	NVDA	Stock	0.1668	0.1668	0.1668	0.1668	3129840.0
2004-06-22 08:00:00	AMZN	Stock	2.4885	2.489	2.485	2.485	74000.0
2004-06-22 09:00:00	AMZN	Stock	2.485	2.4895	2.4665	2.4745	14797340.0
2004-06-22 10:00:00	AMZN	Stock	2.475	2.4815	2.453	2.4535	16777020.0
2004-06-22 11:00:00	AMZN	Stock	2.453	2.454	2.425	2.4355	22849580.0
2004-06-22 12:00:00	AMZN	Stock	2.435	2.4375	2.4255	2.433	16412960.0
2004-06-22 13:00:00	AMZN	Stock	2.433	2.433	2.412	2.416	19980880.0
2004-06-22 14:00:00	AMZN	Stock	2.416	2.4315	2.413	2.4275	34318040.0
2004-06-22 15:00:00	AMZN	Stock	2.4275	2.4475	2.4255	2.4475	32218080.0
2004-06-22 16:00:00	AMZN	Stock	2.447	2.45	2.431	2.441	1736400.0
2004-06-22 17:00:00	AMZN	Stock	2.441	2.441	2.4405	2.4405	77700.0
2004-06-22 18:00:00	AMZN	Stock	2.45	2.45	2.4493	2.45	798340.0
2004-06-22 09:00:00	CL	Stock	29.1	29.105	29.05	29.105	245600.0
2004-06-22 10:00:00	CL	Stock	29.1	29.13	29.035	29.095	292400.0
2004-06-22 11:00:00	CL	Stock	29.095	29.15	29.025	29.15	290600.0
2004-06-22 12:00:00	CL	Stock	29.15	29.37	29.15	29.37	315200.0
2004-06-22 13:00:00	CL	Stock	29.365	29.455	29.35	29.44	277600.0
2004-06-22 14:00:00	CL	Stock	29.43	29.52	29.43	29.435	463600.0
2004-06-22 15:00:00	CL	Stock	29.43	29.475	29.3	29.345	546200.0

> showing 50 of 24,842 rows — these rows as CSV

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