PREVIEW / stock_daily / 2010-05-05

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-05.parquet
  size:    192 KB
  rows:    5,953
  symbols: 3,515

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-05	AAPL	Stock	9.0368	9.2193	8.8832	9.1425	883103200.0
2010-05-05	MSFT	Stock	29.77	30.09	29.69	29.85	66833800.0
2010-05-05	NVDA	Stock	0.3612	0.3718	0.358	0.3625	1330840000.0
2010-05-05	AMZN	Stock	6.4	6.5805	6.3775	6.5465	189162000.0
2010-05-05	TLT	Stock	94.06	94.85	93.35	93.89	12219043.0
2010-05-05	ES	Stock	27.15	27.43	26.92	27.09	1260400.0
2010-05-05	CL	Stock	41.455	41.83	41.225	41.36	5291000.0
2010-05-05	A	Stock	24.9785	25.2575	24.6423	24.8641	4609905.0
2010-05-05	AABA-DELISTED	Stock	16.18	16.7	16.11	16.5	22380625.0
2010-05-05	AACC-DELISTED	Stock	7.22	7.47	7.22	7.4	21255.0
2010-05-05	AACG	Stock	3.5	3.52	3.5	3.52	15400.0
2010-05-05	AAI-DELISTED	Stock	5.25	5.36	5.11	5.16	4585951.0
2010-05-05	AAIC-DELISTED	Stock	20.3	20.58	20.0	20.49	54538.0
2010-05-05	AAME	Stock	1.68	1.68	1.65	1.65	6500.0
2010-05-05	AAON	Stock	4.6064	4.6657	4.4227	4.4583	699637.0
2010-05-05	AAP	Stock	45.2	46.49	45.02	45.12	1366700.0
2010-05-05	AATI-DELISTED	Stock	3.72	3.8	3.67	3.75	581398.0
2010-05-05	AAU-DELISTED	Stock	1.13	1.13	1.1	1.1	100012.0
2010-05-05	AAUAF-DELISTED	Stock	1.13	1.13	1.1	1.1	100512.0
2010-05-05	AAV-DELISTED	Stock	6.75	6.81	6.51	6.64	427341.0
2010-05-05	AAWW-DELISTED	Stock	56.5	59.02	54.29	54.81	1313458.0
2010-05-05	AAXJ	Stock	54.64	55.13	54.01	54.58	194469.0
2010-05-05	AAXN-DELISTED	Stock	4.74	4.78	4.65	4.76	1090134.0
2010-05-05	AB	Stock	31.05	31.21	30.29	30.53	551300.0
2010-05-05	ABAX-DELISTED	Stock	24.98	25.51	24.55	25.2	128810.0
2010-05-05	ABB-DELISTED	Stock	18.43	18.4501	17.86	18.1	8608299.0
2010-05-05	ABBC-DELISTED	Stock	9.97	10.045	9.76	9.79	88542.0
2010-05-05	ABBNY-DELISTED	Stock	18.42	18.4501	17.86	18.1	9059811.0
2010-05-05	ABC-DELISTED	Stock	30.53	31.2	30.53	31.02	3660446.0
2010-05-05	ABCB	Stock	10.6194	10.6592	10.4602	10.6294	156642.0
2010-05-05	ABCD-DELISTED	Stock	4.96	5.08	4.85	5.01	25025.0
2010-05-05	ABCO-DELISTED	Stock	16.6	16.85	16.525	16.755	112774.0
2010-05-05	ABCW-DELISTED	Stock	1.02	1.02	0.95	0.96	148410.0
2010-05-05	ABD-DELISTED	Stock	8.26	8.36	7.85	8.15	423870.0
2010-05-05	ABE-DELISTED	Stock	16.25	16.45	16.05	16.12	16318.0
2010-05-05	ABEO	Stock	3150.0	3250.0	3125.0	3250.0	10.0
2010-05-05	ABFS-DELISTED	Stock	28.94	29.27	28.45	28.74	626722.0
2010-05-05	ABG	Stock	14.97	15.12	14.59	14.6	329800.0
2010-05-05	ABII-DELISTED	Stock	48.88	49.08	48.01	48.67	60907.0
2010-05-05	ABK-DELISTED	Stock	1.39	1.6	1.39	1.48	30657337.0
2010-05-05	ABM	Stock	21.85	22.22	21.68	21.72	313800.0
2010-05-05	ABMD-DELISTED	Stock	9.17	9.31	8.99	9.0	180424.0
2010-05-05	ABR	Stock	3.98	4.1	3.8	4.03	131500.0
2010-05-05	ABT	Stock	24.0956	24.5034	23.87	24.062	22362860.0
2010-05-05	ABTL-DELISTED	Stock	4.5502	5.2503	4.3552	5.0498	110333.0
2010-05-05	ABV-DELISTED	Stock	95.55	97.72	95.07	95.8	825998.0
2010-05-05	ABVA-DELISTED	Stock	3.2499	3.2499	3.01	3.09	3290.0
2010-05-05	ABVT-DELISTED	Stock	48.5	49.8	47.74	48.93	142735.0
2010-05-05	ABX-DELISTED	Stock	41.75	43.27	41.63	42.88	11283351.0
2010-05-05	ACAD	Stock	1.55	1.64	1.52	1.58	388200.0

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

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