PREVIEW / stock_daily / 2019-02-20

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-20.parquet
  size:    221 KB
  rows:    6,564
  symbols: 2,650

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
2019-02-20	AAPL	Stock	42.7975	43.33	42.7475	43.0075	104457600.0
2019-02-20	MSFT	Stock	107.86	107.94	106.29	107.15	21607700.0
2019-02-20	NVDA	Stock	3.9455	4.0315	3.9343	3.9638	540988000.0
2019-02-20	AMZN	Stock	81.5	81.7465	80.506	81.105	66752000.0
2019-02-20	GOOGL	Stock	56.444	56.5465	55.5875	56.0295	24090660.0
2019-02-20	META	Stock	162.25	163.72	161.25	162.56	11770700.0
2019-02-20	TSLA	Stock	20.294	20.42	19.9333	20.1707	107131500.0
2019-02-20	TLT	Stock	121.95	122.08	121.59	121.94	4455832.0
2019-02-20	ES	Stock	70.29	70.51	70.02	70.27	2142500.0
2019-02-20	CL	Stock	66.85	67.11	66.22	66.51	3458600.0
2019-02-20	A	Stock	77.53	78.8	77.33	78.56	2076500.0
2019-02-20	AA	Stock	28.39	29.595	28.34	29.24	6520000.0
2019-02-20	AABA-DELISTED	Stock	69.28	70.04	69.26	69.41	3070106.0
2019-02-20	AAC-DELISTED	Stock	2.97	3.22	2.97	3.14	396363.0
2019-02-20	AACG	Stock	1.07	1.07	1.04	1.07	22000.0
2019-02-20	AAIC-DELISTED	Stock	8.3	8.34	8.04	8.1	4295949.0
2019-02-20	AAL	Stock	35.0	35.24	34.77	35.06	6969900.0
2019-02-20	AAM.A-DELISTED	Stock	25.0	25.0	24.93	24.93	32615.0
2019-02-20	AAM.B-DELISTED	Stock	24.65	24.79	24.65	24.65	39861.0
2019-02-20	AAMC-DELISTED	Stock	9.7118	9.9941	9.7059	9.9941	2472.0
2019-02-20	AAME	Stock	2.62	2.75	2.58	2.63	6000.0
2019-02-20	AAMI	Stock	13.77	13.9	13.7	13.89	596400.0
2019-02-20	AAOI	Stock	14.95	15.65	14.61	14.61	1263600.0
2019-02-20	AAON	Stock	26.8667	27.26	26.8667	27.2467	199650.0
2019-02-20	AAP	Stock	166.0	167.03	162.59	166.0	1990200.0
2019-02-20	AAT	Stock	43.9	43.9	43.3	43.6	144500.0
2019-02-20	AAU-DELISTED	Stock	0.75	0.7582	0.7286	0.7429	201132.0
2019-02-20	AAUAF-DELISTED	Stock	0.75	0.7582	0.7239	0.7239	209352.0
2019-02-20	AAWW-DELISTED	Stock	59.6	60.45	58.09	60.31	266934.0
2019-02-20	AAXJ	Stock	69.33	69.77	69.24	69.38	1767172.0
2019-02-20	AAXN-DELISTED	Stock	55.88	56.34	55.58	56.0	290780.0
2019-02-20	AB	Stock	30.13	30.27	30.01	30.24	374700.0
2019-02-20	ABB-DELISTED	Stock	19.97	20.33	19.97	20.25	5117477.0
2019-02-20	ABBNY-DELISTED	Stock	19.97	20.33	19.97	20.26	5253685.0
2019-02-20	ABBV	Stock	80.53	80.6	79.14	79.99	5564100.0
2019-02-20	ABC-DELISTED	Stock	86.19	87.13	85.43	86.35	592635.0
2019-02-20	ABCB	Stock	40.53	41.04	40.34	40.93	430500.0
2019-02-20	ABDC-DELISTED	Stock	7.19	7.33	7.06	7.07	84603.0
2019-02-20	ABEO	Stock	167.25	169.25	163.25	163.75	9036.0
2019-02-20	ABEV	Stock	4.86	4.92	4.82	4.83	19919200.0
2019-02-20	ABG	Stock	70.96	73.29	70.92	72.95	143200.0
2019-02-20	ABIL-DELISTED	Stock	1.9001	1.9136	1.8611	1.9092	59886.0
2019-02-20	ABM	Stock	36.32	36.84	36.13	36.72	400300.0
2019-02-20	ABMD-DELISTED	Stock	360.57	362.29	355.265	362.27	253589.0
2019-02-20	ABR	Stock	12.6	12.74	12.54	12.72	1390200.0
2019-02-20	ABR.A-DELISTED	Stock	25.3408	25.3899	25.28	25.2808	10717.0
2019-02-20	ABR.B-DELISTED	Stock	25.5	25.5701	25.13	25.3257	3427.0
2019-02-20	ABR.C-DELISTED	Stock	25.36	25.39	25.25	25.29	9407.0
2019-02-20	ABT	Stock	74.83	75.57	74.6	75.54	6316700.0
2019-02-20	ABTC	Stock	305400.0	305400.0	303900.0	303990.0	1.9333333333333333

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

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