PREVIEW / stock_1hour / 2004-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-21.parquet
  size:    486 KB
  rows:    23,222
  symbols: 1,767

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-05-21 08:00:00	AAPL	Stock	0.4786	0.4786	0.4786	0.4786	30800.0
2004-05-21 09:00:00	AAPL	Stock	0.4786	0.4836	0.477	0.4798	28123256.0
2004-05-21 10:00:00	AAPL	Stock	0.4798	0.4816	0.4773	0.4805	22833832.0
2004-05-21 11:00:00	AAPL	Stock	0.4804	0.4857	0.48	0.4821	27093808.0
2004-05-21 12:00:00	AAPL	Stock	0.482	0.4829	0.4802	0.4821	9961728.0
2004-05-21 13:00:00	AAPL	Stock	0.4821	0.4825	0.4796	0.4807	10321976.0
2004-05-21 14:00:00	AAPL	Stock	0.4807	0.4823	0.4791	0.4807	21374640.0
2004-05-21 15:00:00	AAPL	Stock	0.4805	0.4843	0.4791	0.4838	34104952.0
2004-05-21 16:00:00	AAPL	Stock	0.4841	0.4841	0.4807	0.4841	3657864.0
2004-05-21 17:00:00	AAPL	Stock	0.4841	0.4841	0.4836	0.4841	397600.0
2004-05-21 18:00:00	AAPL	Stock	0.4841	0.4841	0.4841	0.4841	16800.0
2004-05-21 08:00:00	MSFT	Stock	25.75	25.93	25.75	25.9	47210.0
2004-05-21 09:00:00	MSFT	Stock	25.9	25.97	25.78	25.84	8042888.0
2004-05-21 10:00:00	MSFT	Stock	25.83	26.0	25.8	25.93	9233380.0
2004-05-21 11:00:00	MSFT	Stock	25.93	26.031	25.91	26.01	9393785.0
2004-05-21 12:00:00	MSFT	Stock	26.0	26.04	25.932	26.01	3301825.0
2004-05-21 13:00:00	MSFT	Stock	26.01	26.01	25.82	25.88	4842724.0
2004-05-21 14:00:00	MSFT	Stock	25.88	25.89	25.78	25.81	8383024.0
2004-05-21 15:00:00	MSFT	Stock	25.83	25.95	25.78	25.9	10749143.0
2004-05-21 16:00:00	MSFT	Stock	25.9	26.86	25.833	25.89	1355024.0
2004-05-21 17:00:00	MSFT	Stock	25.87	25.9	25.8	25.9	101580.0
2004-05-21 18:00:00	MSFT	Stock	25.89	25.89	25.89	25.89	100.0
2004-05-21 08:00:00	NVDA	Stock	0.1776	0.1784	0.1764	0.1784	396000.0
2004-05-21 09:00:00	NVDA	Stock	0.1786	0.1786	0.1763	0.1767	45140760.0
2004-05-21 10:00:00	NVDA	Stock	0.1766	0.1772	0.1742	0.1767	86481360.0
2004-05-21 11:00:00	NVDA	Stock	0.1766	0.1767	0.176	0.1762	34169040.0
2004-05-21 12:00:00	NVDA	Stock	0.1762	0.1765	0.1761	0.1761	13522080.0
2004-05-21 13:00:00	NVDA	Stock	0.1761	0.1761	0.1753	0.1757	16461120.0
2004-05-21 14:00:00	NVDA	Stock	0.1758	0.1762	0.1747	0.1758	25648800.0
2004-05-21 15:00:00	NVDA	Stock	0.1759	0.1767	0.175	0.1762	48783240.0
2004-05-21 16:00:00	NVDA	Stock	0.1767	0.1767	0.1762	0.1762	3419280.0
2004-05-21 17:00:00	NVDA	Stock	0.1764	0.1764	0.1762	0.1762	172800.0
2004-05-21 08:00:00	AMZN	Stock	2.055	2.0605	2.055	2.0585	106000.0
2004-05-21 09:00:00	AMZN	Stock	2.0585	2.074	2.0475	2.049	11093040.0
2004-05-21 10:00:00	AMZN	Stock	2.0495	2.0545	2.03	2.049	23041040.0
2004-05-21 11:00:00	AMZN	Stock	2.049	2.0655	2.048	2.054	12847800.0
2004-05-21 12:00:00	AMZN	Stock	2.054	2.055	2.045	2.049	8628560.0
2004-05-21 13:00:00	AMZN	Stock	2.049	2.055	2.043	2.0465	7912400.0
2004-05-21 14:00:00	AMZN	Stock	2.0465	2.048	2.0285	2.031	10697120.0
2004-05-21 15:00:00	AMZN	Stock	2.032	2.057	2.0275	2.057	26993020.0
2004-05-21 16:00:00	AMZN	Stock	2.055	2.0605	2.053	2.06	1165380.0
2004-05-21 17:00:00	AMZN	Stock	2.0585	2.0625	2.0535	2.06	107920.0
2004-05-21 18:00:00	AMZN	Stock	2.062	2.062	2.062	2.062	8000.0
2004-05-21 09:00:00	CL	Stock	28.25	28.25	28.1	28.215	341600.0
2004-05-21 10:00:00	CL	Stock	28.195	28.3	28.18	28.245	369800.0
2004-05-21 11:00:00	CL	Stock	28.245	28.5	28.245	28.5	881800.0
2004-05-21 12:00:00	CL	Stock	28.5	28.585	28.495	28.535	216200.0
2004-05-21 13:00:00	CL	Stock	28.535	28.615	28.5	28.615	353800.0
2004-05-21 14:00:00	CL	Stock	28.615	28.78	28.59	28.65	725800.0
2004-05-21 15:00:00	CL	Stock	28.65	28.68	28.59	28.625	1041200.0

> showing 50 of 23,222 rows — these rows as CSV

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