PREVIEW / stock_daily / 2021-01-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-15.parquet
  size:    243 KB
  rows:    7,337
  symbols: 2,669

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-01-15	AAPL	Stock	128.78	130.22	127.0	127.14	111598500.0
2021-01-15	MSFT	Stock	213.52	214.51	212.03	212.65	31746500.0
2021-01-15	NVDA	Stock	13.228	13.3252	12.8485	12.8595	277780000.0
2021-01-15	AMZN	Stock	156.151	157.1275	154.7585	155.2125	84880000.0
2021-01-15	GOOGL	Stock	86.451	87.381	85.5855	86.381	31444280.0
2021-01-15	META	Stock	247.9	253.86	247.16	251.36	24942900.0
2021-01-15	TSLA	Stock	284.0	286.6333	273.0333	275.3867	116332800.0
2021-01-15	TLT	Stock	152.185	152.36	151.47	151.82	11624672.0
2021-01-15	ES	Stock	89.16	90.14	87.89	88.57	2065100.0
2021-01-15	CL	Stock	81.94	82.44	81.69	81.88	6359600.0
2021-01-15	A	Stock	125.94	127.12	124.74	126.21	2115400.0
2021-01-15	AA	Stock	24.515	24.515	22.96	23.28	5866800.0
2021-01-15	AACG	Stock	1.25	1.46	1.24	1.26	109100.0
2021-01-15	AACQ-DELISTED	Stock	11.03	11.115	10.78	10.89	1543053.0
2021-01-15	AACQU-DELISTED	Stock	12.01	12.01	11.45	11.68	119081.0
2021-01-15	AACQW-DELISTED	Stock	2.45	2.49	2.25	2.36	384107.0
2021-01-15	AAIC-DELISTED	Stock	3.93	3.94	3.9	3.92	73142.0
2021-01-15	AAIC.C-DELISTED	Stock	21.25	21.2989	21.0101	21.05	2894.0
2021-01-15	AAL	Stock	16.17	16.28	15.74	15.76	55175800.0
2021-01-15	AAM.A-DELISTED	Stock	26.46	26.46	26.4	26.4	10800.0
2021-01-15	AAM.B-DELISTED	Stock	26.89	26.9581	26.71	26.71	8599.0
2021-01-15	AAMC-DELISTED	Stock	6.2412	6.2647	6.2353	6.2647	4757.0
2021-01-15	AAME	Stock	2.35	2.4	2.27	2.33	28800.0
2021-01-15	AAMI	Stock	20.76	21.315	20.29	21.12	285400.0
2021-01-15	AAN-DELISTED	Stock	22.13	22.71	20.89	21.47	669000.0
2021-01-15	AAOI	Stock	10.5	10.94	10.37	10.79	945700.0
2021-01-15	AAON	Stock	46.8533	47.62	45.86	46.96	234150.0
2021-01-15	AAP	Stock	167.4	168.0	164.94	165.25	907100.0
2021-01-15	AAT	Stock	28.73	29.12	28.43	28.94	147200.0
2021-01-15	AAU-DELISTED	Stock	0.63	0.6369	0.5559	0.5639	3390639.0
2021-01-15	AAUAF-DELISTED	Stock	0.63	0.6369	0.5559	0.5639	3456849.0
2021-01-15	AAWW-DELISTED	Stock	53.97	55.1992	53.14	53.22	302350.0
2021-01-15	AAXJ	Stock	94.965	95.2	94.46	94.73	1309253.0
2021-01-15	AAXN-DELISTED	Stock	161.9	166.49	150.0	150.7	1333182.0
2021-01-15	AB	Stock	35.13	35.37	34.32	35.14	298700.0
2021-01-15	ABB-DELISTED	Stock	29.84	29.94	29.31	29.35	2253320.0
2021-01-15	ABBNY-DELISTED	Stock	29.84	29.94	29.31	29.35	2403352.0
2021-01-15	ABBV	Stock	111.2	111.56	109.48	110.52	9196200.0
2021-01-15	ABC-DELISTED	Stock	105.6	107.89	104.53	106.81	2830012.0
2021-01-15	ABCB	Stock	43.99	44.82	43.26	44.1	407800.0
2021-01-15	ABCL	Stock	45.51	46.55	44.07	44.41	1000900.0
2021-01-15	ABCM-DELISTED	Stock	23.18	23.64	22.96	23.185	85900.0
2021-01-15	ABEO	Stock	49.75	51.75	47.0	47.75	86632.0
2021-01-15	ABEV	Stock	3.1	3.13	3.03	3.05	22100400.0
2021-01-15	ABG	Stock	162.59	164.58	159.26	162.46	370600.0
2021-01-15	ABM	Stock	41.59	41.75	40.68	41.19	361300.0
2021-01-15	ABMD-DELISTED	Stock	316.265	333.66	316.265	329.51	258258.0
2021-01-15	ABNB	Stock	184.58	185.995	164.86	169.27	8575700.0
2021-01-15	ABR	Stock	14.36	14.47	14.28	14.38	719100.0
2021-01-15	ABR.A-DELISTED	Stock	25.55	25.65	25.55	25.555	2200.0

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

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