PREVIEW / stock_daily / 2007-07-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-16.parquet
  size:    178 KB
  rows:    5,449
  symbols: 3,275

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-16	AAPL	Stock	4.9425	4.9993	4.9107	4.9321	936112800.0
2007-07-16	MSFT	Stock	29.76	30.24	29.72	30.03	48023200.0
2007-07-16	NVDA	Stock	0.7652	0.7815	0.765	0.7783	541710000.0
2007-07-16	AMZN	Stock	3.7365	3.742	3.65	3.6845	166698000.0
2007-07-16	TLT	Stock	84.52	85.11	84.52	85.07	952000.0
2007-07-16	CL	Stock	34.095	34.265	34.015	34.095	4885800.0
2007-07-16	A	Stock	28.4192	28.6123	28.4049	28.4979	1977471.0
2007-07-16	AABA-DELISTED	Stock	26.48	26.74	26.13	26.68	29128194.0
2007-07-16	AACC-DELISTED	Stock	17.66	17.79	17.34	17.34	421325.0
2007-07-16	AAI-DELISTED	Stock	10.64	10.81	10.5	10.64	1364700.0
2007-07-16	AAIC-DELISTED	Stock	103.2	106.0	101.8	104.2	1734900.0
2007-07-16	AAME	Stock	3.97	4.04	3.97	4.04	2300.0
2007-07-16	AAON	Stock	4.4984	4.5129	4.3984	4.451	773044.0
2007-07-16	AAP	Stock	39.64	40.15	39.45	39.68	683500.0
2007-07-16	AATI-DELISTED	Stock	9.7	10.3	9.7	10.24	710800.0
2007-07-16	AAU-DELISTED	Stock	2.79	2.8	2.73	2.75	75400.0
2007-07-16	AAUAF-DELISTED	Stock	2.79	2.8	2.73	2.75	75500.0
2007-07-16	AAV-DELISTED	Stock	13.85	13.89	13.7	13.72	856400.0
2007-07-16	AAWW-DELISTED	Stock	60.06	60.2	59.14	59.65	91227.0
2007-07-16	AAXN-DELISTED	Stock	16.3	16.95	16.15	16.23	4159391.0
2007-07-16	AB	Stock	89.6	91.09	89.55	89.87	221200.0
2007-07-16	ABAX-DELISTED	Stock	19.48	19.91	19.35	19.67	380664.0
2007-07-16	ABB-DELISTED	Stock	24.86	24.93	24.69	24.72	1934900.0
2007-07-16	ABBC-DELISTED	Stock	9.824	9.83	9.565	9.686	53148.0
2007-07-16	ABBNY-DELISTED	Stock	24.86	24.93	24.69	24.75	1936500.0
2007-07-16	ABC-DELISTED	Stock	24.94	25.0	24.74	24.9	1264000.0
2007-07-16	ABCB	Stock	22.0498	22.0498	21.6413	21.6899	26937.0
2007-07-16	ABCO-DELISTED	Stock	28.66	29.02	28.52	28.62	187698.0
2007-07-16	ABCW-DELISTED	Stock	24.6	24.65	24.37	24.5	141050.0
2007-07-16	ABD-DELISTED	Stock	23.1	23.19	22.76	22.82	369210.0
2007-07-16	ABE-DELISTED	Stock	22.22	22.44	22.2	22.34	16100.0
2007-07-16	ABEO	Stock	5937.5	6187.5	5750.0	6187.5	7.0
2007-07-16	ABFS-DELISTED	Stock	41.25	41.42	40.2	40.67	562898.0
2007-07-16	ABG	Stock	24.13	24.23	23.83	24.12	497200.0
2007-07-16	ABK-DELISTED	Stock	85.42	85.88	84.73	85.52	809700.0
2007-07-16	ABM	Stock	25.54	25.55	25.2	25.3	269600.0
2007-07-16	ABMD-DELISTED	Stock	11.12	11.21	10.9	10.94	286717.0
2007-07-16	ABP-DELISTED	Stock	4.46	4.55	4.35	4.38	260500.0
2007-07-16	ABR	Stock	25.22	25.6	25.18	25.23	82000.0
2007-07-16	ABT	Stock	25.5494	25.7701	25.5014	25.6981	11256774.0
2007-07-16	ABTL-DELISTED	Stock	20.92	21.78	20.92	21.73	42491.0
2007-07-16	ABV-DELISTED	Stock	74.58	75.11	73.71	74.4	399100.0
2007-07-16	ABVA-DELISTED	Stock	12.93	12.94	12.93	12.94	1000.0
2007-07-16	ABVT-DELISTED	Stock	70.0	70.75	69.5	69.5	31308.0
2007-07-16	ABX-DELISTED	Stock	31.88	32.07	31.45	31.89	7171250.0
2007-07-16	ACAD	Stock	13.78	13.87	13.5	13.56	249800.0
2007-07-16	ACAP-DELISTED	Stock	38.64	38.84	38.17	38.27	42843.0
2007-07-16	ACAS-DELISTED	Stock	45.9	46.0	45.4	45.8	1579979.0
2007-07-16	ACAT-DELISTED	Stock	19.535	20.09	19.365	19.665	176676.0
2007-07-16	ACC-DELISTED	Stock	28.66	29.02	28.66	28.82	161976.0

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

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