PREVIEW / stock_daily / 2020-04-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-17.parquet
  size:    216 KB
  rows:    6,611
  symbols: 2,362

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-04-17	AAPL	Stock	71.1725	71.7375	69.215	70.7	215250000.0
2020-04-17	MSFT	Stock	179.5	180.0	175.87	178.6	52765600.0
2020-04-17	NVDA	Stock	7.45	7.4715	7.1735	7.308	539120000.0
2020-04-17	AMZN	Stock	118.6165	120.0	115.801	118.75	158600000.0
2020-04-17	GOOGL	Stock	64.085	64.5	63.3	63.95	51056480.0
2020-04-17	META	Stock	179.2	180.28	176.66	179.24	20974800.0
2020-04-17	TSLA	Stock	51.4853	51.6633	49.844	50.2593	196923000.0
2020-04-17	TLT	Stock	169.82	170.84	167.27	167.81	8612119.0
2020-04-17	ES	Stock	91.49	92.14	89.16	91.56	1586600.0
2020-04-17	CL	Stock	72.71	73.7	71.53	73.42	3762400.0
2020-04-17	A	Stock	80.09	80.35	78.31	79.55	1313400.0
2020-04-17	AA	Stock	7.25	7.62	7.23	7.59	10114400.0
2020-04-17	AACG	Stock	0.83	0.86	0.82	0.84	7600.0
2020-04-17	AAIC-DELISTED	Stock	2.78	2.82	2.66	2.75	468975.0
2020-04-17	AAIC.C-DELISTED	Stock	16.5	17.49	16.5	17.49	8305.0
2020-04-17	AAL	Stock	11.87	11.95	11.5	11.57	61279500.0
2020-04-17	AAM.A-DELISTED	Stock	25.09	25.1665	25.04	25.06	57800.0
2020-04-17	AAM.B-DELISTED	Stock	25.1	25.18	24.92	25.05	131533.0
2020-04-17	AAMC-DELISTED	Stock	4.0626	4.0974	3.9764	4.0974	2196.0
2020-04-17	AAME	Stock	1.99	1.99	1.93	1.93	600.0
2020-04-17	AAMI	Stock	5.4	5.77	5.18	5.42	730500.0
2020-04-17	AAOI	Stock	8.78	8.855	8.34	8.44	620800.0
2020-04-17	AAON	Stock	31.02	32.12	30.42	31.9	403350.0
2020-04-17	AAP	Stock	121.5	123.4	115.64	118.86	949600.0
2020-04-17	AAT	Stock	26.65	27.29	26.07	26.25	218400.0
2020-04-17	AAU-DELISTED	Stock	0.38	0.38	0.355	0.3772	231048.0
2020-04-17	AAUAF-DELISTED	Stock	0.38	0.38	0.355	0.3772	253830.0
2020-04-17	AAWW-DELISTED	Stock	24.83	25.91	24.26	24.75	457403.0
2020-04-17	AAXJ	Stock	63.85	63.94	63.253	63.7	936569.0
2020-04-17	AAXN-DELISTED	Stock	75.85	77.23	75.1	76.72	421612.0
2020-04-17	AB	Stock	20.71	21.34	20.46	20.58	535300.0
2020-04-17	ABB-DELISTED	Stock	17.64	17.69	17.42	17.66	1924267.0
2020-04-17	ABBNY-DELISTED	Stock	17.64	17.69	17.42	17.67	2100092.0
2020-04-17	ABBV	Stock	84.0	84.79	82.5	83.45	10734800.0
2020-04-17	ABC-DELISTED	Stock	88.76	89.89	87.28	89.19	1349371.0
2020-04-17	ABCB	Stock	21.32	23.13	21.32	22.56	579500.0
2020-04-17	ABEO	Stock	61.5	62.25	57.25	58.25	36480.0
2020-04-17	ABEV	Stock	2.27	2.27	2.2	2.22	13471800.0
2020-04-17	ABG	Stock	55.63	58.29	54.65	58.12	354100.0
2020-04-17	ABM	Stock	32.52	33.35	31.63	32.88	767100.0
2020-04-17	ABMD-DELISTED	Stock	162.82	166.52	161.5	166.02	333197.0
2020-04-17	ABR	Stock	6.38	6.89	6.27	6.76	2679800.0
2020-04-17	ABR.A-DELISTED	Stock	20.5	20.5615	19.05	20.4	3847.0
2020-04-17	ABR.B-DELISTED	Stock	19.94	20.4642	18.41	20.4642	2162.0
2020-04-17	ABR.C-DELISTED	Stock	20.12	20.738	20.0	20.6	18120.0
2020-04-17	ABT	Stock	97.45	97.75	94.24	96.01	16074800.0
2020-04-17	ABTC	Stock	236700.0	240000.0	225330.0	235800.0	1.5733333333333335
2020-04-17	ABTS	Stock	12.75	13.5	12.15	12.84	1773.0
2020-04-17	ABTX-DELISTED	Stock	22.36	23.38	22.36	23.19	57888.0
2020-04-17	ABUS	Stock	1.21	1.25	1.16	1.19	442700.0

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

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