PREVIEW / stock_1hour / 2004-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-26.parquet
  size:    480 KB
  rows:    23,268
  symbols: 1,822

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-08-26 08:00:00	AAPL	Stock	0.5893	0.5902	0.5893	0.5902	11200.0
2004-08-26 09:00:00	AAPL	Stock	0.5902	0.5945	0.5846	0.5934	73075520.0
2004-08-26 10:00:00	AAPL	Stock	0.593	0.6063	0.592	0.6048	132552056.0
2004-08-26 11:00:00	AAPL	Stock	0.6048	0.6186	0.6046	0.6173	183517208.0
2004-08-26 12:00:00	AAPL	Stock	0.6175	0.6282	0.6141	0.6229	208313224.0
2004-08-26 13:00:00	AAPL	Stock	0.6229	0.623	0.6164	0.6207	84796152.0
2004-08-26 14:00:00	AAPL	Stock	0.6207	0.6223	0.6163	0.6202	106228416.0
2004-08-26 15:00:00	AAPL	Stock	0.6202	0.6248	0.6189	0.6195	135287096.0
2004-08-26 16:00:00	AAPL	Stock	0.6196	0.6196	0.6179	0.6184	7603624.0
2004-08-26 17:00:00	AAPL	Stock	0.6186	0.6189	0.6186	0.6189	124880.0
2004-08-26 18:00:00	AAPL	Stock	0.6189	0.6189	0.6186	0.6189	134400.0
2004-08-26 08:00:00	MSFT	Stock	27.5	27.55	27.46	27.46	2400.0
2004-08-26 09:00:00	MSFT	Stock	27.5	27.6	27.44	27.55	3900367.0
2004-08-26 10:00:00	MSFT	Stock	27.55	27.6	27.42	27.47	7444869.0
2004-08-26 11:00:00	MSFT	Stock	27.47	27.55	27.46	27.48	4013812.0
2004-08-26 12:00:00	MSFT	Stock	27.5	27.58	27.49	27.51	2365641.0
2004-08-26 13:00:00	MSFT	Stock	27.51	27.52	27.41	27.469	3027313.0
2004-08-26 14:00:00	MSFT	Stock	27.47	27.54	27.41	27.48	4338465.0
2004-08-26 15:00:00	MSFT	Stock	27.47	27.58	27.43	27.45	8204765.0
2004-08-26 16:00:00	MSFT	Stock	27.45	27.55	27.35	27.54	846687.0
2004-08-26 17:00:00	MSFT	Stock	27.53	27.55	27.47	27.4739	29144.0
2004-08-26 18:00:00	MSFT	Stock	27.55	27.55	27.51	27.51	3500.0
2004-08-26 08:00:00	NVDA	Stock	0.1061	0.1061	0.1046	0.1053	348000.0
2004-08-26 09:00:00	NVDA	Stock	0.105	0.1058	0.1046	0.1056	91747920.0
2004-08-26 10:00:00	NVDA	Stock	0.1055	0.1065	0.1047	0.105	138498840.0
2004-08-26 11:00:00	NVDA	Stock	0.105	0.1062	0.105	0.1054	62373600.0
2004-08-26 12:00:00	NVDA	Stock	0.1054	0.1058	0.1052	0.1056	35800680.0
2004-08-26 13:00:00	NVDA	Stock	0.1056	0.1057	0.1048	0.105	52382160.0
2004-08-26 14:00:00	NVDA	Stock	0.1049	0.1058	0.1048	0.1054	79703640.0
2004-08-26 15:00:00	NVDA	Stock	0.1055	0.1061	0.1054	0.1059	100924920.0
2004-08-26 16:00:00	NVDA	Stock	0.1059	0.1061	0.1056	0.106	23801520.0
2004-08-26 17:00:00	NVDA	Stock	0.1061	0.1061	0.1061	0.1061	492000.0
2004-08-26 09:00:00	AMZN	Stock	2.015	2.0345	1.985	2.026	30286840.0
2004-08-26 10:00:00	AMZN	Stock	2.0265	2.0415	2.012	2.021	40406760.0
2004-08-26 11:00:00	AMZN	Stock	2.0215	2.03	2.015	2.0165	12184500.0
2004-08-26 12:00:00	AMZN	Stock	2.016	2.02	2.01	2.0155	8266300.0
2004-08-26 13:00:00	AMZN	Stock	2.0155	2.0175	1.9885	1.989	13125560.0
2004-08-26 14:00:00	AMZN	Stock	1.9885	2.011	1.987	2.006	15551060.0
2004-08-26 15:00:00	AMZN	Stock	2.006	2.02	2.003	2.0095	15399220.0
2004-08-26 16:00:00	AMZN	Stock	2.0095	2.0125	2.006	2.0125	703020.0
2004-08-26 17:00:00	AMZN	Stock	2.0095	2.0135	2.003	2.008	152260.0
2004-08-26 18:00:00	AMZN	Stock	2.008	2.0085	2.0055	2.0055	45000.0
2004-08-26 09:00:00	CL	Stock	26.81	26.945	26.805	26.865	191000.0
2004-08-26 10:00:00	CL	Stock	26.875	26.95	26.835	26.92	272000.0
2004-08-26 11:00:00	CL	Stock	26.92	26.99	26.92	26.955	238800.0
2004-08-26 12:00:00	CL	Stock	26.95	26.955	26.865	26.88	152800.0
2004-08-26 13:00:00	CL	Stock	26.885	26.915	26.885	26.895	174400.0
2004-08-26 14:00:00	CL	Stock	26.895	26.925	26.855	26.865	237400.0
2004-08-26 15:00:00	CL	Stock	26.86	27.015	26.85	26.995	706400.0
2004-08-26 16:00:00	CL	Stock	26.985	26.985	26.985	26.985	7800.0

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

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