PREVIEW / stock_daily / 2020-04-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-06.parquet
  size:    215 KB
  rows:    6,649
  symbols: 2,397

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-06	AAPL	Stock	62.725	65.7775	62.345	65.6175	201820400.0
2020-04-06	MSFT	Stock	160.32	166.5	157.58	165.27	67111700.0
2020-04-06	NVDA	Stock	6.381	6.747	6.3233	6.71	727884000.0
2020-04-06	AMZN	Stock	96.8	99.926	96.501	99.8795	115464000.0
2020-04-06	GOOGL	Stock	56.65	59.5377	56.25	59.1595	63319820.0
2020-04-06	META	Stock	160.15	166.2	158.51	165.55	28453600.0
2020-04-06	TSLA	Stock	34.08	34.7333	33.1973	34.416	223527000.0
2020-04-06	TLT	Stock	167.0	168.27	166.53	168.06	9434786.0
2020-04-06	ES	Stock	78.01	82.88	77.13	82.09	1736800.0
2020-04-06	CL	Stock	69.6	71.73	69.13	70.5	5172800.0
2020-04-06	A	Stock	72.97	74.99	72.25	74.36	2312000.0
2020-04-06	AA	Stock	6.37	6.84	6.25	6.55	9900300.0
2020-04-06	AACG	Stock	0.95	0.95	0.94	0.95	3500.0
2020-04-06	AAIC-DELISTED	Stock	1.87	2.1	1.87	2.0	598758.0
2020-04-06	AAIC.C-DELISTED	Stock	13.1	14.3	13.1	14.0465	9927.0
2020-04-06	AAL	Stock	9.72	9.94	9.11	9.5	94272300.0
2020-04-06	AAM.A-DELISTED	Stock	21.58	22.34	21.58	22.24	82395.0
2020-04-06	AAM.B-DELISTED	Stock	22.39	22.39	21.91	22.1	35072.0
2020-04-06	AAMC-DELISTED	Stock	4.1088	4.1088	3.7522	4.0765	5341.0
2020-04-06	AAME	Stock	2.1	2.21	2.1	2.21	900.0
2020-04-06	AAMI	Stock	5.41	6.625	5.41	6.49	631700.0
2020-04-06	AAOI	Stock	7.78	7.945	7.5	7.92	728400.0
2020-04-06	AAON	Stock	31.1067	32.7133	30.32	32.1533	419100.0
2020-04-06	AAP	Stock	89.44	98.3	88.53	95.81	1378300.0
2020-04-06	AAT	Stock	22.55	23.97	22.42	23.65	604700.0
2020-04-06	AAU-DELISTED	Stock	0.3119	0.3119	0.28	0.2872	368519.0
2020-04-06	AAUAF-DELISTED	Stock	0.3119	0.3119	0.28	0.2872	386963.0
2020-04-06	AAWW-DELISTED	Stock	21.26	22.245	20.75	21.95	505239.0
2020-04-06	AAXJ	Stock	60.16	61.04	59.98	61.0	2624457.0
2020-04-06	AAXN-DELISTED	Stock	64.56	68.65	63.76	67.71	581408.0
2020-04-06	AB	Stock	18.83	19.24	18.19	18.69	476200.0
2020-04-06	ABB-DELISTED	Stock	17.35	17.7	17.28	17.58	2795977.0
2020-04-06	ABBNY-DELISTED	Stock	17.35	17.7	17.28	17.58	2955622.0
2020-04-06	ABBV	Stock	75.74	77.26	74.03	75.73	10266500.0
2020-04-06	ABC-DELISTED	Stock	85.32	86.83	83.07	86.28	1156376.0
2020-04-06	ABCB	Stock	21.68	22.44	21.43	22.36	432700.0
2020-04-06	ABEO	Stock	54.75	57.5	53.75	57.25	58304.0
2020-04-06	ABEV	Stock	2.28	2.42	2.22	2.23	27551200.0
2020-04-06	ABG	Stock	44.38	47.98	44.38	47.65	322600.0
2020-04-06	ABM	Stock	23.83	26.02	23.65	25.97	622900.0
2020-04-06	ABMD-DELISTED	Stock	144.2	150.87	143.66	150.12	398298.0
2020-04-06	ABR	Stock	4.19	5.4	4.16	4.99	3766400.0
2020-04-06	ABR.A-DELISTED	Stock	13.65	16.7071	13.65	15.3	7065.0
2020-04-06	ABR.B-DELISTED	Stock	12.6	14.75	12.6	14.39	2286.0
2020-04-06	ABR.C-DELISTED	Stock	13.65	15.0	13.65	14.32	4294.0
2020-04-06	ABT	Stock	81.08	83.12	79.61	82.73	12373800.0
2020-04-06	ABTC	Stock	173100.0	190200.0	172620.0	184500.0	3.8800000000000003
2020-04-06	ABTS	Stock	9.3	9.45	8.85	8.85	527.0
2020-04-06	ABTX-DELISTED	Stock	22.74	23.64	22.53	23.32	75841.0
2020-04-06	ABUS	Stock	0.98	1.05	0.89	1.04	621300.0

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

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