PREVIEW / stock_daily / 2007-03-21

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-21.parquet
  size:    162 KB
  rows:    4,874
  symbols: 3,065

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-21	AAPL	Stock	3.2854	3.3571	3.2732	3.3525	686896000.0
2007-03-21	MSFT	Stock	27.9	28.52	27.56	28.52	72808200.0
2007-03-21	NVDA	Stock	0.4917	0.5073	0.4823	0.4995	1268376000.0
2007-03-21	AMZN	Stock	1.9275	1.99	1.9155	1.99	99928000.0
2007-03-21	TLT	Stock	89.38	90.09	88.69	89.75	1513399.0
2007-03-21	CL	Stock	32.965	33.435	32.76	33.405	3109200.0
2007-03-21	A	Stock	22.9971	23.0544	22.804	22.9542	3251608.0
2007-03-21	AABA-DELISTED	Stock	30.3299999237061	31.3899993896484	30.2099990844727	31.2900009155273	26667300.0
2007-03-21	AACC-DELISTED	Stock	15.28	15.5	15.19	15.5	116570.0
2007-03-21	AACQ-DELISTED	Stock	4.55	4.55	4.5	4.55	9750.0
2007-03-21	AACQU-DELISTED	Stock	5.75	5.75	5.7	5.7	2500.0
2007-03-21	AACQW-DELISTED	Stock	0.6	0.6	0.6	0.6	56700.0
2007-03-21	AAI-DELISTED	Stock	10.57	11.09	10.36	11.03	4492500.0
2007-03-21	AAIC-DELISTED	Stock	110.4	118.4	108.8	116.0	5141000.0
2007-03-21	AAME	Stock	3.93	4.0	3.9	4.0	4700.0
2007-03-21	AAON	Stock	3.574	3.6174	3.5345	3.5529	184528.0
2007-03-21	AAP	Stock	38.88	39.49	38.75	39.19	955300.0
2007-03-21	AATI-DELISTED	Stock	6.84	6.99	6.77	6.8	334037.0
2007-03-21	AAU-DELISTED	Stock	2.0	2.05	1.88	2.0	213600.0
2007-03-21	AAUAF-DELISTED	Stock	2.0	2.05	1.88	2.0	213600.0
2007-03-21	AAV-DELISTED	Stock	10.22	10.54	10.2	10.42	715200.0
2007-03-21	AAWW-DELISTED	Stock	53.86	54.29	53.4	54.29	199159.0
2007-03-21	AAXN-DELISTED	Stock	8.26000022888184	8.31999969482422	8.10999965667725	8.31999969482422	708100.0
2007-03-21	AB	Stock	83.58	85.96	83.41	85.1	354800.0
2007-03-21	ABAX-DELISTED	Stock	23.51	24.65	23.37	24.51	370403.0
2007-03-21	ABB-DELISTED	Stock	17.19	17.6	17.1	17.6	2723310.0
2007-03-21	ABBC-DELISTED	Stock	19.7	19.97	19.61	19.97	15225.0
2007-03-21	ABC-DELISTED	Stock	26.47	26.48	26.0	26.45	2897306.0
2007-03-21	ABCB	Stock	23.4796	24.6953	23.2656	24.6953	30433.0
2007-03-21	ABCO-DELISTED	Stock	25.54	26.06	25.27	26.06	137820.0
2007-03-21	ABCW-DELISTED	Stock	28.36	29.04	28.25	28.91	47260.0
2007-03-21	ABD-DELISTED	Stock	22.33	22.99	22.3	22.86	260800.0
2007-03-21	ABE-DELISTED	Stock	17.9	18.28	17.4	18.28	49100.0
2007-03-21	ABFS-DELISTED	Stock	37.58	37.91	36.8	37.83	491878.0
2007-03-21	ABG	Stock	28.38	28.44	28.03	28.15	685100.0
2007-03-21	ABK-DELISTED	Stock	87.59	88.51	87.38	88.14	1044300.0
2007-03-21	ABM	Stock	26.0	26.29	25.92	26.22	385300.0
2007-03-21	ABMD-DELISTED	Stock	13.55	14.23	13.25	14.02	384973.0
2007-03-21	ABP-DELISTED	Stock	3.07	3.09	3.0	3.03	109400.0
2007-03-21	ABR	Stock	30.35	30.66	29.9	30.53	121300.0
2007-03-21	ABT	Stock	26.0531	26.293	26.0052	26.2355	16533556.0
2007-03-21	ABTL-DELISTED	Stock	16.5	18.25	16.3	17.85	41349.0
2007-03-21	ABV-DELISTED	Stock	53.0	54.41	52.63	54.2	411100.0
2007-03-21	ABVA-DELISTED	Stock	15.12	15.22	15.11	15.22	600.0
2007-03-21	ABX-DELISTED	Stock	28.86	29.24	28.57	29.24	5097100.0
2007-03-21	ACAD	Stock	13.95	14.79	13.47	13.72	2999300.0
2007-03-21	ACAP-DELISTED	Stock	38.08	38.86	37.72	38.71	62999.0
2007-03-21	ACAS-DELISTED	Stock	44.68	44.74	44.52	44.66	5550801.0
2007-03-21	ACAT-DELISTED	Stock	19.735	19.975	19.585	19.965	51283.0
2007-03-21	ACC-DELISTED	Stock	30.51	30.99	30.06	30.99	227400.0

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

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