PREVIEW / stock_daily / 2021-05-21

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-21.parquet
  size:    256 KB
  rows:    7,834
  symbols: 2,935

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-21	AAPL	Stock	127.82	128.0	125.21	125.43	79295400.0
2021-05-21	MSFT	Stock	247.57	248.33	244.74	245.17	21863100.0
2021-05-21	NVDA	Stock	15.1638	15.222	14.8695	14.9918	672992000.0
2021-05-21	AMZN	Stock	162.5	162.8345	159.8505	160.154	82098000.0
2021-05-21	GOOGL	Stock	115.8705	115.9445	114.465	114.7065	40631800.0
2021-05-21	META	Stock	319.29	319.93	315.81	316.23	13600900.0
2021-05-21	TSLA	Stock	198.7033	198.8933	193.3333	193.6267	78091800.0
2021-05-21	TLT	Stock	137.66	137.7	137.06	137.67	10171561.0
2021-05-21	ES	Stock	84.0	84.75	83.56	84.09	3146500.0
2021-05-21	CL	Stock	84.29	84.66	84.02	84.23	3497900.0
2021-05-21	A	Stock	132.67	134.13	132.22	132.3	1445900.0
2021-05-21	AA	Stock	36.17	37.068	35.65	36.14	6902600.0
2021-05-21	AAC-DELISTED	Stock	9.79	9.79	9.78	9.79	382461.0
2021-05-21	AACG	Stock	2.89	3.06	2.88	2.93	314700.0
2021-05-21	AACQ-DELISTED	Stock	9.85	9.88	9.85	9.865	619004.0
2021-05-21	AACQU-DELISTED	Stock	10.4313	10.4313	10.4313	10.4313	855.0
2021-05-21	AACQW-DELISTED	Stock	1.53	1.64	1.51	1.51	87559.0
2021-05-21	AAIC-DELISTED	Stock	4.05	4.11	4.0	4.11	253530.0
2021-05-21	AAIC.C-DELISTED	Stock	24.8	24.8	24.8	24.8	977.0
2021-05-21	AAL	Stock	22.71	23.04	22.51	22.57	26246500.0
2021-05-21	AAM.A-DELISTED	Stock	26.2	26.3	26.13	26.24	6894.0
2021-05-21	AAM.B-DELISTED	Stock	27.19	27.19	27.08	27.09	12323.0
2021-05-21	AAMC-DELISTED	Stock	5.1912	5.3882	5.0735	5.1376	31878.0
2021-05-21	AAME	Stock	4.2	4.3	4.11	4.3	50400.0
2021-05-21	AAMI	Stock	22.98	23.155	22.49	22.54	481200.0
2021-05-21	AAN-DELISTED	Stock	33.98	35.17	33.535	34.77	412800.0
2021-05-21	AAOI	Stock	7.98	8.23	7.91	8.06	588500.0
2021-05-21	AAON	Stock	44.9533	45.48	44.4267	44.5333	240000.0
2021-05-21	AAP	Stock	197.52	198.5	194.19	194.94	707200.0
2021-05-21	AAQC-DELISTED	Stock	9.72	9.72	9.64	9.65	10481.0
2021-05-21	AAT	Stock	35.05	35.18	34.67	34.97	159500.0
2021-05-21	AAU-DELISTED	Stock	0.56	0.569	0.5401	0.5467	589062.0
2021-05-21	AAUAF-DELISTED	Stock	0.56	0.569	0.5401	0.5481	607501.0
2021-05-21	AAWW-DELISTED	Stock	74.84	75.31	74.11	74.11	185968.0
2021-05-21	AAXJ	Stock	92.32	92.32	91.14	91.27	365310.0
2021-05-21	AB	Stock	43.79	44.6	43.51	44.51	321400.0
2021-05-21	ABB-DELISTED	Stock	33.6	33.73	33.45	33.65	1026238.0
2021-05-21	ABBNY-DELISTED	Stock	33.6	33.73	33.45	33.65	1132356.0
2021-05-21	ABBV	Stock	117.52	118.28	116.06	116.12	5577800.0
2021-05-21	ABC-DELISTED	Stock	120.7	122.31	120.05	120.08	571809.0
2021-05-21	ABCB	Stock	57.5	59.6	57.42	58.52	829200.0
2021-05-21	ABCL	Stock	31.21	32.701	31.21	32.03	409400.0
2021-05-21	ABCM-DELISTED	Stock	20.13	20.13	19.88	19.92	58295.0
2021-05-21	ABEO	Stock	40.0	41.0	38.75	40.5	34416.0
2021-05-21	ABEV	Stock	3.35	3.35	3.25	3.3	50720100.0
2021-05-21	ABG	Stock	198.12	200.44	195.4	197.3	134400.0
2021-05-21	ABGI-DELISTED	Stock	9.8102	9.95	9.8102	9.94	5490.0
2021-05-21	ABM	Stock	49.99	50.29	49.42	49.49	422200.0
2021-05-21	ABMD-DELISTED	Stock	276.4	281.81	276.4	279.76	129351.0
2021-05-21	ABNB	Stock	136.55	137.17	132.88	134.71	10056500.0

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

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