PREVIEW / stock_daily / 2007-07-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-12.parquet
  size:    178 KB
  rows:    5,446
  symbols: 3,265

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-07-12	AAPL	Stock	4.7804	4.7943	4.7282	4.7882	704608800.0
2007-07-12	MSFT	Stock	29.56	30.11	29.44	30.07	54302400.0
2007-07-12	NVDA	Stock	0.76	0.77	0.7547	0.7692	438732000.0
2007-07-12	AMZN	Stock	3.5655	3.6785	3.5365	3.6395	229032000.0
2007-07-12	TLT	Stock	84.55	84.58	83.8714	84.03	1941109.0
2007-07-12	CL	Stock	33.5	34.185	33.445	34.17	5538400.0
2007-07-12	A	Stock	28.5408	28.8984	28.4335	28.8984	3922928.0
2007-07-12	AABA-DELISTED	Stock	26.7	26.97	26.34	26.97	19414542.0
2007-07-12	AACC-DELISTED	Stock	17.54	17.78	17.4	17.64	190543.0
2007-07-12	AAI-DELISTED	Stock	10.74	10.88	10.66	10.82	1078402.0
2007-07-12	AAIC-DELISTED	Stock	102.2	103.2	99.4	102.4	2448800.0
2007-07-12	AAME	Stock	4.06	4.15	3.96	4.07	12100.0
2007-07-12	AAON	Stock	4.3207	4.3444	4.2021	4.3444	772284.0
2007-07-12	AAP	Stock	40.14	40.84	39.94	40.0	1339400.0
2007-07-12	AATI-DELISTED	Stock	9.51	9.84	9.51	9.77	461918.0
2007-07-12	AAU-DELISTED	Stock	2.73	2.75	2.67	2.7	51500.0
2007-07-12	AAUAF-DELISTED	Stock	2.73	2.75	2.67	2.7	51500.0
2007-07-12	AAV-DELISTED	Stock	13.8	13.92	13.8	13.85	697500.0
2007-07-12	AAWW-DELISTED	Stock	59.7	60.27	59.2	60.0	94056.0
2007-07-12	AAXN-DELISTED	Stock	16.17	16.3	15.25	15.5	6542425.0
2007-07-12	AB	Stock	89.8	91.34	89.64	90.62	254300.0
2007-07-12	ABAX-DELISTED	Stock	20.0	20.25	19.94	19.95	388370.0
2007-07-12	ABB-DELISTED	Stock	24.51	25.04	24.51	25.0	3419900.0
2007-07-12	ABBC-DELISTED	Stock	9.74	9.768	9.69	9.74	188496.0
2007-07-12	ABBNY-DELISTED	Stock	24.51	25.04	24.51	25.02	3119900.0
2007-07-12	ABC-DELISTED	Stock	24.45	25.05	24.42	25.03	3153800.0
2007-07-12	ABCB	Stock	21.8163	22.2346	21.7191	22.2346	26423.0
2007-07-12	ABCO-DELISTED	Stock	28.22	28.43	28.03	28.35	178794.0
2007-07-12	ABCW-DELISTED	Stock	24.64	24.91	24.48	24.67	353290.0
2007-07-12	ABD-DELISTED	Stock	23.0	23.32	22.85	23.12	372400.0
2007-07-12	ABE-DELISTED	Stock	21.77	22.3	21.7	22.3	45700.0
2007-07-12	ABEO	Stock	6412.5	6412.5	6287.5	6412.5	5.0
2007-07-12	ABFS-DELISTED	Stock	40.07	40.44	39.75	40.16	227325.0
2007-07-12	ABG	Stock	24.42	24.74	24.21	24.56	226300.0
2007-07-12	ABK-DELISTED	Stock	84.49	86.99	83.86	85.42	1686262.0
2007-07-12	ABM	Stock	25.67	25.83	25.56	25.75	160600.0
2007-07-12	ABMD-DELISTED	Stock	10.2	10.86	10.14	10.79	299778.0
2007-07-12	ABP-DELISTED	Stock	4.48	4.57	4.4	4.48	296900.0
2007-07-12	ABR	Stock	25.2	25.68	24.93	25.4	150200.0
2007-07-12	ABT	Stock	24.9016	25.8516	24.9016	25.794	28102334.0
2007-07-12	ABTL-DELISTED	Stock	21.93	21.93	21.22	21.27	32190.0
2007-07-12	ABV-DELISTED	Stock	73.87	74.42	73.63	74.2	339000.0
2007-07-12	ABVA-DELISTED	Stock	12.76	12.92	12.75	12.77	6865.0
2007-07-12	ABVT-DELISTED	Stock	68.1	72.75	68.1	69.25	44625.0
2007-07-12	ABX-DELISTED	Stock	31.35	31.92	31.32	31.87	7591250.0
2007-07-12	ACAD	Stock	13.64	13.7	13.35	13.49	524300.0
2007-07-12	ACAP-DELISTED	Stock	38.65	39.05	37.92	38.83	122360.0
2007-07-12	ACAS-DELISTED	Stock	44.98	45.72	44.9	45.72	2139182.0
2007-07-12	ACAT-DELISTED	Stock	20.4	20.4	19.87	20.09	247708.0
2007-07-12	ACC-DELISTED	Stock	28.46	28.51	27.85	28.48	179439.0

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

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