PREVIEW / stock_daily / 2020-04-29

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-29.parquet
  size:    218 KB
  rows:    6,619
  symbols: 2,359

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-29	AAPL	Stock	71.1825	72.4175	70.9725	71.9325	137280800.0
2020-04-29	MSFT	Stock	173.22	177.68	171.88	177.43	51286600.0
2020-04-29	NVDA	Stock	7.4192	7.5145	7.3438	7.4615	379160000.0
2020-04-29	AMZN	Stock	116.5005	119.5945	115.5	118.6355	91832000.0
2020-04-29	GOOGL	Stock	67.25	68.0075	66.3365	67.109	108357760.0
2020-04-29	META	Stock	190.93	196.91	190.0	194.19	45954500.0
2020-04-29	TSLA	Stock	52.678	53.5467	52.2107	53.3673	243240000.0
2020-04-29	TLT	Stock	169.53	170.26	167.96	168.71	8619566.0
2020-04-29	ES	Stock	87.15	87.15	82.97	83.37	2346700.0
2020-04-29	CL	Stock	70.54	70.84	68.84	70.16	4675700.0
2020-04-29	A	Stock	76.3	79.38	76.14	78.72	2409400.0
2020-04-29	AA	Stock	8.15	8.895	8.15	8.67	12389200.0
2020-04-29	AACG	Stock	0.74	0.74	0.71	0.72	17200.0
2020-04-29	AAIC-DELISTED	Stock	2.94	3.095	2.89	2.95	606838.0
2020-04-29	AAIC.C-DELISTED	Stock	17.08	17.4	16.9	17.4	12535.0
2020-04-29	AAL	Stock	12.1	12.89	12.02	12.63	113669400.0
2020-04-29	AAM.A-DELISTED	Stock	25.7899	25.825	25.43	25.818	26942.0
2020-04-29	AAM.B-DELISTED	Stock	25.77	25.8	25.48	25.6	24055.0
2020-04-29	AAMC-DELISTED	Stock	4.1618	6.4706	4.1618	5.7382	209134.0
2020-04-29	AAME	Stock	1.61	1.78	1.61	1.75	10300.0
2020-04-29	AAMI	Stock	7.68	8.13	7.57	7.88	869500.0
2020-04-29	AAOI	Stock	10.0	11.17	9.94	10.98	868900.0
2020-04-29	AAON	Stock	32.8	33.64	31.4533	32.3533	745500.0
2020-04-29	AAP	Stock	123.83	126.79	123.0	124.91	938400.0
2020-04-29	AAT	Stock	29.28	30.02	28.78	29.42	572100.0
2020-04-29	AAU-DELISTED	Stock	0.49	0.49	0.45	0.4665	643447.0
2020-04-29	AAUAF-DELISTED	Stock	0.49	0.49	0.45	0.4665	684569.0
2020-04-29	AAWW-DELISTED	Stock	33.0	35.64	32.13	35.23	1088541.0
2020-04-29	AAXJ	Stock	64.68	65.32	64.56	65.2	2189485.0
2020-04-29	AAXN-DELISTED	Stock	77.47	77.47	73.9075	75.23	577817.0
2020-04-29	AB	Stock	22.42	23.48	22.42	23.1	777900.0
2020-04-29	ABB-DELISTED	Stock	19.12	19.33	19.06	19.17	2328369.0
2020-04-29	ABBNY-DELISTED	Stock	19.1	19.33	19.06	19.17	2605375.0
2020-04-29	ABBV	Stock	83.72	84.75	82.14	83.76	8231700.0
2020-04-29	ABC-DELISTED	Stock	90.04	91.28	88.35	89.31	1589486.0
2020-04-29	ABCB	Stock	26.12	28.08	25.72	26.85	565100.0
2020-04-29	ABEO	Stock	64.75	64.75	61.0	64.0	44772.0
2020-04-29	ABEV	Stock	2.18	2.23	2.15	2.19	49640600.0
2020-04-29	ABG	Stock	65.95	70.94	65.64	69.48	234700.0
2020-04-29	ABM	Stock	35.07	36.5	34.8	35.95	482200.0
2020-04-29	ABMD-DELISTED	Stock	165.9	171.005	164.75	169.28	564116.0
2020-04-29	ABR	Stock	6.52	7.33	6.51	7.18	3474600.0
2020-04-29	ABR.A-DELISTED	Stock	21.74	22.45	21.51	22.45	4268.0
2020-04-29	ABR.B-DELISTED	Stock	20.6667	22.28	20.3379	21.2772	15667.0
2020-04-29	ABR.C-DELISTED	Stock	22.11	22.4	21.75	22.1	12260.0
2020-04-29	ABT	Stock	92.09	93.05	91.07	92.28	7068300.0
2020-04-29	ABTC	Stock	283200.0	283200.0	255000.0	265200.0	4.1466666666666665
2020-04-29	ABTS	Stock	11.25	11.25	10.95	10.995	1033.0
2020-04-29	ABTX-DELISTED	Stock	26.48	28.0	24.8269	27.75	78386.0
2020-04-29	ABUS	Stock	1.21	1.24	1.09	1.16	760100.0

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

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