PREVIEW / stock_daily / 2015-04-13

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-13.parquet
  size:    223 KB
  rows:    6,649
  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
2015-04-13	AAPL	Stock	32.0925	32.1425	31.6525	31.7125	145460400.0
2015-04-13	MSFT	Stock	41.4	42.06	41.39	41.76	30276700.0
2015-04-13	NVDA	Stock	0.5678	0.571	0.5612	0.5638	236724000.0
2015-04-13	AMZN	Stock	19.1765	19.264	19.007	19.118	37890000.0
2015-04-13	GOOGL	Stock	27.3525	27.6635	27.315	27.432	29325540.0
2015-04-13	META	Stock	81.93	83.94	81.92	83.01	26883100.0
2015-04-13	TSLA	Stock	14.0293	14.2	13.9367	13.9853	56373000.0
2015-04-13	TLT	Stock	129.53	129.98	129.39	129.8	4010619.0
2015-04-13	ES	Stock	50.31	50.41	49.61	49.68	1003300.0
2015-04-13	CL	Stock	69.35	69.77	69.13	69.31	1553600.0
2015-04-13	A	Stock	43.59	43.59	42.99	43.04	3708600.0
2015-04-13	AA.B-DELISTED	Stock	44.5	45.12	44.47	45.05	110821.0
2015-04-13	AABA-DELISTED	Stock	45.25	45.59	44.7232	44.76	8189268.0
2015-04-13	AAC-DELISTED	Stock	32.27	32.27	30.91	31.27	97835.0
2015-04-13	AACG	Stock	4.6	4.6	4.54	4.55	7900.0
2015-04-13	AAIC-DELISTED	Stock	24.17	24.19	24.0	24.0	193959.0
2015-04-13	AAL	Stock	47.47	48.59	47.47	47.79	9350300.0
2015-04-13	AAMC-DELISTED	Stock	70.5941	70.5941	66.1912	68.75	62036.0
2015-04-13	AAME	Stock	4.0	4.0	3.95	4.0	2400.0
2015-04-13	AAMI	Stock	18.7	19.35	18.67	18.91	282800.0
2015-04-13	AAOI	Stock	13.45	13.455	13.15	13.19	105000.0
2015-04-13	AAON	Stock	15.9	16.2	15.7933	15.8933	150300.0
2015-04-13	AAP	Stock	149.97	150.75	148.92	149.18	376600.0
2015-04-13	AAT	Stock	42.1	42.12	41.69	41.69	103800.0
2015-04-13	AAU-DELISTED	Stock	0.8	0.81	0.7897	0.7903	155073.0
2015-04-13	AAUAF-DELISTED	Stock	0.8	0.81	0.79	0.79	161194.0
2015-04-13	AAV-DELISTED	Stock	5.61	5.68	5.58	5.64	72158.0
2015-04-13	AAVL-DELISTED	Stock	40.56	41.087	38.53	39.22	210463.0
2015-04-13	AAWW-DELISTED	Stock	43.61	45.2	43.55	44.99	231079.0
2015-04-13	AAXJ	Stock	68.61	68.86	68.27	68.32	1542639.0
2015-04-13	AAXN-DELISTED	Stock	27.28	27.46	26.82	27.03	974476.0
2015-04-13	AB	Stock	31.21	31.64	31.2	31.3	206100.0
2015-04-13	ABAC-DELISTED	Stock	1.685	1.685	1.6565	1.6565	700.0
2015-04-13	ABAX-DELISTED	Stock	64.02	64.48	63.95	64.25	47306.0
2015-04-13	ABB-DELISTED	Stock	21.52	21.6	21.43	21.48	777650.0
2015-04-13	ABBNY-DELISTED	Stock	21.52	21.6	21.43	21.48	814402.0
2015-04-13	ABBV	Stock	61.81	62.16	61.06	61.2	11400900.0
2015-04-13	ABC-DELISTED	Stock	115.31	115.8799	113.66	113.94	1659838.0
2015-04-13	ABCB	Stock	26.7	26.86	26.7	26.8	52500.0
2015-04-13	ABCD-DELISTED	Stock	3.05	3.05	2.85	2.99	40754.0
2015-04-13	ABCO-DELISTED	Stock	53.56	54.31	53.06	53.77	139617.0
2015-04-13	ABCW-DELISTED	Stock	34.5	34.65	34.31	34.48	3094.0
2015-04-13	ABDC-DELISTED	Stock	14.18	14.23	14.02	14.09	31221.0
2015-04-13	ABE-DELISTED	Stock	13.16	13.22	13.16	13.2	1323.0
2015-04-13	ABEO	Stock	85.25	87.5	81.5	83.75	1532.0
2015-04-13	ABEOW-DELISTED	Stock	1.11	1.11	1.11	1.11	100.0
2015-04-13	ABEV	Stock	6.33	6.37	6.24	6.26	7003600.0
2015-04-13	ABG	Stock	85.14	85.87	84.83	85.35	213200.0
2015-04-13	ABGB-DELISTED	Stock	17.83	18.37	17.8	18.0999	183808.0
2015-04-13	ABIL-DELISTED	Stock	9.85	10.08	9.65	9.99	12200.0

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

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