PREVIEW / stock_daily / 2007-04-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-09.parquet
  size:    162 KB
  rows:    4,906
  symbols: 3,086

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-04-09	AAPL	Stock	3.4004	3.4036	3.3229	3.3446	413341600.0
2007-04-09	MSFT	Stock	28.58	28.72	28.39	28.57	31384600.0
2007-04-09	NVDA	Stock	0.515	0.5208	0.5047	0.5057	640950000.0
2007-04-09	AMZN	Stock	2.086	2.107	2.0805	2.083	83654000.0
2007-04-09	TLT	Stock	87.28	87.31	87.13	87.17	1283900.0
2007-04-09	CL	Stock	33.325	33.375	33.205	33.355	3335400.0
2007-04-09	A	Stock	24.907	25.1788	24.8569	25.0787	3633961.0
2007-04-09	AABA-DELISTED	Stock	32.0099983215332	32.2400016784668	31.6000003814697	31.6399993896484	12408000.0
2007-04-09	AACC-DELISTED	Stock	15.56	15.68	15.56	15.6	204677.0
2007-04-09	AACQW-DELISTED	Stock	0.57	0.59	0.57	0.59	45000.0
2007-04-09	AAI-DELISTED	Stock	10.85	10.99	10.63	10.94	1314200.0
2007-04-09	AAIC-DELISTED	Stock	112.6	113.0	110.0	110.2	1943500.0
2007-04-09	AAME	Stock	3.93	4.25	3.88	4.24	10100.0
2007-04-09	AAON	Stock	3.3804	3.4173	3.333	3.416	139725.0
2007-04-09	AAP	Stock	39.59	39.67	39.22	39.48	235400.0
2007-04-09	AATI-DELISTED	Stock	6.91	6.99	6.74	6.78	392023.0
2007-04-09	AAU-DELISTED	Stock	2.45	2.53	2.38	2.46	129800.0
2007-04-09	AAUAF-DELISTED	Stock	2.45	2.53	2.38	2.46	129800.0
2007-04-09	AAV-DELISTED	Stock	10.47	10.49	10.27	10.32	521200.0
2007-04-09	AAWW-DELISTED	Stock	56.56	56.59	55.53	55.63	60221.0
2007-04-09	AAXN-DELISTED	Stock	7.96000003814697	7.98000001907349	7.84999990463257	7.84999990463257	741100.0
2007-04-09	AB	Stock	90.5	91.42	90.5	91.04	160700.0
2007-04-09	ABAX-DELISTED	Stock	24.78	25.21	24.78	25.03	205544.0
2007-04-09	ABB-DELISTED	Stock	18.0	18.0	17.83	17.88	1148711.0
2007-04-09	ABBC-DELISTED	Stock	20.1	20.23	20.05	20.2	11606.0
2007-04-09	ABC-DELISTED	Stock	27.01	27.1	26.67	26.87	1837000.0
2007-04-09	ABCB	Stock	24.2966	24.3939	23.7033	23.7324	17478.0
2007-04-09	ABCO-DELISTED	Stock	25.85	25.89	25.27	25.3	127846.0
2007-04-09	ABCW-DELISTED	Stock	27.97	28.02	27.63	27.81	50530.0
2007-04-09	ABD-DELISTED	Stock	25.2	25.29	25.02	25.1	509070.0
2007-04-09	ABE-DELISTED	Stock	19.52	19.98	19.27	19.45	22600.0
2007-04-09	ABFS-DELISTED	Stock	36.53	37.3	36.21	36.29	274427.0
2007-04-09	ABG	Stock	27.01	27.22	27.0	27.11	580300.0
2007-04-09	ABK-DELISTED	Stock	86.12	86.24	85.75	86.04	673700.0
2007-04-09	ABM	Stock	26.95	26.97	26.08	26.35	363400.0
2007-04-09	ABMD-DELISTED	Stock	13.71	13.72	13.4	13.6	126512.0
2007-04-09	ABP-DELISTED	Stock	3.05	3.07	2.96	2.97	329500.0
2007-04-09	ABR	Stock	29.94	30.26	29.66	30.2	189500.0
2007-04-09	ABT	Stock	27.3726	27.5741	27.2526	27.4494	13350146.0
2007-04-09	ABTL-DELISTED	Stock	17.2	17.6	17.05	17.1	11000.0
2007-04-09	ABV-DELISTED	Stock	56.75	57.28	56.73	57.03	263900.0
2007-04-09	ABVA-DELISTED	Stock	14.62	14.68	14.62	14.65	2543.0
2007-04-09	ABVT-DELISTED	Stock	62.05	62.5	62.0	62.0	1041.0
2007-04-09	ABX-DELISTED	Stock	29.37	29.62	29.09	29.17	2753500.0
2007-04-09	ACAD	Stock	15.65	16.33	15.65	16.14	1116300.0
2007-04-09	ACAP-DELISTED	Stock	38.6	39.03	38.47	38.8	52074.0
2007-04-09	ACAS-DELISTED	Stock	45.88	45.94	45.5	45.65	1324480.0
2007-04-09	ACAT-DELISTED	Stock	19.005	19.155	18.915	19.155	38881.0
2007-04-09	ACC-DELISTED	Stock	30.34	30.34	29.94	30.03	99600.0
2007-04-09	ACCL-DELISTED	Stock	6.44	6.55	6.44	6.5462	42098.0

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

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