PREVIEW / stock_daily / 2021-01-07

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-07.parquet
  size:    241 KB
  rows:    7,271
  symbols: 2,631

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-07	AAPL	Stock	128.36	131.63	127.86	130.92	109578200.0
2021-01-07	MSFT	Stock	214.04	219.34	213.71	218.29	27694500.0
2021-01-07	NVDA	Stock	12.9675	13.3778	12.8865	13.344	461480000.0
2021-01-07	AMZN	Stock	157.85	160.427	157.75	158.108	70290000.0
2021-01-07	GOOGL	Stock	86.338	88.891	86.338	88.717	41936580.0
2021-01-07	META	Stock	265.9	271.61	264.78	268.74	15789800.0
2021-01-07	TSLA	Stock	259.21	272.33	258.4	272.0133	154496700.0
2021-01-07	TLT	Stock	151.79	152.17	151.26	151.81	14651882.0
2021-01-07	ES	Stock	89.08	89.46	88.1	88.55	1757600.0
2021-01-07	CL	Stock	81.91	82.55	81.14	81.8	5061000.0
2021-01-07	A	Stock	124.33	127.48	124.11	126.16	1775900.0
2021-01-07	AA	Stock	25.63	26.2	24.96	25.23	4445500.0
2021-01-07	AACG	Stock	1.3	1.3	1.23	1.27	20400.0
2021-01-07	AACQ-DELISTED	Stock	10.62	10.6513	10.48	10.545	839136.0
2021-01-07	AACQU-DELISTED	Stock	11.27	11.2814	11.15	11.15	57941.0
2021-01-07	AACQW-DELISTED	Stock	2.1	2.1	1.89	1.94	513249.0
2021-01-07	AAIC-DELISTED	Stock	3.88	3.955	3.85	3.93	216311.0
2021-01-07	AAIC.C-DELISTED	Stock	21.0	21.32	20.99	21.15	4800.0
2021-01-07	AAL	Stock	15.67	15.87	15.38	15.38	48187900.0
2021-01-07	AAM.A-DELISTED	Stock	26.25	26.4	26.117	26.39	11213.0
2021-01-07	AAM.B-DELISTED	Stock	26.85	26.93	26.597	26.93	24104.0
2021-01-07	AAMC-DELISTED	Stock	6.7647	7.0587	6.5853	6.5853	35462.0
2021-01-07	AAME	Stock	2.3	2.48	2.3	2.36	23100.0
2021-01-07	AAMI	Stock	19.6	19.98	19.36	19.64	391300.0
2021-01-07	AAN-DELISTED	Stock	21.0	21.64	20.9	21.37	984400.0
2021-01-07	AAOI	Stock	9.775	9.87	9.54	9.64	646100.0
2021-01-07	AAON	Stock	46.0533	47.1467	45.3733	46.98	471150.0
2021-01-07	AAP	Stock	165.96	168.8	164.6	167.67	993200.0
2021-01-07	AAT	Stock	28.68	28.68	27.72	28.18	162600.0
2021-01-07	AAU-DELISTED	Stock	0.5425	0.545	0.5076	0.5237	1554892.0
2021-01-07	AAUAF-DELISTED	Stock	0.5425	0.545	0.5076	0.5237	1613542.0
2021-01-07	AAWW-DELISTED	Stock	52.8	53.84	51.1	51.2	509895.0
2021-01-07	AAXJ	Stock	92.19	92.67	91.74	92.56	1758324.0
2021-01-07	AAXN-DELISTED	Stock	121.82	125.05	121.04	124.57	310130.0
2021-01-07	AB	Stock	34.75	35.71	34.16	34.97	410700.0
2021-01-07	ABB-DELISTED	Stock	29.88	30.1216	29.77	30.04	1848597.0
2021-01-07	ABBNY-DELISTED	Stock	29.88	30.1216	29.77	30.04	3599568.0
2021-01-07	ABBV	Stock	106.11	107.06	105.57	106.71	8196000.0
2021-01-07	ABC-DELISTED	Stock	106.55	110.39	106.2405	110.12	1561811.0
2021-01-07	ABCB	Stock	42.59	43.46	40.56	43.4	647500.0
2021-01-07	ABCL	Stock	40.7	40.96	38.64	39.32	992800.0
2021-01-07	ABCM-DELISTED	Stock	19.87	20.41	19.51	19.68	107617.0
2021-01-07	ABEO	Stock	45.0	45.25	43.0	44.5	53620.0
2021-01-07	ABEV	Stock	3.04	3.06	2.98	2.99	28980300.0
2021-01-07	ABG	Stock	157.8	162.01	155.58	161.37	103900.0
2021-01-07	ABM	Stock	41.15	41.31	40.39	41.13	244800.0
2021-01-07	ABMD-DELISTED	Stock	321.63	327.6469	318.16	323.03	224591.0
2021-01-07	ABNB	Stock	146.37	154.42	145.261	151.27	4482800.0
2021-01-07	ABR	Stock	14.42	14.52	14.28	14.32	899000.0
2021-01-07	ABR.A-DELISTED	Stock	25.5668	25.6	25.55	25.6	550.0

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

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