PREVIEW / stock_daily / 2010-04-23

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-23.parquet
  size:    193 KB
  rows:    5,972
  symbols: 3,526

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
2010-04-23	AAPL	Stock	9.5711	9.7207	9.5357	9.6725	796955600.0
2010-04-23	MSFT	Stock	31.12	31.58	30.65	30.96	126766600.0
2010-04-23	NVDA	Stock	0.4155	0.4165	0.4038	0.411	752916000.0
2010-04-23	AMZN	Stock	7.269	7.4545	7.121	7.1815	379504000.0
2010-04-23	TLT	Stock	90.21	90.365	89.87	90.11	4775946.0
2010-04-23	ES	Stock	27.78	27.87	27.65	27.76	1661400.0
2010-04-23	CL	Stock	41.945	41.945	41.29	41.635	6383600.0
2010-04-23	A	Stock	26.03	26.2375	25.8226	26.2089	3653673.0
2010-04-23	AABA-DELISTED	Stock	17.68	17.83	17.5	17.63	18681859.0
2010-04-23	AACC-DELISTED	Stock	6.96	7.3	6.95	7.3	23350.0
2010-04-23	AACG	Stock	3.44	3.45	3.44	3.45	400.0
2010-04-23	AAI-DELISTED	Stock	5.4	5.42	5.3	5.36	3444263.0
2010-04-23	AAIC-DELISTED	Stock	20.34	20.46	20.2204	20.44	39420.0
2010-04-23	AAME	Stock	1.52	1.61	1.52	1.61	4500.0
2010-04-23	AAON	Stock	4.6894	4.7309	4.6578	4.7309	275906.0
2010-04-23	AAP	Stock	45.53	46.17	45.19	46.11	1066400.0
2010-04-23	AATI-DELISTED	Stock	4.02	4.02	3.91	3.95	201554.0
2010-04-23	AAU-DELISTED	Stock	1.08	1.12	1.07	1.1101	73783.0
2010-04-23	AAUAF-DELISTED	Stock	1.08	1.12	1.07	1.1101	74283.0
2010-04-23	AAV-DELISTED	Stock	7.26	7.46	7.22	7.45	459284.0
2010-04-23	AAWW-DELISTED	Stock	57.71	58.49	57.23	58.44	150891.0
2010-04-23	AAXJ	Stock	57.73	58.39	57.7	58.39	151768.0
2010-04-23	AAXN-DELISTED	Stock	5.26	5.39	4.87	4.9	4539089.0
2010-04-23	AB	Stock	33.33	33.57	33.08	33.26	318400.0
2010-04-23	ABAX-DELISTED	Stock	26.79	27.45	26.77	27.39	154528.0
2010-04-23	ABB-DELISTED	Stock	20.68	21.1	20.59	21.06	4579464.0
2010-04-23	ABBC-DELISTED	Stock	8.8	9.19	8.79	9.16	147967.0
2010-04-23	ABBNY-DELISTED	Stock	20.68	21.1	20.59	21.08	4618237.0
2010-04-23	ABC-DELISTED	Stock	31.5	31.57	30.79	31.13	4871066.0
2010-04-23	ABCB	Stock	10.9479	11.137	10.8284	10.9578	217230.0
2010-04-23	ABCD-DELISTED	Stock	5.25	5.47	5.08	5.17	138482.0
2010-04-23	ABCO-DELISTED	Stock	17.865	17.865	16.74	17.03	263408.0
2010-04-23	ABCW-DELISTED	Stock	0.94	1.18	0.94	1.14	657640.0
2010-04-23	ABD-DELISTED	Stock	8.315	8.865	8.265	8.855	311660.0
2010-04-23	ABE-DELISTED	Stock	16.86	16.998	16.86	16.99	8695.0
2010-04-23	ABEO	Stock	3262.5	3500.0	3225.0	3450.0	40.0
2010-04-23	ABFS-DELISTED	Stock	31.2	32.79	30.6425	32.03	1393434.0
2010-04-23	ABG	Stock	15.0	15.06	14.83	15.04	164200.0
2010-04-23	ABII-DELISTED	Stock	50.69	51.34	50.56	51.05	31024.0
2010-04-23	ABK-DELISTED	Stock	2.01	2.04	1.94	1.95	30861070.0
2010-04-23	ABM	Stock	21.71	21.92	21.69	21.78	169600.0
2010-04-23	ABMD-DELISTED	Stock	9.95	9.95	9.6	9.61	186597.0
2010-04-23	ABR	Stock	4.45	4.55	4.35	4.37	274900.0
2010-04-23	ABT	Stock	24.4842	24.5706	24.1195	24.5658	19164444.0
2010-04-23	ABTL-DELISTED	Stock	4.7024	4.7024	4.1477	4.3976	87380.0
2010-04-23	ABV-DELISTED	Stock	97.58	99.5	97.58	99.27	412575.0
2010-04-23	ABVA-DELISTED	Stock	2.985	3.0	2.62	2.82	17905.0
2010-04-23	ABVT-DELISTED	Stock	50.9	51.09	50.39	50.95	120899.0
2010-04-23	ABX-DELISTED	Stock	40.05	40.63	39.47	40.44	7110909.0
2010-04-23	ACAD	Stock	1.72	1.77	1.68	1.7	268200.0

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

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