PREVIEW / stock_daily / 2007-06-27

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-27.parquet
  size:    177 KB
  rows:    5,423
  symbols: 3,265

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-06-27	AAPL	Stock	4.3075	4.3586	4.2593	4.3532	974696800.0
2007-06-27	MSFT	Stock	29.36	29.95	29.36	29.87	53468600.0
2007-06-27	NVDA	Stock	0.675	0.694	0.6717	0.6932	613140000.0
2007-06-27	AMZN	Stock	3.348	3.4105	3.3355	3.407	164858000.0
2007-06-27	TLT	Stock	84.61	84.74	84.2	84.32	6109300.0
2007-06-27	CL	Stock	32.335	32.45	32.205	32.22	5830400.0
2007-06-27	A	Stock	27.3104	27.5823	27.1388	27.5322	2300549.0
2007-06-27	AABA-DELISTED	Stock	27.51	27.655	27.4	27.58	13596117.0
2007-06-27	AACC-DELISTED	Stock	17.05	17.27	16.84	17.25	114093.0
2007-06-27	AAI-DELISTED	Stock	10.7	10.99	10.64	10.99	1172700.0
2007-06-27	AAIC-DELISTED	Stock	108.8	110.4	107.6	110.2	1978200.0
2007-06-27	AAME	Stock	4.04	4.04	3.84	4.0	4300.0
2007-06-27	AAON	Stock	4.1113	4.239	4.1021	4.2232	876319.0
2007-06-27	AAP	Stock	39.31	41.46	39.3	41.02	1837000.0
2007-06-27	AATI-DELISTED	Stock	9.64	9.7	9.48	9.66	242887.0
2007-06-27	AAU-DELISTED	Stock	2.25	2.25	2.22	2.24	39300.0
2007-06-27	AAUAF-DELISTED	Stock	2.25	2.25	2.22	2.24	39300.0
2007-06-27	AAV-DELISTED	Stock	13.57	14.03	13.08	13.97	1431700.0
2007-06-27	AAWW-DELISTED	Stock	57.23	58.99	57.18	58.45	174881.0
2007-06-27	AAXN-DELISTED	Stock	13.09	13.44	12.77	13.26	3321068.0
2007-06-27	AB	Stock	83.4	87.0	83.3	86.99	496100.0
2007-06-27	ABAX-DELISTED	Stock	20.87	21.17	20.78	21.07	287124.0
2007-06-27	ABB-DELISTED	Stock	21.82	22.21	21.74	22.2	1945900.0
2007-06-27	ABBC-DELISTED	Stock	15.87	16.36	15.87	16.27	14587.0
2007-06-27	ABBNY-DELISTED	Stock	21.82	22.21	21.74	22.2	3121800.0
2007-06-27	ABC-DELISTED	Stock	24.62	25.04	24.58	25.02	1345600.0
2007-06-27	ABCB	Stock	21.8261	22.7112	21.8261	22.7112	58089.0
2007-06-27	ABCO-DELISTED	Stock	27.37	27.8	27.28	27.8	345563.0
2007-06-27	ABCW-DELISTED	Stock	26.42	26.84	26.3	26.79	303970.0
2007-06-27	ABD-DELISTED	Stock	23.34	23.88	23.3	23.87	232400.0
2007-06-27	ABE-DELISTED	Stock	20.9	20.95	20.46	20.95	41300.0
2007-06-27	ABEO	Stock	6137.5	6437.5	6087.5	6312.5	34.0
2007-06-27	ABFS-DELISTED	Stock	39.03	40.4	38.85	40.23	404773.0
2007-06-27	ABG	Stock	24.87	25.29	24.53	25.01	466800.0
2007-06-27	ABK-DELISTED	Stock	84.4	85.75	84.2	85.68	1931000.0
2007-06-27	ABM	Stock	24.69	25.38	24.51	25.28	413800.0
2007-06-27	ABMD-DELISTED	Stock	11.1	11.29	11.0	11.27	161454.0
2007-06-27	ABP-DELISTED	Stock	4.3	4.45	4.26	4.4	201300.0
2007-06-27	ABR	Stock	25.72	26.3	25.71	26.26	89500.0
2007-06-27	ABT	Stock	25.7557	25.9284	25.6213	25.8948	11567945.0
2007-06-27	ABTL-DELISTED	Stock	20.72	21.18	20.42	20.93	45158.0
2007-06-27	ABV-DELISTED	Stock	66.3	68.29	66.2	68.24	838800.0
2007-06-27	ABVA-DELISTED	Stock	13.24	13.24	13.0	13.0	3293.0
2007-06-27	ABVT-DELISTED	Stock	55.0	61.0	55.0	61.0	120972.0
2007-06-27	ABX-DELISTED	Stock	28.08	28.68	27.81	28.65	5602559.0
2007-06-27	ACAD	Stock	14.02	14.2	13.93	14.17	453900.0
2007-06-27	ACAP-DELISTED	Stock	39.58	40.64	39.35	40.61	48063.0
2007-06-27	ACAS-DELISTED	Stock	42.39	42.53	40.83	42.53	2432046.0
2007-06-27	ACAT-DELISTED	Stock	20.2	20.6	20.13	20.3	65741.0
2007-06-27	ACC-DELISTED	Stock	27.37	28.16	27.23	28.05	181100.0

> showing 50 of 5,423 rows — these rows as CSV

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