PREVIEW / stock_daily / 2020-07-13

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-13.parquet
  size:    223 KB
  rows:    6,747
  symbols: 2,413

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
2020-07-13	AAPL	Stock	97.265	99.955	95.2575	95.4775	191649200.0
2020-07-13	MSFT	Stock	214.48	215.8	206.5	207.07	38135600.0
2020-07-13	NVDA	Stock	10.595	10.7923	10.025	10.0523	457076000.0
2020-07-13	AMZN	Stock	162.553	167.2145	153.4195	155.2	154408000.0
2020-07-13	GOOGL	Stock	77.497	78.818	75.328	75.6115	42954560.0
2020-07-13	META	Stock	247.01	250.15	238.42	239.0	24674900.0
2020-07-13	TSLA	Stock	110.6	119.666	98.074	99.804	584781000.0
2020-07-13	TLT	Stock	165.5	166.96	165.23	166.88	8054011.0
2020-07-13	ES	Stock	85.09	87.08	85.09	85.94	1721100.0
2020-07-13	CL	Stock	73.63	74.13	73.25	73.46	3142900.0
2020-07-13	A	Stock	89.97	91.24	88.65	89.26	1646200.0
2020-07-13	AA	Stock	11.53	11.975	11.465	11.51	7871900.0
2020-07-13	AACG	Stock	1.48	1.54	1.39	1.46	84500.0
2020-07-13	AAIC-DELISTED	Stock	2.87	2.9626	2.855	2.86	372651.0
2020-07-13	AAIC.C-DELISTED	Stock	19.6	19.6	18.95	19.0512	3282.0
2020-07-13	AAL	Stock	12.13	12.27	11.45	11.63	67580300.0
2020-07-13	AAM.A-DELISTED	Stock	26.15	26.24	26.1236	26.15	22083.0
2020-07-13	AAM.B-DELISTED	Stock	26.49	26.69	26.25	26.64	77574.0
2020-07-13	AAMC-DELISTED	Stock	4.8471	4.8471	4.4824	4.5265	15786.0
2020-07-13	AAME	Stock	1.68	1.7	1.59	1.59	10700.0
2020-07-13	AAMI	Stock	12.87	12.87	12.03	12.12	808100.0
2020-07-13	AAOI	Stock	11.7	11.8	10.765	10.8	833500.0
2020-07-13	AAON	Stock	36.38	37.36	35.9467	36.3133	490050.0
2020-07-13	AAP	Stock	135.22	139.5	134.05	135.13	1064000.0
2020-07-13	AAT	Stock	27.43	27.43	26.27	26.61	272400.0
2020-07-13	AAU-DELISTED	Stock	0.53	0.5339	0.5152	0.523	381858.0
2020-07-13	AAUAF-DELISTED	Stock	0.53	0.5339	0.5152	0.529	416298.0
2020-07-13	AAWW-DELISTED	Stock	47.81	49.27	47.34	47.54	250647.0
2020-07-13	AAXJ	Stock	75.68	76.19	74.62	74.74	1453658.0
2020-07-13	AAXN-DELISTED	Stock	97.17	97.17	90.28	90.79	492673.0
2020-07-13	AB	Stock	27.63	27.63	27.04	27.07	589500.0
2020-07-13	ABB-DELISTED	Stock	24.2	24.49	24.13	24.17	3830694.0
2020-07-13	ABBNY-DELISTED	Stock	24.2	24.49	24.13	24.18	4066800.0
2020-07-13	ABBV	Stock	97.36	99.56	96.92	97.86	8507400.0
2020-07-13	ABC-DELISTED	Stock	97.28	98.83	97.06	97.28	922230.0
2020-07-13	ABCB	Stock	22.0	22.22	21.09	21.74	571300.0
2020-07-13	ABEO	Stock	76.5	76.5	71.25	71.5	49076.0
2020-07-13	ABEV	Stock	2.82	2.82	2.61	2.61	62774000.0
2020-07-13	ABG	Stock	92.4	95.79	90.26	90.44	344700.0
2020-07-13	ABM	Stock	33.23	34.32	32.72	33.71	561200.0
2020-07-13	ABMD-DELISTED	Stock	267.96	274.2	262.74	264.56	351068.0
2020-07-13	ABR	Stock	8.06	8.22	7.88	7.97	1499200.0
2020-07-13	ABR.A-DELISTED	Stock	24.53	24.64	24.505	24.5174	3830.0
2020-07-13	ABR.B-DELISTED	Stock	23.6382	23.645	23.51	23.53	979.0
2020-07-13	ABR.C-DELISTED	Stock	24.88	25.05	24.82	24.82	2269.0
2020-07-13	ABT	Stock	93.14	95.62	92.79	93.09	4297300.0
2020-07-13	ABTC	Stock	225300.0	233700.0	213600.0	214800.0	4.626666666666667
2020-07-13	ABTS	Stock	15.75	17.25	14.145	15.15	20053.0
2020-07-13	ABTX-DELISTED	Stock	22.97	23.43	22.27	22.99	35529.0
2020-07-13	ABUS	Stock	1.85	1.88	1.75	1.75	591100.0

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

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