PREVIEW / stock_daily / 2010-05-04

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-04.parquet
  size:    193 KB
  rows:    5,958
  symbols: 3,523

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-05-04	AAPL	Stock	9.3889	9.4032	9.1696	9.2386	723819600.0
2010-05-04	MSFT	Stock	30.52	30.55	29.75	30.13	82085600.0
2010-05-04	NVDA	Stock	0.3825	0.3833	0.3632	0.3688	1311376000.0
2010-05-04	AMZN	Stock	6.781	6.7905	6.419	6.4915	253356000.0
2010-05-04	TLT	Stock	92.81	93.47	92.56	93.34	11059904.0
2010-05-04	ES	Stock	27.48	27.58	27.23	27.38	1622600.0
2010-05-04	CL	Stock	41.92	41.965	41.36	41.435	5942000.0
2010-05-04	A	Stock	26.0086	26.0086	25.1216	25.2933	4539446.0
2010-05-04	AABA-DELISTED	Stock	16.63	16.9	16.25	16.32	30917121.0
2010-05-04	AACC-DELISTED	Stock	7.37	7.37	7.14	7.26	31383.0
2010-05-04	AACG	Stock	3.5	3.56	3.5	3.55	6700.0
2010-05-04	AAI-DELISTED	Stock	5.38	5.38	5.22	5.31	5520259.0
2010-05-04	AAIC-DELISTED	Stock	20.5	20.59	20.29	20.35	46843.0
2010-05-04	AAME	Stock	1.77	1.81	1.65	1.7	16500.0
2010-05-04	AAON	Stock	4.7565	4.7664	4.6005	4.644	356400.0
2010-05-04	AAP	Stock	45.92	45.92	45.31	45.67	1036800.0
2010-05-04	AATI-DELISTED	Stock	3.88	3.93	3.74	3.76	546408.0
2010-05-04	AAU-DELISTED	Stock	1.18	1.18	1.1	1.14	192258.0
2010-05-04	AAUAF-DELISTED	Stock	1.18	1.18	1.1	1.14	193458.0
2010-05-04	AAV-DELISTED	Stock	7.0	7.08	6.79	6.87	556897.0
2010-05-04	AAWW-DELISTED	Stock	55.03	55.5	53.501	54.78	370328.0
2010-05-04	AAXJ	Stock	56.55	56.55	55.1	55.4	1438338.0
2010-05-04	AAXN-DELISTED	Stock	4.79	4.81	4.69	4.75	1415346.0
2010-05-04	AB	Stock	31.56	31.56	30.14	31.13	752100.0
2010-05-04	ABAX-DELISTED	Stock	25.46	25.46	24.38	25.09	148075.0
2010-05-04	ABB-DELISTED	Stock	18.96	18.96	18.57	18.7335	4788622.0
2010-05-04	ABBC-DELISTED	Stock	9.6	10.2	9.49	10.0	76911.0
2010-05-04	ABBNY-DELISTED	Stock	18.96	18.96	18.57	18.75	5008904.0
2010-05-04	ABC-DELISTED	Stock	31.05	31.18	30.72	30.97	2846205.0
2010-05-04	ABCB	Stock	10.7687	10.8782	10.5597	10.709	401302.0
2010-05-04	ABCD-DELISTED	Stock	5.0001	5.1	4.92	5.0	18536.0
2010-05-04	ABCO-DELISTED	Stock	16.632	16.958	16.562	16.728	114606.0
2010-05-04	ABCW-DELISTED	Stock	1.07	1.07	0.95	1.02	152560.0
2010-05-04	ABD-DELISTED	Stock	8.98	9.0	8.29	8.36	419980.0
2010-05-04	ABE-DELISTED	Stock	16.83	16.83	16.33	16.41	14282.0
2010-05-04	ABEO	Stock	3250.0	3300.0	3137.5	3150.0	8.0
2010-05-04	ABFS-DELISTED	Stock	30.35	30.53	29.13	29.31	605737.0
2010-05-04	ABG	Stock	15.6	15.68	15.09	15.17	368900.0
2010-05-04	ABII-DELISTED	Stock	50.12	50.12	48.742	49.09	37398.0
2010-05-04	ABK-DELISTED	Stock	1.54	1.63	1.48	1.51	47662417.0
2010-05-04	ABM	Stock	21.81	21.81	21.45	21.73	315900.0
2010-05-04	ABMD-DELISTED	Stock	9.74	9.8	9.24	9.27	196418.0
2010-05-04	ABR	Stock	4.15	4.18	3.93	4.01	167000.0
2010-05-04	ABT	Stock	24.3067	24.4026	23.8557	24.0812	21711963.0
2010-05-04	ABTL-DELISTED	Stock	4.5	4.6	4.45	4.6	10482.0
2010-05-04	ABV-DELISTED	Stock	97.68	98.08	95.41	97.15	670884.0
2010-05-04	ABVA-DELISTED	Stock	3.1	3.14	3.1	3.14	588.0
2010-05-04	ABVT-DELISTED	Stock	50.16	50.235	48.83	49.23	112265.0
2010-05-04	ABX-DELISTED	Stock	43.2	43.56	41.95	42.97	13604025.0
2010-05-04	ACAD	Stock	1.65	1.65	1.57	1.57	320500.0

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

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