PREVIEW / stock_daily / 2010-07-19

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-19.parquet
  size:    188 KB
  rows:    5,906
  symbols: 3,470

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-07-19	AAPL	Stock	8.9243	8.9243	8.5571	8.7707	1024478000.0
2010-07-19	MSFT	Stock	24.96	25.3	24.91	25.23	38181800.0
2010-07-19	NVDA	Stock	0.2547	0.2625	0.253	0.2615	798440000.0
2010-07-19	AMZN	Stock	5.919	6.037	5.85	5.997	100618000.0
2010-07-19	TSLA	Stock	1.4247	1.4833	1.3947	1.4607	37297500.0
2010-07-19	TLT	Stock	100.56	100.75	99.98	100.18	4305778.0
2010-07-19	ES	Stock	27.02	27.4	26.97	27.26	880800.0
2010-07-19	CL	Stock	41.575	41.795	41.385	41.555	3807400.0
2010-07-19	A	Stock	19.5207	19.8212	19.3634	19.6996	7919530.0
2010-07-19	AABA-DELISTED	Stock	15.23	15.38	15.02	15.09	15701258.0
2010-07-19	AACC-DELISTED	Stock	3.82	3.9	3.75	3.85	36624.0
2010-07-19	AACG	Stock	2.91	2.96	2.91	2.96	2100.0
2010-07-19	AAI-DELISTED	Stock	4.79	4.81	4.6	4.75	2498643.0
2010-07-19	AAIC-DELISTED	Stock	17.74	17.8499	17.4	17.72	37592.0
2010-07-19	AAON	Stock	4.4721	4.6005	4.4642	4.5867	228825.0
2010-07-19	AAP	Stock	51.3	52.19	51.3	51.96	708400.0
2010-07-19	AATI-DELISTED	Stock	3.41	3.47	3.41	3.47	71128.0
2010-07-19	AAU-DELISTED	Stock	0.88	0.9002	0.8556	0.88	123826.0
2010-07-19	AAUAF-DELISTED	Stock	0.88	0.9002	0.8556	0.88	124126.0
2010-07-19	AAV-DELISTED	Stock	6.06	6.15	5.95	6.12	510357.0
2010-07-19	AAWW-DELISTED	Stock	53.77	54.28	52.46	53.55	171220.0
2010-07-19	AAXJ	Stock	53.68	53.98	53.39	53.89	562830.0
2010-07-19	AAXN-DELISTED	Stock	3.72	3.81	3.72	3.78	368313.0
2010-07-19	AB	Stock	27.75	27.83	26.5	26.85	233400.0
2010-07-19	ABAX-DELISTED	Stock	18.28	18.48	17.54	17.71	158008.0
2010-07-19	ABB-DELISTED	Stock	18.27	18.35	17.98	18.14	1800591.0
2010-07-19	ABBC-DELISTED	Stock	8.86	8.97	8.79	8.96	40155.0
2010-07-19	ABBNY-DELISTED	Stock	18.27	18.35	17.98	18.14	1831937.0
2010-07-19	ABC-DELISTED	Stock	32.18	32.27	31.8	32.01	2043733.0
2010-07-19	ABCB	Stock	9.95	10.05	9.74	10.04	77500.0
2010-07-19	ABCD-DELISTED	Stock	3.35	3.37	3.23	3.23	46884.0
2010-07-19	ABCO-DELISTED	Stock	20.32	20.41	19.875	20.33	41482.0
2010-07-19	ABCW-DELISTED	Stock	0.48	0.55	0.48	0.48	29920.0
2010-07-19	ABD-DELISTED	Stock	4.94	5.0	4.76	4.9	360610.0
2010-07-19	ABE-DELISTED	Stock	16.41	16.69	16.41	16.65	14574.0
2010-07-19	ABEO	Stock	2625.0	2750.0	2375.0	2612.5	13.0
2010-07-19	ABFS-DELISTED	Stock	20.85	21.1	20.27	20.88	411774.0
2010-07-19	ABG	Stock	10.43	10.55	10.06	10.38	130500.0
2010-07-19	ABII-DELISTED	Stock	74.46	74.91	74.46	74.65	40308.0
2010-07-19	ABK-DELISTED	Stock	0.661	0.69	0.652	0.655	4949665.0
2010-07-19	ABM	Stock	20.55	20.68	20.18	20.67	148700.0
2010-07-19	ABMD-DELISTED	Stock	11.13	11.27	10.88	11.01	334081.0
2010-07-19	ABR	Stock	5.62	5.9	5.44	5.87	98200.0
2010-07-19	ABT	Stock	22.7473	22.8289	22.6706	22.7473	8753856.0
2010-07-19	ABTL-DELISTED	Stock	5.75	5.9	5.6	5.75	20393.0
2010-07-19	ABV-DELISTED	Stock	106.62	107.4	106.1	106.75	576594.0
2010-07-19	ABVA-DELISTED	Stock	2.56	2.56	2.53	2.53	1000.0
2010-07-19	ABVT-DELISTED	Stock	47.96	48.16	47.11	47.88	105863.0
2010-07-19	ABX-DELISTED	Stock	41.36	41.44	40.56	41.09	8059037.0
2010-07-19	ACAD	Stock	1.07	1.07	1.01	1.04	130200.0

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

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