PREVIEW / stock_daily / 2006-03-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-27.parquet
  size:    147 KB
  rows:    4,391
  symbols: 2,783

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-27	AAPL	Stock	2.1554	2.1921	2.1214	2.1254	1108072000.0
2006-03-27	MSFT	Stock	27.01	27.3	27.0	27.01	59908600.0
2006-03-27	NVDA	Stock	0.4332	0.4449	0.4318	0.4446	651444000.0
2006-03-27	AMZN	Stock	1.775	1.783	1.757	1.7625	74170000.0
2006-03-27	CL	Stock	28.935	29.05	28.81	28.885	2576600.0
2006-03-27	A	Stock	26.5522	26.5594	26.2375	26.2375	2823541.0
2006-03-27	AABA-DELISTED	Stock	31.8400001525879	32.0800018310547	31.2999992370605	31.4500007629395	14858500.0
2006-03-27	AACC-DELISTED	Stock	19.1	19.37	19.01	19.24	284237.0
2006-03-27	AACQ-DELISTED	Stock	5.46	5.46	5.46	5.46	500.0
2006-03-27	AACQU-DELISTED	Stock	7.0	7.0	6.88	6.88	3000.0
2006-03-27	AACQW-DELISTED	Stock	0.73	0.78	0.73	0.78	65500.0
2006-03-27	AAI-DELISTED	Stock	17.8	18.11	17.64	17.69	886200.0
2006-03-27	AAIC-DELISTED	Stock	186.6	191.0	186.6	190.0	634000.0
2006-03-27	AAME	Stock	2.83	2.94	2.83	2.94	900.0
2006-03-27	AAON	Stock	3.0051	3.0393	2.9761	3.0393	218700.0
2006-03-27	AAP	Stock	41.95	41.97	41.47	41.73	553200.0
2006-03-27	AATI-DELISTED	Stock	10.65	10.8	10.6	10.68	236473.0
2006-03-27	AAU-DELISTED	Stock	2.73	2.75	2.7	2.75	76000.0
2006-03-27	AAUAF-DELISTED	Stock	2.73	2.75	2.7	2.75	76000.0
2006-03-27	AAV-DELISTED	Stock	19.21	19.56	19.15	19.51	265200.0
2006-03-27	AAWW-DELISTED	Stock	47.5	47.5	46.4	46.5	58000.0
2006-03-27	AAXN-DELISTED	Stock	10.8599996566772	10.9200000762939	10.3500003814697	10.7600002288818	1578000.0
2006-03-27	AB	Stock	64.3	64.4	63.87	64.1	225200.0
2006-03-27	ABAX-DELISTED	Stock	24.42	25.08	24.36	24.58	508006.0
2006-03-27	ABB-DELISTED	Stock	12.05	12.1	11.94	12.02	1018800.0
2006-03-27	ABBC-DELISTED	Stock	13.38	13.38	13.3	13.3425	4813.0
2006-03-27	ABC-DELISTED	Stock	23.54	23.56	23.26	23.48	2062200.0
2006-03-27	ABCB	Stock	21.9137	21.9137	21.5537	21.7191	1234.0
2006-03-27	ABCO-DELISTED	Stock	27.96	27.96	27.3	27.5	310698.0
2006-03-27	ABCW-DELISTED	Stock	29.57	29.94	29.42	29.74	19430.0
2006-03-27	ABD-DELISTED	Stock	21.79	22.12	21.76	22.12	336580.0
2006-03-27	ABE-DELISTED	Stock	12.64	12.81	12.6301	12.7	19800.0
2006-03-27	ABFS-DELISTED	Stock	40.85	41.86	40.85	40.97	239307.0
2006-03-27	ABG	Stock	20.33	20.45	20.01	20.1	25000.0
2006-03-27	ABK-DELISTED	Stock	79.43	79.43	78.44	79.01	629800.0
2006-03-27	ABM	Stock	17.5	17.6	17.38	17.5	207400.0
2006-03-27	ABMD-DELISTED	Stock	13.35	13.4	13.01	13.12	133864.0
2006-03-27	ABP-DELISTED	Stock	5.88	6.01	5.76	5.86	239000.0
2006-03-27	ABR	Stock	27.2	27.25	27.0	27.07	54200.0
2006-03-27	ABT	Stock	21.3991	21.3991	20.7466	20.8521	12580242.0
2006-03-27	ABTL-DELISTED	Stock	22.92	23.13	22.62	23.08	25990.0
2006-03-27	ABV-DELISTED	Stock	41.1	41.86	40.78	41.63	673000.0
2006-03-27	ABVA-DELISTED	Stock	18.949	18.98	18.88	18.911	26419.0
2006-03-27	ABVT-DELISTED	Stock	39.0	39.0	38.0	38.0	21100.0
2006-03-27	ABX-DELISTED	Stock	26.35	26.7	26.3	26.57	4998700.0
2006-03-27	ACAD	Stock	14.62	14.72	14.55	14.58	385000.0
2006-03-27	ACAP-DELISTED	Stock	48.31	48.5	47.83	47.98	24463.0
2006-03-27	ACAS-DELISTED	Stock	35.0	35.67	34.95	35.43	952244.0
2006-03-27	ACAT-DELISTED	Stock	23.99	24.19	23.86	24.11	18409.0
2006-03-27	ACC-DELISTED	Stock	26.57	26.57	25.28	25.74	79200.0

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

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