PREVIEW / stock_daily / 2006-04-17

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-17.parquet
  size:    147 KB
  rows:    4,427
  symbols: 2,805

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-04-17	AAPL	Stock	2.3754	2.3871	2.2982	2.3146	721938000.0
2006-04-17	MSFT	Stock	27.03	27.05	26.73	26.84	35796200.0
2006-04-17	NVDA	Stock	0.4925	0.507	0.4907	0.4947	443868000.0
2006-04-17	AMZN	Stock	1.8235	1.831	1.7525	1.7635	88844000.0
2006-04-17	CL	Stock	28.25	28.36	28.0	28.13	2929600.0
2006-04-17	A	Stock	26.2232	26.495	26.1087	26.3662	2351855.0
2006-04-17	AABA-DELISTED	Stock	31.1599998474121	31.7900009155273	30.6599998474121	30.9699993133545	18239900.0
2006-04-17	AACC-DELISTED	Stock	20.2	21.02	20.2	20.4	136037.0
2006-04-17	AACQ-DELISTED	Stock	5.4	5.4	5.4	5.4	500.0
2006-04-17	AACQW-DELISTED	Stock	0.74	0.74	0.72	0.73	82500.0
2006-04-17	AAI-DELISTED	Stock	16.14	16.19	15.07	15.39	2800300.0
2006-04-17	AAIC-DELISTED	Stock	177.0	179.4	176.6	179.2	558400.0
2006-04-17	AAME	Stock	2.86	3.02	2.86	2.91	4800.0
2006-04-17	AAON	Stock	3.1934	3.2922	3.1658	3.2856	252112.0
2006-04-17	AAP	Stock	39.77	39.84	39.0	39.38	559400.0
2006-04-17	AATI-DELISTED	Stock	10.96	11.0	10.6	10.64	106106.0
2006-04-17	AAU-DELISTED	Stock	2.95	3.05	2.9	2.99	205800.0
2006-04-17	AAUAF-DELISTED	Stock	2.95	3.05	2.9	2.99	205800.0
2006-04-17	AAV-DELISTED	Stock	19.39	20.06	19.38	20.05	463500.0
2006-04-17	AAWW-DELISTED	Stock	46.0	46.0	44.0	46.0	16500.0
2006-04-17	AAXN-DELISTED	Stock	10.2700004577637	10.3599996566772	9.93000030517578	10.1499996185303	983800.0
2006-04-17	AB	Stock	70.22	70.69	69.57	69.66	121100.0
2006-04-17	ABAX-DELISTED	Stock	25.28	25.5	24.17	24.71	449352.0
2006-04-17	ABB-DELISTED	Stock	13.05	13.12	12.91	12.921	1045700.0
2006-04-17	ABBC-DELISTED	Stock	13.5	13.55	13.25	13.39	27111.0
2006-04-17	ABC-DELISTED	Stock	23.06	23.44	22.92	23.38	3806400.0
2006-04-17	ABCB	Stock	20.5616	21.0286	20.4644	21.0188	20871.0
2006-04-17	ABCO-DELISTED	Stock	27.07	27.2	26.8	27.2	92872.0
2006-04-17	ABCW-DELISTED	Stock	29.25	29.25	28.43	28.7	23080.0
2006-04-17	ABD-DELISTED	Stock	22.08	22.36	22.06	22.16	70200.0
2006-04-17	ABE-DELISTED	Stock	12.85	13.18	12.85	12.93	34400.0
2006-04-17	ABFS-DELISTED	Stock	39.55	39.6	39.01	39.07	173482.0
2006-04-17	ABG	Stock	18.56	18.56	18.15	18.45	60100.0
2006-04-17	ABK-DELISTED	Stock	77.88	78.05	77.65	77.95	278100.0
2006-04-17	ABM	Stock	17.2	17.3	17.08	17.21	210400.0
2006-04-17	ABMD-DELISTED	Stock	13.4	13.4	12.89	13.16	69471.0
2006-04-17	ABP-DELISTED	Stock	5.25	5.3	5.14	5.17	680000.0
2006-04-17	ABR	Stock	25.61	25.8	25.0	25.18	119500.0
2006-04-17	ABT	Stock	19.8541	19.9453	19.7198	19.7342	6656732.0
2006-04-17	ABTL-DELISTED	Stock	21.7	21.85	21.4	21.65	21269.0
2006-04-17	ABV-DELISTED	Stock	44.5	45.35	44.5	45.26	222000.0
2006-04-17	ABX-DELISTED	Stock	29.4	30.19	29.32	30.14	5267400.0
2006-04-17	ACAD	Stock	14.76	15.01	14.59	14.9	192100.0
2006-04-17	ACAP-DELISTED	Stock	45.7	46.53	45.7	46.19	34406.0
2006-04-17	ACAS-DELISTED	Stock	34.26	34.49	33.82	34.05	1091002.0
2006-04-17	ACAT-DELISTED	Stock	20.98	21.45	20.3	20.73	142716.0
2006-04-17	ACC-DELISTED	Stock	25.12	25.23	25.0	25.19	75000.0
2006-04-17	ACCL-DELISTED	Stock	7.34	7.37	7.24	7.27	67244.0
2006-04-17	ACCO	Stock	22.08	22.36	22.06	22.16	77000.0
2006-04-17	ACCP-DELISTED	Stock	1.1	1.1	1.1	1.1	7500.0

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

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