PREVIEW / stock_daily / 2007-04-27

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-27.parquet
  size:    163 KB
  rows:    4,913
  symbols: 3,070

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-04-27	AAPL	Stock	3.5064	3.5696	3.4889	3.5686	699403600.0
2007-04-27	MSFT	Stock	30.17	30.74	30.0	30.12	128298800.0
2007-04-27	NVDA	Stock	0.5568	0.563	0.5423	0.5512	554058000.0
2007-04-27	AMZN	Stock	3.062	3.192	3.031	3.13	1014668000.0
2007-04-27	TLT	Stock	88.01	88.05	87.78	87.83	428640.0
2007-04-27	CL	Stock	33.205	33.62	33.16	33.52	5057200.0
2007-04-27	A	Stock	24.9285	25.0644	24.7568	24.8283	4155555.0
2007-04-27	AABA-DELISTED	Stock	28.42	28.86	28.23	28.34	15007083.0
2007-04-27	AACC-DELISTED	Stock	18.55	18.67	18.44	18.5	400215.0
2007-04-27	AAI-DELISTED	Stock	11.48	11.49	11.13	11.2	2577509.0
2007-04-27	AAIC-DELISTED	Stock	118.4	118.6	114.0	115.6	4144100.0
2007-04-27	AAME	Stock	4.88	5.3	4.88	5.23	11900.0
2007-04-27	AAON	Stock	3.4739	3.4739	3.3119	3.3185	118462.0
2007-04-27	AAP	Stock	41.78	41.91	41.29	41.67	568000.0
2007-04-27	AATI-DELISTED	Stock	7.66	8.3	7.64	8.05	2000463.0
2007-04-27	AAU-DELISTED	Stock	2.6	2.61	2.51	2.51	25000.0
2007-04-27	AAUAF-DELISTED	Stock	2.6	2.61	2.51	2.51	25000.0
2007-04-27	AAV-DELISTED	Stock	11.22	11.35	11.2	11.27	356700.0
2007-04-27	AAWW-DELISTED	Stock	59.22	59.26	57.71	58.85	102547.0
2007-04-27	AAXN-DELISTED	Stock	8.0600004196167	8.27000045776367	7.98999977111816	8.27000045776367	1491100.0
2007-04-27	AB	Stock	92.2	92.73	90.61	91.73	236800.0
2007-04-27	ABAX-DELISTED	Stock	24.62	24.64	22.64	23.05	794547.0
2007-04-27	ABB-DELISTED	Stock	20.34	20.38	20.16	20.33	3200416.0
2007-04-27	ABBC-DELISTED	Stock	19.51	19.59	19.03	19.05	10063.0
2007-04-27	ABC-DELISTED	Stock	25.35	25.35	24.9	25.18	4344554.0
2007-04-27	ABCB	Stock	23.1294	23.3628	22.7306	22.8181	27657.0
2007-04-27	ABCO-DELISTED	Stock	23.65	23.87	23.52	23.67	227649.0
2007-04-27	ABCW-DELISTED	Stock	28.31	28.31	27.66	27.71	34140.0
2007-04-27	ABD-DELISTED	Stock	24.21	24.24	23.9	23.9	616920.0
2007-04-27	ABE-DELISTED	Stock	21.8	21.8	21.5	21.58	20800.0
2007-04-27	ABFS-DELISTED	Stock	39.55	39.9	39.0	39.5	725696.0
2007-04-27	ABG	Stock	29.57	30.0	29.5	29.82	464900.0
2007-04-27	ABK-DELISTED	Stock	92.45	93.35	92.14	93.09	1003000.0
2007-04-27	ABM	Stock	28.65	28.8	28.5	28.69	265300.0
2007-04-27	ABMD-DELISTED	Stock	13.41	13.52	13.22	13.28	95241.0
2007-04-27	ABP-DELISTED	Stock	3.3	3.44	3.28	3.43	268200.0
2007-04-27	ABR	Stock	31.72	31.97	31.4	31.63	46800.0
2007-04-27	ABT	Stock	27.1567	27.4206	26.9264	27.2334	11226344.0
2007-04-27	ABTL-DELISTED	Stock	16.563	16.814	15.961	16.637	63760.0
2007-04-27	ABV-DELISTED	Stock	58.83	59.28	58.48	58.89	368500.0
2007-04-27	ABX-DELISTED	Stock	28.5	28.61	28.21	28.58	3924019.0
2007-04-27	ACAD	Stock	13.84	14.0	13.52	13.65	357600.0
2007-04-27	ACAP-DELISTED	Stock	39.84	40.82	39.6	40.63	79179.0
2007-04-27	ACAS-DELISTED	Stock	48.36	48.94	48.16	48.79	774577.0
2007-04-27	ACAT-DELISTED	Stock	18.12	18.32	18.0	18.11	50487.0
2007-04-27	ACC-DELISTED	Stock	30.84	31.68	30.71	30.97	185300.0
2007-04-27	ACCL-DELISTED	Stock	6.5	6.54	6.45	6.51	44933.0
2007-04-27	ACCO	Stock	24.21	24.24	23.9	23.9	619900.0
2007-04-27	ACCP-DELISTED	Stock	5.05	5.1	4.75	4.78	40720.0
2007-04-27	ACE-DELISTED	Stock	59.99	60.43	59.52	60.37	805900.0

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

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