PREVIEW / stock_daily / 2008-03-31

all stock daily files

  file:    by_date/stock_daily/2008/2008-03-31.parquet
  size:    181 KB
  rows:    5,694
  symbols: 3,452

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
2008-03-31	AAPL	Stock	5.1168	5.2039	5.09	5.125	768065200.0
2008-03-31	MSFT	Stock	27.88	28.59	27.84	28.38	46780600.0
2008-03-31	NVDA	Stock	0.4972	0.5065	0.4885	0.4948	569992000.0
2008-03-31	AMZN	Stock	3.5125	3.582	3.4815	3.565	109406000.0
2008-03-31	TLT	Stock	96.11	96.32	95.67	95.89	2546257.0
2008-03-31	CL	Stock	38.97	39.085	38.52	38.955	5186200.0
2008-03-31	A	Stock	21.1087	21.3948	20.9585	21.3376	3144382.0
2008-03-31	AABA-DELISTED	Stock	28.55	29.12	28.27	28.98	16507595.0
2008-03-31	AACC-DELISTED	Stock	9.86	9.86	9.52	9.65	272381.0
2008-03-31	AACG	Stock	8.62	9.04	8.52	8.86	11600.0
2008-03-31	AAI-DELISTED	Stock	6.48	6.66	6.36	6.6	2434448.0
2008-03-31	AAIC-DELISTED	Stock	34.2	35.8	33.0	34.0	1582782.0
2008-03-31	AAME	Stock	1.52	1.56	1.45	1.53	3500.0
2008-03-31	AAON	Stock	3.8835	4.0474	3.8835	3.9565	596362.0
2008-03-31	AAP	Stock	33.56	34.28	33.56	34.05	1112700.0
2008-03-31	AATI-DELISTED	Stock	5.48	5.7	5.4	5.61	1130723.0
2008-03-31	AAU-DELISTED	Stock	2.25	2.39	2.25	2.3	48287.0
2008-03-31	AAUAF-DELISTED	Stock	2.25	2.39	2.25	2.3	51687.0
2008-03-31	AAV-DELISTED	Stock	11.4	11.46	11.21	11.43	453700.0
2008-03-31	AAWW-DELISTED	Stock	53.31	55.18	53.31	54.99	214503.0
2008-03-31	AAXN-DELISTED	Stock	9.6	9.79	9.25	9.39	1178153.0
2008-03-31	AB	Stock	63.89	64.65	62.87	63.38	311900.0
2008-03-31	ABAX-DELISTED	Stock	23.03	23.43	22.96	23.17	201559.0
2008-03-31	ABB-DELISTED	Stock	26.68	27.02	26.61	26.89	3071200.0
2008-03-31	ABBC-DELISTED	Stock	10.31	10.45	10.31	10.36	32181.0
2008-03-31	ABBNY-DELISTED	Stock	26.68	27.02	26.61	26.92	3234100.0
2008-03-31	ABC-DELISTED	Stock	20.49	20.6	20.25	20.52	2538490.0
2008-03-31	ABCB	Stock	15.961	16.0195	15.6206	15.6206	18198.0
2008-03-31	ABCO-DELISTED	Stock	27.0	27.86	26.43	27.44	204367.0
2008-03-31	ABCW-DELISTED	Stock	19.07	19.459	18.91	19.0	110000.0
2008-03-31	ABD-DELISTED	Stock	13.1	13.87	13.1	13.57	393400.0
2008-03-31	ABE-DELISTED	Stock	21.71	22.22	21.71	22.03	12300.0
2008-03-31	ABEO	Stock	1637.5	1875.0	1637.5	1875.0	13.0
2008-03-31	ABFS-DELISTED	Stock	30.91	32.12	30.64	31.88	915932.0
2008-03-31	ABG	Stock	13.69	13.94	13.62	13.76	267900.0
2008-03-31	ABII-DELISTED	Stock	59.64	60.2	58.84	60.0	43952.0
2008-03-31	ABK-DELISTED	Stock	5.75	6.33	5.66	5.77	9638852.0
2008-03-31	ABM	Stock	22.46	22.82	22.13	22.44	229000.0
2008-03-31	ABMD-DELISTED	Stock	13.45	13.45	13.02	13.13	139832.0
2008-03-31	ABP-DELISTED	Stock	3.21	3.32	3.2	3.3	114180.0
2008-03-31	ABR	Stock	15.15	15.56	15.05	15.08	173500.0
2008-03-31	ABT	Stock	25.818	26.5809	25.7269	26.461	20083785.0
2008-03-31	ABTL-DELISTED	Stock	10.2	10.8	9.65	10.8	10916.0
2008-03-31	ABV-DELISTED	Stock	75.9	77.46	74.4	75.5	600806.0
2008-03-31	ABVA-DELISTED	Stock	5.19	5.32	5.19	5.23	4000.0
2008-03-31	ABVT-DELISTED	Stock	67.75	72.0	67.0	71.0	8000.0
2008-03-31	ABX-DELISTED	Stock	45.11	45.31	42.39	43.56	7450956.0
2008-03-31	ACAD	Stock	9.08	9.34	9.05	9.06	146400.0
2008-03-31	ACAP-DELISTED	Stock	47.04	47.05	46.2245	46.37	91223.0
2008-03-31	ACAS-DELISTED	Stock	35.07	35.08	34.08	34.18	2229249.0

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

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