PREVIEW / stock_daily / 2021-03-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-09.parquet
  size:    251 KB
  rows:    7,608
  symbols: 2,849

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-09	AAPL	Stock	119.03	122.06	118.79	121.09	129525800.0
2021-03-09	MSFT	Stock	232.88	235.38	231.67	233.78	33080500.0
2021-03-09	NVDA	Stock	12.1302	12.6168	12.0592	12.5203	521824000.0
2021-03-09	AMZN	Stock	150.8995	154.548	150.2575	153.1425	80600000.0
2021-03-09	GOOGL	Stock	102.4875	103.1958	101.78	102.018	33920620.0
2021-03-09	META	Stock	261.18	268.53	259.81	265.74	22039700.0
2021-03-09	TSLA	Stock	202.7267	226.03	198.4033	224.5267	202569900.0
2021-03-09	TLT	Stock	139.27	139.815	138.97	139.74	14463394.0
2021-03-09	ES	Stock	81.17	82.01	80.92	81.66	1108800.0
2021-03-09	CL	Stock	76.73	77.34	74.85	74.94	7085400.0
2021-03-09	A	Stock	117.87	121.39	117.54	119.84	2291100.0
2021-03-09	AA	Stock	28.99	30.05	28.2	29.94	7555200.0
2021-03-09	AACG	Stock	4.19	4.59	4.18	4.37	441100.0
2021-03-09	AACQ-DELISTED	Stock	10.85	10.92	10.535	10.65	1968372.0
2021-03-09	AACQU-DELISTED	Stock	11.56	11.601	11.27	11.33	11756.0
2021-03-09	AACQW-DELISTED	Stock	2.3	2.34	2.0	2.05	217427.0
2021-03-09	AAIC-DELISTED	Stock	4.42	4.42	4.285	4.31	123062.0
2021-03-09	AAIC.C-DELISTED	Stock	21.97	22.1899	21.97	22.01	3044.0
2021-03-09	AAL	Stock	21.59	21.81	20.66	21.6	39820400.0
2021-03-09	AAM.A-DELISTED	Stock	25.8658	25.889	25.839	25.87	19337.0
2021-03-09	AAM.B-DELISTED	Stock	26.53	26.53	26.44	26.505	22987.0
2021-03-09	AAMC-DELISTED	Stock	6.0588	6.4382	6.0571	6.1176	87244.0
2021-03-09	AAME	Stock	3.6	3.96	3.57	3.8	62500.0
2021-03-09	AAMI	Stock	19.44	19.65	19.06	19.44	372500.0
2021-03-09	AAN-DELISTED	Stock	24.7	25.15	24.27	24.46	352300.0
2021-03-09	AAOI	Stock	7.97	8.55	7.94	8.45	810600.0
2021-03-09	AAON	Stock	49.1533	49.98	49.12	49.1667	182100.0
2021-03-09	AAP	Stock	178.01	178.36	172.93	173.05	1141600.0
2021-03-09	AAT	Stock	36.4	36.6	35.56	35.6	1034900.0
2021-03-09	AAU-DELISTED	Stock	0.68	0.6831	0.6219	0.656	3240895.0
2021-03-09	AAUAF-DELISTED	Stock	0.68	0.6831	0.6219	0.6568	3309827.0
2021-03-09	AAWW-DELISTED	Stock	58.0	59.48	56.61	58.55	440065.0
2021-03-09	AAXJ	Stock	92.88	94.26	92.88	93.78	743684.0
2021-03-09	AB	Stock	37.99	38.35	37.6	37.81	429800.0
2021-03-09	ABB-DELISTED	Stock	30.19	30.5999	30.11	30.44	1247935.0
2021-03-09	ABBNY-DELISTED	Stock	30.19	30.5999	30.11	30.44	1339643.0
2021-03-09	ABBV	Stock	106.48	108.69	106.44	106.79	6857500.0
2021-03-09	ABC-DELISTED	Stock	107.79	111.14	107.72	110.14	1227633.0
2021-03-09	ABCB	Stock	51.13	52.26	49.66	51.62	376400.0
2021-03-09	ABCL	Stock	28.71	31.17	27.89	30.64	1005800.0
2021-03-09	ABCM-DELISTED	Stock	20.68	20.89	20.45	20.76	67752.0
2021-03-09	ABEO	Stock	53.25	56.0	52.0	54.5	105400.0
2021-03-09	ABEV	Stock	2.57	2.66	2.56	2.64	20018100.0
2021-03-09	ABG	Stock	180.17	182.1	173.52	176.72	315300.0
2021-03-09	ABGI-DELISTED	Stock	10.12	10.14	9.95	9.99	214537.0
2021-03-09	ABM	Stock	48.05	48.46	47.09	47.34	259100.0
2021-03-09	ABMD-DELISTED	Stock	291.48	307.0	290.83	296.53	204804.0
2021-03-09	ABNB	Stock	184.99	189.46	180.72	183.11	6079900.0
2021-03-09	ABR	Stock	16.08	16.24	15.75	16.16	1121800.0
2021-03-09	ABR.A-DELISTED	Stock	25.59	25.64	25.53	25.55	2865.0

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

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