PREVIEW / stock_daily / 2012-05-31

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-31.parquet
  size:    200 KB
  rows:    6,217
  symbols: 3,567

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
2012-05-31	AAPL	Stock	20.7407	20.7679	20.4093	20.6332	491674400.0
2012-05-31	MSFT	Stock	29.3	29.42	28.94	29.19	39134000.0
2012-05-31	NVDA	Stock	0.3143	0.3155	0.3068	0.3108	358192000.0
2012-05-31	AMZN	Stock	10.474	10.6895	10.3555	10.6455	98880000.0
2012-05-31	META	Stock	28.55	29.67	26.83	29.6	111639200.0
2012-05-31	TSLA	Stock	2.0047	2.0193	1.9167	1.9667	16780500.0
2012-05-31	TLT	Stock	127.03	129.08	126.67	127.6	31176344.0
2012-05-31	ES	Stock	35.99	36.36	35.68	36.01	2277500.0
2012-05-31	CL	Stock	49.505	49.505	49.02	49.15	4892400.0
2012-05-31	A	Stock	29.6567	29.7711	28.8054	29.0844	5887258.0
2012-05-31	AABA-DELISTED	Stock	15.23	15.37	15.12	15.25	16199245.0
2012-05-31	AACC-DELISTED	Stock	5.54	5.9	5.54	5.81	43364.0
2012-05-31	AACG	Stock	6.13	6.13	5.35	5.36	9600.0
2012-05-31	AAIC-DELISTED	Stock	22.36	22.79	22.27	22.58	77033.0
2012-05-31	AAME	Stock	2.77	2.78	2.75	2.77	2000.0
2012-05-31	AAMRQ-DELISTED	Stock	0.466	0.4754	0.461	0.467	703546.0
2012-05-31	AAON	Stock	5.6385	5.6385	5.4904	5.5526	281813.0
2012-05-31	AAP	Stock	72.65	73.43	71.65	72.94	1007300.0
2012-05-31	AAT	Stock	22.73	22.81	22.46	22.59	296900.0
2012-05-31	AAU-DELISTED	Stock	1.94	1.97	1.87	1.91	55543.0
2012-05-31	AAUAF-DELISTED	Stock	1.94	1.97	1.87	1.91	55644.0
2012-05-31	AAV-DELISTED	Stock	2.86	2.86	2.76	2.78	179865.0
2012-05-31	AAWW-DELISTED	Stock	45.49	45.83	44.19	45.42	169608.0
2012-05-31	AAXJ	Stock	50.67	51.06	50.37	50.71	408750.0
2012-05-31	AAXN-DELISTED	Stock	5.31	5.46	5.23	5.38	375729.0
2012-05-31	AB	Stock	13.08	13.08	12.87	12.9	164500.0
2012-05-31	ABAC-DELISTED	Stock	1.4899	1.5	1.45	1.45	1300.0
2012-05-31	ABAX-DELISTED	Stock	32.45	33.31	31.7	32.75	114176.0
2012-05-31	ABB-DELISTED	Stock	15.83	15.89	15.51	15.81	4071589.0
2012-05-31	ABBNY-DELISTED	Stock	15.83	15.89	15.51	15.81	4069846.0
2012-05-31	ABC-DELISTED	Stock	36.8	37.26	36.54	36.99	3960777.0
2012-05-31	ABCB	Stock	11.37	11.46	11.2	11.37	58100.0
2012-05-31	ABCD-DELISTED	Stock	1.29	1.33	1.21	1.21	78097.0
2012-05-31	ABCO-DELISTED	Stock	48.12	48.67	47.89	48.43	195019.0
2012-05-31	ABCW-DELISTED	Stock	0.4418	0.4619	0.4418	0.4619	4510.0
2012-05-31	ABE-DELISTED	Stock	17.87	17.99	17.81	17.89	12475.0
2012-05-31	ABEO	Stock	1062.5	1225.0	1062.5	1225.0	45.0
2012-05-31	ABFS-DELISTED	Stock	12.69	12.82	12.4	12.64	348423.0
2012-05-31	ABG	Stock	26.54	27.07	25.96	26.73	249500.0
2012-05-31	ABM	Stock	21.3	21.67	20.92	21.47	349400.0
2012-05-31	ABMD-DELISTED	Stock	20.48	20.75	19.9	20.35	676110.0
2012-05-31	ABR	Stock	5.91	6.1	5.88	6.1	29600.0
2012-05-31	ABT	Stock	29.69	29.81	29.4645	29.6468	11688620.0
2012-05-31	ABTL-DELISTED	Stock	3.6735	3.6735	3.6	3.6	15944.0
2012-05-31	ABUS	Stock	2.1	2.15	2.05	2.15	5100.0
2012-05-31	ABV-DELISTED	Stock	37.01	38.38	36.99	38.35	5904332.0
2012-05-31	ABVA-DELISTED	Stock	4.34	4.4	4.32	4.32	10900.0
2012-05-31	ABVT-DELISTED	Stock	83.23	83.39	83.21	83.3	173034.0
2012-05-31	ABX-DELISTED	Stock	39.03	39.6	38.53	39.03	9471631.0
2012-05-31	ACAD	Stock	1.42	1.42	1.37	1.38	146200.0

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

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