PREVIEW / stock_daily / 2010-05-03

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-03.parquet
  size:    193 KB
  rows:    5,983
  symbols: 3,536

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-03	AAPL	Stock	9.4229	9.5671	9.3886	9.5125	454342000.0
2010-05-03	MSFT	Stock	30.67	31.06	30.58	30.86	43989500.0
2010-05-03	NVDA	Stock	0.3948	0.397	0.3825	0.3885	1078972000.0
2010-05-03	AMZN	Stock	6.86	6.972	6.8055	6.8745	113092000.0
2010-05-03	TLT	Stock	91.42	92.02	91.28	91.69	4211801.0
2010-05-03	ES	Stock	27.96	28.0	27.6	27.75	2588300.0
2010-05-03	CL	Stock	42.15	42.23	41.76	42.135	4227200.0
2010-05-03	A	Stock	26.1087	26.3877	26.0157	26.3019	2599162.0
2010-05-03	AABA-DELISTED	Stock	16.68	16.985	16.56	16.92	18009936.0
2010-05-03	AACC-DELISTED	Stock	7.39	7.48	7.32	7.47	32928.0
2010-05-03	AACG	Stock	3.53	3.56	3.5	3.52	14200.0
2010-05-03	AAI-DELISTED	Stock	5.31	5.5	5.3	5.46	3986265.0
2010-05-03	AAIC-DELISTED	Stock	20.3	20.78	20.3	20.74	24990.0
2010-05-03	AAME	Stock	1.76	1.82	1.76	1.82	400.0
2010-05-03	AAON	Stock	4.7704	4.8395	4.6815	4.8316	279450.0
2010-05-03	AAP	Stock	45.13	46.46	45.09	46.32	861000.0
2010-05-03	AATI-DELISTED	Stock	3.81	3.85	3.66	3.78	237759.0
2010-05-03	AAU-DELISTED	Stock	1.29	1.29	1.09	1.19	208583.0
2010-05-03	AAUAF-DELISTED	Stock	1.29	1.29	1.09	1.19	208783.0
2010-05-03	AAV-DELISTED	Stock	7.1	7.24	7.05	7.21	272975.0
2010-05-03	AAWW-DELISTED	Stock	55.45	56.5	55.02	55.96	524940.0
2010-05-03	AAXJ	Stock	56.79	57.436	56.79	57.24	125247.0
2010-05-03	AAXN-DELISTED	Stock	4.86	4.86	4.61	4.84	1160118.0
2010-05-03	AB	Stock	31.74	32.3	31.61	32.19	227100.0
2010-05-03	ABAX-DELISTED	Stock	25.89	25.89	25.02	25.76	209861.0
2010-05-03	ABB-DELISTED	Stock	19.28	19.575	19.22	19.45	2828812.0
2010-05-03	ABBC-DELISTED	Stock	9.5	9.75	9.4399	9.75	71687.0
2010-05-03	ABBNY-DELISTED	Stock	19.28	19.575	19.22	19.45	2832791.0
2010-05-03	ABC-DELISTED	Stock	31.03	31.36	30.91	31.27	2469768.0
2010-05-03	ABCB	Stock	11.137	11.1967	10.6194	10.8882	110423.0
2010-05-03	ABCD-DELISTED	Stock	4.92	5.17	4.89	5.1	39000.0
2010-05-03	ABCO-DELISTED	Stock	16.725	16.86	16.51	16.855	78506.0
2010-05-03	ABCW-DELISTED	Stock	1.0403	1.0712	0.9785	1.03	185820.0
2010-05-03	ABD-DELISTED	Stock	9.19	9.3	9.05	9.2	409100.0
2010-05-03	ABE-DELISTED	Stock	17.06	17.06	16.901	16.9245	7993.0
2010-05-03	ABEO	Stock	3250.0	3312.5	3137.5	3312.5	24.0
2010-05-03	ABFS-DELISTED	Stock	30.52	31.09	30.44	31.07	482586.0
2010-05-03	ABG	Stock	15.67	16.32	15.48	15.93	373500.0
2010-05-03	ABII-DELISTED	Stock	50.03	50.47	49.52	50.39	35817.0
2010-05-03	ABK-DELISTED	Stock	1.53	1.78	1.31	1.718	93440744.0
2010-05-03	ABM	Stock	21.63	22.04	21.44	22.03	131000.0
2010-05-03	ABMD-DELISTED	Stock	9.64	9.98	9.51	9.88	311677.0
2010-05-03	ABR	Stock	4.09	4.35	4.06	4.24	111600.0
2010-05-03	ABT	Stock	24.6857	24.7529	24.2491	24.4074	18336182.0
2010-05-03	ABTL-DELISTED	Stock	4.6498	4.6498	4.2502	4.5002	3790.0
2010-05-03	ABV-DELISTED	Stock	99.38	100.64	97.9	98.79	382878.0
2010-05-03	ABVA-DELISTED	Stock	3.1001	3.1001	3.1001	3.1001	500.0
2010-05-03	ABVT-DELISTED	Stock	50.54	52.1	50.2	50.8	93433.0
2010-05-03	ABX-DELISTED	Stock	43.95	44.11	42.32	42.83	7986407.0
2010-05-03	ACAD	Stock	1.66	1.7	1.65	1.67	274900.0

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

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