PREVIEW / stock_1hour / 2006-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-18.parquet
  size:    596 KB
  rows:    28,290
  symbols: 2,166

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-01-18 06:00:00	AAPL	Stock	2.9321	2.9429	2.9321	2.9429	39200.0
2006-01-18 07:00:00	AAPL	Stock	2.9446	2.9607	2.9425	2.9557	428596.0
2006-01-18 08:00:00	AAPL	Stock	2.9589	2.9721	2.9446	2.9707	12673976.0
2006-01-18 09:00:00	AAPL	Stock	2.9704	2.9882	2.9232	2.9725	196375256.0
2006-01-18 10:00:00	AAPL	Stock	2.9721	3.0018	2.965	2.9861	157446660.0
2006-01-18 11:00:00	AAPL	Stock	2.9864	2.9896	2.9589	2.9661	101638068.0
2006-01-18 12:00:00	AAPL	Stock	2.9668	2.9725	2.9596	2.9635	63557032.0
2006-01-18 13:00:00	AAPL	Stock	2.9632	2.965	2.9436	2.9607	98083440.0
2006-01-18 14:00:00	AAPL	Stock	2.9607	2.9775	2.9532	2.9621	125509524.0
2006-01-18 15:00:00	AAPL	Stock	2.9621	2.9743	2.9436	2.9454	140334908.0
2006-01-18 16:00:00	AAPL	Stock	2.9464	2.9639	2.7114	2.7332	194297068.0
2006-01-18 17:00:00	AAPL	Stock	2.7329	2.9461	2.7304	2.8475	103541060.0
2006-01-18 18:00:00	AAPL	Stock	2.8464	2.8518	2.8325	2.8493	6242516.0
2006-01-18 07:00:00	MSFT	Stock	26.6	26.65	26.6	26.6	4600.0
2006-01-18 08:00:00	MSFT	Stock	26.6	26.69	26.55	26.66	101274.0
2006-01-18 09:00:00	MSFT	Stock	26.65	26.86	26.63	26.812	7277592.0
2006-01-18 10:00:00	MSFT	Stock	26.82	26.98	26.8	26.86	8780497.0
2006-01-18 11:00:00	MSFT	Stock	26.86	26.9	26.79	26.84	6320022.0
2006-01-18 12:00:00	MSFT	Stock	26.832	26.87	26.75	26.8	4997531.0
2006-01-18 13:00:00	MSFT	Stock	26.81	26.85	26.76	26.79	5128105.0
2006-01-18 14:00:00	MSFT	Stock	26.79	26.91	26.79	26.82	7407819.0
2006-01-18 15:00:00	MSFT	Stock	26.83	26.88	26.79	26.82	10007757.0
2006-01-18 16:00:00	MSFT	Stock	26.83	26.91	26.76	26.88	367515.0
2006-01-18 17:00:00	MSFT	Stock	26.85	26.9	26.8	26.83	131251.0
2006-01-18 18:00:00	MSFT	Stock	26.83	26.83	26.83	26.83	100.0
2006-01-18 08:00:00	NVDA	Stock	0.3506	0.3506	0.345	0.3471	972000.0
2006-01-18 09:00:00	NVDA	Stock	0.3458	0.3491	0.34	0.3478	121274040.0
2006-01-18 10:00:00	NVDA	Stock	0.3479	0.3522	0.3477	0.3507	106808040.0
2006-01-18 11:00:00	NVDA	Stock	0.3508	0.3517	0.3488	0.3512	45020760.0
2006-01-18 12:00:00	NVDA	Stock	0.351	0.3514	0.3491	0.3507	21617400.0
2006-01-18 13:00:00	NVDA	Stock	0.3507	0.3521	0.3503	0.3516	24731640.0
2006-01-18 14:00:00	NVDA	Stock	0.3516	0.3557	0.3514	0.3533	53668440.0
2006-01-18 15:00:00	NVDA	Stock	0.3534	0.357	0.3531	0.3561	76125360.0
2006-01-18 16:00:00	NVDA	Stock	0.3558	0.3561	0.3529	0.3529	828480.0
2006-01-18 17:00:00	NVDA	Stock	0.355	0.3574	0.355	0.355	179280.0
2006-01-18 18:00:00	NVDA	Stock	0.3574	0.3574	0.3574	0.3574	12000.0
2006-01-18 08:00:00	AMZN	Stock	2.15	2.1775	2.15	2.1555	467500.0
2006-01-18 09:00:00	AMZN	Stock	2.156	2.194	2.151	2.168	25755220.0
2006-01-18 10:00:00	AMZN	Stock	2.1685	2.201	2.1685	2.1935	24729800.0
2006-01-18 11:00:00	AMZN	Stock	2.193	2.196	2.182	2.19	16827060.0
2006-01-18 12:00:00	AMZN	Stock	2.19	2.2095	2.1895	2.197	20814100.0
2006-01-18 13:00:00	AMZN	Stock	2.1975	2.206	2.1945	2.1945	14895420.0
2006-01-18 14:00:00	AMZN	Stock	2.1945	2.2135	2.1945	2.2095	21563080.0
2006-01-18 15:00:00	AMZN	Stock	2.21	2.2295	2.201	2.2165	44626740.0
2006-01-18 16:00:00	AMZN	Stock	2.216	2.2165	2.1775	2.193	2597440.0
2006-01-18 17:00:00	AMZN	Stock	2.1905	2.216	2.185	2.1995	223360.0
2006-01-18 18:00:00	AMZN	Stock	2.2165	2.2165	2.2165	2.2165	8000.0
2006-01-18 09:00:00	CL	Stock	27.185	27.265	27.16	27.195	366400.0
2006-01-18 10:00:00	CL	Stock	27.195	27.245	27.1455	27.165	373800.0
2006-01-18 11:00:00	CL	Stock	27.16	27.26	27.14	27.16	350800.0

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

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