PREVIEW / stock_daily / 2021-02-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-26.parquet
  size:    249 KB
  rows:    7,558
  symbols: 2,816

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-26	AAPL	Stock	122.59	124.85	121.2	121.26	164560400.0
2021-02-26	MSFT	Stock	231.53	235.37	229.54	232.38	37819200.0
2021-02-26	NVDA	Stock	13.7525	13.8545	13.361	13.7145	500932000.0
2021-02-26	AMZN	Stock	154.76	156.122	151.835	154.6465	85518000.0
2021-02-26	GOOGL	Stock	101.4975	102.826	100.0505	101.0955	40041280.0
2021-02-26	META	Stock	256.47	265.55	256.47	257.62	26619500.0
2021-02-26	TSLA	Stock	233.3333	235.5667	219.8367	225.1667	123267600.0
2021-02-26	TLT	Stock	140.77	143.3	139.68	143.12	45423326.0
2021-02-26	ES	Stock	80.97	82.44	79.43	79.48	2347500.0
2021-02-26	CL	Stock	76.66	76.66	75.15	75.2	5421200.0
2021-02-26	A	Stock	122.93	123.51	120.65	122.07	1909700.0
2021-02-26	AA	Stock	24.2	24.98	23.64	24.55	6412700.0
2021-02-26	AACG	Stock	5.05	5.64	4.65	5.05	1337000.0
2021-02-26	AACQ-DELISTED	Stock	11.25	11.29	10.52	10.85	4534107.0
2021-02-26	AACQU-DELISTED	Stock	12.22	12.37	11.39	11.76	97596.0
2021-02-26	AACQW-DELISTED	Stock	2.91	3.0	2.52	2.78	700356.0
2021-02-26	AAIC-DELISTED	Stock	3.95	4.09	3.91	4.01	188628.0
2021-02-26	AAIC.C-DELISTED	Stock	22.0	22.01	21.95	22.0	2614.0
2021-02-26	AAL	Stock	20.61	21.43	20.34	20.94	42397300.0
2021-02-26	AAM.A-DELISTED	Stock	25.67	25.75	25.62	25.69	66046.0
2021-02-26	AAM.B-DELISTED	Stock	26.16	26.16	25.84	26.07	109643.0
2021-02-26	AAMC-DELISTED	Stock	7.0567	7.2794	6.6853	6.7059	75548.0
2021-02-26	AAME	Stock	4.64	4.75	4.43	4.47	80100.0
2021-02-26	AAMI	Stock	18.49	18.55	17.86	18.1	668900.0
2021-02-26	AAN-DELISTED	Stock	22.27	22.41	21.795	21.96	405700.0
2021-02-26	AAOI	Stock	10.53	10.72	9.201	9.325	1833000.0
2021-02-26	AAON	Stock	51.6067	52.1267	50.9	51.4	286950.0
2021-02-26	AAP	Stock	162.36	163.31	160.03	160.35	951600.0
2021-02-26	AAT	Stock	32.79	32.98	31.08	31.08	355400.0
2021-02-26	AAU-DELISTED	Stock	0.7698	0.7799	0.721	0.734	2232427.0
2021-02-26	AAUAF-DELISTED	Stock	0.7698	0.7799	0.721	0.7332	2286786.0
2021-02-26	AAWW-DELISTED	Stock	56.13	56.83	55.05	55.05	412282.0
2021-02-26	AAXJ	Stock	95.1	95.27	93.88	94.65	1621546.0
2021-02-26	AB	Stock	36.67	36.89	35.82	36.56	364800.0
2021-02-26	ABB-DELISTED	Stock	29.1	29.11	28.72	28.78	1711697.0
2021-02-26	ABBNY-DELISTED	Stock	29.1	29.11	28.72	28.78	1850470.0
2021-02-26	ABBV	Stock	107.68	108.58	105.36	107.74	9250000.0
2021-02-26	ABC-DELISTED	Stock	102.96	103.4	100.71	101.19	1062670.0
2021-02-26	ABCB	Stock	47.71	48.54	47.15	47.64	333600.0
2021-02-26	ABCL	Stock	38.95	39.274	36.24	37.71	797500.0
2021-02-26	ABCM-DELISTED	Stock	23.32	23.99	23.12	23.84	57545.0
2021-02-26	ABEO	Stock	66.75	71.75	59.0	60.5	563076.0
2021-02-26	ABEV	Stock	2.63	2.64	2.54	2.55	38830800.0
2021-02-26	ABG	Stock	168.13	172.88	164.48	169.45	133200.0
2021-02-26	ABGI-DELISTED	Stock	10.3	10.39	10.2	10.26	408121.0
2021-02-26	ABM	Stock	43.5	44.21	42.95	43.18	262000.0
2021-02-26	ABMD-DELISTED	Stock	322.01	327.82	314.43	324.24	310899.0
2021-02-26	ABNB	Stock	194.18	214.1	185.75	206.35	19368600.0
2021-02-26	ABR	Stock	16.78	16.86	16.4	16.67	2779500.0
2021-02-26	ABR.A-DELISTED	Stock	25.61	25.7	25.61	25.7	300.0

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

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