PREVIEW / stock_daily / 2010-10-07

all stock daily files

  file:    by_date/stock_daily/2010/2010-10-07.parquet
  size:    191 KB
  rows:    5,985
  symbols: 3,512

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-10-07	AAPL	Stock	10.3693	10.3743	10.2468	10.3293	408399600.0
2010-10-07	MSFT	Stock	24.62	24.75	24.28	24.53	50096100.0
2010-10-07	NVDA	Stock	0.2708	0.271	0.2595	0.2675	761488000.0
2010-10-07	AMZN	Stock	7.8255	7.87	7.6695	7.8135	92440000.0
2010-10-07	TSLA	Stock	1.3713	1.376	1.356	1.362	2115000.0
2010-10-07	TLT	Stock	105.17	105.38	104.67	104.68	5780957.0
2010-10-07	ES	Stock	30.3	30.39	30.13	30.23	799400.0
2010-10-07	CL	Stock	37.22	37.25	36.835	36.875	7566800.0
2010-10-07	A	Stock	23.5551	23.9771	23.4907	23.7482	5224606.0
2010-10-07	AABA-DELISTED	Stock	14.6	14.61	14.14	14.24	17441687.0
2010-10-07	AACC-DELISTED	Stock	5.38	5.38	5.13	5.2	14691.0
2010-10-07	AACG	Stock	3.07	3.07	3.05	3.05	1000.0
2010-10-07	AAI-DELISTED	Stock	7.35	7.35	7.34	7.34	3365577.0
2010-10-07	AAIC-DELISTED	Stock	23.51	23.52	23.3	23.32	23143.0
2010-10-07	AAME	Stock	1.68	1.75	1.66	1.72	2800.0
2010-10-07	AAON	Stock	4.8395	4.8395	4.6598	4.6775	110362.0
2010-10-07	AAP	Stock	58.76	59.06	58.1	58.79	553800.0
2010-10-07	AATI-DELISTED	Stock	3.45	3.55	3.43	3.5	238311.0
2010-10-07	AAU-DELISTED	Stock	3.14	3.15	2.77	2.849	866341.0
2010-10-07	AAUAF-DELISTED	Stock	3.14	3.15	2.77	2.849	867441.0
2010-10-07	AAV-DELISTED	Stock	6.38	6.38	6.25	6.28	307214.0
2010-10-07	AAWW-DELISTED	Stock	52.55	52.65	51.29	51.98	183089.0
2010-10-07	AAXJ	Stock	62.6	62.6	62.01	62.27	740038.0
2010-10-07	AAXN-DELISTED	Stock	4.03	4.12	3.98	4.11	459512.0
2010-10-07	AB	Stock	27.31	27.31	26.76	27.04	176200.0
2010-10-07	ABAC-DELISTED	Stock	4.29	4.39	4.29	4.3	13420.0
2010-10-07	ABAX-DELISTED	Stock	23.56	23.71	23.31	23.34	42156.0
2010-10-07	ABB-DELISTED	Stock	22.03	22.04	21.59	21.76	1670680.0
2010-10-07	ABBC-DELISTED	Stock	10.8	10.8	10.55	10.5775	32200.0
2010-10-07	ABBNY-DELISTED	Stock	22.03	22.04	21.59	21.79	1682991.0
2010-10-07	ABC-DELISTED	Stock	31.58	32.1	31.49	31.7	4440254.0
2010-10-07	ABCB	Stock	9.94	9.95	9.73	9.74	78500.0
2010-10-07	ABCD-DELISTED	Stock	3.08	3.109	3.03	3.08	20398.0
2010-10-07	ABCO-DELISTED	Stock	23.17	23.17	22.88	22.91	72477.0
2010-10-07	ABCW-DELISTED	Stock	0.6804	0.6806	0.6796	0.6796	28220.0
2010-10-07	ABD-DELISTED	Stock	5.88	5.92	5.64	5.73	158450.0
2010-10-07	ABE-DELISTED	Stock	19.45	19.45	19.02	19.16	31523.0
2010-10-07	ABEO	Stock	3187.5	3287.5	3062.5	3125.0	40.0
2010-10-07	ABFS-DELISTED	Stock	24.42	24.54	24.0	24.03	146898.0
2010-10-07	ABG	Stock	14.28	14.4	14.01	14.29	123300.0
2010-10-07	ABII-DELISTED	Stock	77.2	77.2	76.57	76.78	20447.0
2010-10-07	ABK-DELISTED	Stock	0.7686	0.937	0.76	0.79	67670894.0
2010-10-07	ABM	Stock	22.29	22.42	22.01	22.03	154300.0
2010-10-07	ABMD-DELISTED	Stock	11.03	11.03	10.8	10.86	57107.0
2010-10-07	ABR	Stock	5.14	5.16	5.03	5.12	72800.0
2010-10-07	ABT	Stock	25.5206	25.5398	25.1607	25.2279	33616924.0
2010-10-07	ABTL-DELISTED	Stock	4.1975	4.3526	4.1525	4.2525	56944.0
2010-10-07	ABV-DELISTED	Stock	130.57	130.6	128.88	129.85	761149.0
2010-10-07	ABVA-DELISTED	Stock	2.85	2.86	2.8	2.8	7177.0
2010-10-07	ABVT-DELISTED	Stock	52.5	53.08	52.5	52.93	70349.0

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

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