PREVIEW / stock_daily / 2021-02-24

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-24.parquet
  size:    249 KB
  rows:    7,550
  symbols: 2,805

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-02-24	AAPL	Stock	124.94	125.56	122.23	125.35	111039900.0
2021-02-24	MSFT	Stock	230.01	235.2	229.0	234.55	26339700.0
2021-02-24	NVDA	Stock	14.1228	14.5068	13.756	14.499	448320000.0
2021-02-24	AMZN	Stock	158.3375	158.5615	156.269	157.9765	60226000.0
2021-02-24	GOOGL	Stock	101.502	104.416	101.3765	104.1905	22608740.0
2021-02-24	META	Stock	262.33	266.38	258.39	264.31	15736100.0
2021-02-24	TSLA	Stock	237.2833	248.3333	231.39	247.34	110301000.0
2021-02-24	TLT	Stock	139.352	141.175	139.16	140.84	17363058.0
2021-02-24	ES	Stock	80.13	80.75	79.08	80.11	1655500.0
2021-02-24	CL	Stock	77.09	77.64	76.63	76.64	4083400.0
2021-02-24	A	Stock	122.26	125.41	122.01	125.02	1898400.0
2021-02-24	AA	Stock	25.1	27.29	25.1	27.2	8974300.0
2021-02-24	AACG	Stock	4.58	5.14	4.58	5.06	264500.0
2021-02-24	AACQ-DELISTED	Stock	12.55	12.78	11.61	11.8	3401297.0
2021-02-24	AACQU-DELISTED	Stock	13.33	13.66	12.69	12.7	52707.0
2021-02-24	AACQW-DELISTED	Stock	3.4	3.58	3.0	3.01	870425.0
2021-02-24	AAIC-DELISTED	Stock	3.86	4.14	3.86	4.12	315369.0
2021-02-24	AAIC.C-DELISTED	Stock	22.6	22.7699	22.4501	22.4501	4930.0
2021-02-24	AAL	Stock	20.87	22.12	20.75	21.82	74610200.0
2021-02-24	AAM.A-DELISTED	Stock	26.03	26.1094	25.95	26.07	19441.0
2021-02-24	AAM.B-DELISTED	Stock	26.64	26.64	26.42	26.53	14357.0
2021-02-24	AAMC-DELISTED	Stock	6.8824	7.3441	6.6073	6.9611	91460.0
2021-02-24	AAME	Stock	4.48	4.64	4.48	4.53	64900.0
2021-02-24	AAMI	Stock	18.85	19.52	18.68	19.3	475400.0
2021-02-24	AAN-DELISTED	Stock	21.05	22.13	20.44	22.13	301300.0
2021-02-24	AAOI	Stock	11.36	11.73	11.05	11.61	485300.0
2021-02-24	AAON	Stock	51.12	52.0467	50.18	51.92	198300.0
2021-02-24	AAP	Stock	166.94	167.1	163.46	166.15	948800.0
2021-02-24	AAT	Stock	31.74	32.89	31.66	32.68	430900.0
2021-02-24	AAU-DELISTED	Stock	0.75	0.845	0.739	0.8078	2450646.0
2021-02-24	AAUAF-DELISTED	Stock	0.75	0.845	0.739	0.8116	2555759.0
2021-02-24	AAWW-DELISTED	Stock	57.81	59.74	57.41	59.01	368106.0
2021-02-24	AAXJ	Stock	97.34	97.72	96.25	97.66	3582954.0
2021-02-24	AB	Stock	36.0	37.17	36.0	36.57	409400.0
2021-02-24	ABB-DELISTED	Stock	29.37	29.75	29.22	29.72	1528654.0
2021-02-24	ABBNY-DELISTED	Stock	29.37	29.75	29.22	29.72	1727856.0
2021-02-24	ABBV	Stock	106.0	109.44	105.6	108.69	7626200.0
2021-02-24	ABC-DELISTED	Stock	106.13	107.35	104.7	105.25	730654.0
2021-02-24	ABCB	Stock	49.54	50.61	49.5	50.24	402800.0
2021-02-24	ABCL	Stock	40.91	41.36	39.56	40.1	661200.0
2021-02-24	ABCM-DELISTED	Stock	23.12	23.16	22.24	22.43	39149.0
2021-02-24	ABEO	Stock	53.75	58.0	53.75	55.0	111208.0
2021-02-24	ABEV	Stock	2.72	2.76	2.69	2.73	15062600.0
2021-02-24	ABG	Stock	166.99	171.01	164.82	170.42	153500.0
2021-02-24	ABGI-DELISTED	Stock	10.3	10.4	10.25	10.36	173490.0
2021-02-24	ABM	Stock	44.02	45.0	43.98	44.85	197700.0
2021-02-24	ABMD-DELISTED	Stock	320.4	327.73	316.75	323.72	146899.0
2021-02-24	ABNB	Stock	190.98	208.145	189.0	200.2	5983500.0
2021-02-24	ABR	Stock	16.62	16.97	16.25	16.97	2539500.0
2021-02-24	ABR.A-DELISTED	Stock	25.72	25.72	25.64	25.72	2200.0

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

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