PREVIEW / stock_daily / 2006-04-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-27.parquet
  size:    147 KB
  rows:    4,405
  symbols: 2,781

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-27	AAPL	Stock	2.4189	2.495	2.4054	2.4771	845947200.0
2006-04-27	MSFT	Stock	26.97	27.63	26.94	27.25	96509600.0
2006-04-27	NVDA	Stock	0.4767	0.4907	0.4663	0.4862	462966000.0
2006-04-27	AMZN	Stock	1.7755	1.7935	1.765	1.787	118650000.0
2006-04-27	CL	Stock	29.87	29.87	29.445	29.72	6648400.0
2006-04-27	A	Stock	27.711	28.2833	27.6609	27.897	4104248.0
2006-04-27	AABA-DELISTED	Stock	32.7900009155273	33.5	32.4000015258789	33.2000007629395	19635700.0
2006-04-27	AACC-DELISTED	Stock	20.79	20.94	20.31	20.66	58066.0
2006-04-27	AACQ-DELISTED	Stock	5.36	5.36	5.36	5.36	2000.0
2006-04-27	AACQU-DELISTED	Stock	6.7	6.7	6.7	6.7	1000.0
2006-04-27	AACQW-DELISTED	Stock	0.69	0.7	0.69	0.7	84000.0
2006-04-27	AAI-DELISTED	Stock	15.45	15.5	14.67	14.67	3144000.0
2006-04-27	AAIC-DELISTED	Stock	192.0	209.0	192.0	207.0	5087800.0
2006-04-27	AAME	Stock	3.11	3.16	2.69	2.91	10200.0
2006-04-27	AAON	Stock	3.6214	3.6214	3.3857	3.5147	601425.0
2006-04-27	AAP	Stock	38.65	39.95	38.43	39.88	2231400.0
2006-04-27	AATI-DELISTED	Stock	11.34	11.45	11.24	11.25	174252.0
2006-04-27	AAU-DELISTED	Stock	2.83	2.83	2.7	2.76	37400.0
2006-04-27	AAUAF-DELISTED	Stock	2.83	2.83	2.7	2.76	37400.0
2006-04-27	AAV-DELISTED	Stock	19.37	19.37	19.01	19.11	299300.0
2006-04-27	AAWW-DELISTED	Stock	46.0	48.0	46.0	46.0	12300.0
2006-04-27	AAXN-DELISTED	Stock	10.8999996185303	11.0	10.5100002288818	10.5200004577637	1538300.0
2006-04-27	AB	Stock	69.25	70.11	67.5	68.3	334300.0
2006-04-27	ABAX-DELISTED	Stock	26.16	26.38	23.18	23.52	918240.0
2006-04-27	ABB-DELISTED	Stock	14.0	14.2499	13.9216	14.09	3552100.0
2006-04-27	ABBC-DELISTED	Stock	13.5	13.57	13.5	13.57	2172.0
2006-04-27	ABC-DELISTED	Stock	21.75	21.9	21.52	21.64	6935200.0
2006-04-27	ABCB	Stock	22.1762	22.361	21.7774	22.1373	12646.0
2006-04-27	ABCO-DELISTED	Stock	27.41	27.74	26.84	27.66	76110.0
2006-04-27	ABCW-DELISTED	Stock	28.5	29.26	28.43	28.65	24020.0
2006-04-27	ABD-DELISTED	Stock	21.95	22.02	21.7	21.73	54200.0
2006-04-27	ABE-DELISTED	Stock	13.55	13.77	13.55	13.67	17100.0
2006-04-27	ABFS-DELISTED	Stock	42.85	44.2	42.25	43.16	373269.0
2006-04-27	ABG	Stock	18.7	19.49	18.62	19.0	110600.0
2006-04-27	ABK-DELISTED	Stock	81.44	82.33	80.62	82.06	652500.0
2006-04-27	ABM	Stock	17.6	17.93	17.31	17.61	274300.0
2006-04-27	ABMD-DELISTED	Stock	13.08	13.25	12.59	12.89	66230.0
2006-04-27	ABP-DELISTED	Stock	6.07	6.09	5.87	5.97	272500.0
2006-04-27	ABR	Stock	25.1	25.68	25.01	25.49	88000.0
2006-04-27	ABT	Stock	19.6382	20.2476	19.6382	20.166	11115256.0
2006-04-27	ABTL-DELISTED	Stock	22.2	22.5	21.61	22.35	29818.0
2006-04-27	ABV-DELISTED	Stock	47.0	47.54	46.29	46.43	360800.0
2006-04-27	ABVA-DELISTED	Stock	18.75	18.85	18.723	18.723	1900.0
2006-04-27	ABVT-DELISTED	Stock	40.0	40.0	40.0	40.0	50000.0
2006-04-27	ABX-DELISTED	Stock	30.04	30.99	29.52	29.59	4097100.0
2006-04-27	ACAD	Stock	13.37	13.9	12.4	12.72	851400.0
2006-04-27	ACAP-DELISTED	Stock	48.71	49.17	47.5	48.2	30572.0
2006-04-27	ACAS-DELISTED	Stock	33.62	34.71	33.53	34.55	1077796.0
2006-04-27	ACAT-DELISTED	Stock	21.5	21.78	20.93	21.61	38531.0
2006-04-27	ACC-DELISTED	Stock	23.9	24.23	23.67	24.05	111000.0

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

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