PREVIEW / stock_daily / 2021-03-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-15.parquet
  size:    252 KB
  rows:    7,635
  symbols: 2,871

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-03-15	AAPL	Stock	121.41	124.0	120.42	123.99	92403800.0
2021-03-15	MSFT	Stock	234.96	235.19	231.81	234.81	26034900.0
2021-03-15	NVDA	Stock	12.8648	13.2068	12.7672	13.1912	221988000.0
2021-03-15	AMZN	Stock	153.7285	154.112	151.6045	154.084	58272000.0
2021-03-15	GOOGL	Stock	102.2488	102.7495	101.3895	102.722	26214820.0
2021-03-15	META	Stock	269.08	275.96	268.5	273.75	16844800.0
2021-03-15	TSLA	Stock	231.3633	237.7267	228.0133	235.98	88006800.0
2021-03-15	TLT	Stock	136.49	137.09	136.41	136.86	11366662.0
2021-03-15	ES	Stock	82.19	83.25	81.96	82.75	1395300.0
2021-03-15	CL	Stock	76.04	76.12	74.91	75.68	4860300.0
2021-03-15	A	Stock	120.92	124.28	120.34	124.04	1230000.0
2021-03-15	AA	Stock	31.45	31.68	30.34	31.04	4532200.0
2021-03-15	AACG	Stock	4.79	4.79	4.43	4.66	191900.0
2021-03-15	AACQ-DELISTED	Stock	10.74	10.75	10.57	10.6	1768299.0
2021-03-15	AACQU-DELISTED	Stock	11.5	11.5799	11.5	11.512	1187.0
2021-03-15	AACQW-DELISTED	Stock	2.36	2.59	2.36	2.42	285202.0
2021-03-15	AAIC-DELISTED	Stock	4.28	4.3	4.18	4.25	183735.0
2021-03-15	AAIC.C-DELISTED	Stock	22.22	22.4972	21.9001	22.06	7093.0
2021-03-15	AAL	Stock	24.55	25.94	24.21	25.17	93746800.0
2021-03-15	AAM.A-DELISTED	Stock	25.89	25.94	25.87	25.94	19565.0
2021-03-15	AAM.B-DELISTED	Stock	26.6	26.6129	26.5	26.61	18984.0
2021-03-15	AAMC-DELISTED	Stock	5.55	5.7805	5.3118	5.7588	32572.0
2021-03-15	AAME	Stock	4.37	4.43	4.08	4.25	102900.0
2021-03-15	AAMI	Stock	20.02	20.14	19.545	20.09	367800.0
2021-03-15	AAN-DELISTED	Stock	25.48	26.665	25.1	26.5	624100.0
2021-03-15	AAOI	Stock	8.95	9.11	8.86	9.04	595500.0
2021-03-15	AAON	Stock	49.3333	50.0	48.8333	50.0	246900.0
2021-03-15	AAP	Stock	179.06	181.83	178.19	181.69	961600.0
2021-03-15	AAT	Stock	35.29	35.94	34.69	35.62	198700.0
2021-03-15	AAU-DELISTED	Stock	0.7429	0.7489	0.7	0.7265	1720892.0
2021-03-15	AAUAF-DELISTED	Stock	0.7429	0.7489	0.7	0.7284	1770209.0
2021-03-15	AAWW-DELISTED	Stock	59.77	60.3799	58.62	59.58	242677.0
2021-03-15	AAXJ	Stock	93.72	94.4	93.44	94.4	670557.0
2021-03-15	AB	Stock	39.54	39.6	38.79	39.47	909100.0
2021-03-15	ABB-DELISTED	Stock	30.73	31.165	30.53	31.1	2363447.0
2021-03-15	ABBNY-DELISTED	Stock	30.73	31.165	30.53	31.1	2517532.0
2021-03-15	ABBV	Stock	108.67	110.36	108.36	110.26	6642200.0
2021-03-15	ABC-DELISTED	Stock	113.14	114.08	112.09	113.85	497089.0
2021-03-15	ABCB	Stock	55.85	56.45	54.42	55.7	501400.0
2021-03-15	ABCL	Stock	37.41	38.25	36.45	37.55	891700.0
2021-03-15	ABCM-DELISTED	Stock	21.57	21.69	21.17	21.49	80233.0
2021-03-15	ABEO	Stock	59.5	60.25	56.25	57.75	70628.0
2021-03-15	ABEV	Stock	2.71	2.76	2.7	2.74	11592000.0
2021-03-15	ABG	Stock	190.38	191.22	186.53	190.5	108600.0
2021-03-15	ABGI-DELISTED	Stock	10.02	10.02	9.91	9.91	131791.0
2021-03-15	ABM	Stock	52.32	52.52	51.26	52.0	449800.0
2021-03-15	ABMD-DELISTED	Stock	300.85	308.56	299.6	306.52	136748.0
2021-03-15	ABNB	Stock	209.538	213.74	203.81	209.99	4329400.0
2021-03-15	ABR	Stock	16.75	16.91	16.7	16.91	1103500.0
2021-03-15	ABR.A-DELISTED	Stock	25.59	25.655	25.54	25.57	1160.0

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

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