PREVIEW / stock_daily / 2010-04-29

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-29.parquet
  size:    193 KB
  rows:    5,979
  symbols: 3,535

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-29	AAPL	Stock	9.3936	9.6429	9.3575	9.5943	558840800.0
2010-04-29	MSFT	Stock	30.93	31.43	30.67	31.0	52665200.0
2010-04-29	NVDA	Stock	0.4053	0.4168	0.3993	0.4162	987128000.0
2010-04-29	AMZN	Stock	7.0045	7.1225	6.9895	7.0865	126284000.0
2010-04-29	TLT	Stock	90.86	91.2225	90.52	91.08	4067153.0
2010-04-29	ES	Stock	27.49	27.59	27.26	27.57	1352900.0
2010-04-29	CL	Stock	42.25	42.91	42.18	42.4	6213200.0
2010-04-29	A	Stock	26.4163	26.7525	26.3662	26.6309	3237349.0
2010-04-29	AABA-DELISTED	Stock	16.82	17.05	16.78	16.97	16610889.0
2010-04-29	AACC-DELISTED	Stock	7.22	7.44	7.22	7.42	30810.0
2010-04-29	AACG	Stock	3.46	3.53	3.33	3.53	10400.0
2010-04-29	AAI-DELISTED	Stock	5.43	5.47	5.3	5.35	4084257.0
2010-04-29	AAIC-DELISTED	Stock	20.65	20.73	20.581	20.65	59106.0
2010-04-29	AAME	Stock	1.9	1.91	1.85	1.87	4900.0
2010-04-29	AAON	Stock	4.7783	4.8593	4.6657	4.8474	302231.0
2010-04-29	AAP	Stock	46.05	46.88	45.75	45.88	1879400.0
2010-04-29	AATI-DELISTED	Stock	3.93	4.02	3.91	4.01	387956.0
2010-04-29	AAU-DELISTED	Stock	1.19	1.19	1.11	1.13	133685.0
2010-04-29	AAUAF-DELISTED	Stock	1.19	1.19	1.11	1.13	133885.0
2010-04-29	AAV-DELISTED	Stock	7.24	7.34	7.17	7.22	366746.0
2010-04-29	AAWW-DELISTED	Stock	56.92	57.32	56.13	56.64	357525.0
2010-04-29	AAXJ	Stock	57.39	57.69	57.11	57.67	123994.0
2010-04-29	AAXN-DELISTED	Stock	4.86	4.9	4.81	4.89	1362073.0
2010-04-29	AB	Stock	31.59	32.67	31.59	32.09	599100.0
2010-04-29	ABAX-DELISTED	Stock	26.86	28.11	26.83	28.06	231837.0
2010-04-29	ABB-DELISTED	Stock	19.64	19.65	19.13	19.35	8519479.0
2010-04-29	ABBC-DELISTED	Stock	9.61	9.61	9.2	9.45	103730.0
2010-04-29	ABBNY-DELISTED	Stock	19.64	19.65	19.13	19.34	8610112.0
2010-04-29	ABC-DELISTED	Stock	30.97	31.64	30.93	31.38	3885150.0
2010-04-29	ABCB	Stock	11.0872	11.1967	10.6493	11.0275	258927.0
2010-04-29	ABCD-DELISTED	Stock	5.21	5.29	5.12	5.24	34457.0
2010-04-29	ABCO-DELISTED	Stock	16.915	17.275	16.83	17.135	88822.0
2010-04-29	ABCW-DELISTED	Stock	1.0698	1.1513	0.9883	1.08	582950.0
2010-04-29	ABD-DELISTED	Stock	9.25	9.47	9.21	9.32	348760.0
2010-04-29	ABE-DELISTED	Stock	16.92	17.04	16.888	16.98	15664.0
2010-04-29	ABEO	Stock	3375.0	3375.0	3250.0	3325.0	13.0
2010-04-29	ABFS-DELISTED	Stock	29.81	31.64	29.67	31.54	624344.0
2010-04-29	ABG	Stock	14.67	16.92	14.67	16.79	1492400.0
2010-04-29	ABII-DELISTED	Stock	50.85	51.01	49.101	50.18	75726.0
2010-04-29	ABK-DELISTED	Stock	1.74	1.75	1.65	1.67	19022465.0
2010-04-29	ABM	Stock	21.99	22.14	21.65	22.0	185000.0
2010-04-29	ABMD-DELISTED	Stock	9.35	9.8	9.1858	9.8	190001.0
2010-04-29	ABR	Stock	4.0	4.24	3.92	4.21	157600.0
2010-04-29	ABT	Stock	24.2347	24.5322	24.1531	24.3498	19325135.0
2010-04-29	ABTL-DELISTED	Stock	4.95	4.95	4.4505	4.5	5120.0
2010-04-29	ABV-DELISTED	Stock	96.78	98.36	96.63	97.9	555240.0
2010-04-29	ABVA-DELISTED	Stock	3.2	3.3	3.18	3.3	1565.0
2010-04-29	ABVT-DELISTED	Stock	50.21	51.12	49.99	50.97	154250.0
2010-04-29	ABX-DELISTED	Stock	42.79	43.5	42.47	42.88	14133790.0
2010-04-29	ACAD	Stock	1.59	1.67	1.56	1.59	352700.0

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

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