PREVIEW / stock_1hour / 2004-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-30.parquet
  size:    504 KB
  rows:    24,361
  symbols: 1,809

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-07-30 08:00:00	AAPL	Stock	0.58	0.58	0.5782	0.5782	28000.0
2004-07-30 09:00:00	AAPL	Stock	0.5821	0.5848	0.5796	0.5818	14351960.0
2004-07-30 10:00:00	AAPL	Stock	0.5818	0.5891	0.5771	0.5891	52534160.0
2004-07-30 11:00:00	AAPL	Stock	0.5891	0.5893	0.5857	0.5877	36033200.0
2004-07-30 12:00:00	AAPL	Stock	0.5875	0.5882	0.5841	0.5852	26338984.0
2004-07-30 13:00:00	AAPL	Stock	0.5848	0.5857	0.5821	0.5839	18639264.0
2004-07-30 14:00:00	AAPL	Stock	0.5839	0.585	0.5804	0.5807	23827384.0
2004-07-30 15:00:00	AAPL	Stock	0.5807	0.5813	0.5714	0.5788	56202496.0
2004-07-30 16:00:00	AAPL	Stock	0.5782	0.5802	0.5775	0.5802	2567936.0
2004-07-30 17:00:00	AAPL	Stock	0.5775	0.5775	0.577	0.577	436744.0
2004-07-30 08:00:00	MSFT	Stock	28.46	28.47	28.39	28.45	32270.0
2004-07-30 09:00:00	MSFT	Stock	28.47	28.62	28.4	28.54	5447996.0
2004-07-30 10:00:00	MSFT	Stock	28.53	28.78	28.53	28.73	9819731.0
2004-07-30 11:00:00	MSFT	Stock	28.74	28.81	28.61	28.66	8106033.0
2004-07-30 12:00:00	MSFT	Stock	28.65	28.71	28.57	28.66	3731029.0
2004-07-30 13:00:00	MSFT	Stock	28.66	28.69	28.5	28.51	5877350.0
2004-07-30 14:00:00	MSFT	Stock	28.51	28.58	28.39	28.45	10016798.0
2004-07-30 15:00:00	MSFT	Stock	28.46	28.51	28.33	28.48	11208936.0
2004-07-30 16:00:00	MSFT	Stock	28.47	28.52	28.45	28.5	1354776.0
2004-07-30 17:00:00	MSFT	Stock	28.4537	28.5	28.4537	28.48	743339.0
2004-07-30 18:00:00	MSFT	Stock	28.5	28.5	28.49	28.49	300.0
2004-07-30 08:00:00	NVDA	Stock	0.1292	0.1292	0.1259	0.1267	1194000.0
2004-07-30 09:00:00	NVDA	Stock	0.1268	0.1275	0.1252	0.1258	43474680.0
2004-07-30 10:00:00	NVDA	Stock	0.1258	0.1297	0.1256	0.129	92403240.0
2004-07-30 11:00:00	NVDA	Stock	0.129	0.1308	0.129	0.1292	81142200.0
2004-07-30 12:00:00	NVDA	Stock	0.1292	0.1307	0.1292	0.1304	38584320.0
2004-07-30 13:00:00	NVDA	Stock	0.1304	0.1307	0.1285	0.1293	40564560.0
2004-07-30 14:00:00	NVDA	Stock	0.1294	0.1302	0.1288	0.1291	25890480.0
2004-07-30 15:00:00	NVDA	Stock	0.1291	0.1295	0.1277	0.1283	63473880.0
2004-07-30 16:00:00	NVDA	Stock	0.1283	0.1287	0.1282	0.1283	7503240.0
2004-07-30 17:00:00	NVDA	Stock	0.1283	0.1287	0.1281	0.1287	557880.0
2004-07-30 18:00:00	NVDA	Stock	0.1285	0.1285	0.1285	0.1285	30000.0
2004-07-30 08:00:00	AMZN	Stock	1.929	1.929	1.92	1.925	28200.0
2004-07-30 09:00:00	AMZN	Stock	1.9135	1.9385	1.9075	1.93	18901500.0
2004-07-30 10:00:00	AMZN	Stock	1.93	1.9695	1.93	1.9645	30169240.0
2004-07-30 11:00:00	AMZN	Stock	1.9645	1.971	1.95	1.956	12200020.0
2004-07-30 12:00:00	AMZN	Stock	1.956	1.9695	1.9555	1.968	7090240.0
2004-07-30 13:00:00	AMZN	Stock	1.969	1.97	1.954	1.9545	8938220.0
2004-07-30 14:00:00	AMZN	Stock	1.954	1.959	1.951	1.954	8685740.0
2004-07-30 15:00:00	AMZN	Stock	1.954	1.9545	1.934	1.9455	25314360.0
2004-07-30 16:00:00	AMZN	Stock	1.9445	1.954	1.9432	1.945	2611840.0
2004-07-30 17:00:00	AMZN	Stock	1.946	1.95	1.946	1.95	196920.0
2004-07-30 09:00:00	CL	Stock	26.51	26.55	26.33	26.37	213000.0
2004-07-30 10:00:00	CL	Stock	26.37	26.5	26.26	26.33	431400.0
2004-07-30 11:00:00	CL	Stock	26.325	26.43	26.28	26.43	312600.0
2004-07-30 12:00:00	CL	Stock	26.435	26.45	26.325	26.385	332000.0
2004-07-30 13:00:00	CL	Stock	26.39	26.42	26.355	26.42	331600.0
2004-07-30 14:00:00	CL	Stock	26.42	26.46	26.375	26.4	604600.0
2004-07-30 15:00:00	CL	Stock	26.405	26.605	26.395	26.605	903400.0
2004-07-30 16:00:00	CL	Stock	26.6	26.6	26.5815	26.5815	29800.0

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

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