PREVIEW / stock_daily / 2021-03-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-29.parquet
  size:    252 KB
  rows:    7,704
  symbols: 2,903

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-29	AAPL	Stock	121.65	122.58	120.73	121.39	80819200.0
2021-03-29	MSFT	Stock	236.59	236.8	231.88	235.24	25227500.0
2021-03-29	NVDA	Stock	12.8202	13.0625	12.7	12.9482	273520000.0
2021-03-29	AMZN	Stock	152.772	154.5625	151.4225	153.7865	54920000.0
2021-03-29	GOOGL	Stock	101.108	102.4605	100.2725	102.2895	26492620.0
2021-03-29	META	Stock	285.77	293.18	284.7	290.82	21718800.0
2021-03-29	TSLA	Stock	205.2133	205.4933	198.6733	203.7633	85911000.0
2021-03-29	TLT	Stock	136.83	136.8465	134.97	135.5	13968084.0
2021-03-29	ES	Stock	86.02	87.29	85.59	86.95	932800.0
2021-03-29	CL	Stock	79.11	79.97	79.11	79.9	3811800.0
2021-03-29	A	Stock	124.88	125.82	123.74	125.42	1539700.0
2021-03-29	AA	Stock	32.45	33.99	31.855	32.04	8276200.0
2021-03-29	AAC-DELISTED	Stock	9.7	9.9022	9.5	9.78	52926.0
2021-03-29	AACG	Stock	4.39	4.68	4.2	4.36	714400.0
2021-03-29	AACQ-DELISTED	Stock	10.2	10.215	10.01	10.04	1308544.0
2021-03-29	AACQU-DELISTED	Stock	10.96	10.96	10.56	10.56	3201.0
2021-03-29	AACQW-DELISTED	Stock	1.95	1.95	1.65	1.7	445641.0
2021-03-29	AAIC-DELISTED	Stock	4.04	4.04	3.9	3.9	180712.0
2021-03-29	AAIC.C-DELISTED	Stock	23.51	23.5135	23.43	23.5135	8500.0
2021-03-29	AAL	Stock	23.16	23.19	22.4	22.91	30700100.0
2021-03-29	AAM.A-DELISTED	Stock	26.04	26.04	25.88	25.89	26063.0
2021-03-29	AAM.B-DELISTED	Stock	26.91	26.91	26.63	26.67	24892.0
2021-03-29	AAMC-DELISTED	Stock	4.9412	5.4912	4.9265	5.2794	172295.0
2021-03-29	AAME	Stock	3.73	4.18	3.51	3.9	255100.0
2021-03-29	AAMI	Stock	19.25	19.9	18.94	18.96	318000.0
2021-03-29	AAN-DELISTED	Stock	25.85	26.6	24.92	24.93	161900.0
2021-03-29	AAOI	Stock	8.29	8.41	7.96	8.01	686400.0
2021-03-29	AAON	Stock	48.0333	49.2533	46.5867	46.94	303150.0
2021-03-29	AAP	Stock	187.48	187.91	183.98	185.06	862500.0
2021-03-29	AAT	Stock	33.23	33.59	32.42	32.47	337900.0
2021-03-29	AAU-DELISTED	Stock	0.5696	0.5696	0.53	0.5307	1477616.0
2021-03-29	AAUAF-DELISTED	Stock	0.5696	0.5696	0.53	0.5307	1525572.0
2021-03-29	AAWW-DELISTED	Stock	58.855	59.85	57.55	58.63	390773.0
2021-03-29	AAXJ	Stock	92.02	92.4	91.69	92.1	566232.0
2021-03-29	AB	Stock	39.19	39.55	38.67	38.93	367500.0
2021-03-29	ABB-DELISTED	Stock	30.29	30.49	30.19	30.32	1388422.0
2021-03-29	ABBNY-DELISTED	Stock	30.29	30.49	30.19	30.32	1805660.0
2021-03-29	ABBV	Stock	105.76	107.0	105.49	106.73	5472700.0
2021-03-29	ABC-DELISTED	Stock	118.15	119.81	117.78	119.04	446067.0
2021-03-29	ABCB	Stock	53.97	54.77	52.6	52.7	605200.0
2021-03-29	ABCL	Stock	25.266	26.0	23.2	23.29	1366500.0
2021-03-29	ABCM-DELISTED	Stock	19.52	19.89	19.21	19.62	188027.0
2021-03-29	ABEO	Stock	45.0	48.5	44.5	44.75	76452.0
2021-03-29	ABEV	Stock	2.65	2.7	2.62	2.7	15967800.0
2021-03-29	ABG	Stock	199.42	204.12	191.05	194.09	190900.0
2021-03-29	ABGI-DELISTED	Stock	9.75	9.8	9.63	9.79	11426.0
2021-03-29	ABM	Stock	52.17	53.28	50.02	50.09	534200.0
2021-03-29	ABMD-DELISTED	Stock	301.94	307.96	301.4	305.76	143152.0
2021-03-29	ABNB	Stock	175.36	185.46	173.5	182.5	4508800.0
2021-03-29	ABR	Stock	15.54	15.81	15.41	15.53	3362800.0

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

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