PREVIEW / stock_1hour / 2006-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-08.parquet
  size:    615 KB
  rows:    28,842
  symbols: 2,194

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
2006-03-08 08:00:00	AAPL	Stock	2.3571	2.3643	2.3539	2.3557	916524.0
2006-03-08 09:00:00	AAPL	Stock	2.3554	2.3886	2.3489	2.3836	95744796.0
2006-03-08 10:00:00	AAPL	Stock	2.3836	2.4	2.3661	2.3779	154402668.0
2006-03-08 11:00:00	AAPL	Stock	2.3786	2.3814	2.3364	2.3379	96194924.0
2006-03-08 12:00:00	AAPL	Stock	2.3379	2.3564	2.3339	2.3529	65812432.0
2006-03-08 13:00:00	AAPL	Stock	2.3532	2.3564	2.3421	2.3507	38060512.0
2006-03-08 14:00:00	AAPL	Stock	2.3507	2.3714	2.3454	2.3625	101083920.0
2006-03-08 15:00:00	AAPL	Stock	2.3621	2.3657	2.3429	2.3454	77205100.0
2006-03-08 16:00:00	AAPL	Stock	2.3411	2.3475	2.3379	2.3404	14128436.0
2006-03-08 17:00:00	AAPL	Stock	2.3404	2.3461	2.3404	2.3425	1438752.0
2006-03-08 18:00:00	AAPL	Stock	2.3421	2.345	2.3411	2.3411	179172.0
2006-03-08 05:00:00	MSFT	Stock	27.02	27.02	26.99	26.99	1010.0
2006-03-08 06:00:00	MSFT	Stock	26.99	26.99	26.99	26.99	900.0
2006-03-08 07:00:00	MSFT	Stock	27.02	27.02	26.95	26.98	10482.0
2006-03-08 08:00:00	MSFT	Stock	26.98	27.01	26.96	26.96	22946.0
2006-03-08 09:00:00	MSFT	Stock	26.98	27.33	26.97	27.31	7488856.0
2006-03-08 10:00:00	MSFT	Stock	27.31	27.49	27.28	27.41	14110985.0
2006-03-08 11:00:00	MSFT	Stock	27.41	27.42	27.23	27.3	7752967.0
2006-03-08 12:00:00	MSFT	Stock	27.3	27.42	27.29	27.35	3978113.0
2006-03-08 13:00:00	MSFT	Stock	27.352	27.39	27.29	27.35	3369513.0
2006-03-08 14:00:00	MSFT	Stock	27.34	27.5	27.308	27.44	6497364.0
2006-03-08 15:00:00	MSFT	Stock	27.45	27.5	27.24	27.26	10680561.0
2006-03-08 16:00:00	MSFT	Stock	27.26	27.32	27.23	27.28	1397861.0
2006-03-08 17:00:00	MSFT	Stock	27.29	27.3	27.26	27.26	114352.0
2006-03-08 18:00:00	MSFT	Stock	27.29	27.29	27.249	27.249	7114.0
2006-03-08 08:00:00	NVDA	Stock	0.4029	0.4029	0.3992	0.3992	96000.0
2006-03-08 09:00:00	NVDA	Stock	0.3992	0.4019	0.3967	0.3988	78715080.0
2006-03-08 10:00:00	NVDA	Stock	0.3988	0.3996	0.3934	0.3937	87429960.0
2006-03-08 11:00:00	NVDA	Stock	0.3939	0.394	0.3857	0.3866	134086320.0
2006-03-08 12:00:00	NVDA	Stock	0.3866	0.3925	0.3855	0.3918	79620240.0
2006-03-08 13:00:00	NVDA	Stock	0.3918	0.3937	0.3911	0.3925	47756400.0
2006-03-08 14:00:00	NVDA	Stock	0.3925	0.404	0.3912	0.4017	125255160.0
2006-03-08 15:00:00	NVDA	Stock	0.4017	0.4027	0.3992	0.3996	95565120.0
2006-03-08 16:00:00	NVDA	Stock	0.3992	0.3998	0.3975	0.3998	3632520.0
2006-03-08 17:00:00	NVDA	Stock	0.3998	0.4	0.3998	0.3998	552720.0
2006-03-08 18:00:00	NVDA	Stock	0.3998	0.3998	0.3998	0.3998	38160.0
2006-03-08 08:00:00	AMZN	Stock	1.8455	1.8455	1.839	1.839	20000.0
2006-03-08 09:00:00	AMZN	Stock	1.8385	1.8715	1.8305	1.871	12028040.0
2006-03-08 10:00:00	AMZN	Stock	1.871	1.8735	1.836	1.848	28340020.0
2006-03-08 11:00:00	AMZN	Stock	1.848	1.85	1.838	1.8385	13326840.0
2006-03-08 12:00:00	AMZN	Stock	1.8385	1.8485	1.834	1.837	18233420.0
2006-03-08 13:00:00	AMZN	Stock	1.8365	1.841	1.833	1.8345	5230820.0
2006-03-08 14:00:00	AMZN	Stock	1.8345	1.8505	1.8315	1.8415	11546280.0
2006-03-08 15:00:00	AMZN	Stock	1.842	1.848	1.8375	1.8385	26027760.0
2006-03-08 16:00:00	AMZN	Stock	1.838	1.841	1.838	1.8385	1892600.0
2006-03-08 17:00:00	AMZN	Stock	1.8385	1.8405	1.8385	1.839	139020.0
2006-03-08 18:00:00	AMZN	Stock	1.8404	1.8404	1.8404	1.8404	10360.0
2006-03-08 09:00:00	CL	Stock	27.375	27.845	27.36	27.835	690600.0
2006-03-08 10:00:00	CL	Stock	27.835	27.98	27.75	27.965	1293800.0
2006-03-08 11:00:00	CL	Stock	27.97	28.08	27.94	28.04	982400.0

> showing 50 of 28,842 rows — these rows as CSV

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