PREVIEW / stock_daily / 2021-03-30

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-30.parquet
  size:    252 KB
  rows:    7,703
  symbols: 2,902

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-30	AAPL	Stock	120.11	120.4	118.86	119.9	85671900.0
2021-03-30	MSFT	Stock	233.53	233.85	231.1	231.85	24792000.0
2021-03-30	NVDA	Stock	12.842	12.9753	12.705	12.8718	200204000.0
2021-03-30	AMZN	Stock	153.5005	153.65	151.7	152.7645	46752000.0
2021-03-30	GOOGL	Stock	102.649	103.1335	101.8075	102.3235	27317120.0
2021-03-30	META	Stock	289.83	292.47	286.7	288.0	17474500.0
2021-03-30	TSLA	Stock	200.5833	212.5533	197.0033	211.8733	118297200.0
2021-03-30	TLT	Stock	135.3	136.515	135.005	136.21	15020777.0
2021-03-30	ES	Stock	86.29	87.02	85.38	86.29	1226300.0
2021-03-30	CL	Stock	79.47	79.74	79.01	79.33	4841700.0
2021-03-30	A	Stock	124.61	125.7	124.41	124.84	1033700.0
2021-03-30	AA	Stock	32.15	33.05	31.34	32.97	6286700.0
2021-03-30	AAC-DELISTED	Stock	9.8	9.85	9.8	9.83	51883.0
2021-03-30	AACG	Stock	4.42	4.45	4.2	4.27	265400.0
2021-03-30	AACQ-DELISTED	Stock	10.0	10.1	9.96	10.04	3171417.0
2021-03-30	AACQU-DELISTED	Stock	10.51	10.68	10.51	10.6	434106.0
2021-03-30	AACQW-DELISTED	Stock	1.7	1.75	1.63	1.67	323344.0
2021-03-30	AAIC-DELISTED	Stock	3.91	4.03	3.87	3.975	172593.0
2021-03-30	AAIC.C-DELISTED	Stock	23.49	23.51	23.49	23.5012	4018.0
2021-03-30	AAL	Stock	23.1	24.2	23.02	24.12	39747900.0
2021-03-30	AAM.A-DELISTED	Stock	25.87	25.94	25.87	25.91	32586.0
2021-03-30	AAM.B-DELISTED	Stock	26.79	26.83	26.72	26.8	15474.0
2021-03-30	AAMC-DELISTED	Stock	4.9147	5.3088	4.9147	5.2588	135558.0
2021-03-30	AAME	Stock	3.81	3.88	3.58	3.59	152200.0
2021-03-30	AAMI	Stock	18.94	19.35	18.93	19.16	328800.0
2021-03-30	AAN-DELISTED	Stock	24.81	25.455	24.68	25.18	241100.0
2021-03-30	AAOI	Stock	7.94	8.02	7.79	7.97	472600.0
2021-03-30	AAON	Stock	46.8533	47.58	46.7467	47.18	180450.0
2021-03-30	AAP	Stock	185.36	186.92	182.47	186.07	631000.0
2021-03-30	AAT	Stock	32.41	33.21	32.16	32.97	264400.0
2021-03-30	AAU-DELISTED	Stock	0.522	0.5275	0.505	0.5077	1748491.0
2021-03-30	AAUAF-DELISTED	Stock	0.52	0.5275	0.505	0.5077	1810016.0
2021-03-30	AAWW-DELISTED	Stock	58.25	59.94	58.0	59.84	313118.0
2021-03-30	AAXJ	Stock	92.2	92.78	91.87	92.4	1374632.0
2021-03-30	AB	Stock	38.94	39.75	38.94	39.74	256100.0
2021-03-30	ABB-DELISTED	Stock	30.09	30.31	30.07	30.21	1060414.0
2021-03-30	ABBNY-DELISTED	Stock	30.09	30.31	30.07	30.22	1153685.0
2021-03-30	ABBV	Stock	106.86	107.03	105.87	106.79	5354100.0
2021-03-30	ABC-DELISTED	Stock	119.06	120.54	118.65	119.1	623681.0
2021-03-30	ABCB	Stock	52.13	55.35	52.13	53.24	410800.0
2021-03-30	ABCL	Stock	27.52	27.947	24.57	26.68	3580200.0
2021-03-30	ABCM-DELISTED	Stock	19.5	19.5	19.1	19.25	72136.0
2021-03-30	ABEO	Stock	45.0	47.0	43.0	46.0	42596.0
2021-03-30	ABEV	Stock	2.7	2.76	2.67	2.74	11320000.0
2021-03-30	ABG	Stock	194.96	203.93	194.96	201.07	223400.0
2021-03-30	ABGI-DELISTED	Stock	9.77	9.77	9.75	9.76	1700.0
2021-03-30	ABM	Stock	50.28	51.26	49.82	51.17	466700.0
2021-03-30	ABMD-DELISTED	Stock	301.74	310.32	298.96	309.87	143171.0
2021-03-30	ABNB	Stock	182.35	185.23	178.38	183.1	2903300.0
2021-03-30	ABR	Stock	15.74	15.95	15.52	15.9	2111600.0

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

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