PREVIEW / stock_daily / 2006-03-31

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-31.parquet
  size:    148 KB
  rows:    4,386
  symbols: 2,773

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-03-31	AAPL	Stock	2.2589	2.2718	2.2229	2.24	815357200.0
2006-03-31	MSFT	Stock	27.3	27.54	27.21	27.21	62190500.0
2006-03-31	NVDA	Stock	0.4786	0.4852	0.4742	0.4772	835560000.0
2006-03-31	AMZN	Stock	1.834	1.8385	1.824	1.8265	53180000.0
2006-03-31	CL	Stock	29.01	29.1	28.55	28.55	5275000.0
2006-03-31	A	Stock	26.681	26.9313	26.681	26.8598	3822412.0
2006-03-31	AABA-DELISTED	Stock	32.4500007629395	32.6300010681152	32.0099983215332	32.2599983215332	12677300.0
2006-03-31	AACC-DELISTED	Stock	19.51	19.64	19.4	19.46	243356.0
2006-03-31	AACQU-DELISTED	Stock	6.88	6.88	6.8	6.88	102400.0
2006-03-31	AACQW-DELISTED	Stock	0.77	0.77	0.73	0.73	96000.0
2006-03-31	AAI-DELISTED	Stock	17.87	18.2	17.82	18.08	1020800.0
2006-03-31	AAIC-DELISTED	Stock	185.0	188.0	183.6	187.6	850700.0
2006-03-31	AAME	Stock	2.78	2.85	2.78	2.81	3600.0
2006-03-31	AAON	Stock	3.0802	3.1486	3.0328	3.1486	154153.0
2006-03-31	AAP	Stock	41.54	41.92	41.51	41.64	453200.0
2006-03-31	AATI-DELISTED	Stock	11.45	11.55	11.35	11.4	358578.0
2006-03-31	AAU-DELISTED	Stock	2.84	2.9	2.77	2.8	31100.0
2006-03-31	AAUAF-DELISTED	Stock	2.84	2.9	2.77	2.8	31100.0
2006-03-31	AAV-DELISTED	Stock	19.38	19.4	19.2	19.21	197200.0
2006-03-31	AAWW-DELISTED	Stock	47.25	47.6	47.0	47.1	15600.0
2006-03-31	AAXN-DELISTED	Stock	10.5900001525879	10.6400003433228	10.460000038147	10.5900001525879	553200.0
2006-03-31	AB	Stock	65.87	66.49	65.86	66.25	198400.0
2006-03-31	ABAX-DELISTED	Stock	22.36	22.96	22.3	22.7	409273.0
2006-03-31	ABB-DELISTED	Stock	12.62	12.65	12.5	12.54	1246400.0
2006-03-31	ABBC-DELISTED	Stock	13.5	13.68	13.5	13.61	49279.0
2006-03-31	ABC-DELISTED	Stock	23.94	24.32	23.85	24.16	2920800.0
2006-03-31	ABCB	Stock	22.468	22.7598	22.4194	22.6237	42976.0
2006-03-31	ABCO-DELISTED	Stock	27.96	28.3	27.62	27.88	213114.0
2006-03-31	ABCW-DELISTED	Stock	30.0	30.33	29.82	30.33	40430.0
2006-03-31	ABD-DELISTED	Stock	22.01	22.25	22.0	22.17	236960.0
2006-03-31	ABE-DELISTED	Stock	12.57	12.64	12.57	12.61	11500.0
2006-03-31	ABFS-DELISTED	Stock	40.42	40.42	38.9	39.11	788679.0
2006-03-31	ABG	Stock	19.91	19.94	19.49	19.72	98200.0
2006-03-31	ABK-DELISTED	Stock	79.4	79.97	79.07	79.57	959600.0
2006-03-31	ABM	Stock	18.55	19.17	18.55	19.17	301000.0
2006-03-31	ABMD-DELISTED	Stock	12.8	12.9	12.62	12.8	197434.0
2006-03-31	ABP-DELISTED	Stock	5.85	5.85	5.71	5.82	528000.0
2006-03-31	ABR	Stock	27.2	27.29	26.85	26.99	98400.0
2006-03-31	ABT	Stock	20.4587	20.6122	20.3051	20.3771	8415798.0
2006-03-31	ABTL-DELISTED	Stock	23.78	24.27	23.33	24.17	24360.0
2006-03-31	ABV-DELISTED	Stock	42.0	43.23	41.59	42.95	439000.0
2006-03-31	ABX-DELISTED	Stock	27.41	27.82	27.0401	27.21	3772900.0
2006-03-31	ACAD	Stock	15.86	16.25	15.71	15.98	251300.0
2006-03-31	ACAP-DELISTED	Stock	46.77	47.84	46.54	47.83	52797.0
2006-03-31	ACAS-DELISTED	Stock	35.05	35.23	34.9051	35.18	1838911.0
2006-03-31	ACAT-DELISTED	Stock	24.11	24.15	23.84	24.06	58790.0
2006-03-31	ACC-DELISTED	Stock	25.91	26.11	25.31	25.91	50500.0
2006-03-31	ACCL-DELISTED	Stock	7.23	7.34	7.1	7.25	348329.0
2006-03-31	ACCO	Stock	21.98	22.23	21.98	22.2	248600.0
2006-03-31	ACCP-DELISTED	Stock	1.55	1.55	1.3	1.3	48978.0

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

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