PREVIEW / stock_daily / 2007-03-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-12.parquet
  size:    162 KB
  rows:    4,860
  symbols: 3,051

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-12	AAPL	Stock	3.1454	3.2139	3.1425	3.2096	729408400.0
2007-03-12	MSFT	Stock	27.18	27.48	27.13	27.44	36516400.0
2007-03-12	NVDA	Stock	0.5027	0.5128	0.502	0.5055	428010000.0
2007-03-12	AMZN	Stock	1.932	1.9525	1.919	1.9405	97580000.0
2007-03-12	TLT	Stock	89.73	89.98	89.68	89.75	594400.0
2007-03-12	CL	Stock	33.315	33.395	33.165	33.3	2715000.0
2007-03-12	A	Stock	22.6753	22.99	22.6538	22.99	3820594.0
2007-03-12	AABA-DELISTED	Stock	29.2999992370605	30.1100006103516	29.2900009155273	29.9899997711182	35991600.0
2007-03-12	AACC-DELISTED	Stock	15.53	15.62	15.41	15.51	74781.0
2007-03-12	AAI-DELISTED	Stock	10.18	10.41	10.14	10.38	1889800.0
2007-03-12	AAIC-DELISTED	Stock	116.0	116.0	107.6	110.8	6414200.0
2007-03-12	AAME	Stock	3.56	3.56	3.22	3.28	9400.0
2007-03-12	AAON	Stock	3.4937	3.4937	3.4291	3.4291	131372.0
2007-03-12	AAP	Stock	38.3	38.94	38.29	38.92	673200.0
2007-03-12	AATI-DELISTED	Stock	6.32	6.65	6.29	6.59	301636.0
2007-03-12	AAU-DELISTED	Stock	2.22	2.2223	2.17	2.18	22750.0
2007-03-12	AAUAF-DELISTED	Stock	2.21	2.2172	2.17	2.18	22800.0
2007-03-12	AAV-DELISTED	Stock	10.11	10.19	10.0	10.01	481500.0
2007-03-12	AAWW-DELISTED	Stock	49.99	50.78	49.56	50.62	147594.0
2007-03-12	AAXN-DELISTED	Stock	7.76000022888184	7.84999990463257	7.75	7.84999990463257	480500.0
2007-03-12	AB	Stock	85.79	86.05	85.5	85.68	209200.0
2007-03-12	ABAX-DELISTED	Stock	22.32	22.8	22.22	22.76	121701.0
2007-03-12	ABB-DELISTED	Stock	16.85	17.12	16.81	17.06	1340000.0
2007-03-12	ABBC-DELISTED	Stock	19.355	19.355	19.05	19.17	4811.0
2007-03-12	ABC-DELISTED	Stock	26.58	26.745	26.36	26.37	1508220.0
2007-03-12	ABCB	Stock	23.6449	24.3646	23.6449	23.7909	45135.0
2007-03-12	ABCO-DELISTED	Stock	25.74	25.9	25.62	25.79	96257.0
2007-03-12	ABCW-DELISTED	Stock	27.97	28.19	27.85	27.89	64280.0
2007-03-12	ABD-DELISTED	Stock	21.23	21.35	21.08	21.33	235570.0
2007-03-12	ABE-DELISTED	Stock	17.6	17.6	17.5	17.5101	55500.0
2007-03-12	ABFS-DELISTED	Stock	38.08	38.08	37.4	37.4	335085.0
2007-03-12	ABG	Stock	27.61	28.03	27.55	27.75	356500.0
2007-03-12	ABK-DELISTED	Stock	88.9	90.19	88.65	89.75	842900.0
2007-03-12	ABM	Stock	26.4	26.55	26.32	26.4	594500.0
2007-03-12	ABMD-DELISTED	Stock	13.44	13.45	13.34	13.41	76963.0
2007-03-12	ABP-DELISTED	Stock	3.1	3.25	3.05	3.21	222500.0
2007-03-12	ABR	Stock	30.18	30.6	29.81	30.3	132700.0
2007-03-12	ABT	Stock	26.1203	26.1491	26.0244	26.0915	13325761.0
2007-03-12	ABTL-DELISTED	Stock	18.651	18.802	18.348	18.55	19507.0
2007-03-12	ABV-DELISTED	Stock	52.8	53.14	52.21	52.9	289000.0
2007-03-12	ABVA-DELISTED	Stock	15.1	15.38	15.1	15.28	2235.0
2007-03-12	ABX-DELISTED	Stock	27.97	28.6	27.95	28.46	3558900.0
2007-03-12	ACAD	Stock	6.76	7.0	6.76	7.0	108100.0
2007-03-12	ACAP-DELISTED	Stock	36.94	37.2	36.69	37.0	36988.0
2007-03-12	ACAS-DELISTED	Stock	44.13	44.44	43.75	44.06	855244.0
2007-03-12	ACAT-DELISTED	Stock	19.23	19.3	18.71	18.96	36121.0
2007-03-12	ACC-DELISTED	Stock	30.13	30.98	30.09	30.98	174912.0
2007-03-12	ACCL-DELISTED	Stock	6.27	6.5	6.27	6.43	48458.0
2007-03-12	ACCO	Stock	21.22	21.34	21.07	21.34	275900.0
2007-03-12	ACCP-DELISTED	Stock	6.2	6.2	6.0	6.1	25555.0

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

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