PREVIEW / stock_daily / 2007-03-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-20.parquet
  size:    161 KB
  rows:    4,873
  symbols: 3,063

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-20	AAPL	Stock	3.2625	3.28	3.2521	3.2671	488916400.0
2007-03-20	MSFT	Stock	27.93	28.16	27.76	27.84	47902400.0
2007-03-20	NVDA	Stock	0.4733	0.4842	0.4707	0.4725	656490000.0
2007-03-20	AMZN	Stock	1.9265	1.9345	1.9115	1.929	76026000.0
2007-03-20	TLT	Stock	89.91	89.95	89.69	89.71	768400.0
2007-03-20	CL	Stock	32.65	32.955	32.625	32.905	3341200.0
2007-03-20	A	Stock	22.8183	23.1903	22.7611	22.9328	3546446.0
2007-03-20	AABA-DELISTED	Stock	30.0	30.3500003814697	29.9400005340576	30.3299999237061	12203800.0
2007-03-20	AACC-DELISTED	Stock	15.22	15.47	15.18	15.25	114651.0
2007-03-20	AACQ-DELISTED	Stock	4.5	4.55	4.5	4.54	39555.0
2007-03-20	AACQW-DELISTED	Stock	0.63	0.63	0.6	0.6	26000.0
2007-03-20	AAI-DELISTED	Stock	9.88	10.1	9.86	10.04	1711300.0
2007-03-20	AAIC-DELISTED	Stock	106.6	112.0	104.8	108.4	3542900.0
2007-03-20	AAME	Stock	3.98	4.0	3.96	3.96	1700.0
2007-03-20	AAON	Stock	3.5503	3.5885	3.5305	3.5621	125297.0
2007-03-20	AAP	Stock	39.18	39.27	38.66	38.83	875900.0
2007-03-20	AATI-DELISTED	Stock	6.87	6.92	6.73	6.8	329989.0
2007-03-20	AAU-DELISTED	Stock	2.09	2.12	1.98	2.0	141300.0
2007-03-20	AAUAF-DELISTED	Stock	2.09	2.12	1.98	2.0	141300.0
2007-03-20	AAV-DELISTED	Stock	9.96	10.19	9.95	10.15	924175.0
2007-03-20	AAWW-DELISTED	Stock	52.86	53.78	52.86	53.72	99452.0
2007-03-20	AAXN-DELISTED	Stock	8.10000038146973	8.27000045776367	8.06999969482422	8.19999980926514	1020400.0
2007-03-20	AB	Stock	82.53	83.56	82.42	83.0	153800.0
2007-03-20	ABAX-DELISTED	Stock	23.04	23.52	22.9	23.51	229205.0
2007-03-20	ABB-DELISTED	Stock	16.92	17.07	16.89	17.04	1453400.0
2007-03-20	ABBC-DELISTED	Stock	19.72	19.74	19.65	19.66	11825.0
2007-03-20	ABC-DELISTED	Stock	26.6	26.65	26.29	26.4	1951200.0
2007-03-20	ABCB	Stock	22.7598	23.6157	22.7598	23.3628	58912.0
2007-03-20	ABCO-DELISTED	Stock	25.62	25.68	25.28	25.46	166532.0
2007-03-20	ABCW-DELISTED	Stock	28.04	28.34	28.04	28.22	34310.0
2007-03-20	ABD-DELISTED	Stock	22.15	22.45	22.1	22.33	208500.0
2007-03-20	ABE-DELISTED	Stock	17.7	17.85	17.5	17.84	31400.0
2007-03-20	ABFS-DELISTED	Stock	36.07	37.72	36.07	37.6	501376.0
2007-03-20	ABG	Stock	28.42	28.7	28.27	28.5	414900.0
2007-03-20	ABK-DELISTED	Stock	87.0	87.97	86.7	87.33	774900.0
2007-03-20	ABM	Stock	26.08	26.23	25.93	26.0	404000.0
2007-03-20	ABMD-DELISTED	Stock	12.25	13.78	12.19	13.49	789473.0
2007-03-20	ABP-DELISTED	Stock	3.09	3.1	3.0	3.05	75200.0
2007-03-20	ABR	Stock	30.25	30.44	29.85	30.29	101900.0
2007-03-20	ABT	Stock	25.5446	26.1395	25.4438	26.1395	17536890.0
2007-03-20	ABTL-DELISTED	Stock	16.976	17.026	16.174	16.274	42441.0
2007-03-20	ABV-DELISTED	Stock	52.02	52.76	51.78	52.76	352300.0
2007-03-20	ABVA-DELISTED	Stock	15.25	15.28	15.13	15.27	1100.0
2007-03-20	ABX-DELISTED	Stock	28.88	28.92	28.62	28.65	4969242.0
2007-03-20	ACAD	Stock	13.24	15.84	12.65	14.55	12562600.0
2007-03-20	ACAP-DELISTED	Stock	37.66	38.0	37.27	38.0	49774.0
2007-03-20	ACAS-DELISTED	Stock	44.55	45.09	44.47	44.7	1358121.0
2007-03-20	ACAT-DELISTED	Stock	19.21	19.71	18.98	19.67	63211.0
2007-03-20	ACC-DELISTED	Stock	30.33	30.69	30.2	30.55	138100.0
2007-03-20	ACCL-DELISTED	Stock	6.4	6.43	6.35	6.39	41080.0

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

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