PREVIEW / stock_daily / 2016-03-23

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-23.parquet
  size:    218 KB
  rows:    6,558
  symbols: 3,326

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
2016-03-23	AAPL	Stock	26.62	26.7675	26.475	26.5325	102814000.0
2016-03-23	MSFT	Stock	54.11	54.24	53.74	53.97	20129000.0
2016-03-23	NVDA	Stock	0.85	0.867	0.8462	0.8608	429008000.0
2016-03-23	AMZN	Stock	28.05	28.624	27.905	28.4815	79674000.0
2016-03-23	GOOGL	Stock	38.1675	38.2695	37.8015	37.878	24677080.0
2016-03-23	META	Stock	112.01	113.19	112.0	112.54	18562000.0
2016-03-23	TSLA	Stock	15.4913	15.6487	14.802	14.8387	74232000.0
2016-03-23	TLT	Stock	128.41	129.82	128.285	129.49	10628207.0
2016-03-23	ES	Stock	57.49	58.08	57.13	57.93	1344200.0
2016-03-23	CL	Stock	69.6	70.08	69.54	69.8	2296900.0
2016-03-23	A	Stock	39.9	39.99	39.37	39.47	1554800.0
2016-03-23	AA.B-DELISTED	Stock	32.35	32.49	31.354	31.56	28784.0
2016-03-23	AAAP-DELISTED	Stock	37.03	37.78	35.52	35.52	61246.0
2016-03-23	AABA-DELISTED	Stock	35.43	35.695	34.71	34.81	11516334.0
2016-03-23	AAC-DELISTED	Stock	19.2	19.24	18.08	18.2	215634.0
2016-03-23	AACG	Stock	5.28	5.49	4.96	5.09	65500.0
2016-03-23	AAIC-DELISTED	Stock	13.46	13.5	13.28	13.29	255729.0
2016-03-23	AAL	Stock	42.8	42.86	41.58	41.92	9583400.0
2016-03-23	AAMC-DELISTED	Stock	4.1176	4.1176	4.0118	4.0118	32317.0
2016-03-23	AAME	Stock	4.02	4.02	3.66	3.93	9600.0
2016-03-23	AAMI	Stock	12.51	12.51	12.2	12.22	112400.0
2016-03-23	AAOI	Stock	16.16	16.83	15.79	16.02	506000.0
2016-03-23	AAON	Stock	18.2533	18.2533	17.7067	17.7933	331500.0
2016-03-23	AAP	Stock	158.23	161.92	157.53	161.09	775600.0
2016-03-23	AAT	Stock	37.9	38.15	37.69	37.77	116800.0
2016-03-23	AAU-DELISTED	Stock	0.71	0.7178	0.6745	0.69	179017.0
2016-03-23	AAUAF-DELISTED	Stock	0.71	0.7178	0.6745	0.69	182544.0
2016-03-23	AAV-DELISTED	Stock	5.31	5.31	5.0857	5.16	48376.0
2016-03-23	AAVL-DELISTED	Stock	5.36	5.58	4.94	4.95	379343.0
2016-03-23	AAWW-DELISTED	Stock	41.39	41.98	40.01	40.73	216963.0
2016-03-23	AAXJ	Stock	54.0	54.0	53.51	53.55	405899.0
2016-03-23	AAXN-DELISTED	Stock	18.63	18.76	18.37	18.38	903058.0
2016-03-23	AB	Stock	22.55	22.79	22.2	22.25	287200.0
2016-03-23	ABAC-DELISTED	Stock	0.778	0.778	0.6611	0.7	1689.0
2016-03-23	ABAX-DELISTED	Stock	42.47	42.88	41.2601	41.8	147933.0
2016-03-23	ABB-DELISTED	Stock	19.2	19.2	19.07	19.095	1271585.0
2016-03-23	ABBNY-DELISTED	Stock	19.2	19.2	19.07	19.09	1305768.0
2016-03-23	ABBV	Stock	57.16	57.5	56.22	56.36	5116400.0
2016-03-23	ABC-DELISTED	Stock	87.5	87.84	87.09	87.26	1117171.0
2016-03-23	ABCB	Stock	28.86	29.52	28.6	28.7	102800.0
2016-03-23	ABCD-DELISTED	Stock	4.4	4.438	4.25	4.3	15667.0
2016-03-23	ABCO-DELISTED	Stock	30.58	31.09	30.18	30.39	423135.0
2016-03-23	ABCW-DELISTED	Stock	43.79	43.79	43.22	43.27	43126.0
2016-03-23	ABDC-DELISTED	Stock	11.1	11.53	11.03	11.03	80964.0
2016-03-23	ABE-DELISTED	Stock	11.4304	11.4399	11.38	11.4	2850.0
2016-03-23	ABEO	Stock	71.75	74.0	65.75	65.75	1772.0
2016-03-23	ABEV	Stock	5.11	5.16	5.09	5.11	18658400.0
2016-03-23	ABG	Stock	60.23	60.23	59.29	59.45	428300.0
2016-03-23	ABGB-DELISTED	Stock	1.45	1.51	1.4	1.44	41634.0
2016-03-23	ABIL-DELISTED	Stock	6.25	6.65	6.13	6.48	14516.0

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

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