PREVIEW / stock_daily / 2008-06-20

all stock daily files

  file:    by_date/stock_daily/2008/2008-06-20.parquet
  size:    184 KB
  rows:    5,728
  symbols: 3,470

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-06-20	AAPL	Stock	6.4054	6.4643	6.25	6.2596	888367200.0
2008-06-20	MSFT	Stock	28.9	28.92	28.1	28.23	97480400.0
2008-06-20	NVDA	Stock	0.4855	0.4995	0.4852	0.494	741008000.0
2008-06-20	AMZN	Stock	4.155	4.173	4.0255	4.055	131778000.0
2008-06-20	TLT	Stock	89.94	90.07	89.69	89.81	4580862.0
2008-06-20	CL	Stock	35.745	35.745	34.57	34.805	10807400.0
2008-06-20	A	Stock	26.8526	27.0172	26.4664	26.8741	6029574.0
2008-06-20	AABA-DELISTED	Stock	22.43	22.53	21.9	22.04	32571999.0
2008-06-20	AACC-DELISTED	Stock	12.83	12.83	12.53	12.62	152401.0
2008-06-20	AACG	Stock	14.8	15.14	14.8	14.9	13900.0
2008-06-20	AAI-DELISTED	Stock	2.6	2.76	2.36	2.59	4561963.0
2008-06-20	AAIC-DELISTED	Stock	30.0	36.8	25.8	36.8	2649699.0
2008-06-20	AAME	Stock	1.65	1.68	1.6	1.67	6500.0
2008-06-20	AAON	Stock	3.9822	4.0553	3.8716	3.9348	478912.0
2008-06-20	AAP	Stock	40.49	40.5	39.36	39.97	1781000.0
2008-06-20	AATI-DELISTED	Stock	5.65	5.65	5.4	5.46	542517.0
2008-06-20	AAU-DELISTED	Stock	2.11	2.13	1.98	2.01	61685.0
2008-06-20	AAUAF-DELISTED	Stock	2.11	2.13	1.98	2.01	61275.0
2008-06-20	AAV-DELISTED	Stock	13.12	13.36	12.92	12.93	635023.0
2008-06-20	AAWW-DELISTED	Stock	56.47	56.52	54.21	55.45	249828.0
2008-06-20	AAXN-DELISTED	Stock	5.7	5.75	5.52	5.75	1369616.0
2008-06-20	AB	Stock	61.79	61.9	60.61	60.8	321700.0
2008-06-20	ABAX-DELISTED	Stock	29.27	29.545	28.21	28.74	407765.0
2008-06-20	ABB-DELISTED	Stock	30.71	31.0	30.15	30.4	3619278.0
2008-06-20	ABBC-DELISTED	Stock	9.79	9.97	9.68	9.89	71006.0
2008-06-20	ABBNY-DELISTED	Stock	30.71	31.0	30.15	30.38	3621978.0
2008-06-20	ABC-DELISTED	Stock	19.84	19.98	19.65	19.87	3289132.0
2008-06-20	ABCB	Stock	10.7087	10.7964	10.2128	10.2516	192465.0
2008-06-20	ABCO-DELISTED	Stock	21.06	21.07	20.78	20.95	495110.0
2008-06-20	ABCW-DELISTED	Stock	7.59	7.99	7.32	7.96	553360.0
2008-06-20	ABD-DELISTED	Stock	13.94	14.08	13.39	13.63	477630.0
2008-06-20	ABE-DELISTED	Stock	20.5	20.558	20.47	20.47	33667.0
2008-06-20	ABEO	Stock	3750.0	3750.0	3687.5	3687.5	4.0
2008-06-20	ABFS-DELISTED	Stock	40.12	40.3	38.82	39.05	957460.0
2008-06-20	ABG	Stock	13.71	13.85	13.64	13.7	687100.0
2008-06-20	ABII-DELISTED	Stock	63.5	64.0	61.77	63.55	20968.0
2008-06-20	ABK-DELISTED	Stock	1.91	2.03	1.91	2.01	10708359.0
2008-06-20	ABM	Stock	23.53	23.69	23.16	23.59	492300.0
2008-06-20	ABMD-DELISTED	Stock	18.61	18.7	18.14	18.6	458440.0
2008-06-20	ABP-DELISTED	Stock	5.24	5.3	5.0	5.06	649427.0
2008-06-20	ABR	Stock	10.62	10.66	10.21	10.3	357700.0
2008-06-20	ABT	Stock	25.7269	26.0627	25.4726	25.5973	13924760.0
2008-06-20	ABTL-DELISTED	Stock	7.295	7.784	6.805	7.05	37315.0
2008-06-20	ABV-DELISTED	Stock	67.05	67.18	65.43	65.69	951987.0
2008-06-20	ABVA-DELISTED	Stock	3.61	4.0	3.61	3.8	9493.0
2008-06-20	ABX-DELISTED	Stock	40.64	41.29	39.89	40.35	8440951.0
2008-06-20	ACAD	Stock	3.82	4.15	3.8	4.08	641400.0
2008-06-20	ACAP-DELISTED	Stock	47.04	48.87	46.9	48.87	99208.0
2008-06-20	ACAS-DELISTED	Stock	27.52	27.81	27.07	27.15	3695394.0
2008-06-20	ACAT-DELISTED	Stock	7.96	8.21	7.92	8.16	119352.0

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

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