PREVIEW / stock_1hour / 2004-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-27.parquet
  size:    490 KB
  rows:    23,814
  symbols: 1,816

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-27 08:00:00	AAPL	Stock	0.62	0.62	0.6159	0.6161	823200.0
2004-08-27 09:00:00	AAPL	Stock	0.6163	0.6207	0.6146	0.6177	58926504.0
2004-08-27 10:00:00	AAPL	Stock	0.6177	0.62	0.608	0.6086	100132200.0
2004-08-27 11:00:00	AAPL	Stock	0.6086	0.6107	0.6071	0.61	63993328.0
2004-08-27 12:00:00	AAPL	Stock	0.61	0.6105	0.6084	0.6098	21128128.0
2004-08-27 13:00:00	AAPL	Stock	0.6096	0.612	0.6096	0.612	24376352.0
2004-08-27 14:00:00	AAPL	Stock	0.612	0.6134	0.6105	0.6123	35286272.0
2004-08-27 15:00:00	AAPL	Stock	0.6123	0.6152	0.6098	0.6134	57523704.0
2004-08-27 16:00:00	AAPL	Stock	0.6132	0.6141	0.6121	0.6141	3958360.0
2004-08-27 17:00:00	AAPL	Stock	0.6121	0.6138	0.6121	0.6138	41552.0
2004-08-27 18:00:00	AAPL	Stock	0.6134	0.6134	0.6134	0.6134	69776.0
2004-08-27 08:00:00	MSFT	Stock	27.55	27.55	27.48	27.52	10644.0
2004-08-27 09:00:00	MSFT	Stock	27.52	27.65	27.46	27.58	5584249.0
2004-08-27 10:00:00	MSFT	Stock	27.58	27.61	27.53	27.55	5340580.0
2004-08-27 11:00:00	MSFT	Stock	27.56	27.6	27.5	27.51	4913228.0
2004-08-27 12:00:00	MSFT	Stock	27.5	27.53	27.47	27.5	3042822.0
2004-08-27 13:00:00	MSFT	Stock	27.49	27.55	27.49	27.53	2427151.0
2004-08-27 14:00:00	MSFT	Stock	27.53	27.57	27.47	27.55	4888042.0
2004-08-27 15:00:00	MSFT	Stock	27.55	27.56	27.45	27.46	4755175.0
2004-08-27 16:00:00	MSFT	Stock	27.46	27.5	27.44	27.44	358736.0
2004-08-27 17:00:00	MSFT	Stock	27.52	27.52	27.44	27.47	5700.0
2004-08-27 18:00:00	MSFT	Stock	27.47	27.47	27.47	27.47	13200.0
2004-08-27 08:00:00	NVDA	Stock	0.1057	0.1057	0.1057	0.1057	118800.0
2004-08-27 09:00:00	NVDA	Stock	0.1059	0.1072	0.1058	0.1071	60712680.0
2004-08-27 10:00:00	NVDA	Stock	0.1072	0.1093	0.1069	0.1081	147029880.0
2004-08-27 11:00:00	NVDA	Stock	0.1081	0.1087	0.1077	0.1077	90311160.0
2004-08-27 12:00:00	NVDA	Stock	0.1077	0.1082	0.1077	0.108	32359440.0
2004-08-27 13:00:00	NVDA	Stock	0.1079	0.1081	0.1077	0.108	67258440.0
2004-08-27 14:00:00	NVDA	Stock	0.108	0.1082	0.1079	0.108	46873800.0
2004-08-27 15:00:00	NVDA	Stock	0.108	0.1083	0.1077	0.1078	108726120.0
2004-08-27 16:00:00	NVDA	Stock	0.1081	0.1083	0.1078	0.1078	5257320.0
2004-08-27 17:00:00	NVDA	Stock	0.1082	0.1082	0.1082	0.1082	137160.0
2004-08-27 08:00:00	AMZN	Stock	2.0065	2.0065	2.0065	2.0065	2000.0
2004-08-27 09:00:00	AMZN	Stock	2.019	2.0195	1.9985	2.0085	15448560.0
2004-08-27 10:00:00	AMZN	Stock	2.0085	2.0085	1.986	1.9865	20164260.0
2004-08-27 11:00:00	AMZN	Stock	1.986	2.004	1.98	1.989	11909960.0
2004-08-27 12:00:00	AMZN	Stock	1.9895	1.9935	1.9855	1.992	5344600.0
2004-08-27 13:00:00	AMZN	Stock	1.993	2.0025	1.9925	2.001	8092000.0
2004-08-27 14:00:00	AMZN	Stock	2.002	2.008	1.9955	2.0	8029240.0
2004-08-27 15:00:00	AMZN	Stock	2.0	2.001	1.987	1.995	13766260.0
2004-08-27 16:00:00	AMZN	Stock	1.9935	1.999	1.992	1.999	1153900.0
2004-08-27 17:00:00	AMZN	Stock	1.9975	1.9975	1.9975	1.9975	4000.0
2004-08-27 18:00:00	AMZN	Stock	1.997	1.997	1.997	1.997	10000.0
2004-08-27 09:00:00	CL	Stock	26.935	26.945	26.865	26.92	151400.0
2004-08-27 10:00:00	CL	Stock	26.915	26.96	26.905	26.935	119000.0
2004-08-27 11:00:00	CL	Stock	26.935	26.955	26.91	26.93	169200.0
2004-08-27 12:00:00	CL	Stock	26.93	26.96	26.92	26.96	82000.0
2004-08-27 13:00:00	CL	Stock	26.965	27.005	26.955	26.99	107400.0
2004-08-27 14:00:00	CL	Stock	26.99	27.01	26.97	26.98	168200.0
2004-08-27 15:00:00	CL	Stock	26.98	27.025	26.98	27.005	423800.0

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

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