PREVIEW / stock_daily / 2007-09-18

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-18.parquet
  size:    178 KB
  rows:    5,501
  symbols: 3,321

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-09-18	AAPL	Stock	4.9664	5.1018	4.9225	5.0329	1064089600.0
2007-09-18	MSFT	Stock	28.7	28.97	28.27	28.93	77462400.0
2007-09-18	NVDA	Stock	0.813	0.8875	0.8118	0.875	844740000.0
2007-09-18	AMZN	Stock	4.369	4.58	4.3355	4.4375	178488000.0
2007-09-18	TLT	Stock	89.8	90.24	89.0	89.66	3132800.0
2007-09-18	CL	Stock	34.2	34.705	34.125	34.555	5100200.0
2007-09-18	A	Stock	25.8512	26.7525	25.8512	26.6094	2753081.0
2007-09-18	AABA-DELISTED	Stock	25.06	25.21	24.53	25.05	19116319.0
2007-09-18	AACC-DELISTED	Stock	9.59	10.2	9.52	10.18	136334.0
2007-09-18	AAI-DELISTED	Stock	10.22	10.47	10.07	10.46	1123700.0
2007-09-18	AAIC-DELISTED	Stock	96.0	103.6	95.2	103.2	3404700.0
2007-09-18	AAME	Stock	2.85	2.95	2.82	2.88	1600.0
2007-09-18	AAON	Stock	3.7393	4.0454	3.6602	4.0395	359944.0
2007-09-18	AAP	Stock	33.7	35.16	33.38	35.0	952400.0
2007-09-18	AATI-DELISTED	Stock	9.8	10.54	9.74	10.5	1697574.0
2007-09-18	AAU-DELISTED	Stock	2.16	2.25	2.15	2.24	55600.0
2007-09-18	AAUAF-DELISTED	Stock	2.16	2.25	2.15	2.24	50300.0
2007-09-18	AAV-DELISTED	Stock	11.29	11.4	11.2	11.38	608900.0
2007-09-18	AAWW-DELISTED	Stock	51.81	53.47	51.0	53.45	116331.0
2007-09-18	AAXN-DELISTED	Stock	14.85	15.25	14.71	15.02	2419732.0
2007-09-18	AB	Stock	81.02	84.35	80.39	83.74	437600.0
2007-09-18	ABAX-DELISTED	Stock	21.0	21.94	20.44	21.88	230605.0
2007-09-18	ABB-DELISTED	Stock	24.06	24.92	23.91	24.81	1984400.0
2007-09-18	ABBC-DELISTED	Stock	9.71	9.75	9.68	9.7	111275.0
2007-09-18	ABBNY-DELISTED	Stock	24.06	24.92	23.91	24.8	2180300.0
2007-09-18	ABC-DELISTED	Stock	22.58	23.12	22.54	23.0	2944200.0
2007-09-18	ABCB	Stock	17.6049	18.2565	17.3908	18.2468	75773.0
2007-09-18	ABCO-DELISTED	Stock	28.21	29.28	28.12	28.86	219996.0
2007-09-18	ABCW-DELISTED	Stock	27.69	28.64	27.31	28.64	110550.0
2007-09-18	ABD-DELISTED	Stock	21.07	21.81	20.89	21.52	534750.0
2007-09-18	ABE-DELISTED	Stock	21.61	22.4	21.55	22.4	55200.0
2007-09-18	ABEO	Stock	5625.0	6025.0	5562.5	5875.0	25.0
2007-09-18	ABFS-DELISTED	Stock	33.64	34.86	33.3099	34.84	262393.0
2007-09-18	ABG	Stock	20.81	22.26	20.22	22.2	561600.0
2007-09-18	ABK-DELISTED	Stock	62.2	66.24	61.4	65.1	2781898.0
2007-09-18	ABM	Stock	19.89	20.83	19.85	20.76	598400.0
2007-09-18	ABMD-DELISTED	Stock	11.22	11.98	10.83	11.94	203153.0
2007-09-18	ABP-DELISTED	Stock	3.4	3.5	3.4	3.49	87900.0
2007-09-18	ABR	Stock	19.69	20.74	19.11	20.53	303600.0
2007-09-18	ABT	Stock	25.1079	25.7797	25.0168	25.7173	18119842.0
2007-09-18	ABTL-DELISTED	Stock	14.624	15.526	14.624	15.226	7010.0
2007-09-18	ABV-DELISTED	Stock	68.61	69.13	66.84	68.98	1183717.0
2007-09-18	ABVA-DELISTED	Stock	10.06	10.06	9.88	9.88	200.0
2007-09-18	ABVT-DELISTED	Stock	80.0	81.5	80.0	81.5	17661.0
2007-09-18	ABX-DELISTED	Stock	37.66	38.92	36.86	38.73	7197200.0
2007-09-18	ACAD	Stock	14.95	15.53	14.77	15.34	219200.0
2007-09-18	ACAP-DELISTED	Stock	36.77	39.22	36.75	39.19	53653.0
2007-09-18	ACAS-DELISTED	Stock	39.395	40.35	39.025	40.3351	2595917.0
2007-09-18	ACAT-DELISTED	Stock	15.89	16.32	15.76	16.32	99628.0
2007-09-18	ACC-DELISTED	Stock	28.3	28.48	28.0	28.31	330303.0

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

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