PREVIEW / stock_daily / 2020-12-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-21.parquet
  size:    240 KB
  rows:    7,276
  symbols: 2,649

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
2020-12-21	AAPL	Stock	125.02	128.31	123.45	128.23	121251600.0
2020-12-21	MSFT	Stock	217.55	224.0	217.28	222.59	37181900.0
2020-12-21	NVDA	Stock	13.0748	13.37	12.9675	13.3322	302332000.0
2020-12-21	AMZN	Stock	160.0005	161.3485	158.3	160.309	76736000.0
2020-12-21	GOOGL	Stock	85.4565	86.85	84.7	86.728	33974140.0
2020-12-21	META	Stock	272.98	274.67	267.79	272.79	16553700.0
2020-12-21	TSLA	Stock	222.08	222.8333	215.3567	216.62	174135900.0
2020-12-21	TLT	Stock	157.2	157.34	156.45	156.95	8988176.0
2020-12-21	ES	Stock	83.37	83.88	82.17	83.71	1898100.0
2020-12-21	CL	Stock	85.05	85.49	84.37	85.31	2757900.0
2020-12-21	A	Stock	117.7	118.45	115.96	117.78	2082000.0
2020-12-21	AA	Stock	21.25	22.24	21.13	22.11	3869400.0
2020-12-21	AACG	Stock	1.18	1.2	1.18	1.2	12100.0
2020-12-21	AACQ-DELISTED	Stock	10.35	10.45	10.27	10.4	906884.0
2020-12-21	AACQU-DELISTED	Stock	10.96	11.04	10.9	11.0	173199.0
2020-12-21	AACQW-DELISTED	Stock	1.7	1.9499	1.7	1.85	317273.0
2020-12-21	AAIC-DELISTED	Stock	3.77	3.81	3.62	3.8	389542.0
2020-12-21	AAIC.C-DELISTED	Stock	20.8849	20.95	20.875	20.9	1900.0
2020-12-21	AAL	Stock	15.77	16.24	15.56	16.1	87243800.0
2020-12-21	AAM.A-DELISTED	Stock	26.43	26.59	26.4183	26.58	8875.0
2020-12-21	AAM.B-DELISTED	Stock	27.31	27.31	27.23	27.26	10982.0
2020-12-21	AAMC-DELISTED	Stock	6.7647	6.8118	6.7647	6.8118	5178.0
2020-12-21	AAME	Stock	2.17	2.17	2.1	2.11	3300.0
2020-12-21	AAMI	Stock	18.49	18.84	18.45	18.75	628600.0
2020-12-21	AAN-DELISTED	Stock	17.83	18.19	17.38	18.01	674300.0
2020-12-21	AAOI	Stock	8.34	8.45	8.18	8.38	627000.0
2020-12-21	AAON	Stock	42.02	42.8733	41.6867	42.8267	229950.0
2020-12-21	AAP	Stock	158.44	160.58	156.69	160.49	1075200.0
2020-12-21	AAT	Stock	27.64	28.16	27.15	27.86	304200.0
2020-12-21	AAU-DELISTED	Stock	0.75	0.75	0.4801	0.5089	13329722.0
2020-12-21	AAUAF-DELISTED	Stock	0.75	0.75	0.4801	0.515	13989582.0
2020-12-21	AAWW-DELISTED	Stock	54.51	55.7299	54.37	55.4	222453.0
2020-12-21	AAXJ	Stock	86.39	87.19	86.13	86.91	1479282.0
2020-12-21	AAXN-DELISTED	Stock	126.12	128.23	124.51	127.8	369067.0
2020-12-21	AB	Stock	33.44	33.61	33.02	33.52	189900.0
2020-12-21	ABB-DELISTED	Stock	26.96	27.455	26.81	27.4	1465647.0
2020-12-21	ABBNY-DELISTED	Stock	26.95	27.455	26.81	27.4	1566580.0
2020-12-21	ABBV	Stock	102.76	103.92	101.55	103.71	6664600.0
2020-12-21	ABC-DELISTED	Stock	97.32	97.8408	95.765	97.66	659743.0
2020-12-21	ABCB	Stock	38.0	38.6	36.23	36.67	389300.0
2020-12-21	ABCL	Stock	48.5	48.99	43.632	45.3	912700.0
2020-12-21	ABCM-DELISTED	Stock	19.17	20.05	19.17	19.8	269674.0
2020-12-21	ABEO	Stock	38.25	41.5	36.75	38.75	187472.0
2020-12-21	ABEV	Stock	3.05	3.07	2.98	3.04	21670100.0
2020-12-21	ABG	Stock	139.4	141.95	137.43	141.46	274200.0
2020-12-21	ABM	Stock	39.1	39.28	37.38	38.7	626700.0
2020-12-21	ABMD-DELISTED	Stock	292.76	296.6	283.73	296.24	289771.0
2020-12-21	ABNB	Stock	155.31	172.0	145.11	163.02	17788100.0
2020-12-21	ABR	Stock	14.0	14.05	13.48	13.79	1832700.0
2020-12-21	ABR.A-DELISTED	Stock	25.477	25.56	25.382	25.4772	7564.0

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

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