PREVIEW / stock_1hour / 2004-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-09.parquet
  size:    494 KB
  rows:    23,525
  symbols: 1,803

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-09 08:00:00	AAPL	Stock	0.5429	0.5429	0.5402	0.5413	330400.0
2004-07-09 09:00:00	AAPL	Stock	0.5411	0.5446	0.5393	0.5407	18198096.0
2004-07-09 10:00:00	AAPL	Stock	0.5407	0.5427	0.5386	0.5388	20630064.0
2004-07-09 11:00:00	AAPL	Stock	0.5389	0.5441	0.5388	0.5425	20464136.0
2004-07-09 12:00:00	AAPL	Stock	0.5423	0.5429	0.5407	0.542	11060672.0
2004-07-09 13:00:00	AAPL	Stock	0.5421	0.5429	0.5407	0.5423	9159136.0
2004-07-09 14:00:00	AAPL	Stock	0.5421	0.5425	0.5393	0.5398	15586256.0
2004-07-09 15:00:00	AAPL	Stock	0.5398	0.5434	0.5364	0.537	59425296.0
2004-07-09 16:00:00	AAPL	Stock	0.5364	0.5414	0.5354	0.5363	25075344.0
2004-07-09 17:00:00	AAPL	Stock	0.5402	0.5402	0.5402	0.5402	5600.0
2004-07-09 08:00:00	MSFT	Stock	27.92	27.92	27.64	27.81	44275.0
2004-07-09 09:00:00	MSFT	Stock	27.84	27.89	27.69	27.84	5019094.0
2004-07-09 10:00:00	MSFT	Stock	27.83	28.001	27.76	27.81	7651455.0
2004-07-09 11:00:00	MSFT	Stock	27.82	27.85	27.72	27.78	8638364.0
2004-07-09 12:00:00	MSFT	Stock	27.78	27.82	27.66	27.79	4391616.0
2004-07-09 13:00:00	MSFT	Stock	27.781	27.86	27.72	27.79	4207799.0
2004-07-09 14:00:00	MSFT	Stock	27.8	27.8	27.66	27.679	6638688.0
2004-07-09 15:00:00	MSFT	Stock	27.67	27.93	27.64	27.87	11384053.0
2004-07-09 16:00:00	MSFT	Stock	27.87	27.92	27.7933	27.87	680759.0
2004-07-09 17:00:00	MSFT	Stock	27.85	27.91	27.7954	27.91	15128.0
2004-07-09 18:00:00	MSFT	Stock	27.87	27.87	27.84	27.84	1700.0
2004-07-09 08:00:00	NVDA	Stock	0.1475	0.1477	0.1474	0.1476	516000.0
2004-07-09 09:00:00	NVDA	Stock	0.1479	0.1479	0.1425	0.144	187546200.0
2004-07-09 10:00:00	NVDA	Stock	0.1439	0.1448	0.1396	0.1406	223819080.0
2004-07-09 11:00:00	NVDA	Stock	0.1407	0.1407	0.139	0.1395	151417440.0
2004-07-09 12:00:00	NVDA	Stock	0.1395	0.1406	0.1381	0.1397	158029320.0
2004-07-09 13:00:00	NVDA	Stock	0.1397	0.1413	0.1387	0.1406	79221720.0
2004-07-09 14:00:00	NVDA	Stock	0.1407	0.1408	0.1387	0.1397	104981640.0
2004-07-09 15:00:00	NVDA	Stock	0.1397	0.1407	0.1387	0.1402	182417160.0
2004-07-09 16:00:00	NVDA	Stock	0.1402	0.1409	0.1395	0.1401	10201080.0
2004-07-09 17:00:00	NVDA	Stock	0.1401	0.1401	0.1395	0.14	420000.0
2004-07-09 18:00:00	NVDA	Stock	0.1406	0.1407	0.1406	0.1407	143640.0
2004-07-09 08:00:00	AMZN	Stock	2.4995	2.512	2.49	2.495	60000.0
2004-07-09 09:00:00	AMZN	Stock	2.491	2.5	2.46	2.4655	18582980.0
2004-07-09 10:00:00	AMZN	Stock	2.466	2.475	2.451	2.4525	18335260.0
2004-07-09 11:00:00	AMZN	Stock	2.4525	2.4605	2.4065	2.4065	26714880.0
2004-07-09 12:00:00	AMZN	Stock	2.4065	2.421	2.401	2.4085	20541840.0
2004-07-09 13:00:00	AMZN	Stock	2.4085	2.4185	2.404	2.405	15651900.0
2004-07-09 14:00:00	AMZN	Stock	2.405	2.416	2.391	2.395	24428380.0
2004-07-09 15:00:00	AMZN	Stock	2.3955	2.416	2.3925	2.4135	32372600.0
2004-07-09 16:00:00	AMZN	Stock	2.4155	2.4276	2.4047	2.412	1799400.0
2004-07-09 17:00:00	AMZN	Stock	2.416	2.416	2.416	2.416	23720.0
2004-07-09 18:00:00	AMZN	Stock	2.412	2.412	2.412	2.412	2000.0
2004-07-09 09:00:00	CL	Stock	29.08	29.11	28.945	28.95	206000.0
2004-07-09 10:00:00	CL	Stock	28.93	29.01	28.9	28.94	320200.0
2004-07-09 11:00:00	CL	Stock	28.935	28.995	28.92	28.985	215600.0
2004-07-09 12:00:00	CL	Stock	28.985	29.0	28.95	29.0	168200.0
2004-07-09 13:00:00	CL	Stock	29.0	29.0	28.95	28.96	161200.0
2004-07-09 14:00:00	CL	Stock	28.96	28.965	28.82	28.835	290200.0
2004-07-09 15:00:00	CL	Stock	28.835	28.95	28.83	28.9	401400.0

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

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