PREVIEW / stock_daily / 2013-05-20

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-20.parquet
  size:    210 KB
  rows:    6,328
  symbols: 3,522

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
2013-05-20	AAPL	Stock	15.4254	15.9214	15.3607	15.8189	451578400.0
2013-05-20	MSFT	Stock	34.73	35.1	34.68	35.08	54020800.0
2013-05-20	NVDA	Stock	0.3703	0.3725	0.369	0.371	236380000.0
2013-05-20	AMZN	Stock	13.45	13.5895	13.325	13.3815	44180000.0
2013-05-20	META	Stock	26.18	26.19	25.69	25.76	42402900.0
2013-05-20	TSLA	Stock	6.0747	6.1667	5.9087	5.996	125226000.0
2013-05-20	TLT	Stock	117.63	117.67	116.79	116.922	5839704.0
2013-05-20	ES	Stock	44.45	44.63	44.24	44.43	1039300.0
2013-05-20	CL	Stock	62.04	62.05	61.42	61.55	2321300.0
2013-05-20	A	Stock	32.5322	33.9413	32.4678	33.1474	7966363.0
2013-05-20	AABA-DELISTED	Stock	26.68	27.05	26.21	26.585	24827452.0
2013-05-20	AACC-DELISTED	Stock	6.63	6.66	6.61	6.65	34091.0
2013-05-20	AACG	Stock	4.11	4.25	4.11	4.21	50400.0
2013-05-20	AAIC-DELISTED	Stock	29.08	29.59	28.91	29.2	265430.0
2013-05-20	AAMC-DELISTED	Stock	88.2382	88.2382	88.2382	88.2382	449.0
2013-05-20	AAME	Stock	3.71	3.79	3.63	3.63	12000.0
2013-05-20	AAMRQ-DELISTED	Stock	6.53	6.55	5.95	6.04	13670984.0
2013-05-20	AAON	Stock	9.3896	9.5793	9.3422	9.5289	203175.0
2013-05-20	AAP	Stock	85.79	86.98	85.37	86.52	630400.0
2013-05-20	AAT	Stock	35.13	35.42	34.85	35.01	185900.0
2013-05-20	AAU-DELISTED	Stock	1.49	1.62	1.47	1.62	158392.0
2013-05-20	AAUAF-DELISTED	Stock	1.49	1.62	1.47	1.62	158592.0
2013-05-20	AAV-DELISTED	Stock	3.84	3.89	3.82	3.84	97822.0
2013-05-20	AAWW-DELISTED	Stock	46.0	46.8	45.64	46.31	191154.0
2013-05-20	AAXJ	Stock	61.17	61.28	61.02	61.28	329054.0
2013-05-20	AAXN-DELISTED	Stock	9.02	9.53	8.99	9.21	937106.0
2013-05-20	AB	Stock	25.65	26.88	25.65	26.44	472200.0
2013-05-20	ABAC-DELISTED	Stock	0.68	0.74	0.68	0.7101	18908.0
2013-05-20	ABAX-DELISTED	Stock	45.13	45.42	44.59	44.67	81135.0
2013-05-20	ABB-DELISTED	Stock	22.37	22.43	22.31	22.33	1202158.0
2013-05-20	ABBNY-DELISTED	Stock	22.37	22.43	22.31	22.34	1205931.0
2013-05-20	ABBV	Stock	47.12	47.14	46.07	46.26	3537800.0
2013-05-20	ABC-DELISTED	Stock	55.01	55.23	54.71	54.82	1687335.0
2013-05-20	ABCB	Stock	16.3	16.45	16.12	16.44	17600.0
2013-05-20	ABCD-DELISTED	Stock	1.1799	1.18	1.15	1.15	2247.0
2013-05-20	ABCO-DELISTED	Stock	49.68	50.43	49.61	50.35	282175.0
2013-05-20	ABCW-DELISTED	Stock	0.699	0.699	0.63	0.631	26440.0
2013-05-20	ABE-DELISTED	Stock	21.73	21.85	21.73	21.84	38915.0
2013-05-20	ABEO	Stock	525.0	650.0	525.0	650.0	8.0
2013-05-20	ABFS-DELISTED	Stock	17.39	17.9	17.36	17.76	402979.0
2013-05-20	ABG	Stock	41.47	42.08	41.21	41.53	80700.0
2013-05-20	ABM	Stock	23.29	23.5	23.15	23.29	211000.0
2013-05-20	ABMD-DELISTED	Stock	23.31	23.4	23.02	23.1	378670.0
2013-05-20	ABR	Stock	7.25	7.39	7.1	7.22	218700.0
2013-05-20	ABR.A-DELISTED	Stock	25.59	25.61	25.52	25.6	3500.0
2013-05-20	ABR.B-DELISTED	Stock	25.16	25.22	25.16	25.2	12228.0
2013-05-20	ABT	Stock	36.95	37.93	36.87	37.81	8885200.0
2013-05-20	ABTL-DELISTED	Stock	4.23	4.2605	4.15	4.21	28700.0
2013-05-20	ABUS	Stock	4.73	4.84	4.65	4.7	44800.0
2013-05-20	ABV-DELISTED	Stock	43.2	43.26	42.45	42.52	1704937.0

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

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