PREVIEW / stock_1hour / 2004-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-15.parquet
  size:    509 KB
  rows:    24,056
  symbols: 1,794

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-15 08:00:00	AAPL	Stock	0.5411	0.5429	0.5402	0.5429	402136.0
2004-06-15 09:00:00	AAPL	Stock	0.543	0.5536	0.5404	0.5511	51294656.0
2004-06-15 10:00:00	AAPL	Stock	0.5509	0.5554	0.5505	0.5513	94439744.0
2004-06-15 11:00:00	AAPL	Stock	0.5513	0.5561	0.5511	0.5532	58101960.0
2004-06-15 12:00:00	AAPL	Stock	0.5532	0.5546	0.5514	0.5534	53103232.0
2004-06-15 13:00:00	AAPL	Stock	0.5534	0.5541	0.552	0.5539	32131400.0
2004-06-15 14:00:00	AAPL	Stock	0.5539	0.5545	0.55	0.5507	45311672.0
2004-06-15 15:00:00	AAPL	Stock	0.5505	0.5514	0.5466	0.5479	90972560.0
2004-06-15 16:00:00	AAPL	Stock	0.5479	0.5491	0.5475	0.5489	3647448.0
2004-06-15 17:00:00	AAPL	Stock	0.5488	0.5488	0.548	0.548	151200.0
2004-06-15 08:00:00	MSFT	Stock	27.15	27.2	26.96	27.07	558598.0
2004-06-15 09:00:00	MSFT	Stock	27.09	27.36	26.97	27.27	18959028.0
2004-06-15 10:00:00	MSFT	Stock	27.26	27.49	27.26	27.46	18003677.0
2004-06-15 11:00:00	MSFT	Stock	27.46	27.5	27.4	27.49	16656261.0
2004-06-15 12:00:00	MSFT	Stock	27.49	27.55	27.43	27.51	14548125.0
2004-06-15 13:00:00	MSFT	Stock	27.51	27.6	27.49	27.55	11166591.0
2004-06-15 14:00:00	MSFT	Stock	27.54	27.59	27.45	27.48	9614708.0
2004-06-15 15:00:00	MSFT	Stock	27.48	27.5	27.35	27.37	20944700.0
2004-06-15 16:00:00	MSFT	Stock	27.38	27.53	27.29	27.34	798379.0
2004-06-15 17:00:00	MSFT	Stock	27.34	27.385	27.31	27.34	71549.0
2004-06-15 18:00:00	MSFT	Stock	27.34	27.34	27.3	27.3	24150.0
2004-06-15 08:00:00	NVDA	Stock	0.17	0.17	0.17	0.17	12000.0
2004-06-15 09:00:00	NVDA	Stock	0.1696	0.1722	0.1692	0.1718	66443280.0
2004-06-15 10:00:00	NVDA	Stock	0.1718	0.1728	0.1708	0.1709	64241760.0
2004-06-15 11:00:00	NVDA	Stock	0.1709	0.1717	0.1698	0.1711	45087960.0
2004-06-15 12:00:00	NVDA	Stock	0.1711	0.173	0.1709	0.1722	46383840.0
2004-06-15 13:00:00	NVDA	Stock	0.1722	0.1727	0.1719	0.1722	18215280.0
2004-06-15 14:00:00	NVDA	Stock	0.1722	0.1723	0.1702	0.1707	50596680.0
2004-06-15 15:00:00	NVDA	Stock	0.1706	0.1712	0.1688	0.1702	94572480.0
2004-06-15 16:00:00	NVDA	Stock	0.1701	0.1714	0.1697	0.1704	3842880.0
2004-06-15 17:00:00	NVDA	Stock	0.1704	0.1708	0.1704	0.1708	7164000.0
2004-06-15 08:00:00	AMZN	Stock	2.463	2.4825	2.463	2.4805	56820.0
2004-06-15 09:00:00	AMZN	Stock	2.4805	2.5075	2.47	2.493	20473700.0
2004-06-15 10:00:00	AMZN	Stock	2.4945	2.525	2.4935	2.518	26523860.0
2004-06-15 11:00:00	AMZN	Stock	2.519	2.5235	2.507	2.516	18256140.0
2004-06-15 12:00:00	AMZN	Stock	2.5165	2.5241	2.5115	2.5235	13784060.0
2004-06-15 13:00:00	AMZN	Stock	2.5231	2.53	2.5205	2.524	9977400.0
2004-06-15 14:00:00	AMZN	Stock	2.5235	2.5265	2.513	2.5145	12481760.0
2004-06-15 15:00:00	AMZN	Stock	2.5145	2.5205	2.4985	2.507	27636160.0
2004-06-15 16:00:00	AMZN	Stock	2.5075	2.5115	2.505	2.506	1369800.0
2004-06-15 17:00:00	AMZN	Stock	2.506	2.5086	2.5055	2.5055	241280.0
2004-06-15 09:00:00	CL	Stock	29.085	29.175	29.005	29.035	234800.0
2004-06-15 10:00:00	CL	Stock	29.03	29.19	29.025	29.115	453200.0
2004-06-15 11:00:00	CL	Stock	29.11	29.16	29.075	29.125	279400.0
2004-06-15 12:00:00	CL	Stock	29.125	29.155	29.075	29.11	263000.0
2004-06-15 13:00:00	CL	Stock	29.105	29.135	29.08	29.08	193200.0
2004-06-15 14:00:00	CL	Stock	29.085	29.145	29.05	29.05	207600.0
2004-06-15 15:00:00	CL	Stock	29.045	29.105	28.995	29.095	530600.0

> showing 48 of 24,056 rows — these rows as CSV

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