PREVIEW / stock_daily / 2021-09-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-08.parquet
  size:    256 KB
  rows:    7,843
  symbols: 2,677

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-09-08	AAPL	Stock	156.98	157.04	153.98	155.11	74420200.0
2021-09-08	MSFT	Stock	299.78	300.61	297.47	300.21	15046800.0
2021-09-08	NVDA	Stock	22.513	22.61	21.977	22.339	254434000.0
2021-09-08	AMZN	Stock	175.5825	177.2815	174.7835	176.275	61068000.0
2021-09-08	GOOGL	Stock	144.1	144.4	143.0	143.691	18350220.0
2021-09-08	META	Stock	380.16	380.87	374.79	377.57	11067200.0
2021-09-08	TSLA	Stock	253.86	254.8167	246.9233	251.29	56379000.0
2021-09-08	TLT	Stock	147.66	148.19	147.39	147.93	14533699.0
2021-09-08	ES	Stock	89.81	92.61	89.39	91.89	2738700.0
2021-09-08	CL	Stock	76.61	77.86	76.6	77.78	3863900.0
2021-09-08	A	Stock	177.42	179.18	176.57	178.73	1174600.0
2021-09-08	AA	Stock	46.52	47.77	45.405	45.73	5689800.0
2021-09-08	AAC-DELISTED	Stock	9.7	9.72	9.7	9.7	1372766.0
2021-09-08	AACG	Stock	2.8	2.99	2.67	2.71	68800.0
2021-09-08	AAIC-DELISTED	Stock	3.76	3.8064	3.76	3.77	53031.0
2021-09-08	AAIC.C-DELISTED	Stock	25.39	25.42	25.06	25.42	2779.0
2021-09-08	AAL	Stock	19.53	19.8	19.05	19.13	21836100.0
2021-09-08	AAM.A-DELISTED	Stock	26.02	26.02	25.97	26.0	15685.0
2021-09-08	AAM.B-DELISTED	Stock	26.8	26.88	26.8	26.82	4992.0
2021-09-08	AAMC-DELISTED	Stock	7.4471	8.3824	7.4	8.3824	198081.0
2021-09-08	AAME	Stock	3.9	4.06	3.83	3.92	114900.0
2021-09-08	AAMI	Stock	27.04	27.17	26.74	26.91	305700.0
2021-09-08	AAN-DELISTED	Stock	26.34	26.62	26.05	26.34	186900.0
2021-09-08	AAOI	Stock	7.77	8.0	7.77	7.78	292200.0
2021-09-08	AAON	Stock	42.94	43.6333	42.7133	43.2733	221850.0
2021-09-08	AAP	Stock	200.25	200.51	198.15	200.18	573000.0
2021-09-08	AAQC-DELISTED	Stock	9.6493	9.69	9.63	9.69	9986.0
2021-09-08	AAT	Stock	39.87	40.62	39.65	39.88	208900.0
2021-09-08	AATC	Stock	8.08	8.28	7.95	8.12	36095.0
2021-09-08	AAU-DELISTED	Stock	0.4146	0.4146	0.399	0.4001	596973.0
2021-09-08	AAUAF-DELISTED	Stock	0.4146	0.4146	0.399	0.4001	608852.0
2021-09-08	AAWW-DELISTED	Stock	73.39	73.9	72.61	72.75	201389.0
2021-09-08	AAXJ	Stock	90.17	90.17	89.31	89.52	739495.0
2021-09-08	AB	Stock	50.75	51.18	50.42	50.67	190100.0
2021-09-08	ABB-DELISTED	Stock	36.66	36.715	36.35	36.5	799738.0
2021-09-08	ABBNY-DELISTED	Stock	36.66	36.715	36.35	36.5	900394.0
2021-09-08	ABBV	Stock	108.06	110.9	107.72	110.36	10823200.0
2021-09-08	ABC-DELISTED	Stock	124.18	125.27	123.52	124.34	295208.0
2021-09-08	ABCB	Stock	47.3	47.45	46.16	46.43	289100.0
2021-09-08	ABCL	Stock	19.035	19.24	18.11	18.24	1432400.0
2021-09-08	ABCM-DELISTED	Stock	20.97	21.1199	20.72	20.74	28237.0
2021-09-08	ABEO	Stock	32.75	32.75	29.75	31.25	33456.0
2021-09-08	ABEV	Stock	3.18	3.2	3.01	3.04	37294800.0
2021-09-08	ABG	Stock	172.9	175.3	171.0	174.67	192100.0
2021-09-08	ABGI-DELISTED	Stock	9.65	9.65	9.65	9.65	300.0
2021-09-08	ABM	Stock	47.16	47.51	46.8	47.25	509100.0
2021-09-08	ABMD-DELISTED	Stock	375.27	376.2	369.22	374.78	89571.0
2021-09-08	ABNB	Stock	163.23	166.55	161.6	163.93	5866500.0
2021-09-08	ABOS	Stock	18.52	18.95	17.95	18.32	327800.0
2021-09-08	ABR	Stock	18.13	18.2	17.96	18.08	848000.0

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

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