PREVIEW / stock_daily / 2010-07-20

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-20.parquet
  size:    188 KB
  rows:    5,920
  symbols: 3,481

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-20	AAPL	Stock	8.675	9.0321	8.5718	8.9961	1074950800.0
2010-07-20	MSFT	Stock	24.86	25.48	24.7	25.48	45530700.0
2010-07-20	NVDA	Stock	0.2547	0.2695	0.2525	0.268	1160988000.0
2010-07-20	AMZN	Stock	6.0305	6.0355	5.8755	6.005	135700000.0
2010-07-20	TSLA	Stock	1.4567	1.4567	1.3367	1.3533	27379500.0
2010-07-20	TLT	Stock	100.67	100.9	100.18	100.33	5077056.0
2010-07-20	ES	Stock	27.06	27.6	26.96	27.59	1078500.0
2010-07-20	CL	Stock	41.315	42.005	41.285	41.985	3872000.0
2010-07-20	A	Stock	19.3348	19.7067	19.1273	19.6853	6096818.0
2010-07-20	AABA-DELISTED	Stock	14.99	15.28	14.8	15.17	28425240.0
2010-07-20	AACC-DELISTED	Stock	3.8	3.99	3.77	3.98	16264.0
2010-07-20	AACG	Stock	2.87	3.15	2.87	3.08	7500.0
2010-07-20	AAI-DELISTED	Stock	4.71	4.9	4.68	4.89	1626674.0
2010-07-20	AAIC-DELISTED	Stock	17.55	18.38	17.23	18.37	76088.0
2010-07-20	AAON	Stock	4.5294	4.6894	4.5294	4.6815	170100.0
2010-07-20	AAP	Stock	51.53	53.17	51.39	53.0	843500.0
2010-07-20	AATI-DELISTED	Stock	3.42	3.42	3.34	3.42	70328.0
2010-07-20	AAU-DELISTED	Stock	0.871	0.885	0.86	0.885	84890.0
2010-07-20	AAUAF-DELISTED	Stock	0.871	0.885	0.86	0.885	85190.0
2010-07-20	AAV-DELISTED	Stock	6.13	6.27	6.05	6.2699	511484.0
2010-07-20	AAWW-DELISTED	Stock	52.67	55.17	51.85	55.0	208322.0
2010-07-20	AAXJ	Stock	53.86	54.91	53.67	54.86	164546.0
2010-07-20	AAXN-DELISTED	Stock	3.73	3.86	3.723	3.85	382065.0
2010-07-20	AB	Stock	26.42	27.02	26.19	27.01	329500.0
2010-07-20	ABAC-DELISTED	Stock	6.49	6.49	5.25	5.35	237000.0
2010-07-20	ABAX-DELISTED	Stock	17.59	18.82	17.56	18.75	313525.0
2010-07-20	ABB-DELISTED	Stock	17.95	18.42	17.92	18.38	3084148.0
2010-07-20	ABBC-DELISTED	Stock	8.87	9.08	8.81	9.05	35370.0
2010-07-20	ABBNY-DELISTED	Stock	17.95	18.42	17.92	18.39	3131901.0
2010-07-20	ABC-DELISTED	Stock	31.75	32.27	31.61	32.25	2250109.0
2010-07-20	ABCB	Stock	9.84	9.99	9.71	9.96	59600.0
2010-07-20	ABCD-DELISTED	Stock	3.21	3.3	3.17	3.28	61823.0
2010-07-20	ABCO-DELISTED	Stock	20.15	20.67	20.04	20.64	78249.0
2010-07-20	ABCW-DELISTED	Stock	0.48	0.53	0.47	0.53	27520.0
2010-07-20	ABD-DELISTED	Stock	4.8	5.01	4.7	5.0	500540.0
2010-07-20	ABE-DELISTED	Stock	16.1125	16.87	16.1125	16.87	10196.0
2010-07-20	ABEO	Stock	2875.0	2875.0	2312.5	2500.0	21.0
2010-07-20	ABFS-DELISTED	Stock	20.56	21.65	20.375	21.39	555156.0
2010-07-20	ABG	Stock	10.18	11.04	10.16	10.99	334700.0
2010-07-20	ABII-DELISTED	Stock	74.82	74.82	74.22	74.51	57565.0
2010-07-20	ABK-DELISTED	Stock	0.6595	0.6885	0.65	0.686	4397185.0
2010-07-20	ABM	Stock	20.4	21.09	20.35	21.07	247500.0
2010-07-20	ABMD-DELISTED	Stock	10.89	11.15	10.87	11.14	170458.0
2010-07-20	ABR	Stock	5.71	6.06	5.62	5.96	99600.0
2010-07-20	ABT	Stock	22.613	22.8145	22.4834	22.7761	16479992.0
2010-07-20	ABTL-DELISTED	Stock	5.9073	6.0109	5.5964	5.7	30387.0
2010-07-20	ABV-DELISTED	Stock	105.9	107.2	105.53	107.08	522936.0
2010-07-20	ABVA-DELISTED	Stock	2.53	2.53	2.53	2.53	531.0
2010-07-20	ABVT-DELISTED	Stock	47.25	48.32	46.64	48.25	123120.0
2010-07-20	ABX-DELISTED	Stock	40.91	42.0	40.88	41.8	6262982.0

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

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