PREVIEW / stock_daily / 2007-03-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-09.parquet
  size:    160 KB
  rows:    4,829
  symbols: 3,029

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-09	AAPL	Stock	3.1714	3.1732	3.1214	3.1418	451836000.0
2007-03-09	MSFT	Stock	27.42	27.48	27.03	27.29	80125000.0
2007-03-09	NVDA	Stock	0.5208	0.5267	0.5027	0.5085	555306000.0
2007-03-09	AMZN	Stock	1.924	1.9445	1.9	1.942	124002000.0
2007-03-09	TLT	Stock	89.38	89.9	89.19	89.4	1534700.0
2007-03-09	CL	Stock	33.115	33.38	33.05	33.315	3331800.0
2007-03-09	A	Stock	22.7325	22.8898	22.5036	22.7182	5203216.0
2007-03-09	AABA-DELISTED	Stock	29.8500003814697	30.1499996185303	28.7900009155273	29.1200008392334	72749900.0
2007-03-09	AACC-DELISTED	Stock	15.33	15.52	15.26	15.5	116782.0
2007-03-09	AACQ-DELISTED	Stock	4.71	4.76	4.63	4.65	22250.0
2007-03-09	AACQW-DELISTED	Stock	0.6	0.64	0.6	0.62	59500.0
2007-03-09	AAI-DELISTED	Stock	10.14	10.2	10.01	10.1	2173500.0
2007-03-09	AAIC-DELISTED	Stock	122.0	123.2	116.0	118.4	2087200.0
2007-03-09	AAME	Stock	3.56	3.56	3.5	3.56	2500.0
2007-03-09	AAON	Stock	3.4436	3.5187	3.4384	3.4686	118462.0
2007-03-09	AAP	Stock	38.66	38.66	37.79	38.14	594600.0
2007-03-09	AATI-DELISTED	Stock	6.42	6.58	6.27	6.29	329925.0
2007-03-09	AAU-DELISTED	Stock	2.4	2.4	2.17	2.21	64800.0
2007-03-09	AAUAF-DELISTED	Stock	2.4	2.4	2.17	2.21	64800.0
2007-03-09	AAV-DELISTED	Stock	10.21	10.25	10.11	10.15	375600.0
2007-03-09	AAWW-DELISTED	Stock	49.82	49.91	48.21	49.1	212376.0
2007-03-09	AAXN-DELISTED	Stock	7.80999994277954	7.90999984741211	7.75	7.78000020980835	601500.0
2007-03-09	AB	Stock	85.0	86.11	84.61	85.75	370200.0
2007-03-09	ABAX-DELISTED	Stock	22.22	22.4	22.0	22.37	126643.0
2007-03-09	ABB-DELISTED	Stock	16.98	17.04	16.79	16.88	1916500.0
2007-03-09	ABBC-DELISTED	Stock	19.29	19.31	19.05	19.18	12670.0
2007-03-09	ABC-DELISTED	Stock	26.46	26.64	26.36	26.55	1840000.0
2007-03-09	ABCB	Stock	23.6157	24.3063	23.5282	23.8395	17067.0
2007-03-09	ABCO-DELISTED	Stock	25.85	26.05	25.59	25.88	77526.0
2007-03-09	ABCW-DELISTED	Stock	28.0	28.13	27.73	28.13	116820.0
2007-03-09	ABD-DELISTED	Stock	21.18	21.27	21.0	21.25	367600.0
2007-03-09	ABE-DELISTED	Stock	17.98	17.99	17.51	17.57	28600.0
2007-03-09	ABFS-DELISTED	Stock	38.29	38.38	37.73	38.02	298354.0
2007-03-09	ABG	Stock	27.75	28.03	27.34	27.61	351500.0
2007-03-09	ABK-DELISTED	Stock	89.1	89.52	88.57	89.33	894900.0
2007-03-09	ABM	Stock	26.97	26.97	26.38	26.5	490600.0
2007-03-09	ABMD-DELISTED	Stock	13.5	13.52	13.32	13.45	72244.0
2007-03-09	ABP-DELISTED	Stock	3.15	3.15	2.96	3.05	111400.0
2007-03-09	ABR	Stock	30.32	30.65	29.78	30.02	167900.0
2007-03-09	ABT	Stock	25.8852	26.1299	25.7892	26.0963	21899541.0
2007-03-09	ABTL-DELISTED	Stock	18.154	18.549	17.807	18.5	9370.0
2007-03-09	ABV-DELISTED	Stock	52.0	52.69	51.63	52.56	415100.0
2007-03-09	ABVA-DELISTED	Stock	15.25	15.25	15.17	15.23	3896.0
2007-03-09	ABX-DELISTED	Stock	28.24	28.3	27.94	27.98	5605086.0
2007-03-09	ACAD	Stock	6.94	7.04	6.71	6.76	128800.0
2007-03-09	ACAP-DELISTED	Stock	35.82	36.73	35.82	36.73	42497.0
2007-03-09	ACAS-DELISTED	Stock	43.74	44.1	43.33	43.9	1369925.0
2007-03-09	ACAT-DELISTED	Stock	19.01	19.43	18.85	19.23	58831.0
2007-03-09	ACC-DELISTED	Stock	29.89	30.64	29.54	30.19	202600.0
2007-03-09	ACCL-DELISTED	Stock	6.2401	6.49	6.2401	6.35	67833.0

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

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