PREVIEW / stock_daily / 2021-02-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-22.parquet
  size:    249 KB
  rows:    7,553
  symbols: 2,806

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-22	AAPL	Stock	128.01	129.72	125.6	126.0	103916400.0
2021-02-22	MSFT	Stock	237.42	237.93	232.4	234.51	36446900.0
2021-02-22	NVDA	Stock	14.7748	15.1333	14.325	14.3558	325884000.0
2021-02-22	AMZN	Stock	160.4065	161.616	158.613	159.037	70314000.0
2021-02-22	GOOGL	Stock	102.68	104.0165	102.4	102.713	29466340.0
2021-02-22	META	Stock	257.95	263.07	257.53	260.33	17434900.0
2021-02-22	TSLA	Stock	254.2133	256.1667	236.7333	238.1667	111809100.0
2021-02-22	TLT	Stock	143.03	143.74	141.72	142.18	13203873.0
2021-02-22	ES	Stock	81.69	81.69	77.74	78.65	2367500.0
2021-02-22	CL	Stock	77.22	77.44	76.88	77.27	2573400.0
2021-02-22	A	Stock	125.95	126.16	123.09	123.5	1340100.0
2021-02-22	AA	Stock	23.46	25.475	23.05	24.8	9399500.0
2021-02-22	AACG	Stock	5.62	5.66	5.2	5.39	1048300.0
2021-02-22	AACQ-DELISTED	Stock	13.15	14.01	13.02	13.37	5367994.0
2021-02-22	AACQU-DELISTED	Stock	14.61	15.39	14.35	14.7	131571.0
2021-02-22	AACQW-DELISTED	Stock	3.85	4.17	3.69	3.86	2612727.0
2021-02-22	AAIC-DELISTED	Stock	3.92	4.07	3.92	4.0	145286.0
2021-02-22	AAIC.C-DELISTED	Stock	22.7599	22.76	22.4001	22.7	6720.0
2021-02-22	AAL	Stock	19.84	21.11	19.31	20.44	99937700.0
2021-02-22	AAM.A-DELISTED	Stock	26.02	26.15	25.99	26.07	78603.0
2021-02-22	AAM.B-DELISTED	Stock	26.74	26.74	26.57	26.6	24006.0
2021-02-22	AAMC-DELISTED	Stock	6.7677	7.2764	6.7677	6.8147	76231.0
2021-02-22	AAME	Stock	4.64	5.23	4.56	4.96	161900.0
2021-02-22	AAMI	Stock	19.0	19.21	18.81	19.04	338300.0
2021-02-22	AAN-DELISTED	Stock	21.09	22.43	21.02	22.42	482000.0
2021-02-22	AAOI	Stock	12.19	12.373	11.74	11.74	554800.0
2021-02-22	AAON	Stock	50.9267	51.12	50.0067	50.6667	221700.0
2021-02-22	AAP	Stock	165.13	169.31	164.5	167.7	957900.0
2021-02-22	AAT	Stock	29.3	30.46	29.24	30.45	283700.0
2021-02-22	AAU-DELISTED	Stock	0.84	0.8446	0.8	0.8096	3174762.0
2021-02-22	AAUAF-DELISTED	Stock	0.84	0.8446	0.8	0.8065	3321243.0
2021-02-22	AAWW-DELISTED	Stock	61.99	63.19	59.5	60.0	678423.0
2021-02-22	AAXJ	Stock	98.82	99.28	98.26	98.3	1634798.0
2021-02-22	AB	Stock	37.0	37.26	35.82	36.82	352000.0
2021-02-22	ABB-DELISTED	Stock	29.92	30.11	29.77	29.78	1247619.0
2021-02-22	ABBNY-DELISTED	Stock	29.92	30.11	29.77	29.78	2461991.0
2021-02-22	ABBV	Stock	104.66	107.68	104.23	107.06	10272500.0
2021-02-22	ABC-DELISTED	Stock	105.28	106.62	104.05	106.16	562199.0
2021-02-22	ABCB	Stock	47.12	48.82	47.03	48.35	304100.0
2021-02-22	ABCL	Stock	44.25	44.95	39.8	40.37	597600.0
2021-02-22	ABCM-DELISTED	Stock	23.8	23.96	23.32	23.46	25650.0
2021-02-22	ABEO	Stock	59.0	60.75	55.75	55.75	130096.0
2021-02-22	ABEV	Stock	2.68	2.76	2.65	2.7	39281400.0
2021-02-22	ABG	Stock	161.17	166.37	160.16	163.88	94000.0
2021-02-22	ABGI-DELISTED	Stock	10.54	10.69	10.43	10.45	246844.0
2021-02-22	ABM	Stock	42.48	43.63	42.19	43.37	262500.0
2021-02-22	ABMD-DELISTED	Stock	330.39	332.84	321.92	322.39	231204.0
2021-02-22	ABNB	Stock	200.7	205.0	193.5	195.34	3674200.0
2021-02-22	ABR	Stock	16.3	16.64	16.21	16.36	2148100.0
2021-02-22	ABR.A-DELISTED	Stock	25.6901	25.6901	25.6901	25.6901	500.0

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

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