PREVIEW / stock_daily / 2016-12-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-15.parquet
  size:    218 KB
  rows:    6,544
  symbols: 3,153

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-15	AAPL	Stock	28.845	29.1825	28.8075	28.955	186098000.0
2016-12-15	MSFT	Stock	62.7	63.15	62.3	62.58	27669900.0
2016-12-15	NVDA	Stock	2.4225	2.4985	2.415	2.4678	746548000.0
2016-12-15	AMZN	Stock	38.314	38.455	38.0155	38.05	76038000.0
2016-12-15	GOOGL	Stock	40.868	41.15	40.6	40.7825	35394380.0
2016-12-15	META	Stock	120.08	122.5	119.63	120.57	20139600.0
2016-12-15	TSLA	Stock	13.2273	13.3827	13.1593	13.172	48294000.0
2016-12-15	TLT	Stock	117.56	118.29	117.03	117.41	12400456.0
2016-12-15	ES	Stock	52.94	53.69	52.59	53.68	1470900.0
2016-12-15	CL	Stock	65.72	66.35	64.99	66.23	4838100.0
2016-12-15	A	Stock	46.08	46.77	45.92	46.56	1338900.0
2016-12-15	AA	Stock	30.16	30.44	29.65	29.79	3753200.0
2016-12-15	AAAP-DELISTED	Stock	28.2	28.6	27.5	27.79	60719.0
2016-12-15	AABA-DELISTED	Stock	40.01	40.01	38.25	38.41	41410976.0
2016-12-15	AAC-DELISTED	Stock	7.75	8.05	7.715	7.8	153847.0
2016-12-15	AACG	Stock	3.94	3.94	3.94	3.94	300.0
2016-12-15	AAIC-DELISTED	Stock	15.92	16.0752	15.0	15.03	949090.0
2016-12-15	AAL	Stock	48.1	49.95	48.1	48.3	7530800.0
2016-12-15	AAMC-DELISTED	Stock	13.0	13.8824	12.9412	13.7794	75344.0
2016-12-15	AAME	Stock	4.05	4.05	4.05	4.05	600.0
2016-12-15	AAMI	Stock	14.0	14.35	13.95	14.27	1486400.0
2016-12-15	AAOI	Stock	23.82	24.45	23.81	24.4	332000.0
2016-12-15	AAON	Stock	21.8	22.0	21.5	21.8333	266700.0
2016-12-15	AAP	Stock	171.62	173.45	171.01	172.92	662900.0
2016-12-15	AAT	Stock	41.7	42.15	41.42	41.57	321800.0
2016-12-15	AAU-DELISTED	Stock	1.01	1.06	0.9316	0.94	621914.0
2016-12-15	AAUAF-DELISTED	Stock	1.01	1.06	0.9316	0.94	631461.0
2016-12-15	AAV-DELISTED	Stock	6.75	7.0	6.7	6.9	102788.0
2016-12-15	AAWW-DELISTED	Stock	51.7	52.35	50.75	51.9	221241.0
2016-12-15	AAXJ	Stock	56.29	56.31	56.07	56.13	1756114.0
2016-12-15	AAXN-DELISTED	Stock	24.47	24.61	23.99	24.15	522960.0
2016-12-15	AB	Stock	22.5	22.9	22.3	22.4	482500.0
2016-12-15	ABAC-DELISTED	Stock	3.6	3.8087	3.34	3.5301	5597.0
2016-12-15	ABAX-DELISTED	Stock	54.44	54.645	53.5	53.95	206140.0
2016-12-15	ABB-DELISTED	Stock	20.86	20.98	20.8	20.97	1896310.0
2016-12-15	ABBNY-DELISTED	Stock	20.86	20.98	20.8	20.97	1951829.0
2016-12-15	ABBV	Stock	61.8	62.11	61.55	62.02	6416900.0
2016-12-15	ABC-DELISTED	Stock	76.8	76.83	75.46	76.67	1885208.0
2016-12-15	ABCB	Stock	45.65	46.35	45.55	45.75	265500.0
2016-12-15	ABCD-DELISTED	Stock	4.83	4.96	4.48	4.9	38292.0
2016-12-15	ABCO-DELISTED	Stock	32.1	32.8	31.25	32.55	515383.0
2016-12-15	ABDC-DELISTED	Stock	12.5	12.5	12.4	12.4	40502.0
2016-12-15	ABE-DELISTED	Stock	11.1412	11.2689	11.1412	11.24	5652.0
2016-12-15	ABEO	Stock	122.5	124.5	115.0	117.5	11856.0
2016-12-15	ABEOW-DELISTED	Stock	2.72	2.72	2.7	2.72	3200.0
2016-12-15	ABEV	Stock	4.8	4.87	4.77	4.81	50656200.0
2016-12-15	ABG	Stock	61.5	63.0	60.9	62.3	189700.0
2016-12-15	ABIL-DELISTED	Stock	3.1228	3.1228	2.92	2.92	31115.0
2016-12-15	ABM	Stock	39.25	39.92	38.54	39.7	1135200.0
2016-12-15	ABMD-DELISTED	Stock	119.02	120.79	118.18	118.67	227433.0

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

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