PREVIEW / stock_daily / 2020-04-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-16.parquet
  size:    215 KB
  rows:    6,591
  symbols: 2,347

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-16	AAPL	Stock	71.845	72.05	70.5875	71.6725	157125200.0
2020-04-16	MSFT	Stock	174.3	177.28	172.9	177.04	50479600.0
2020-04-16	NVDA	Stock	7.177	7.475	7.1638	7.3675	745620000.0
2020-04-16	AMZN	Stock	117.3	123.05	116.75	120.4095	240764000.0
2020-04-16	GOOGL	Stock	63.357	63.6679	61.91	62.8715	57895140.0
2020-04-16	META	Stock	177.95	178.05	172.51	176.25	23593200.0
2020-04-16	TSLA	Stock	47.796	50.63	47.1147	49.6807	309868500.0
2020-04-16	TLT	Stock	169.26	170.315	169.0156	170.09	8265414.0
2020-04-16	ES	Stock	89.44	90.31	88.8	89.79	1771400.0
2020-04-16	CL	Stock	72.9	73.28	71.74	72.84	3561800.0
2020-04-16	A	Stock	78.06	78.92	76.47	78.75	1969300.0
2020-04-16	AA	Stock	7.21	7.4	6.79	6.96	7963300.0
2020-04-16	AACG	Stock	0.87	0.87	0.82	0.85	8200.0
2020-04-16	AAIC-DELISTED	Stock	2.8	2.8	2.57	2.61	396330.0
2020-04-16	AAIC.C-DELISTED	Stock	16.75	16.75	16.68	16.71	729.0
2020-04-16	AAL	Stock	11.91	12.03	11.05	11.07	83627000.0
2020-04-16	AAM.A-DELISTED	Stock	24.9155	24.99	24.71	24.94	12931.0
2020-04-16	AAM.B-DELISTED	Stock	24.76	25.1	24.75	25.05	36306.0
2020-04-16	AAMC-DELISTED	Stock	3.7235	4.0941	3.7235	4.0941	7426.0
2020-04-16	AAME	Stock	1.83	2.0	1.83	1.99	1800.0
2020-04-16	AAMI	Stock	5.46	5.755	5.195	5.25	431600.0
2020-04-16	AAOI	Stock	8.8	9.14	8.4	8.59	750900.0
2020-04-16	AAON	Stock	31.3	31.6	30.0	30.3467	410400.0
2020-04-16	AAP	Stock	112.84	118.22	110.96	117.53	1139500.0
2020-04-16	AAT	Stock	26.58	27.05	25.2	25.59	467000.0
2020-04-16	AAU-DELISTED	Stock	0.36	0.39	0.358	0.3669	349678.0
2020-04-16	AAUAF-DELISTED	Stock	0.36	0.39	0.358	0.3669	367550.0
2020-04-16	AAWW-DELISTED	Stock	23.85	24.57	23.36	23.97	334583.0
2020-04-16	AAXJ	Stock	62.5	62.59	62.07	62.33	1030857.0
2020-04-16	AAXN-DELISTED	Stock	74.9	75.0	70.65	72.66	464482.0
2020-04-16	AB	Stock	19.94	20.29	19.34	19.86	426000.0
2020-04-16	ABB-DELISTED	Stock	17.2	17.245	16.885	17.1	2008706.0
2020-04-16	ABBNY-DELISTED	Stock	17.2	17.245	16.885	17.1	2202507.0
2020-04-16	ABBV	Stock	82.73	83.72	81.58	81.86	10326900.0
2020-04-16	ABC-DELISTED	Stock	88.26	89.26	85.54	86.29	1361608.0
2020-04-16	ABCB	Stock	21.89	21.89	19.75	20.19	460800.0
2020-04-16	ABEO	Stock	62.0	63.25	58.25	59.25	43540.0
2020-04-16	ABEV	Stock	2.31	2.31	2.19	2.2	21200000.0
2020-04-16	ABG	Stock	53.37	54.8	51.39	53.17	315800.0
2020-04-16	ABM	Stock	30.56	31.68	30.14	31.54	722400.0
2020-04-16	ABMD-DELISTED	Stock	160.19	162.06	158.08	160.2	149166.0
2020-04-16	ABR	Stock	6.41	6.49	6.0	6.08	1813800.0
2020-04-16	ABR.A-DELISTED	Stock	20.5	20.581	19.8	20.0	2690.0
2020-04-16	ABR.B-DELISTED	Stock	19.28	20.34	19.14	19.65	4629.0
2020-04-16	ABR.C-DELISTED	Stock	20.3759	20.75	20.0	20.1	19405.0
2020-04-16	ABT	Stock	92.6	96.99	91.14	96.0	27036500.0
2020-04-16	ABTC	Stock	238200.0	239400.0	225000.0	231000.0	1.4400000000000002
2020-04-16	ABTS	Stock	13.65	14.025	12.075	12.75	3667.0
2020-04-16	ABTX-DELISTED	Stock	22.79	23.245	20.88	21.56	101998.0
2020-04-16	ABUS	Stock	1.17	1.22	1.11	1.2	583500.0

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

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