PREVIEW / stock_daily / 2007-06-28

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-28.parquet
  size:    176 KB
  rows:    5,379
  symbols: 3,222

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-28	AAPL	Stock	4.37	4.3746	4.2857	4.3057	838143600.0
2007-06-28	MSFT	Stock	29.86	29.97	29.68	29.83	46055200.0
2007-06-28	NVDA	Stock	0.6952	0.7073	0.6883	0.6998	597534000.0
2007-06-28	AMZN	Stock	3.423	3.5115	3.4075	3.4445	195644000.0
2007-06-28	TLT	Stock	84.32	84.58	84.18	84.3	3612493.0
2007-06-28	CL	Stock	32.17	32.74	32.08	32.68	5541600.0
2007-06-28	A	Stock	27.5393	27.7825	27.2175	27.525	2670040.0
2007-06-28	AABA-DELISTED	Stock	27.44	27.49	27.12	27.2401	16648499.0
2007-06-28	AACC-DELISTED	Stock	17.7	17.91	17.4525	17.89	270792.0
2007-06-28	AAI-DELISTED	Stock	11.25	11.25	10.89	10.89	1966900.0
2007-06-28	AAIC-DELISTED	Stock	110.0	112.8	108.0	112.0	1177700.0
2007-06-28	AAME	Stock	3.99	3.99	3.85	3.94	14200.0
2007-06-28	AAON	Stock	4.2206	4.2298	4.1942	4.2179	455625.0
2007-06-28	AAP	Stock	41.17	41.17	40.67	40.82	900400.0
2007-06-28	AATI-DELISTED	Stock	9.68	9.74	9.41	9.62	440451.0
2007-06-28	AAU-DELISTED	Stock	2.22	2.25	2.21	2.24	48600.0
2007-06-28	AAUAF-DELISTED	Stock	2.22	2.25	2.21	2.24	48600.0
2007-06-28	AAV-DELISTED	Stock	14.08	14.14	13.64	13.9	735500.0
2007-06-28	AAWW-DELISTED	Stock	58.6	59.96	58.48	59.72	149405.0
2007-06-28	AAXN-DELISTED	Stock	13.78	13.8	13.31	13.41	2895778.0
2007-06-28	AB	Stock	87.37	88.6	86.96	88.09	286900.0
2007-06-28	ABAX-DELISTED	Stock	21.08	21.17	20.97	21.09	354845.0
2007-06-28	ABB-DELISTED	Stock	22.33	22.59	22.32	22.46	2085000.0
2007-06-28	ABBC-DELISTED	Stock	10.3	10.3	9.57	9.6	1709748.0
2007-06-28	ABBNY-DELISTED	Stock	22.33	22.59	22.32	22.46	2112500.0
2007-06-28	ABC-DELISTED	Stock	25.01	25.12	24.76	24.82	1609098.0
2007-06-28	ABCB	Stock	22.7987	23.1294	22.7112	23.0322	51304.0
2007-06-28	ABCO-DELISTED	Stock	27.77	28.42	27.77	28.35	373099.0
2007-06-28	ABCW-DELISTED	Stock	26.74	27.02	26.63	26.63	170930.0
2007-06-28	ABD-DELISTED	Stock	23.88	24.19	23.77	23.99	179900.0
2007-06-28	ABE-DELISTED	Stock	20.851	21.1	20.851	21.05	8900.0
2007-06-28	ABEO	Stock	6312.5	6312.5	6250.0	6312.5	8.0
2007-06-28	ABFS-DELISTED	Stock	39.72	40.19	39.04	39.78	578943.0
2007-06-28	ABG	Stock	24.93	25.28	24.73	25.13	296800.0
2007-06-28	ABK-DELISTED	Stock	86.53	88.65	86.5	87.89	2194580.0
2007-06-28	ABM	Stock	25.38	26.26	25.31	25.85	302100.0
2007-06-28	ABMD-DELISTED	Stock	11.25	11.28	10.95	11.0	138619.0
2007-06-28	ABP-DELISTED	Stock	4.31	4.68	4.31	4.53	456100.0
2007-06-28	ABR	Stock	26.22	26.48	26.06	26.25	217000.0
2007-06-28	ABT	Stock	25.8948	25.9092	25.6837	25.7749	9635473.0
2007-06-28	ABTL-DELISTED	Stock	20.85	21.05	20.7	20.95	23101.0
2007-06-28	ABV-DELISTED	Stock	68.9	69.88	68.13	69.27	812300.0
2007-06-28	ABVA-DELISTED	Stock	13.1	13.16	13.0375	13.1	2230.0
2007-06-28	ABX-DELISTED	Stock	28.87	29.07	28.73	28.78	5381300.0
2007-06-28	ACAD	Stock	14.2	14.25	13.89	14.0	395200.0
2007-06-28	ACAP-DELISTED	Stock	40.69	41.28	39.99	40.72	33217.0
2007-06-28	ACAS-DELISTED	Stock	42.42	43.3	42.26	43.12	1763858.0
2007-06-28	ACAT-DELISTED	Stock	20.35	20.35	20.04	20.15	43780.0
2007-06-28	ACC-DELISTED	Stock	27.16	28.31	27.16	28.1	161200.0
2007-06-28	ACCL-DELISTED	Stock	5.94	6.26	5.94	6.1	110669.0

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

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