PREVIEW / stock_daily / 2006-01-12

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-12.parquet
  size:    144 KB
  rows:    4,320
  symbols: 2,730

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-01-12	AAPL	Stock	3.0346	3.0857	2.9864	3.0104	1280809600.0
2006-01-12	MSFT	Stock	27.25	27.26	26.97	27.14	45994800.0
2006-01-12	NVDA	Stock	0.3625	0.3681	0.3548	0.3574	495504000.0
2006-01-12	AMZN	Stock	2.2395	2.2545	2.2045	2.218	116366000.0
2006-01-12	CL	Stock	27.325	27.325	27.05	27.125	4095400.0
2006-01-12	A	Stock	24.8569	24.9285	24.4492	24.4778	5484354.0
2006-01-12	AABA-DELISTED	Stock	41.9199981689453	41.9900016784668	40.7599983215332	40.8899993896484	18921700.0
2006-01-12	AACC-DELISTED	Stock	23.0	23.1	22.8	22.86	105268.0
2006-01-12	AACQ-DELISTED	Stock	5.21	5.21	5.2	5.2	4500.0
2006-01-12	AACQU-DELISTED	Stock	6.18	6.3	6.18	6.3	8600.0
2006-01-12	AACQW-DELISTED	Stock	0.55	0.56	0.55	0.56	32500.0
2006-01-12	AAI-DELISTED	Stock	15.66	15.8	15.41	15.44	2279800.0
2006-01-12	AAIC-DELISTED	Stock	223.8	224.0	218.0	220.0	1027200.0
2006-01-12	AAME	Stock	2.67	2.79	2.66	2.77	8000.0
2006-01-12	AAON	Stock	2.4336	2.4336	2.3849	2.3967	239203.0
2006-01-12	AAP	Stock	44.31	44.59	44.23	44.36	914500.0
2006-01-12	AATI-DELISTED	Stock	14.2	14.48	13.98	13.98	179773.0
2006-01-12	AAU-DELISTED	Stock	2.74	2.74	2.51	2.68	140400.0
2006-01-12	AAUAF-DELISTED	Stock	2.74	2.74	2.51	2.68	140400.0
2006-01-12	AAV-DELISTED	Stock	18.36	18.59	18.35	18.49	222200.0
2006-01-12	AAWW-DELISTED	Stock	45.0	45.0	44.0	44.0	42400.0
2006-01-12	AAXN-DELISTED	Stock	9.27000045776367	9.30000019073486	8.57999992370605	8.64999961853027	3578700.0
2006-01-12	ABAX-DELISTED	Stock	18.13	18.24	17.91	18.12	133526.0
2006-01-12	ABB-DELISTED	Stock	11.12	11.12	10.96	11.01	1236500.0
2006-01-12	ABBC-DELISTED	Stock	13.22	13.339	13.2	13.2	6851.0
2006-01-12	ABC-DELISTED	Stock	20.5	20.8	20.42	20.64	3554800.0
2006-01-12	ABCB	Stock	20.0364	20.0754	19.9003	19.9975	1337.0
2006-01-12	ABCO-DELISTED	Stock	23.3	23.43	22.66	22.73	608482.0
2006-01-12	ABCW-DELISTED	Stock	31.52	31.52	31.25	31.32	23160.0
2006-01-12	ABD-DELISTED	Stock	24.85	25.4	24.85	25.03	582130.0
2006-01-12	ABE-DELISTED	Stock	12.88	12.88	12.65	12.68	40300.0
2006-01-12	ABFS-DELISTED	Stock	43.8	45.2	43.47	45.13	344244.0
2006-01-12	ABG	Stock	16.74	16.89	16.3	16.41	47700.0
2006-01-12	ABK-DELISTED	Stock	78.16	78.85	77.35	77.37	415100.0
2006-01-12	ABM	Stock	19.85	19.9	19.54	19.72	104900.0
2006-01-12	ABMD-DELISTED	Stock	10.61	10.73	10.5	10.66	60665.0
2006-01-12	ABP-DELISTED	Stock	5.42	5.58	5.4	5.45	550600.0
2006-01-12	ABR	Stock	27.4	27.76	26.97	27.0	132800.0
2006-01-12	ABT	Stock	19.787	19.8589	19.7294	19.8349	7043143.0
2006-01-12	ABTL-DELISTED	Stock	25.25	25.65	25.25	25.5	27413.0
2006-01-12	ABV-DELISTED	Stock	41.8	42.0	41.54	41.65	443100.0
2006-01-12	ABVA-DELISTED	Stock	16.37	16.5	16.37	16.5	853.0
2006-01-12	ABX-DELISTED	Stock	28.9	29.34	28.58	29.13	4866100.0
2006-01-12	ACAD	Stock	10.69	10.89	10.56	10.71	90700.0
2006-01-12	ACAP-DELISTED	Stock	49.21	49.39	47.75	47.89	29375.0
2006-01-12	ACAS-DELISTED	Stock	35.5	35.79	35.19	35.37	2312835.0
2006-01-12	ACAT-DELISTED	Stock	22.81	22.86	22.54	22.69	33331.0
2006-01-12	ACC-DELISTED	Stock	25.26	25.29	25.08	25.18	27189.0
2006-01-12	ACCL-DELISTED	Stock	7.07	7.14	6.56	6.81	377619.0
2006-01-12	ACCO	Stock	24.85	25.4	24.85	25.03	582200.0

> showing 50 of 4,320 rows — these rows as CSV

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