PREVIEW / stock_daily / 2021-05-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-19.parquet
  size:    254 KB
  rows:    7,808
  symbols: 2,924

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
2021-05-19	AAPL	Stock	123.16	124.92	122.86	124.69	92612000.0
2021-05-19	MSFT	Stock	239.31	243.23	238.6	243.12	25739800.0
2021-05-19	NVDA	Stock	13.5665	14.0795	13.5432	14.0658	344000000.0
2021-05-19	AMZN	Stock	159.75	161.7375	159.2	161.59	53594000.0
2021-05-19	GOOGL	Stock	111.4215	113.7495	111.272	113.575	23684100.0
2021-05-19	META	Stock	304.19	314.66	303.57	313.59	19106200.0
2021-05-19	TSLA	Stock	184.1833	188.7367	182.3267	187.82	118735200.0
2021-05-19	TLT	Stock	136.54	137.3	135.62	136.11	14296300.0
2021-05-19	ES	Stock	83.46	83.57	82.43	83.25	1705700.0
2021-05-19	CL	Stock	82.8	83.26	82.44	83.21	4078400.0
2021-05-19	A	Stock	127.6	130.28	127.13	130.21	1119400.0
2021-05-19	AA	Stock	38.34	38.37	35.39	36.17	15755900.0
2021-05-19	AAC-DELISTED	Stock	9.78	9.82	9.75	9.79	586973.0
2021-05-19	AACG	Stock	2.84	2.9	2.71	2.86	38000.0
2021-05-19	AACQ-DELISTED	Stock	9.84	9.8699	9.83	9.83	455933.0
2021-05-19	AACQU-DELISTED	Stock	10.35	10.38	10.35	10.35	1507.0
2021-05-19	AACQW-DELISTED	Stock	1.55	1.555	1.46	1.52	49191.0
2021-05-19	AAIC-DELISTED	Stock	4.06	4.12	3.94	3.99	216436.0
2021-05-19	AAIC.C-DELISTED	Stock	24.76	24.82	24.75	24.8	1775.0
2021-05-19	AAL	Stock	22.97	23.27	22.62	22.97	34558200.0
2021-05-19	AAM.A-DELISTED	Stock	26.3	26.33	26.23	26.295	8618.0
2021-05-19	AAM.B-DELISTED	Stock	27.11	27.2	27.05	27.2	5188.0
2021-05-19	AAMC-DELISTED	Stock	5.0676	5.2559	5.0676	5.153	22161.0
2021-05-19	AAME	Stock	4.47	4.47	3.98	4.09	292600.0
2021-05-19	AAMI	Stock	22.48	22.61	22.11	22.56	329300.0
2021-05-19	AAN-DELISTED	Stock	31.71	33.14	31.51	33.09	237700.0
2021-05-19	AAOI	Stock	7.62	7.82	7.53	7.78	343600.0
2021-05-19	AAON	Stock	43.9467	44.56	43.2267	44.3333	155550.0
2021-05-19	AAP	Stock	199.03	199.66	191.67	194.58	1973200.0
2021-05-19	AAQC-DELISTED	Stock	9.69	9.7	9.65	9.65	2900.0
2021-05-19	AAT	Stock	34.77	35.21	34.08	35.03	256800.0
2021-05-19	AAU-DELISTED	Stock	0.55	0.566	0.5394	0.5532	882296.0
2021-05-19	AAUAF-DELISTED	Stock	0.55	0.566	0.5394	0.5555	920629.0
2021-05-19	AAWW-DELISTED	Stock	73.02	75.21	73.0	74.9832	287811.0
2021-05-19	AAXJ	Stock	90.99	92.08	90.7	91.85	519889.0
2021-05-19	AB	Stock	42.99	43.52	42.64	43.29	247600.0
2021-05-19	ABB-DELISTED	Stock	32.81	33.105	32.575	32.93	1602745.0
2021-05-19	ABBNY-DELISTED	Stock	32.81	33.105	32.575	32.94	1727646.0
2021-05-19	ABBV	Stock	116.46	116.5	114.38	115.85	6433600.0
2021-05-19	ABC-DELISTED	Stock	116.71	118.93	115.355	118.81	1033027.0
2021-05-19	ABCB	Stock	55.29	56.25	54.46	56.2	538100.0
2021-05-19	ABCL	Stock	32.56	32.57	31.32	32.35	327100.0
2021-05-19	ABCM-DELISTED	Stock	19.87	20.1	19.815	20.01	288111.0
2021-05-19	ABEO	Stock	37.25	39.75	36.25	38.5	59716.0
2021-05-19	ABEV	Stock	3.33	3.37	3.31	3.35	21863100.0
2021-05-19	ABG	Stock	197.71	198.11	192.88	196.65	216000.0
2021-05-19	ABGI-DELISTED	Stock	9.91	9.9359	9.84	9.92	9369.0
2021-05-19	ABM	Stock	50.62	50.72	50.07	50.65	584500.0
2021-05-19	ABMD-DELISTED	Stock	267.44	274.92	266.8	273.97	176772.0
2021-05-19	ABNB	Stock	129.95	138.38	129.71	138.19	15565500.0

> showing 50 of 7,808 rows — these rows as CSV

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