PREVIEW / stock_daily / 2007-03-27

all stock daily files

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

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-27	AAPL	Stock	3.4182	3.4582	3.3929	3.4093	932052800.0
2007-03-27	MSFT	Stock	28.04	28.16	27.65	27.72	58979800.0
2007-03-27	NVDA	Stock	0.5047	0.5057	0.4958	0.4963	469020000.0
2007-03-27	AMZN	Stock	1.941	1.971	1.938	1.9685	79872000.0
2007-03-27	TLT	Stock	88.64	88.81	88.56	88.75	619800.0
2007-03-27	CL	Stock	33.36	33.395	33.13	33.235	2728000.0
2007-03-27	A	Stock	23.8197	24.1845	23.7268	24.0558	4205743.0
2007-03-27	AABA-DELISTED	Stock	31.5599994659424	31.6599998474121	31.2399997711182	31.5499992370605	9403100.0
2007-03-27	AACC-DELISTED	Stock	15.63	15.65	15.54	15.59	47483.0
2007-03-27	AACQ-DELISTED	Stock	4.38	4.38	4.3	4.3	12000.0
2007-03-27	AACQU-DELISTED	Stock	5.5	5.5	5.5	5.5	500.0
2007-03-27	AACQW-DELISTED	Stock	0.59	0.59	0.57	0.59	14500.0
2007-03-27	AAI-DELISTED	Stock	10.44	10.51	10.26	10.36	1971400.0
2007-03-27	AAIC-DELISTED	Stock	109.8	111.4	107.4	108.4	2322000.0
2007-03-27	AAME	Stock	3.97	3.97	3.54	3.94	4100.0
2007-03-27	AAON	Stock	3.4897	3.5411	3.4357	3.437	91125.0
2007-03-27	AAP	Stock	39.21	39.26	38.7	38.99	583300.0
2007-03-27	AATI-DELISTED	Stock	6.66	6.96	6.66	6.74	250177.0
2007-03-27	AAU-DELISTED	Stock	2.11	2.13	2.08	2.09	25800.0
2007-03-27	AAUAF-DELISTED	Stock	2.11	2.13	2.08	2.09	25800.0
2007-03-27	AAV-DELISTED	Stock	10.79	10.79	10.7	10.76	661500.0
2007-03-27	AAWW-DELISTED	Stock	52.99	53.6	52.85	53.0	72935.0
2007-03-27	AAXN-DELISTED	Stock	8.22000026702881	8.3100004196167	8.17000007629395	8.27999973297119	620900.0
2007-03-27	AB	Stock	86.7	87.97	86.49	87.67	280500.0
2007-03-27	ABAX-DELISTED	Stock	25.4	25.48	24.76	25.07	220865.0
2007-03-27	ABB-DELISTED	Stock	17.28	17.35	17.16	17.28	876600.0
2007-03-27	ABBC-DELISTED	Stock	19.69	19.95	19.6	19.66	12088.0
2007-03-27	ABC-DELISTED	Stock	26.76	26.84	26.5	26.66	1759600.0
2007-03-27	ABCB	Stock	24.6856	24.6953	24.034	24.2577	24675.0
2007-03-27	ABCO-DELISTED	Stock	25.47	25.55	25.13	25.22	231556.0
2007-03-27	ABCW-DELISTED	Stock	28.61	28.61	28.06	28.15	23840.0
2007-03-27	ABD-DELISTED	Stock	23.36	24.0	23.2	23.53	932570.0
2007-03-27	ABE-DELISTED	Stock	18.53	18.53	18.3	18.36	14800.0
2007-03-27	ABFS-DELISTED	Stock	36.7	36.7	35.82	35.9	508889.0
2007-03-27	ABG	Stock	28.11	28.14	27.55	27.96	577300.0
2007-03-27	ABK-DELISTED	Stock	86.94	87.88	86.51	86.91	752900.0
2007-03-27	ABM	Stock	26.4	26.49	26.28	26.33	517500.0
2007-03-27	ABMD-DELISTED	Stock	13.41	13.79	13.41	13.71	307066.0
2007-03-27	ABP-DELISTED	Stock	3.2	3.22	3.14	3.18	166500.0
2007-03-27	ABR	Stock	30.6	30.68	30.25	30.4	97000.0
2007-03-27	ABT	Stock	27.2526	27.459	27.0703	27.1567	29693414.0
2007-03-27	ABTL-DELISTED	Stock	17.001	17.299	16.553	17.299	30314.0
2007-03-27	ABV-DELISTED	Stock	54.49	54.49	52.99	53.07	294600.0
2007-03-27	ABVA-DELISTED	Stock	15.1	15.48	15.09	15.48	3250.0
2007-03-27	ABVT-DELISTED	Stock	59.0	59.0	59.0	59.0	400.0
2007-03-27	ABX-DELISTED	Stock	29.04	29.07	28.77	28.93	3534700.0
2007-03-27	ACAD	Stock	15.14	16.84	15.11	16.37	3017400.0
2007-03-27	ACAP-DELISTED	Stock	38.76	38.79	38.24	38.59	31210.0
2007-03-27	ACAS-DELISTED	Stock	44.8	44.8	44.29	44.49	1050400.0
2007-03-27	ACAT-DELISTED	Stock	19.435	19.735	19.335	19.405	33348.0

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

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