PREVIEW / stock_daily / 2021-12-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-09.parquet
  size:    261 KB
  rows:    8,015
  symbols: 2,642

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-12-09	AAPL	Stock	174.91	176.75	173.92	174.56	108923700.0
2021-12-09	MSFT	Stock	334.41	336.49	332.12	333.1	22214200.0
2021-12-09	NVDA	Stock	31.734	32.205	30.428	30.49	488507000.0
2021-12-09	AMZN	Stock	175.75	176.9695	174.1395	174.171	46062000.0
2021-12-09	GOOGL	Stock	147.591	149.1	147.115	147.6385	23269720.0
2021-12-09	META	Stock	329.54	336.13	328.0	329.82	16879200.0
2021-12-09	TSLA	Stock	353.5467	354.1633	334.12	334.6	59438400.0
2021-12-09	TLT	Stock	149.34	149.84	148.48	149.22	17544892.0
2021-12-09	ES	Stock	87.41	88.18	86.21	87.53	1314100.0
2021-12-09	CL	Stock	77.67	78.3	77.31	78.0	2928500.0
2021-12-09	A	Stock	156.5	158.0	154.51	154.61	1272300.0
2021-12-09	AA	Stock	47.8	50.98	47.35	49.98	8732000.0
2021-12-09	AAC-DELISTED	Stock	9.82	9.82	9.78	9.78	36348.0
2021-12-09	AACG	Stock	1.44	1.63	1.34	1.57	83900.0
2021-12-09	AACIW-DELISTED	Stock	0.5159	0.516	0.501	0.501	20701.0
2021-12-09	AAIC-DELISTED	Stock	3.65	3.73	3.65	3.7	75906.0
2021-12-09	AAL	Stock	18.04	18.29	17.85	18.14	36027700.0
2021-12-09	AAM.A-DELISTED	Stock	25.315	25.3204	25.27	25.28	15350.0
2021-12-09	AAM.B-DELISTED	Stock	26.06	26.14	26.04	26.09	14874.0
2021-12-09	AAME	Stock	3.81	3.86	3.71	3.71	5500.0
2021-12-09	AAMI	Stock	29.67	31.17	29.3	30.31	3977700.0
2021-12-09	AAN-DELISTED	Stock	24.49	24.91	24.31	24.38	162400.0
2021-12-09	AAOI	Stock	5.89	6.14	5.87	5.93	529500.0
2021-12-09	AAON	Stock	55.3267	55.62	53.2267	53.2733	202800.0
2021-12-09	AAP	Stock	234.43	236.49	232.75	234.62	551000.0
2021-12-09	AAQC-DELISTED	Stock	9.74	9.74	9.73	9.73	2600.0
2021-12-09	AAT	Stock	36.4	36.4	35.45	35.87	319400.0
2021-12-09	AATC	Stock	6.45	6.6027	6.45	6.51	10270.0
2021-12-09	AAU-DELISTED	Stock	0.32	0.32	0.314	0.3192	209208.0
2021-12-09	AAUAF-DELISTED	Stock	0.32	0.32	0.314	0.3192	212804.0
2021-12-09	AAWW-DELISTED	Stock	86.61	87.68	85.8	86.71	113189.0
2021-12-09	AAXJ	Stock	85.45	85.83	85.25	85.33	1434757.0
2021-12-09	AB	Stock	50.05	50.89	49.5	49.85	1049200.0
2021-12-09	ABB-DELISTED	Stock	36.71	36.81	36.615	36.72	1067854.0
2021-12-09	ABBNY-DELISTED	Stock	36.71	36.81	36.615	36.72	1182675.0
2021-12-09	ABBV	Stock	122.21	124.46	122.1	124.15	8082300.0
2021-12-09	ABC-DELISTED	Stock	120.32	122.36	119.835	121.71	752368.0
2021-12-09	ABCB	Stock	49.01	49.4	48.62	49.06	223300.0
2021-12-09	ABCL	Stock	15.07	15.1	14.5	14.55	946800.0
2021-12-09	ABCM-DELISTED	Stock	22.86	22.9	22.57	22.8	91046.0
2021-12-09	ABEO	Stock	16.25	17.0	15.5	15.5	24704.0
2021-12-09	ABEV	Stock	2.85	2.86	2.78	2.78	25156100.0
2021-12-09	ABG	Stock	167.51	171.15	166.23	167.51	179800.0
2021-12-09	ABGI-DELISTED	Stock	9.74	9.75	9.74	9.75	9918.0
2021-12-09	ABM	Stock	45.65	46.01	44.97	45.38	382700.0
2021-12-09	ABMD-DELISTED	Stock	323.88	326.98	312.18	312.19	108809.0
2021-12-09	ABNB	Stock	182.09	185.302	179.28	181.46	3518000.0
2021-12-09	ABOS	Stock	7.45	7.45	7.11	7.22	120800.0
2021-12-09	ABR	Stock	18.3	18.32	18.08	18.1	662700.0
2021-12-09	ABR.D	Stock	25.1913	25.2	25.1893	25.2	11982.0

> showing 50 of 8,015 rows — these rows as CSV

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