PREVIEW / stock_1hour / 2004-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-10.parquet
  size:    505 KB
  rows:    24,331
  symbols: 1,824

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-10 08:00:00	AAPL	Stock	0.6375	0.6375	0.6375	0.6375	221760.0
2004-09-10 09:00:00	AAPL	Stock	0.6366	0.647	0.6357	0.6429	50925616.0
2004-09-10 10:00:00	AAPL	Stock	0.643	0.6457	0.6405	0.642	54309472.0
2004-09-10 11:00:00	AAPL	Stock	0.642	0.643	0.6402	0.6411	33005952.0
2004-09-10 12:00:00	AAPL	Stock	0.6409	0.6411	0.6359	0.6396	31574760.0
2004-09-10 13:00:00	AAPL	Stock	0.6397	0.6405	0.6332	0.6336	30985416.0
2004-09-10 14:00:00	AAPL	Stock	0.6338	0.6395	0.6334	0.6386	34463408.0
2004-09-10 15:00:00	AAPL	Stock	0.6386	0.6414	0.637	0.64	51115400.0
2004-09-10 16:00:00	AAPL	Stock	0.6395	0.6407	0.6393	0.6402	6128640.0
2004-09-10 17:00:00	AAPL	Stock	0.6405	0.6411	0.6405	0.6411	516880.0
2004-09-10 08:00:00	MSFT	Stock	27.43	27.49	27.28	27.38	109420.0
2004-09-10 09:00:00	MSFT	Stock	27.38	27.4	27.18	27.24	6471696.0
2004-09-10 10:00:00	MSFT	Stock	27.24	27.29	27.2	27.24	7195161.0
2004-09-10 11:00:00	MSFT	Stock	27.24	27.328	27.21	27.23	5898025.0
2004-09-10 12:00:00	MSFT	Stock	27.23	27.28	27.23	27.25	2119037.0
2004-09-10 13:00:00	MSFT	Stock	27.25	27.29	27.21	27.22	3934539.0
2004-09-10 14:00:00	MSFT	Stock	27.22	27.38	27.21	27.34	9338673.0
2004-09-10 15:00:00	MSFT	Stock	27.34	27.51	27.32	27.49	14649542.0
2004-09-10 16:00:00	MSFT	Stock	27.49	27.52	26.1257	27.43	603298.0
2004-09-10 17:00:00	MSFT	Stock	27.45	27.49	27.43	27.43	153810.0
2004-09-10 18:00:00	MSFT	Stock	27.44	27.51	27.44	27.51	7193.0
2004-09-10 08:00:00	NVDA	Stock	0.1129	0.1137	0.1129	0.1133	3096000.0
2004-09-10 09:00:00	NVDA	Stock	0.1133	0.1152	0.1107	0.1137	148027560.0
2004-09-10 10:00:00	NVDA	Stock	0.1137	0.1173	0.1133	0.1165	218635320.0
2004-09-10 11:00:00	NVDA	Stock	0.1164	0.1172	0.1149	0.1155	169442760.0
2004-09-10 12:00:00	NVDA	Stock	0.1155	0.1158	0.1144	0.1151	114256680.0
2004-09-10 13:00:00	NVDA	Stock	0.1151	0.1167	0.115	0.1165	81113040.0
2004-09-10 14:00:00	NVDA	Stock	0.1165	0.1177	0.1162	0.1172	120096960.0
2004-09-10 15:00:00	NVDA	Stock	0.1172	0.1178	0.1171	0.1172	157608120.0
2004-09-10 16:00:00	NVDA	Stock	0.1172	0.1174	0.1158	0.1172	5079480.0
2004-09-10 17:00:00	NVDA	Stock	0.1172	0.1172	0.1172	0.1172	540600.0
2004-09-10 08:00:00	AMZN	Stock	1.9055	1.9055	1.904	1.904	306000.0
2004-09-10 09:00:00	AMZN	Stock	1.9015	1.9205	1.895	1.909	14433640.0
2004-09-10 10:00:00	AMZN	Stock	1.909	1.9265	1.9055	1.92	17438760.0
2004-09-10 11:00:00	AMZN	Stock	1.9205	1.9365	1.9085	1.9115	11846980.0
2004-09-10 12:00:00	AMZN	Stock	1.912	1.9235	1.9095	1.919	5415800.0
2004-09-10 13:00:00	AMZN	Stock	1.9195	1.9265	1.916	1.9195	6490260.0
2004-09-10 14:00:00	AMZN	Stock	1.9195	1.9365	1.913	1.9325	11432000.0
2004-09-10 15:00:00	AMZN	Stock	1.933	1.94	1.927	1.9305	20955000.0
2004-09-10 16:00:00	AMZN	Stock	1.933	1.933	1.928	1.928	576900.0
2004-09-10 17:00:00	AMZN	Stock	1.9285	1.9285	1.9285	1.9285	81400.0
2004-09-10 09:00:00	CL	Stock	27.05	27.075	27.025	27.03	213200.0
2004-09-10 10:00:00	CL	Stock	27.03	27.12	26.98	27.005	279400.0
2004-09-10 11:00:00	CL	Stock	27.0	27.175	27.0	27.15	237800.0
2004-09-10 12:00:00	CL	Stock	27.145	27.175	27.135	27.145	104200.0
2004-09-10 13:00:00	CL	Stock	27.14	27.19	27.125	27.15	135600.0
2004-09-10 14:00:00	CL	Stock	27.15	27.2	27.15	27.18	235400.0
2004-09-10 15:00:00	CL	Stock	27.175	27.235	27.175	27.2	301400.0
2004-09-10 17:00:00	CL	Stock	27.195	27.2	27.195	27.2	5400.0

> showing 49 of 24,331 rows — these rows as CSV

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