PREVIEW / stock_daily / 2007-03-29

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-29.parquet
  size:    161 KB
  rows:    4,864
  symbols: 3,052

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
2007-03-29	AAPL	Stock	3.3639	3.3639	3.2939	3.3482	725723600.0
2007-03-29	MSFT	Stock	27.84	27.85	27.49	27.75	42629900.0
2007-03-29	NVDA	Stock	0.4942	0.4948	0.4705	0.4783	719016000.0
2007-03-29	AMZN	Stock	1.9825	1.996	1.965	1.9905	128104000.0
2007-03-29	TLT	Stock	88.54	88.67	88.32	88.45	823000.0
2007-03-29	CL	Stock	33.525	33.54	33.285	33.42	3706600.0
2007-03-29	A	Stock	24.1488	24.2918	23.9485	24.113	5008195.0
2007-03-29	AABA-DELISTED	Stock	31.7099990844727	31.7299995422363	30.8299999237061	31.3400001525879	13815000.0
2007-03-29	AACC-DELISTED	Stock	15.52	15.55	15.3	15.4	77252.0
2007-03-29	AACQ-DELISTED	Stock	4.25	4.34	4.25	4.3	9100.0
2007-03-29	AACQW-DELISTED	Stock	0.56	0.56	0.56	0.56	12000.0
2007-03-29	AAI-DELISTED	Stock	10.37	10.43	9.99	10.17	1860300.0
2007-03-29	AAIC-DELISTED	Stock	111.0	112.4	108.6	110.2	4145400.0
2007-03-29	AAME	Stock	3.96	4.0	3.55	3.98	21400.0
2007-03-29	AAON	Stock	3.3988	3.3988	3.3133	3.3712	324253.0
2007-03-29	AAP	Stock	38.94	39.02	38.2	38.35	1793500.0
2007-03-29	AATI-DELISTED	Stock	6.65	6.67	6.52	6.6	169591.0
2007-03-29	AAU-DELISTED	Stock	2.12	2.15	2.12	2.15	19100.0
2007-03-29	AAUAF-DELISTED	Stock	2.12	2.15	2.12	2.15	19100.0
2007-03-29	AAV-DELISTED	Stock	10.64	10.642	10.41	10.4479	539600.0
2007-03-29	AAWW-DELISTED	Stock	52.5	53.1	52.15	52.74	143012.0
2007-03-29	AAXN-DELISTED	Stock	8.22000026702881	8.23999977111816	7.98000001907349	8.02999973297119	804200.0
2007-03-29	AB	Stock	87.97	89.53	87.76	88.5	405900.0
2007-03-29	ABAX-DELISTED	Stock	24.93	25.0	24.55	24.64	281443.0
2007-03-29	ABB-DELISTED	Stock	17.14	17.23	17.04	17.18	1398800.0
2007-03-29	ABBC-DELISTED	Stock	19.89	19.98	19.74	19.79	8979.0
2007-03-29	ABC-DELISTED	Stock	26.02	26.95	26.02	26.72	2401656.0
2007-03-29	ABCB	Stock	23.7422	23.7422	22.4583	23.2073	44415.0
2007-03-29	ABCO-DELISTED	Stock	25.24	25.37	25.0	25.35	154928.0
2007-03-29	ABCW-DELISTED	Stock	28.03	28.36	27.89	28.35	71310.0
2007-03-29	ABD-DELISTED	Stock	23.56	23.81	23.44	23.79	570400.0
2007-03-29	ABE-DELISTED	Stock	18.98	19.01	18.61	18.67	30100.0
2007-03-29	ABFS-DELISTED	Stock	35.65	35.7	35.11	35.15	518938.0
2007-03-29	ABG	Stock	28.15	28.28	27.67	27.95	366600.0
2007-03-29	ABK-DELISTED	Stock	87.31	87.64	86.16	86.28	641900.0
2007-03-29	ABM	Stock	26.42	26.43	26.02	26.15	319900.0
2007-03-29	ABMD-DELISTED	Stock	13.56	13.8	13.42	13.8	138449.0
2007-03-29	ABP-DELISTED	Stock	3.21	3.23	3.17	3.18	168200.0
2007-03-29	ABR	Stock	29.91	30.2	29.69	30.05	84400.0
2007-03-29	ABT	Stock	26.3986	26.9408	26.3938	26.7776	17924343.0
2007-03-29	ABTL-DELISTED	Stock	17.15	17.5	16.9	17.2	22527.0
2007-03-29	ABV-DELISTED	Stock	53.5	54.31	53.27	54.28	427600.0
2007-03-29	ABVA-DELISTED	Stock	15.81	15.81	15.5	15.51	3056.0
2007-03-29	ABVT-DELISTED	Stock	59.5	59.5	59.0	59.0	800.0
2007-03-29	ABX-DELISTED	Stock	28.83	29.05	28.55	28.84	4236600.0
2007-03-29	ACAD	Stock	15.85	16.75	15.78	16.5	1076600.0
2007-03-29	ACAP-DELISTED	Stock	39.02	39.11	38.63	38.85	35463.0
2007-03-29	ACAS-DELISTED	Stock	44.62	44.75	43.81	44.23	1537361.0
2007-03-29	ACAT-DELISTED	Stock	19.18	19.45	18.75	19.27	61371.0
2007-03-29	ACC-DELISTED	Stock	30.1	30.13	29.51	29.62	113600.0

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

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