PREVIEW / stock_daily / 2021-05-27

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-27.parquet
  size:    257 KB
  rows:    7,846
  symbols: 2,938

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-27	AAPL	Stock	126.44	127.64	125.08	125.28	94625600.0
2021-05-27	MSFT	Stock	251.17	251.48	249.25	249.31	24426200.0
2021-05-27	NVDA	Stock	15.6998	15.75	15.46	15.488	581476000.0
2021-05-27	AMZN	Stock	162.8	163.018	161.502	161.5055	51224000.0
2021-05-27	GOOGL	Stock	119.4525	119.4525	117.813	118.134	35224020.0
2021-05-27	META	Stock	328.0	333.78	326.76	332.75	20477700.0
2021-05-27	TSLA	Stock	206.7467	210.3767	205.4033	210.2833	79111800.0
2021-05-27	TLT	Stock	138.5	138.69	137.99	138.655	10695157.0
2021-05-27	ES	Stock	81.58	81.68	81.04	81.15	1871900.0
2021-05-27	CL	Stock	84.37	84.67	83.69	83.69	4686300.0
2021-05-27	A	Stock	133.32	138.14	133.16	137.54	3699600.0
2021-05-27	AA	Stock	37.51	39.055	37.3	39.01	6946100.0
2021-05-27	AAC-DELISTED	Stock	9.83	9.855	9.81	9.855	73755.0
2021-05-27	AACG	Stock	2.82	3.0	2.82	2.95	58000.0
2021-05-27	AACQ-DELISTED	Stock	9.96	9.965	9.94	9.95	681246.0
2021-05-27	AACQU-DELISTED	Stock	10.52	10.52	10.52	10.52	1500.0
2021-05-27	AACQW-DELISTED	Stock	1.755	1.81	1.7	1.77	100483.0
2021-05-27	AAIC-DELISTED	Stock	4.05	4.07	4.02	4.04	163761.0
2021-05-27	AAIC.C-DELISTED	Stock	24.9	24.9	24.7994	24.8	3385.0
2021-05-27	AAL	Stock	24.03	24.49	23.68	24.43	36389500.0
2021-05-27	AAM.A-DELISTED	Stock	26.18	26.18	26.04	26.08	44725.0
2021-05-27	AAM.B-DELISTED	Stock	27.13	27.14	27.0428	27.1	6726.0
2021-05-27	AAMC-DELISTED	Stock	4.9353	4.9971	4.9353	4.9441	14086.0
2021-05-27	AAME	Stock	4.36	4.41	4.28	4.29	38300.0
2021-05-27	AAMI	Stock	22.74	22.88	22.47	22.5	306600.0
2021-05-27	AAN-DELISTED	Stock	36.5	36.81	36.05	36.13	194400.0
2021-05-27	AAOI	Stock	8.08	8.32	8.01	8.21	513900.0
2021-05-27	AAON	Stock	44.62	44.76	43.96	43.9733	261750.0
2021-05-27	AAP	Stock	189.85	190.28	187.5	188.64	1011600.0
2021-05-27	AAQC-DELISTED	Stock	9.74	9.74	9.65	9.65	2254.0
2021-05-27	AAT	Stock	36.44	36.44	35.65	36.0	486600.0
2021-05-27	AAU-DELISTED	Stock	0.5474	0.554	0.5425	0.5533	650850.0
2021-05-27	AAUAF-DELISTED	Stock	0.5474	0.554	0.5425	0.5539	668923.0
2021-05-27	AAWW-DELISTED	Stock	75.48	76.045	74.77	75.56	201010.0
2021-05-27	AAXJ	Stock	94.0	94.13	93.69	93.84	1283450.0
2021-05-27	AB	Stock	44.98	45.27	44.75	45.06	270600.0
2021-05-27	ABB-DELISTED	Stock	33.93	34.2	33.92	34.15	2540337.0
2021-05-27	ABBNY-DELISTED	Stock	33.93	34.2	33.92	34.16	2678012.0
2021-05-27	ABBV	Stock	115.12	115.2	112.02	112.32	26406000.0
2021-05-27	ABC-DELISTED	Stock	115.4	115.44	113.79	115.01	1420554.0
2021-05-27	ABCB	Stock	55.02	55.49	54.55	55.09	296700.0
2021-05-27	ABCL	Stock	28.2	28.5	26.78	27.15	1581900.0
2021-05-27	ABCM-DELISTED	Stock	20.06	20.38	20.01	20.14	48581.0
2021-05-27	ABEO	Stock	42.25	42.5	40.25	41.25	46320.0
2021-05-27	ABEV	Stock	3.3	3.4	3.28	3.37	33293900.0
2021-05-27	ABG	Stock	198.72	202.9	197.85	199.46	143700.0
2021-05-27	ABM	Stock	50.26	50.54	49.94	50.01	305800.0
2021-05-27	ABMD-DELISTED	Stock	281.87	287.59	278.74	285.85	397130.0
2021-05-27	ABNB	Stock	135.07	143.82	134.5	143.17	21270200.0
2021-05-27	ABR	Stock	17.98	18.38	17.97	18.16	1634900.0

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

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