PREVIEW / stock_daily / 2016-12-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-19.parquet
  size:    217 KB
  rows:    6,532
  symbols: 3,142

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-12-19	AAPL	Stock	28.95	29.345	28.9375	29.16	111117600.0
2016-12-19	MSFT	Stock	62.56	63.77	62.42	63.62	34338200.0
2016-12-19	NVDA	Stock	2.4925	2.5613	2.475	2.5408	744656000.0
2016-12-19	AMZN	Stock	37.9445	38.525	37.808	38.3	62264000.0
2016-12-19	GOOGL	Stock	40.464	40.811	40.225	40.625	25271620.0
2016-12-19	META	Stock	119.85	120.36	118.51	119.24	15918100.0
2016-12-19	TSLA	Stock	13.4993	13.63	13.3227	13.5153	52321500.0
2016-12-19	TLT	Stock	117.98	118.58	117.74	118.4	10868274.0
2016-12-19	ES	Stock	54.94	55.09	54.49	55.07	1545500.0
2016-12-19	CL	Stock	66.11	66.49	65.85	66.06	2408800.0
2016-12-19	A	Stock	45.89	46.22	45.36	45.43	1084200.0
2016-12-19	AA	Stock	28.89	29.49	28.75	29.29	2572500.0
2016-12-19	AAAP-DELISTED	Stock	27.6	27.82	26.25	26.28	50143.0
2016-12-19	AABA-DELISTED	Stock	38.66	38.79	38.27	38.42	12990508.0
2016-12-19	AAC-DELISTED	Stock	7.72	7.97	7.6	7.64	204040.0
2016-12-19	AACG	Stock	3.85	3.85	3.64	3.75	1800.0
2016-12-19	AAIC-DELISTED	Stock	15.5	15.92	15.38	15.84	663081.0
2016-12-19	AAL	Stock	47.89	48.6	47.74	48.58	4729900.0
2016-12-19	AAMC-DELISTED	Stock	15.8676	17.1912	13.8235	14.1176	130835.0
2016-12-19	AAME	Stock	3.95	3.95	3.86	3.86	1000.0
2016-12-19	AAMI	Stock	14.3	14.52	14.24	14.44	481700.0
2016-12-19	AAOI	Stock	24.75	25.52	24.75	24.96	321500.0
2016-12-19	AAON	Stock	21.7667	22.1333	21.5	21.8333	238950.0
2016-12-19	AAP	Stock	171.61	175.55	171.61	173.82	548400.0
2016-12-19	AAT	Stock	42.94	43.33	42.66	43.14	166900.0
2016-12-19	AAU-DELISTED	Stock	0.9	0.9	0.78	0.798	875487.0
2016-12-19	AAUAF-DELISTED	Stock	0.9	0.9	0.78	0.798	911157.0
2016-12-19	AAV-DELISTED	Stock	6.75	6.85	6.7	6.75	58625.0
2016-12-19	AAWW-DELISTED	Stock	50.25	50.9	49.9	50.55	109140.0
2016-12-19	AAXJ	Stock	55.67	55.774	55.51	55.55	1448342.0
2016-12-19	AAXN-DELISTED	Stock	23.98	24.25	23.75	23.99	551161.0
2016-12-19	AB	Stock	22.4	22.75	22.3	22.65	263100.0
2016-12-19	ABAC-DELISTED	Stock	3.74	3.74	3.3	3.45	26206.0
2016-12-19	ABAX-DELISTED	Stock	53.34	53.69	51.74	51.86	139127.0
2016-12-19	ABB-DELISTED	Stock	21.05	21.14	20.984	21.13	2699977.0
2016-12-19	ABBNY-DELISTED	Stock	21.05	21.14	20.984	21.14	2834579.0
2016-12-19	ABBV	Stock	62.37	63.33	62.12	62.22	5976800.0
2016-12-19	ABC-DELISTED	Stock	77.58	78.65	77.375	78.42	1576988.0
2016-12-19	ABCB	Stock	45.35	45.35	42.75	43.35	686800.0
2016-12-19	ABCD-DELISTED	Stock	4.95	5.0	4.85	4.995	20293.0
2016-12-19	ABCO-DELISTED	Stock	32.45	33.05	32.35	32.75	173135.0
2016-12-19	ABDC-DELISTED	Stock	12.51	12.59	12.4	12.4	29621.0
2016-12-19	ABE-DELISTED	Stock	11.2	11.2	11.18	11.2	6111.0
2016-12-19	ABEO	Stock	111.25	118.75	111.25	116.25	10872.0
2016-12-19	ABEOW-DELISTED	Stock	2.64	2.64	2.6	2.6	444.0
2016-12-19	ABEV	Stock	4.88	4.89	4.79	4.84	16443400.0
2016-12-19	ABG	Stock	61.75	64.15	61.75	63.5	128800.0
2016-12-19	ABIL-DELISTED	Stock	3.02	3.02	2.79	2.9	21549.0
2016-12-19	ABM	Stock	40.43	40.75	39.82	40.27	534600.0
2016-12-19	ABMD-DELISTED	Stock	117.54	118.36	116.33	116.74	383488.0

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

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