PREVIEW / stock_daily / 2021-06-23

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-23.parquet
  size:    258 KB
  rows:    7,875
  symbols: 2,896

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-06-23	AAPL	Stock	133.77	134.32	133.23	133.7	60214200.0
2021-06-23	MSFT	Stock	265.99	266.83	264.43	265.27	19518700.0
2021-06-23	NVDA	Stock	19.0077	19.1528	18.9078	19.0572	332356000.0
2021-06-23	AMZN	Stock	175.25	176.05	174.16	175.191	56266000.0
2021-06-23	GOOGL	Stock	122.0935	123.0955	121.8345	122.127	19154160.0
2021-06-23	META	Stock	339.35	343.42	338.2	340.59	14817800.0
2021-06-23	TSLA	Stock	210.6667	219.0667	210.0133	218.8567	93297600.0
2021-06-23	TLT	Stock	143.11	143.5	142.71	143.27	12041212.0
2021-06-23	ES	Stock	79.9	80.1	78.68	78.74	1310900.0
2021-06-23	CL	Stock	81.28	81.34	80.24	80.25	3673800.0
2021-06-23	A	Stock	146.72	148.06	146.43	147.24	1455700.0
2021-06-23	AA	Stock	35.08	35.96	34.82	35.04	9462600.0
2021-06-23	AAC-DELISTED	Stock	9.78	9.79	9.76	9.76	372737.0
2021-06-23	AACG	Stock	2.87	3.04	2.83	2.97	94600.0
2021-06-23	AACQ-DELISTED	Stock	9.5	10.01	9.2211	9.7	2230034.0
2021-06-23	AACQU-DELISTED	Stock	10.41	10.79	10.1	10.61	15218.0
2021-06-23	AACQW-DELISTED	Stock	2.13	2.5	2.1	2.4	241254.0
2021-06-23	AAIC-DELISTED	Stock	3.95	4.01	3.91	3.92	334091.0
2021-06-23	AAIC.C-DELISTED	Stock	24.85	24.9742	24.75	24.9742	5218.0
2021-06-23	AAL	Stock	22.17	22.34	22.08	22.2	17394700.0
2021-06-23	AAM.A-DELISTED	Stock	26.32	26.46	26.25	26.31	52559.0
2021-06-23	AAM.B-DELISTED	Stock	27.16	27.2	27.12	27.14	2746.0
2021-06-23	AAMC-DELISTED	Stock	5.6118	5.7235	5.5941	5.7235	4797.0
2021-06-23	AAME	Stock	4.02	4.14	4.01	4.12	19600.0
2021-06-23	AAMI	Stock	23.81	24.13	23.66	23.85	407300.0
2021-06-23	AAN-DELISTED	Stock	32.97	33.57	32.48	33.31	312400.0
2021-06-23	AAOI	Stock	8.45	8.64	8.33	8.36	334900.0
2021-06-23	AAON	Stock	41.34	41.3867	40.6067	40.66	205950.0
2021-06-23	AAP	Stock	200.0	201.73	199.7	200.71	699400.0
2021-06-23	AAQC-DELISTED	Stock	9.73	9.73	9.69	9.695	5115.0
2021-06-23	AAT	Stock	37.55	37.75	37.43	37.54	151400.0
2021-06-23	AAU-DELISTED	Stock	0.499	0.5	0.491	0.4951	378353.0
2021-06-23	AAUAF-DELISTED	Stock	0.5	0.5	0.491	0.4951	387461.0
2021-06-23	AAWW-DELISTED	Stock	68.99	69.4	68.23	68.8	183302.0
2021-06-23	AAXJ	Stock	93.34	93.78	93.2	93.26	545367.0
2021-06-23	AB	Stock	44.8	45.27	44.8	45.14	136800.0
2021-06-23	ABB-DELISTED	Stock	34.0	34.085	33.7	33.7	1019872.0
2021-06-23	ABBNY-DELISTED	Stock	34.0	34.085	33.7	33.7	1100367.0
2021-06-23	ABBV	Stock	114.55	115.03	113.95	114.0	3837300.0
2021-06-23	ABC-DELISTED	Stock	116.47	116.67	115.49	115.79	488879.0
2021-06-23	ABCB	Stock	52.18	52.33	51.5	51.68	595200.0
2021-06-23	ABCL	Stock	21.0	21.77	19.8	21.71	6377700.0
2021-06-23	ABCM-DELISTED	Stock	19.06	19.06	18.82	18.83	76444.0
2021-06-23	ABEO	Stock	41.0	43.0	39.75	40.5	64756.0
2021-06-23	ABEV	Stock	3.66	3.71	3.57	3.59	30134500.0
2021-06-23	ABG	Stock	160.74	164.66	159.57	162.05	129300.0
2021-06-23	ABGI-DELISTED	Stock	9.87	9.895	9.8	9.85	38046.0
2021-06-23	ABM	Stock	45.18	45.55	44.78	45.11	260800.0
2021-06-23	ABMD-DELISTED	Stock	327.49	328.0	319.315	321.63	168696.0
2021-06-23	ABNB	Stock	149.76	154.59	147.8	151.58	9335700.0

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

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