PREVIEW / stock_1hour / 2004-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-25.parquet
  size:    598 KB
  rows:    26,749
  symbols: 1,782

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-25 08:00:00	AAPL	Stock	0.592	0.592	0.592	0.592	11200.0
2004-06-25 09:00:00	AAPL	Stock	0.5902	0.598	0.5893	0.595	27824664.0
2004-06-25 10:00:00	AAPL	Stock	0.5948	0.5998	0.5943	0.5974	27163024.0
2004-06-25 11:00:00	AAPL	Stock	0.5975	0.6005	0.5959	0.5971	25239648.0
2004-06-25 12:00:00	AAPL	Stock	0.5973	0.5977	0.5923	0.5938	34689200.0
2004-06-25 13:00:00	AAPL	Stock	0.5938	0.5966	0.5925	0.5945	34353200.0
2004-06-25 14:00:00	AAPL	Stock	0.5945	0.5945	0.5909	0.5929	40442584.0
2004-06-25 15:00:00	AAPL	Stock	0.5929	0.5982	0.5925	0.5973	64670816.0
2004-06-25 16:00:00	AAPL	Stock	0.5973	0.6018	0.595	0.6018	27837992.0
2004-06-25 17:00:00	AAPL	Stock	0.6018	0.603	0.6006	0.6015	8496992.0
2004-06-25 18:00:00	AAPL	Stock	0.5973	0.6018	0.5973	0.6018	33962264.0
2004-06-25 08:00:00	MSFT	Stock	28.03	28.44	28.03	28.4	11734.0
2004-06-25 09:00:00	MSFT	Stock	28.35	28.54	28.35	28.45	5417229.0
2004-06-25 10:00:00	MSFT	Stock	28.44	28.63	28.4	28.56	9611300.0
2004-06-25 11:00:00	MSFT	Stock	28.55	28.6	28.46	28.479	5607648.0
2004-06-25 12:00:00	MSFT	Stock	28.48	28.5	28.39	28.44	6591186.0
2004-06-25 13:00:00	MSFT	Stock	28.44	28.49	28.42	28.43	4439376.0
2004-06-25 14:00:00	MSFT	Stock	28.44	28.47	28.33	28.451	6880616.0
2004-06-25 15:00:00	MSFT	Stock	28.46	28.6	28.44	28.56	10682368.0
2004-06-25 16:00:00	MSFT	Stock	28.56	28.63	28.26	28.26	11218849.0
2004-06-25 17:00:00	MSFT	Stock	28.46	28.5	28.2035	28.243	1087138.0
2004-06-25 18:00:00	MSFT	Stock	28.262	28.51	28.2575	28.51	5145672.0
2004-06-25 08:00:00	NVDA	Stock	0.1679	0.1687	0.1679	0.1687	108000.0
2004-06-25 09:00:00	NVDA	Stock	0.1679	0.1707	0.1668	0.1696	40221120.0
2004-06-25 10:00:00	NVDA	Stock	0.1695	0.17	0.1682	0.1693	63612960.0
2004-06-25 11:00:00	NVDA	Stock	0.1692	0.1693	0.1672	0.1683	40760760.0
2004-06-25 12:00:00	NVDA	Stock	0.1683	0.169	0.1675	0.169	21948600.0
2004-06-25 13:00:00	NVDA	Stock	0.169	0.1694	0.1682	0.1685	15812160.0
2004-06-25 14:00:00	NVDA	Stock	0.1685	0.1685	0.1673	0.1676	31300320.0
2004-06-25 15:00:00	NVDA	Stock	0.1676	0.1692	0.1676	0.1684	72025440.0
2004-06-25 16:00:00	NVDA	Stock	0.1685	0.1698	0.1682	0.1688	2701560.0
2004-06-25 17:00:00	NVDA	Stock	0.1697	0.1698	0.1694	0.1697	12083160.0
2004-06-25 18:00:00	NVDA	Stock	0.1697	0.1699	0.1697	0.1698	4818720.0
2004-06-25 09:00:00	AMZN	Stock	2.5485	2.584	2.5435	2.5797	14205440.0
2004-06-25 10:00:00	AMZN	Stock	2.5805	2.5965	2.5745	2.581	20839800.0
2004-06-25 11:00:00	AMZN	Stock	2.581	2.5865	2.5575	2.567	12908360.0
2004-06-25 12:00:00	AMZN	Stock	2.5675	2.589	2.56	2.584	11849780.0
2004-06-25 13:00:00	AMZN	Stock	2.584	2.5895	2.582	2.5825	6444420.0
2004-06-25 14:00:00	AMZN	Stock	2.5825	2.5835	2.55	2.551	18632400.0
2004-06-25 15:00:00	AMZN	Stock	2.5505	2.5815	2.5445	2.5775	25790760.0
2004-06-25 16:00:00	AMZN	Stock	2.5795	2.59	2.5695	2.5845	12800120.0
2004-06-25 17:00:00	AMZN	Stock	2.5884	2.5899	2.5835	2.5892	5699960.0
2004-06-25 18:00:00	AMZN	Stock	2.5893	2.5901	2.584	2.584	12403680.0
2004-06-25 09:00:00	CL	Stock	29.04	29.075	29.0	29.01	134400.0
2004-06-25 10:00:00	CL	Stock	29.01	29.085	29.0	29.025	296600.0
2004-06-25 11:00:00	CL	Stock	29.02	29.05	28.905	28.915	413600.0
2004-06-25 12:00:00	CL	Stock	28.91	28.955	28.865	28.92	205200.0
2004-06-25 13:00:00	CL	Stock	28.915	28.93	28.86	28.86	206000.0
2004-06-25 14:00:00	CL	Stock	28.86	28.895	28.8	28.86	403600.0
2004-06-25 15:00:00	CL	Stock	28.86	28.885	28.75	28.795	637200.0

> showing 50 of 26,749 rows — these rows as CSV

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