PREVIEW / stock_daily / 2021-04-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-29.parquet
  size:    256 KB
  rows:    7,823
  symbols: 2,962

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-04-29	AAPL	Stock	136.47	137.07	132.45	133.48	151101000.0
2021-04-29	MSFT	Stock	255.46	256.1	249.0	252.51	40589000.0
2021-04-29	NVDA	Stock	15.4	15.4365	15.0715	15.3248	173196000.0
2021-04-29	AMZN	Stock	175.255	175.7225	171.75	173.5655	153648000.0
2021-04-29	GOOGL	Stock	119.4615	120.208	118.6925	119.638	41233080.0
2021-04-29	META	Stock	330.12	331.81	321.61	329.51	56526800.0
2021-04-29	TSLA	Stock	233.17	234.0833	222.8333	225.6667	86536200.0
2021-04-29	TLT	Stock	137.45	138.36	137.125	138.32	17178229.0
2021-04-29	ES	Stock	85.18	85.65	83.45	85.09	2791600.0
2021-04-29	CL	Stock	79.07	80.23	79.02	79.82	4828400.0
2021-04-29	A	Stock	135.41	135.41	133.54	134.15	2135900.0
2021-04-29	AA	Stock	36.99	37.5	36.36	37.17	4895400.0
2021-04-29	AAC-DELISTED	Stock	9.81	9.86	9.8045	9.82	56420.0
2021-04-29	AACG	Stock	3.41	3.5	3.17	3.36	179500.0
2021-04-29	AACQ-DELISTED	Stock	10.06	10.08	9.995	10.03	816707.0
2021-04-29	AACQU-DELISTED	Stock	10.84	10.84	10.5717	10.695	10397.0
2021-04-29	AACQW-DELISTED	Stock	1.8505	1.8505	1.63	1.72	91590.0
2021-04-29	AAIC-DELISTED	Stock	4.14	4.17	4.06	4.08	152746.0
2021-04-29	AAIC.C-DELISTED	Stock	24.45	24.49	24.4001	24.4001	3765.0
2021-04-29	AAL	Stock	21.94	22.15	21.21	21.3	34430900.0
2021-04-29	AAM.A-DELISTED	Stock	26.105	26.15	26.05	26.07	13532.0
2021-04-29	AAM.B-DELISTED	Stock	27.03	27.06	26.995	27.03	8056.0
2021-04-29	AAMC-DELISTED	Stock	5.1618	5.2894	5.0	5.0735	54917.0
2021-04-29	AAME	Stock	4.3	4.35	4.09	4.18	90300.0
2021-04-29	AAMI	Stock	23.03	23.34	22.65	23.18	554000.0
2021-04-29	AAN-DELISTED	Stock	33.01	33.4	30.3	31.32	624800.0
2021-04-29	AAOI	Stock	8.26	8.26	7.81	7.91	480100.0
2021-04-29	AAON	Stock	45.4933	45.8133	44.7667	45.04	109500.0
2021-04-29	AAP	Stock	200.0	201.54	198.19	200.68	750300.0
2021-04-29	AAT	Stock	34.97	35.6	34.97	35.46	323700.0
2021-04-29	AAU-DELISTED	Stock	0.569	0.5832	0.5512	0.5797	1517383.0
2021-04-29	AAUAF-DELISTED	Stock	0.569	0.5832	0.5512	0.58	1574283.0
2021-04-29	AAWW-DELISTED	Stock	70.11	70.3421	68.5	69.13	321600.0
2021-04-29	AAXJ	Stock	95.81	95.81	94.43	95.21	750789.0
2021-04-29	AB	Stock	42.31	42.64	41.8	42.53	370500.0
2021-04-29	ABB-DELISTED	Stock	33.37	33.4	32.94	33.24	823817.0
2021-04-29	ABBNY-DELISTED	Stock	33.37	33.4	32.94	33.24	934499.0
2021-04-29	ABBV	Stock	112.38	112.61	110.33	110.89	6766700.0
2021-04-29	ABC-DELISTED	Stock	120.42	121.39	119.21	121.21	624468.0
2021-04-29	ABCB	Stock	53.45	54.45	53.0	54.35	517200.0
2021-04-29	ABCL	Stock	30.06	30.3	28.66	28.78	719100.0
2021-04-29	ABCM-DELISTED	Stock	21.38	21.44	21.02	21.1	38566.0
2021-04-29	ABEO	Stock	42.5	43.25	40.5	42.0	34708.0
2021-04-29	ABEV	Stock	2.87	2.92	2.87	2.89	11157100.0
2021-04-29	ABG	Stock	207.8	208.0	199.99	204.12	108100.0
2021-04-29	ABGI-DELISTED	Stock	9.99	10.0	9.96	9.96	1505.0
2021-04-29	ABM	Stock	52.75	53.3	52.5	52.92	326600.0
2021-04-29	ABMD-DELISTED	Stock	349.22	350.88	320.01	323.0	248619.0
2021-04-29	ABNB	Stock	182.75	183.22	173.35	177.68	3116000.0
2021-04-29	ABR	Stock	18.0	18.06	17.68	17.89	866200.0

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

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