PREVIEW / stock_1hour / 2004-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-29.parquet
  size:    498 KB
  rows:    24,166
  symbols: 1,833

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-09-29 08:00:00	AAPL	Stock	0.6848	0.6848	0.6848	0.6848	5600.0
2004-09-29 09:00:00	AAPL	Stock	0.6786	0.6871	0.6757	0.6861	23128784.0
2004-09-29 10:00:00	AAPL	Stock	0.6859	0.6888	0.6818	0.6868	54489064.0
2004-09-29 11:00:00	AAPL	Stock	0.687	0.6873	0.6823	0.685	21037128.0
2004-09-29 12:00:00	AAPL	Stock	0.685	0.6909	0.6827	0.6902	23720928.0
2004-09-29 13:00:00	AAPL	Stock	0.6902	0.6939	0.6871	0.6889	45287760.0
2004-09-29 14:00:00	AAPL	Stock	0.6889	0.6891	0.6861	0.6886	41746544.0
2004-09-29 15:00:00	AAPL	Stock	0.6884	0.6911	0.6882	0.6905	50314992.0
2004-09-29 16:00:00	AAPL	Stock	0.6907	0.693	0.6898	0.6907	3542336.0
2004-09-29 17:00:00	AAPL	Stock	0.6893	0.6893	0.6893	0.6893	28000.0
2004-09-29 08:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	500.0
2004-09-29 09:00:00	MSFT	Stock	27.26	27.35	27.2333	27.31	4483747.0
2004-09-29 10:00:00	MSFT	Stock	27.31	27.611	27.31	27.5	16410753.0
2004-09-29 11:00:00	MSFT	Stock	27.51	27.58	27.48	27.54	4839908.0
2004-09-29 12:00:00	MSFT	Stock	27.54	27.58	27.47	27.54	7801511.0
2004-09-29 13:00:00	MSFT	Stock	27.5386	27.58	27.5	27.55	4285936.0
2004-09-29 14:00:00	MSFT	Stock	27.56	27.61	27.49	27.58	5969423.0
2004-09-29 15:00:00	MSFT	Stock	27.58	27.67	27.56	27.58	9833161.0
2004-09-29 16:00:00	MSFT	Stock	27.58	27.61	27.56	27.58	4178556.0
2004-09-29 17:00:00	MSFT	Stock	27.58	27.62	27.58	27.62	20308.0
2004-09-29 18:00:00	MSFT	Stock	27.59	27.59	27.59	27.59	4500.0
2004-09-29 09:00:00	NVDA	Stock	0.1163	0.1178	0.1151	0.1173	87519000.0
2004-09-29 10:00:00	NVDA	Stock	0.1172	0.1195	0.1163	0.1191	89990760.0
2004-09-29 11:00:00	NVDA	Stock	0.1191	0.1195	0.1183	0.1183	41570160.0
2004-09-29 12:00:00	NVDA	Stock	0.1183	0.1228	0.1177	0.1192	84886080.0
2004-09-29 13:00:00	NVDA	Stock	0.1194	0.1195	0.1191	0.1192	49566120.0
2004-09-29 14:00:00	NVDA	Stock	0.1192	0.1194	0.1187	0.119	65280840.0
2004-09-29 15:00:00	NVDA	Stock	0.119	0.1194	0.1189	0.1194	108431640.0
2004-09-29 16:00:00	NVDA	Stock	0.1194	0.12	0.1192	0.1195	2937360.0
2004-09-29 17:00:00	NVDA	Stock	0.1196	0.1202	0.1196	0.1202	358320.0
2004-09-29 18:00:00	NVDA	Stock	0.12	0.12	0.12	0.12	48000.0
2004-09-29 08:00:00	AMZN	Stock	1.9725	1.9725	1.9725	1.9725	2000.0
2004-09-29 09:00:00	AMZN	Stock	1.9725	2.01	1.9665	2.0095	23937260.0
2004-09-29 10:00:00	AMZN	Stock	2.0095	2.024	1.996	2.011	52616240.0
2004-09-29 11:00:00	AMZN	Stock	2.012	2.018	1.996	2.0065	21214020.0
2004-09-29 12:00:00	AMZN	Stock	2.007	2.009	1.995	2.007	12497080.0
2004-09-29 13:00:00	AMZN	Stock	2.0065	2.023	2.0045	2.0175	13650720.0
2004-09-29 14:00:00	AMZN	Stock	2.018	2.04	2.012	2.034	22458440.0
2004-09-29 15:00:00	AMZN	Stock	2.034	2.046	2.031	2.0425	45183040.0
2004-09-29 16:00:00	AMZN	Stock	2.042	2.0485	2.038	2.0485	2720600.0
2004-09-29 17:00:00	AMZN	Stock	2.042	2.042	2.0385	2.0385	1586400.0
2004-09-29 18:00:00	AMZN	Stock	2.0385	2.0385	2.0385	2.0385	20000.0
2004-09-29 09:00:00	CL	Stock	22.69	22.7	22.64	22.69	554200.0
2004-09-29 10:00:00	CL	Stock	22.69	22.8	22.665	22.755	1312800.0
2004-09-29 11:00:00	CL	Stock	22.755	22.81	22.745	22.79	1116800.0
2004-09-29 12:00:00	CL	Stock	22.795	22.855	22.79	22.835	986000.0
2004-09-29 13:00:00	CL	Stock	22.835	22.84	22.76	22.82	737200.0
2004-09-29 14:00:00	CL	Stock	22.82	22.825	22.775	22.825	870800.0
2004-09-29 15:00:00	CL	Stock	22.805	22.82	22.74	22.76	1465600.0
2004-09-29 16:00:00	CL	Stock	22.8	22.8	22.75	22.755	517600.0

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

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