PREVIEW / stock_daily / 2007-05-17

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-17.parquet
  size:    175 KB
  rows:    5,343
  symbols: 3,213

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-17	AAPL	Stock	3.8268	3.9239	3.8268	3.9086	735291200.0
2007-05-17	MSFT	Stock	31.03	31.14	30.96	30.98	41045600.0
2007-05-17	NVDA	Stock	0.5803	0.5833	0.569	0.5723	443664000.0
2007-05-17	AMZN	Stock	3.144	3.176	3.101	3.1085	237418000.0
2007-05-17	TLT	Stock	87.6	87.72	87.411	87.51	397000.0
2007-05-17	CL	Stock	33.86	33.89	33.5	33.705	3970000.0
2007-05-17	A	Stock	26.7454	27.1745	26.7454	26.917	3485074.0
2007-05-17	AABA-DELISTED	Stock	28.99	29.13	28.49	28.55	21861533.0
2007-05-17	AACC-DELISTED	Stock	18.64	18.74	18.54	18.6	140277.0
2007-05-17	AAI-DELISTED	Stock	11.9	12.2	11.81	12.11	2281602.0
2007-05-17	AAIC-DELISTED	Stock	111.6	112.1	110.0	111.2	915743.0
2007-05-17	AAME	Stock	5.08	5.09	4.81	5.03	16900.0
2007-05-17	AAON	Stock	3.6859	3.7544	3.6556	3.6556	418416.0
2007-05-17	AAP	Stock	40.35	42.15	40.08	41.35	2528600.0
2007-05-17	AATI-DELISTED	Stock	7.81	7.96	7.8	7.9	282281.0
2007-05-17	AAU-DELISTED	Stock	2.27	2.34	2.27	2.29	45300.0
2007-05-17	AAUAF-DELISTED	Stock	2.27	2.3425	2.27	2.29	45300.0
2007-05-17	AAV-DELISTED	Stock	12.18	12.34	12.1	12.34	793300.0
2007-05-17	AAWW-DELISTED	Stock	57.95	58.8	57.75	58.45	79157.0
2007-05-17	AAXN-DELISTED	Stock	9.29	9.4	9.07	9.24	1541399.0
2007-05-17	AB	Stock	86.73	87.97	86.73	87.88	280100.0
2007-05-17	ABAX-DELISTED	Stock	21.06	21.06	20.5	20.58	147551.0
2007-05-17	ABB-DELISTED	Stock	20.26	20.26	20.05	20.1	680300.0
2007-05-17	ABBC-DELISTED	Stock	18.17	18.34	18.1	18.2	12804.0
2007-05-17	ABBNY-DELISTED	Stock	20.26	20.26	20.05	20.1	682900.0
2007-05-17	ABC-DELISTED	Stock	25.5	25.53	25.08	25.42	3122600.0
2007-05-17	ABCB	Stock	22.2249	22.2638	21.5634	21.6899	38452.0
2007-05-17	ABCO-DELISTED	Stock	24.49	24.68	24.26	24.5	393694.0
2007-05-17	ABCW-DELISTED	Stock	28.21	28.44	27.98	28.24	36330.0
2007-05-17	ABD-DELISTED	Stock	22.58	22.99	22.51	22.91	905350.0
2007-05-17	ABE-DELISTED	Stock	20.78	20.81	20.5	20.8	22400.0
2007-05-17	ABEO	Stock	6187.5	6500.0	6187.5	6500.0	2.0
2007-05-17	ABFS-DELISTED	Stock	38.8	39.27	38.36	38.77	442925.0
2007-05-17	ABG	Stock	26.87	26.96	26.55	26.6	175900.0
2007-05-17	ABK-DELISTED	Stock	94.72	95.97	94.31	95.62	1078100.0
2007-05-17	ABM	Stock	28.52	28.74	28.12	28.29	184000.0
2007-05-17	ABMD-DELISTED	Stock	12.03	12.5	11.59	11.76	396688.0
2007-05-17	ABP-DELISTED	Stock	3.9	3.97	3.71	3.84	372600.0
2007-05-17	ABR	Stock	28.45	28.6	27.65	27.71	102000.0
2007-05-17	ABT	Stock	28.3082	28.337	28.0875	28.2602	6402043.0
2007-05-17	ABTL-DELISTED	Stock	19.45	19.55	19.05	19.45	12061.0
2007-05-17	ABV-DELISTED	Stock	63.85	66.25	63.61	65.76	546480.0
2007-05-17	ABVA-DELISTED	Stock	13.29	13.42	13.29	13.35	19436.0
2007-05-17	ABVT-DELISTED	Stock	65.0	65.0	61.0	61.0	898.0
2007-05-17	ABX-DELISTED	Stock	29.69	29.78	29.35	29.48	5157542.0
2007-05-17	ACAD	Stock	12.92	13.42	12.92	13.32	267000.0
2007-05-17	ACAP-DELISTED	Stock	39.1	39.22	38.2	38.26	72358.0
2007-05-17	ACAS-DELISTED	Stock	46.25	46.59	46.09	46.48	850361.0
2007-05-17	ACAT-DELISTED	Stock	18.81	19.27	18.72	19.22	132089.0
2007-05-17	ACC-DELISTED	Stock	28.51	28.67	27.81	27.85	208000.0

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

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