PREVIEW / stock_daily / 2016-03-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-15.parquet
  size:    216 KB
  rows:    6,540
  symbols: 3,312

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-15	AAPL	Stock	25.99	26.295	25.9625	26.145	160270800.0
2016-03-15	MSFT	Stock	52.75	53.59	52.74	53.59	21104800.0
2016-03-15	NVDA	Stock	0.8033	0.8085	0.7892	0.8035	226216000.0
2016-03-15	AMZN	Stock	28.55	29.076	28.35	28.851	77536000.0
2016-03-15	GOOGL	Stock	37.301	37.6505	37.142	37.5285	29831560.0
2016-03-15	META	Stock	109.11	110.83	108.84	110.67	17618500.0
2016-03-15	TSLA	Stock	14.2847	14.598	14.1	14.556	47707500.0
2016-03-15	TLT	Stock	128.5	128.66	127.61	127.88	6413224.0
2016-03-15	ES	Stock	56.73	57.35	56.46	56.75	1990900.0
2016-03-15	CL	Stock	67.83	68.75	67.7	68.59	2474800.0
2016-03-15	A	Stock	38.59	38.71	38.08	38.29	1059400.0
2016-03-15	AA.B-DELISTED	Stock	32.0	32.0	30.55	30.71	38561.0
2016-03-15	AAAP-DELISTED	Stock	33.37	35.4	33.05	34.3	124189.0
2016-03-15	AABA-DELISTED	Stock	33.32	33.46	33.11	33.26	9727840.0
2016-03-15	AAC-DELISTED	Stock	17.81	17.8201	16.5791	17.05	151368.0
2016-03-15	AACG	Stock	4.81	5.02	4.81	4.96	5100.0
2016-03-15	AAIC-DELISTED	Stock	12.89	13.03	12.64	12.89	307471.0
2016-03-15	AAL	Stock	42.3	42.49	41.98	42.11	4445400.0
2016-03-15	AAMC-DELISTED	Stock	3.9124	4.0324	3.8647	3.9206	41361.0
2016-03-15	AAME	Stock	4.06	4.15	4.05	4.15	2600.0
2016-03-15	AAMI	Stock	12.0	12.092	11.74	11.93	408300.0
2016-03-15	AAOI	Stock	17.23	17.33	16.81	16.91	148300.0
2016-03-15	AAON	Stock	17.26	17.3533	16.9533	16.98	172050.0
2016-03-15	AAP	Stock	158.33	160.12	157.35	158.58	830000.0
2016-03-15	AAT	Stock	38.0	38.02	37.3	37.82	131300.0
2016-03-15	AAU-DELISTED	Stock	0.726	0.75	0.684	0.6981	166693.0
2016-03-15	AAUAF-DELISTED	Stock	0.726	0.75	0.684	0.6981	167223.0
2016-03-15	AAV-DELISTED	Stock	5.4	5.42	5.29	5.33	68508.0
2016-03-15	AAVL-DELISTED	Stock	5.21	5.21	4.85	4.87	303295.0
2016-03-15	AAWW-DELISTED	Stock	39.27	39.36	38.55	38.72	141070.0
2016-03-15	AAXJ	Stock	52.34	52.5	52.16	52.48	378618.0
2016-03-15	AAXN-DELISTED	Stock	19.17	19.29	18.32	18.37	1242192.0
2016-03-15	AB	Stock	22.34	22.44	21.68	21.75	410200.0
2016-03-15	ABAC-DELISTED	Stock	0.66	0.66	0.59	0.64	1338.0
2016-03-15	ABAX-DELISTED	Stock	42.49	42.49	41.46	41.98	129048.0
2016-03-15	ABB-DELISTED	Stock	18.41	18.41	18.29	18.35	1130280.0
2016-03-15	ABBNY-DELISTED	Stock	18.41	18.41	18.29	18.35	1169601.0
2016-03-15	ABBV	Stock	56.65	56.93	55.13	55.62	5779600.0
2016-03-15	ABC-DELISTED	Stock	87.5	88.13	86.11	86.3	2014318.0
2016-03-15	ABCB	Stock	28.81	28.97	28.27	28.33	194200.0
2016-03-15	ABCD-DELISTED	Stock	4.47	4.54	4.37	4.37	6273.0
2016-03-15	ABCO-DELISTED	Stock	28.78	28.78	27.54	28.23	314491.0
2016-03-15	ABCW-DELISTED	Stock	43.85	43.9	43.4	43.4	19740.0
2016-03-15	ABDC-DELISTED	Stock	10.69	10.915	10.59	10.67	23749.0
2016-03-15	ABE-DELISTED	Stock	11.17	11.1799	11.14	11.15	3745.0
2016-03-15	ABEO	Stock	73.0	75.0	71.0	71.0	920.0
2016-03-15	ABEV	Stock	4.8	4.91	4.76	4.82	20962900.0
2016-03-15	ABG	Stock	58.71	58.71	57.08	58.13	466400.0
2016-03-15	ABGB-DELISTED	Stock	1.6	1.7	1.6	1.65	10895.0
2016-03-15	ABM	Stock	30.57	31.13	30.46	31.08	258900.0

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

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