PREVIEW / stock_daily / 2016-12-09

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-09.parquet
  size:    217 KB
  rows:    6,530
  symbols: 3,144

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-09	AAPL	Stock	28.0775	28.675	28.0775	28.4875	137610400.0
2016-12-09	MSFT	Stock	61.18	61.99	61.13	61.97	27349400.0
2016-12-09	NVDA	Stock	2.355	2.3568	2.2678	2.2955	382312000.0
2016-12-09	AMZN	Stock	38.5	38.5125	38.267	38.433	49418000.0
2016-12-09	GOOGL	Stock	39.965	40.4975	39.9025	40.4725	38089260.0
2016-12-09	META	Stock	119.22	119.94	118.95	119.68	17464700.0
2016-12-09	TSLA	Stock	12.7247	12.9227	12.7207	12.812	40837500.0
2016-12-09	TLT	Stock	118.64	118.86	117.28	117.5	14646449.0
2016-12-09	ES	Stock	53.28	53.82	53.21	53.76	1538500.0
2016-12-09	CL	Stock	65.7	66.37	65.64	66.29	2465300.0
2016-12-09	A	Stock	45.91	46.32	45.85	46.3	1937500.0
2016-12-09	AA	Stock	31.31	32.11	31.04	32.05	4344300.0
2016-12-09	AAAP-DELISTED	Stock	30.28	30.95	29.8901	30.21	64276.0
2016-12-09	AABA-DELISTED	Stock	41.52	41.8	41.44	41.76	6434442.0
2016-12-09	AAC-DELISTED	Stock	8.25	8.7	8.13	8.39	282103.0
2016-12-09	AACG	Stock	4.0	4.0	3.85	3.99	4000.0
2016-12-09	AAIC-DELISTED	Stock	17.1	17.13	16.93	17.08	409096.0
2016-12-09	AAL	Stock	49.27	50.64	48.74	49.64	9850800.0
2016-12-09	AAMC-DELISTED	Stock	12.3824	12.9412	11.8603	12.5	80648.0
2016-12-09	AAME	Stock	3.9	4.0	3.75	3.95	1600.0
2016-12-09	AAMI	Stock	15.25	15.49	15.15	15.49	308100.0
2016-12-09	AAOI	Stock	25.58	26.26	24.23	24.74	581400.0
2016-12-09	AAON	Stock	21.9667	22.2667	21.8333	22.0333	398100.0
2016-12-09	AAP	Stock	176.05	177.32	173.96	175.58	521500.0
2016-12-09	AAT	Stock	42.25	42.68	42.25	42.65	401800.0
2016-12-09	AAU-DELISTED	Stock	1.18	1.2	1.08	1.1	307413.0
2016-12-09	AAUAF-DELISTED	Stock	1.18	1.2	1.08	1.1	335815.0
2016-12-09	AAV-DELISTED	Stock	7.15	7.375	7.15	7.3	101537.0
2016-12-09	AAWW-DELISTED	Stock	52.05	52.95	51.6	52.8	164862.0
2016-12-09	AAXJ	Stock	57.48	57.58	57.39	57.49	2689353.0
2016-12-09	AAXN-DELISTED	Stock	25.27	25.46	23.75	23.84	2684886.0
2016-12-09	AB	Stock	23.1	23.35	22.7	23.2	624800.0
2016-12-09	ABAC-DELISTED	Stock	3.16	3.395	3.16	3.39	33287.0
2016-12-09	ABAX-DELISTED	Stock	53.57	54.59	52.6	54.05	87339.0
2016-12-09	ABB-DELISTED	Stock	20.87	21.025	20.865	20.99	1054687.0
2016-12-09	ABBNY-DELISTED	Stock	20.87	21.025	20.865	20.98	1090224.0
2016-12-09	ABBV	Stock	61.19	61.93	60.92	61.54	7102900.0
2016-12-09	ABC-DELISTED	Stock	77.19	79.22	77.02	78.89	1571406.0
2016-12-09	ABCB	Stock	47.5	47.7	46.8	47.2	150000.0
2016-12-09	ABCD-DELISTED	Stock	4.85	4.98	4.6	4.9	82175.0
2016-12-09	ABCO-DELISTED	Stock	34.2	34.4	33.7	33.95	295280.0
2016-12-09	ABDC-DELISTED	Stock	11.96	12.28	11.73	12.16	48604.0
2016-12-09	ABE-DELISTED	Stock	11.35	11.38	11.31	11.318	8449.0
2016-12-09	ABEO	Stock	146.25	148.75	127.5	128.75	22944.0
2016-12-09	ABEOW-DELISTED	Stock	2.87	2.89	2.75	2.75	1270.0
2016-12-09	ABEV	Stock	4.86	4.96	4.85	4.89	19669900.0
2016-12-09	ABG	Stock	63.75	64.1	62.85	63.45	182200.0
2016-12-09	ABIL-DELISTED	Stock	3.34	3.41	3.21	3.32	26021.0
2016-12-09	ABM	Stock	43.0	43.15	42.57	43.01	661200.0
2016-12-09	ABMD-DELISTED	Stock	118.76	118.76	116.42	116.9	282768.0

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

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