PREVIEW / stock_daily / 2017-01-04

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-04.parquet
  size:    218 KB
  rows:    6,543
  symbols: 3,139

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
2017-01-04	AAPL	Stock	28.9625	29.1275	28.9375	29.005	84472400.0
2017-01-04	MSFT	Stock	62.48	62.75	62.12	62.3	21340000.0
2017-01-04	NVDA	Stock	2.585	2.6375	2.5382	2.6098	1199220000.0
2017-01-04	AMZN	Stock	37.9195	37.984	37.71	37.859	50210000.0
2017-01-04	GOOGL	Stock	40.4945	40.6715	40.2055	40.3885	30306780.0
2017-01-04	META	Stock	117.55	119.66	117.29	118.69	19630900.0
2017-01-04	TSLA	Stock	14.3167	15.2	14.2873	15.1327	168202500.0
2017-01-04	TLT	Stock	119.76	120.24	119.45	120.1	6699562.0
2017-01-04	ES	Stock	55.17	55.62	54.95	55.27	1264600.0
2017-01-04	CL	Stock	65.81	66.37	65.8	66.26	4047900.0
2017-01-04	A	Stock	46.93	47.38	46.82	47.1	1821300.0
2017-01-04	AA	Stock	29.02	30.3	29.02	30.26	3339500.0
2017-01-04	AAAP-DELISTED	Stock	27.34	27.9099	26.93	27.25	66455.0
2017-01-04	AABA-DELISTED	Stock	39.0	40.25	38.92	40.07	10892413.0
2017-01-04	AAC-DELISTED	Stock	7.72	7.89	7.62	7.69	231438.0
2017-01-04	AACG	Stock	3.88	3.99	3.78	3.99	5400.0
2017-01-04	AAIC-DELISTED	Stock	15.19	15.31	15.05	15.26	241068.0
2017-01-04	AAL	Stock	46.63	47.44	46.35	46.7	5859600.0
2017-01-04	AAMC-DELISTED	Stock	15.7353	16.4559	15.0342	16.4559	55304.0
2017-01-04	AAME	Stock	4.15	4.2	4.1	4.1	4600.0
2017-01-04	AAMI	Stock	14.56	14.68	14.47	14.61	476400.0
2017-01-04	AAOI	Stock	23.13	23.61	23.13	23.51	199100.0
2017-01-04	AAON	Stock	22.3	22.7733	22.1667	22.7333	217500.0
2017-01-04	AAP	Stock	170.37	173.17	170.37	172.0	641700.0
2017-01-04	AAT	Stock	43.32	43.93	43.22	43.88	688300.0
2017-01-04	AAU-DELISTED	Stock	1.02	1.02	0.97	0.98	420367.0
2017-01-04	AAUAF-DELISTED	Stock	1.02	1.02	0.97	0.9707	423481.0
2017-01-04	AAV-DELISTED	Stock	6.55	6.7	6.505	6.6	131589.0
2017-01-04	AAWW-DELISTED	Stock	51.9	52.45	51.0	52.1	214436.0
2017-01-04	AAXJ	Stock	55.76	56.16	55.76	56.02	1122554.0
2017-01-04	AAXN-DELISTED	Stock	24.59	24.863	24.48	24.85	523248.0
2017-01-04	AB	Stock	24.3	24.4	24.05	24.15	428900.0
2017-01-04	ABAC-DELISTED	Stock	3.6701	3.6774	3.6701	3.6774	614.0
2017-01-04	ABAX-DELISTED	Stock	53.89	53.89	52.92	53.4	91009.0
2017-01-04	ABB-DELISTED	Stock	21.15	21.38	21.14	21.37	1331453.0
2017-01-04	ABBNY-DELISTED	Stock	21.15	21.38	21.14	21.37	2333104.0
2017-01-04	ABBV	Stock	62.64	63.8	62.64	63.29	8674800.0
2017-01-04	ABC-DELISTED	Stock	82.6	85.14	82.47	84.67	2263508.0
2017-01-04	ABCB	Stock	43.8	44.7	43.04	44.65	198600.0
2017-01-04	ABCD-DELISTED	Stock	4.97	5.05	4.85	5.0301	93551.0
2017-01-04	ABCO-DELISTED	Stock	33.15	33.775	32.15	33.5	1936413.0
2017-01-04	ABDC-DELISTED	Stock	12.24	12.72	12.05	12.66	150325.0
2017-01-04	ABE-DELISTED	Stock	11.44	11.44	11.38	11.38	1070.0
2017-01-04	ABEO	Stock	123.75	133.75	123.75	133.75	7464.0
2017-01-04	ABEV	Stock	5.09	5.13	5.06	5.11	11868200.0
2017-01-04	ABG	Stock	63.0	65.0	62.7	64.0	689900.0
2017-01-04	ABIL-DELISTED	Stock	2.95	3.08	2.95	3.07	35854.0
2017-01-04	ABM	Stock	41.05	41.54	40.75	41.44	433700.0
2017-01-04	ABMD-DELISTED	Stock	113.02	115.97	112.32	115.74	273374.0
2017-01-04	ABR	Stock	7.58	7.65	7.58	7.65	155700.0

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

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