PREVIEW / stock_daily / 2017-02-14

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-14.parquet
  size:    216 KB
  rows:    6,496
  symbols: 3,086

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-02-14	AAPL	Stock	33.3675	33.7725	33.3125	33.755	132904800.0
2017-02-14	MSFT	Stock	64.41	64.72	64.02	64.57	23108400.0
2017-02-14	NVDA	Stock	2.6998	2.7538	2.6573	2.7195	850632000.0
2017-02-14	AMZN	Stock	41.85	41.9155	41.5725	41.8195	55848000.0
2017-02-14	GOOGL	Stock	41.9885	42.1	41.7915	42.0015	27266900.0
2017-02-14	META	Stock	134.1	134.23	132.55	133.85	14364900.0
2017-02-14	TSLA	Stock	18.602	19.1593	18.574	18.732	110178000.0
2017-02-14	TLT	Stock	120.24	120.3	118.83	119.51	13210451.0
2017-02-14	ES	Stock	56.34	56.44	55.66	55.95	1048900.0
2017-02-14	CL	Stock	67.5	68.12	67.19	67.74	5137800.0
2017-02-14	A	Stock	50.24	50.68	50.09	50.39	3546900.0
2017-02-14	AA	Stock	38.57	39.25	38.18	38.56	3818600.0
2017-02-14	AAAP-DELISTED	Stock	36.41	36.625	35.5001	35.69	135376.0
2017-02-14	AABA-DELISTED	Stock	45.38	45.58	44.9	45.015	6204114.0
2017-02-14	AAC-DELISTED	Stock	7.78	8.02	7.75	7.92	84190.0
2017-02-14	AACG	Stock	3.79	3.79	3.66	3.75	3700.0
2017-02-14	AAIC-DELISTED	Stock	14.9	15.02	14.789	14.95	349806.0
2017-02-14	AAL	Stock	47.26	47.28	46.45	46.57	6271700.0
2017-02-14	AAMC-DELISTED	Stock	22.3676	23.1618	22.0588	22.375	12787.0
2017-02-14	AAME	Stock	3.74	4.2	3.7	3.95	21700.0
2017-02-14	AAMI	Stock	14.9	15.21	14.82	15.13	364400.0
2017-02-14	AAOI	Stock	34.01	36.7	34.01	36.38	1005300.0
2017-02-14	AAON	Stock	23.1667	23.1667	22.7667	22.9667	134550.0
2017-02-14	AAP	Stock	162.39	164.79	161.85	164.37	935300.0
2017-02-14	AAT	Stock	43.45	43.51	43.06	43.42	106100.0
2017-02-14	AAU-DELISTED	Stock	1.27	1.28	1.23	1.23	260262.0
2017-02-14	AAUAF-DELISTED	Stock	1.27	1.28	1.23	1.23	281047.0
2017-02-14	AAV-DELISTED	Stock	6.45	6.55	6.405	6.525	57150.0
2017-02-14	AAWW-DELISTED	Stock	52.35	52.8	52.15	52.3	109070.0
2017-02-14	AAXJ	Stock	60.4	60.43	59.97	60.43	778218.0
2017-02-14	AAXN-DELISTED	Stock	27.16	27.19	26.89	27.02	288841.0
2017-02-14	AB	Stock	24.5	24.9	24.3	24.5	673500.0
2017-02-14	ABAC-DELISTED	Stock	3.48	3.56	3.4	3.5453	1600.0
2017-02-14	ABAX-DELISTED	Stock	49.25	49.75	48.27	49.09	264395.0
2017-02-14	ABB-DELISTED	Stock	22.92	22.92	22.71	22.83	1176948.0
2017-02-14	ABBNY-DELISTED	Stock	22.92	22.92	22.71	22.82	1233030.0
2017-02-14	ABBV	Stock	60.44	60.98	60.15	60.82	13562200.0
2017-02-14	ABC-DELISTED	Stock	90.0	91.09	89.73	90.82	1739252.0
2017-02-14	ABCB	Stock	47.05	47.75	47.0	47.6	137000.0
2017-02-14	ABCD-DELISTED	Stock	4.9	4.94	4.75	4.82	42691.0
2017-02-14	ABCO-DELISTED	Stock	46.95	47.6	46.7	47.4	772121.0
2017-02-14	ABDC-DELISTED	Stock	12.52	12.68	12.36	12.655	38604.0
2017-02-14	ABE-DELISTED	Stock	12.15	12.16	11.98	12.05	33353.0
2017-02-14	ABEO	Stock	131.25	142.0	130.0	137.5	28676.0
2017-02-14	ABEV	Stock	5.53	5.62	5.52	5.6	12019900.0
2017-02-14	ABG	Stock	65.65	67.15	65.65	66.4	315300.0
2017-02-14	ABIL-DELISTED	Stock	3.31	3.32	3.2388	3.24	1496.0
2017-02-14	ABM	Stock	40.64	40.73	40.25	40.35	230100.0
2017-02-14	ABMD-DELISTED	Stock	107.6	109.48	107.6	108.89	307995.0
2017-02-14	ABR	Stock	7.31	7.38	7.3	7.36	87400.0

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

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