PREVIEW / stock_daily / 2015-03-13

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-13.parquet
  size:    222 KB
  rows:    6,593
  symbols: 3,487

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-03-13	AAPL	Stock	31.1	31.35	30.645	30.8975	207309200.0
2015-03-13	MSFT	Stock	40.7	41.47	40.61	41.38	58007700.0
2015-03-13	NVDA	Stock	0.564	0.569	0.5562	0.5675	359288000.0
2015-03-13	AMZN	Stock	18.576	18.6995	18.334	18.529	52234000.0
2015-03-13	GOOGL	Stock	27.9615	28.218	27.5165	27.65	35427080.0
2015-03-13	META	Stock	78.6	79.38	77.68	78.05	18557300.0
2015-03-13	TSLA	Stock	12.5967	12.7833	12.488	12.5787	81514500.0
2015-03-13	TLT	Stock	126.76	127.59	126.49	126.72	7247189.0
2015-03-13	ES	Stock	49.62	49.62	48.79	49.13	969500.0
2015-03-13	CL	Stock	68.29	68.52	67.92	68.46	3451400.0
2015-03-13	A	Stock	40.96	41.46	40.52	40.87	4704600.0
2015-03-13	AA.B-DELISTED	Stock	45.45	45.45	44.714	45.1699	52995.0
2015-03-13	AABA-DELISTED	Stock	42.84	42.98	42.44	42.86	8593891.0
2015-03-13	AAC-DELISTED	Stock	25.96	28.67	25.96	27.74	544511.0
2015-03-13	AACG	Stock	4.0	4.18	3.98	4.04	9500.0
2015-03-13	AAIC-DELISTED	Stock	25.0	25.0	24.5288	24.77	291285.0
2015-03-13	AAL	Stock	48.75	49.49	48.28	49.22	9188000.0
2015-03-13	AAMC-DELISTED	Stock	74.4118	74.4118	67.5676	69.5382	53186.0
2015-03-13	AAME	Stock	4.02	4.02	4.02	4.02	1300.0
2015-03-13	AAMI	Stock	17.73	17.73	17.03	17.1	241600.0
2015-03-13	AAOI	Stock	12.93	13.13	12.56	12.98	293600.0
2015-03-13	AAON	Stock	14.9533	14.9533	14.52	14.7667	157200.0
2015-03-13	AAP	Stock	149.2	150.4	146.58	149.61	674600.0
2015-03-13	AAT	Stock	41.86	42.26	41.71	41.94	117700.0
2015-03-13	AAU-DELISTED	Stock	0.92	0.92	0.878	0.8934	171608.0
2015-03-13	AAUAF-DELISTED	Stock	0.92	0.92	0.878	0.9	172228.0
2015-03-13	AAV-DELISTED	Stock	4.95	4.98	4.87	4.89	80725.0
2015-03-13	AAVL-DELISTED	Stock	40.6	44.25	40.38	43.24	566055.0
2015-03-13	AAWW-DELISTED	Stock	46.14	46.81	45.91	46.48	161501.0
2015-03-13	AAXJ	Stock	61.71	61.71	61.27	61.48	1368574.0
2015-03-13	AAXN-DELISTED	Stock	24.1	24.19	23.69	23.92	1840299.0
2015-03-13	AB	Stock	28.18	28.56	28.02	28.49	395200.0
2015-03-13	ABAC-DELISTED	Stock	1.47	1.56	1.46	1.56	5250.0
2015-03-13	ABAX-DELISTED	Stock	62.95	63.52	62.06	62.94	69835.0
2015-03-13	ABB-DELISTED	Stock	20.06	20.18	19.93	20.165	1515820.0
2015-03-13	ABBNY-DELISTED	Stock	20.06	20.18	19.93	20.16	1585161.0
2015-03-13	ABBV	Stock	58.12	58.87	57.35	58.0	10114500.0
2015-03-13	ABC-DELISTED	Stock	105.26	106.38	105.12	106.16	1492286.0
2015-03-13	ABCB	Stock	26.6	26.6	25.77	26.4	61800.0
2015-03-13	ABCD-DELISTED	Stock	3.02	3.03	2.95	3.0	58836.0
2015-03-13	ABCO-DELISTED	Stock	54.32	54.32	52.1	53.2	210729.0
2015-03-13	ABCW-DELISTED	Stock	34.35	34.35	33.93	34.01	2368.0
2015-03-13	ABDC-DELISTED	Stock	13.55	13.79	13.55	13.73	40733.0
2015-03-13	ABE-DELISTED	Stock	12.51	12.51	12.41	12.45	5323.0
2015-03-13	ABEO	Stock	87.0	87.0	80.0	85.0	408.0
2015-03-13	ABEOW-DELISTED	Stock	0.87	0.94	0.87	0.94	900.0
2015-03-13	ABEV	Stock	5.56	5.63	5.51	5.57	9554600.0
2015-03-13	ABG	Stock	77.01	77.24	75.82	76.3	204200.0
2015-03-13	ABGB-DELISTED	Stock	16.28	16.32	16.07	16.32	37250.0
2015-03-13	ABIL-DELISTED	Stock	9.91	9.91	9.9	9.9	2100.0

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

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