PREVIEW / stock_daily / 2007-05-15

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-15.parquet
  size:    170 KB
  rows:    5,144
  symbols: 3,170

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-05-15	AAPL	Stock	3.9132	3.9357	3.8029	3.84	954514400.0
2007-05-15	MSFT	Stock	30.9	31.09	30.84	30.9	75013900.0
2007-05-15	NVDA	Stock	0.5815	0.585	0.5733	0.5747	621360000.0
2007-05-15	AMZN	Stock	3.07	3.0985	3.026	3.029	174042000.0
2007-05-15	TLT	Stock	88.19	88.2101	87.66	87.93	382400.0
2007-05-15	CL	Stock	33.2	33.435	33.13	33.17	4764400.0
2007-05-15	A	Stock	26.7024	27.5179	26.7024	27.0243	11697346.0
2007-05-15	AABA-DELISTED	Stock	29.16	29.42	28.75	28.8	20567341.0
2007-05-15	AACC-DELISTED	Stock	18.82	18.86	18.56	18.6	360623.0
2007-05-15	AAI-DELISTED	Stock	11.64	11.69	11.37	11.4	1687639.0
2007-05-15	AAIC-DELISTED	Stock	112.8	113.8	110.0	110.0	2601400.0
2007-05-15	AAME	Stock	5.05	5.09	4.92	4.96	30200.0
2007-05-15	AAON	Stock	3.9506	3.9612	3.7136	3.7228	363741.0
2007-05-15	AAP	Stock	39.97	41.15	39.9	40.47	1595900.0
2007-05-15	AATI-DELISTED	Stock	7.8	7.8	7.57	7.61	409920.0
2007-05-15	AAU-DELISTED	Stock	2.28	2.39	2.28	2.35	82700.0
2007-05-15	AAUAF-DELISTED	Stock	2.28	2.39	2.28	2.35	82700.0
2007-05-15	AAV-DELISTED	Stock	11.67	12.0	11.67	11.94	828150.0
2007-05-15	AAWW-DELISTED	Stock	58.33	59.61	58.27	58.27	62956.0
2007-05-15	AAXN-DELISTED	Stock	9.2	9.24	8.97	8.99	2052000.0
2007-05-15	AB	Stock	88.64	90.0	87.53	87.98	216900.0
2007-05-15	ABAX-DELISTED	Stock	21.29	21.57	21.04	21.15	182217.0
2007-05-15	ABB-DELISTED	Stock	19.99	20.23	19.94	20.0	1694200.0
2007-05-15	ABBC-DELISTED	Stock	18.4	18.81	18.4	18.4	9464.0
2007-05-15	ABBNY-DELISTED	Stock	19.99	20.23	19.94	20.0	1796900.0
2007-05-15	ABC-DELISTED	Stock	25.5	25.5	24.69	24.87	5597988.0
2007-05-15	ABCB	Stock	21.6705	22.2638	21.3106	21.9915	81016.0
2007-05-15	ABCO-DELISTED	Stock	24.52	24.87	24.39	24.45	354098.0
2007-05-15	ABCW-DELISTED	Stock	28.3	28.68	27.98	28.0	55590.0
2007-05-15	ABD-DELISTED	Stock	22.46	22.83	22.33	22.35	402800.0
2007-05-15	ABE-DELISTED	Stock	20.95	20.95	20.6	20.8899	31400.0
2007-05-15	ABFS-DELISTED	Stock	37.65	38.91	37.65	38.22	423932.0
2007-05-15	ABG	Stock	27.12	27.36	26.47	26.54	543400.0
2007-05-15	ABK-DELISTED	Stock	94.21	94.97	94.14	94.69	915227.0
2007-05-15	ABM	Stock	28.35	28.65	27.73	27.76	224100.0
2007-05-15	ABMD-DELISTED	Stock	12.36	12.59	11.62	11.96	274128.0
2007-05-15	ABP-DELISTED	Stock	3.96	4.02	3.91	4.0	454400.0
2007-05-15	ABR	Stock	28.9	29.3	28.05	28.05	121400.0
2007-05-15	ABT	Stock	28.0011	28.4282	27.9004	28.1547	12775531.0
2007-05-15	ABTL-DELISTED	Stock	19.562	19.738	17.989	18.638	52449.0
2007-05-15	ABV-DELISTED	Stock	61.0	62.49	61.0	62.03	637440.0
2007-05-15	ABVA-DELISTED	Stock	12.81	12.9	12.7	12.9	103705.0
2007-05-15	ABX-DELISTED	Stock	29.75	30.39	29.66	30.02	5543874.0
2007-05-15	ACAD	Stock	13.29	13.46	12.87	12.87	329200.0
2007-05-15	ACAP-DELISTED	Stock	39.12	39.99	38.9	39.47	153232.0
2007-05-15	ACAS-DELISTED	Stock	45.91	46.47	45.66	45.74	934424.0
2007-05-15	ACAT-DELISTED	Stock	17.69	19.25	17.69	18.28	186935.0
2007-05-15	ACC-DELISTED	Stock	28.55	28.88	28.52	28.66	209300.0
2007-05-15	ACCL-DELISTED	Stock	6.21	6.35	5.63	6.24	136881.0
2007-05-15	ACCO	Stock	22.46	22.83	22.33	22.35	448300.0

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

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