PREVIEW / stock_daily / 2011-05-24

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-24.parquet
  size:    198 KB
  rows:    6,115
  symbols: 3,564

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
2011-05-24	AAPL	Stock	11.9821	11.9964	11.8336	11.8639	321927200.0
2011-05-24	MSFT	Stock	24.2	24.29	24.04	24.15	47691800.0
2011-05-24	NVDA	Stock	0.454	0.4718	0.4528	0.4535	720372000.0
2011-05-24	AMZN	Stock	9.85	9.85	9.65	9.6635	59454000.0
2011-05-24	TSLA	Stock	1.8013	1.8333	1.7733	1.7813	9205500.0
2011-05-24	TLT	Stock	95.64	96.14	95.46	96.14	5549151.0
2011-05-24	ES	Stock	35.63	35.66	35.39	35.53	986700.0
2011-05-24	CL	Stock	43.0	43.03	42.675	42.8	3033200.0
2011-05-24	A	Stock	35.2217	35.2217	34.6137	34.8283	4805206.0
2011-05-24	AABA-DELISTED	Stock	16.11	16.41	16.05	16.13	22537751.0
2011-05-24	AACC-DELISTED	Stock	4.06	4.12	3.99	4.0	15872.0
2011-05-24	AACG	Stock	10.03	10.62	10.03	10.62	5700.0
2011-05-24	AAIC-DELISTED	Stock	27.0	27.04	26.35	26.49	81997.0
2011-05-24	AAME	Stock	2.01	2.03	1.97	2.03	2100.0
2011-05-24	AAON	Stock	6.3309	6.5185	6.244	6.2558	376144.0
2011-05-24	AAP	Stock	63.06	63.08	61.91	62.2	1984300.0
2011-05-24	AAT	Stock	21.25	21.47	21.23	21.23	149300.0
2011-05-24	AATI-DELISTED	Stock	3.61	3.67	3.6001	3.66	218377.0
2011-05-24	AAU-DELISTED	Stock	3.75	3.9	3.7	3.85	312598.0
2011-05-24	AAUAF-DELISTED	Stock	3.75	3.9	3.7	3.83	312898.0
2011-05-24	AAV-DELISTED	Stock	7.93	8.05	7.92	7.99	304329.0
2011-05-24	AAWW-DELISTED	Stock	61.59	61.59	60.25	60.61	118998.0
2011-05-24	AAXJ	Stock	61.82	61.82	61.33	61.44	174112.0
2011-05-24	AAXN-DELISTED	Stock	4.49	4.5	4.38	4.38	413837.0
2011-05-24	AB	Stock	21.17	21.41	20.79	20.83	642600.0
2011-05-24	ABAC-DELISTED	Stock	2.92	2.92	2.77	2.77	15272.0
2011-05-24	ABAX-DELISTED	Stock	29.9	30.05	29.1	29.72	98598.0
2011-05-24	ABB-DELISTED	Stock	25.97	26.05	25.85	25.89	2219317.0
2011-05-24	ABBC-DELISTED	Stock	11.28	11.35	11.12	11.28	89975.0
2011-05-24	ABBNY-DELISTED	Stock	25.97	26.05	25.85	25.89	2297042.0
2011-05-24	ABC-DELISTED	Stock	41.36	41.36	40.9	40.92	2031903.0
2011-05-24	ABCB	Stock	8.77	8.87	8.65	8.65	42800.0
2011-05-24	ABCD-DELISTED	Stock	2.9	2.93	2.85	2.9	67150.0
2011-05-24	ABCO-DELISTED	Stock	25.2	25.69	25.18	25.3	155850.0
2011-05-24	ABCW-DELISTED	Stock	0.83	0.8301	0.75	0.75	35440.0
2011-05-24	ABD-DELISTED	Stock	8.35	8.39	8.06	8.16	251230.0
2011-05-24	ABE-DELISTED	Stock	18.44	18.54	18.41	18.49	3832.0
2011-05-24	ABEO	Stock	2562.5	2862.5	2500.0	2812.5	76.0
2011-05-24	ABFS-DELISTED	Stock	24.4	24.68	24.1629	24.41	290885.0
2011-05-24	ABG	Stock	16.1	16.46	16.0	16.32	526400.0
2011-05-24	ABH-DELISTED	Stock	23.49	24.27	23.27	24.11	734634.0
2011-05-24	ABM	Stock	22.99	23.04	22.66	22.69	344900.0
2011-05-24	ABMD-DELISTED	Stock	17.91	18.53	17.75	18.33	631454.0
2011-05-24	ABR	Stock	4.84	5.19	4.8	5.08	45100.0
2011-05-24	ABT	Stock	25.6309	25.6885	25.4246	25.5877	9291580.0
2011-05-24	ABTL-DELISTED	Stock	5.7	6.0	5.45	6.0	41221.0
2011-05-24	ABUS	Stock	2.87	2.87	2.76	2.8	6500.0
2011-05-24	ABV-DELISTED	Stock	31.0	31.0	30.67	30.78	1378509.0
2011-05-24	ABVA-DELISTED	Stock	5.5	5.76	5.5	5.76	1363.0
2011-05-24	ABVT-DELISTED	Stock	63.67	71.52	62.8	69.35	1380854.0

> showing 50 of 6,115 rows — these rows as CSV

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