PREVIEW / stock_daily / 2021-02-17

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-17.parquet
  size:    248 KB
  rows:    7,515
  symbols: 2,790

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-17	AAPL	Stock	131.25	132.22	129.47	130.84	97918500.0
2021-02-17	MSFT	Stock	241.32	244.31	240.94	244.2	21653500.0
2021-02-17	NVDA	Stock	15.171	15.2235	14.78	14.906	274756000.0
2021-02-17	AMZN	Stock	163.18	166.0455	162.975	165.432	65950000.0
2021-02-17	GOOGL	Stock	104.699	106.1222	104.4175	105.931	20303540.0
2021-02-17	META	Stock	271.24	273.97	269.58	273.57	12763200.0
2021-02-17	TSLA	Stock	259.6967	266.6133	254.0033	266.05	77989500.0
2021-02-17	TLT	Stock	145.95	146.38	144.98	145.79	11203329.0
2021-02-17	ES	Stock	83.98	84.58	81.45	82.34	1684200.0
2021-02-17	CL	Stock	77.9	78.92	77.86	78.44	3145000.0
2021-02-17	A	Stock	132.8	136.98	129.59	130.12	4214700.0
2021-02-17	AA	Stock	22.41	22.675	21.71	21.93	4239500.0
2021-02-17	AACG	Stock	5.82	6.36	5.65	6.02	1580400.0
2021-02-17	AACQ-DELISTED	Stock	13.6635	13.91	12.93	13.485	17689321.0
2021-02-17	AACQU-DELISTED	Stock	15.15	15.15	14.06	15.0	1020765.0
2021-02-17	AACQW-DELISTED	Stock	3.88	3.95	3.38	3.9	3654255.0
2021-02-17	AAIC-DELISTED	Stock	4.1	4.1	3.965	3.99	204279.0
2021-02-17	AAIC.C-DELISTED	Stock	22.6	22.6	22.5	22.585	6704.0
2021-02-17	AAL	Stock	17.69	18.34	17.48	17.99	35475700.0
2021-02-17	AAM.A-DELISTED	Stock	26.1	26.17	26.01	26.17	22639.0
2021-02-17	AAM.B-DELISTED	Stock	26.89	26.89	26.6	26.62	19494.0
2021-02-17	AAMC-DELISTED	Stock	7.1971	7.1971	7.1971	7.1971	2145.0
2021-02-17	AAME	Stock	5.43	5.71	5.15	5.53	336200.0
2021-02-17	AAMI	Stock	20.32	20.49	19.9	20.17	249800.0
2021-02-17	AAN-DELISTED	Stock	20.27	20.75	20.16	20.51	280600.0
2021-02-17	AAOI	Stock	12.77	12.82	12.08	12.36	422800.0
2021-02-17	AAON	Stock	50.9667	51.5533	50.0067	50.3533	303450.0
2021-02-17	AAP	Stock	154.82	162.93	154.43	161.82	1590600.0
2021-02-17	AAT	Stock	29.07	29.79	28.9	29.2	325700.0
2021-02-17	AAU-DELISTED	Stock	0.974	0.974	0.86	0.9033	4244013.0
2021-02-17	AAUAF-DELISTED	Stock	0.974	0.974	0.86	0.9	4392498.0
2021-02-17	AAWW-DELISTED	Stock	55.07	56.0	53.88	56.0	491065.0
2021-02-17	AAXJ	Stock	101.89	102.1	101.4	102.08	882182.0
2021-02-17	AB	Stock	38.82	39.07	38.3	38.52	721800.0
2021-02-17	ABB-DELISTED	Stock	29.52	29.6	29.19	29.37	834934.0
2021-02-17	ABBNY-DELISTED	Stock	29.52	29.6	29.19	29.37	906337.0
2021-02-17	ABBV	Stock	104.7	106.75	104.15	106.29	6940400.0
2021-02-17	ABC-DELISTED	Stock	102.71	105.7	102.68	105.34	657300.0
2021-02-17	ABCB	Stock	46.51	47.36	46.39	46.92	230700.0
2021-02-17	ABCL	Stock	44.2	46.72	43.52	45.64	609700.0
2021-02-17	ABCM-DELISTED	Stock	23.71	24.18	23.45	24.12	206436.0
2021-02-17	ABEO	Stock	65.0	68.0	53.25	65.75	494428.0
2021-02-17	ABEV	Stock	2.86	2.88	2.8	2.87	26617000.0
2021-02-17	ABG	Stock	154.76	161.31	154.26	160.65	183000.0
2021-02-17	ABGI-DELISTED	Stock	10.5	10.5	10.23	10.34	4620510.0
2021-02-17	ABM	Stock	41.03	42.19	40.98	41.82	168800.0
2021-02-17	ABMD-DELISTED	Stock	314.01	321.735	314.0	316.585	187118.0
2021-02-17	ABNB	Stock	207.05	208.765	196.02	201.96	4090600.0
2021-02-17	ABR	Stock	15.79	15.87	15.36	15.47	920000.0
2021-02-17	ABR.A-DELISTED	Stock	25.7	25.8	25.41	25.68	3296.0

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

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