PREVIEW / stock_daily / 2021-02-18

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-18.parquet
  size:    248 KB
  rows:    7,517
  symbols: 2,795

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-18	AAPL	Stock	129.2	130.0	127.41	129.71	96856700.0
2021-02-18	MSFT	Stock	241.8	243.93	240.86	243.79	16925600.0
2021-02-18	NVDA	Stock	14.729	14.8732	14.575	14.829	233868000.0
2021-02-18	AMZN	Stock	164.121	166.9	163.697	166.4115	60548000.0
2021-02-18	GOOGL	Stock	105.25	106.0995	104.6665	105.2905	22570980.0
2021-02-18	META	Stock	269.57	271.95	266.03	269.39	15249100.0
2021-02-18	TSLA	Stock	260.3	264.8967	258.7567	262.46	53871300.0
2021-02-18	TLT	Stock	144.61	145.6	144.32	145.2	10755817.0
2021-02-18	ES	Stock	81.62	82.82	81.0	82.55	1488800.0
2021-02-18	CL	Stock	78.34	78.86	78.09	78.72	2565600.0
2021-02-18	A	Stock	129.0	130.39	127.58	127.68	1941400.0
2021-02-18	AA	Stock	22.03	22.26	21.07	21.12	3545600.0
2021-02-18	AACG	Stock	5.97	6.25	5.65	5.75	1028000.0
2021-02-18	AACQ-DELISTED	Stock	13.39	13.73	12.76	12.8	5340865.0
2021-02-18	AACQU-DELISTED	Stock	14.75	15.0	13.9	13.91	708738.0
2021-02-18	AACQW-DELISTED	Stock	3.88	3.88	3.56	3.56	1767991.0
2021-02-18	AAIC-DELISTED	Stock	3.99	4.01	3.85	3.92	182077.0
2021-02-18	AAIC.C-DELISTED	Stock	22.76	22.76	22.45	22.5	3373.0
2021-02-18	AAL	Stock	17.83	17.98	17.45	17.71	26328200.0
2021-02-18	AAM.A-DELISTED	Stock	26.15	26.2	26.0	26.2	15122.0
2021-02-18	AAM.B-DELISTED	Stock	26.68	26.68	26.52	26.5711	9242.0
2021-02-18	AAMC-DELISTED	Stock	7.4941	9.1882	7.1971	7.341	338388.0
2021-02-18	AAME	Stock	5.55	5.85	5.08	5.24	343100.0
2021-02-18	AAMI	Stock	19.89	20.01	19.27	19.36	365100.0
2021-02-18	AAN-DELISTED	Stock	20.48	20.59	20.35	20.48	136400.0
2021-02-18	AAOI	Stock	12.22	12.39	11.9	11.94	605600.0
2021-02-18	AAON	Stock	50.3533	50.7533	49.4133	50.3267	222900.0
2021-02-18	AAP	Stock	160.02	167.68	159.71	167.55	1584500.0
2021-02-18	AAT	Stock	28.94	29.71	28.94	29.26	332100.0
2021-02-18	AAU-DELISTED	Stock	0.9	0.903	0.8112	0.815	3200893.0
2021-02-18	AAUAF-DELISTED	Stock	0.9	0.903	0.8101	0.8101	3290456.0
2021-02-18	AAWW-DELISTED	Stock	58.06	59.14	55.01	57.1	663026.0
2021-02-18	AAXJ	Stock	100.38	100.53	99.389	100.42	1414201.0
2021-02-18	AB	Stock	38.1	38.4	37.4	37.89	934600.0
2021-02-18	ABB-DELISTED	Stock	29.51	29.77	29.38	29.69	1423851.0
2021-02-18	ABBNY-DELISTED	Stock	29.51	29.77	29.38	29.68	1517465.0
2021-02-18	ABBV	Stock	105.32	106.61	105.21	106.06	5386600.0
2021-02-18	ABC-DELISTED	Stock	104.72	105.73	104.31	105.26	474257.0
2021-02-18	ABCB	Stock	46.62	47.11	46.1	46.32	182400.0
2021-02-18	ABCL	Stock	45.65	45.65	43.36	43.8	499100.0
2021-02-18	ABCM-DELISTED	Stock	23.87	24.38	23.63	24.27	35257.0
2021-02-18	ABEO	Stock	60.25	63.0	56.25	61.5	171604.0
2021-02-18	ABEV	Stock	2.79	2.81	2.75	2.76	25886400.0
2021-02-18	ABG	Stock	160.18	161.64	155.83	157.0	88900.0
2021-02-18	ABGI-DELISTED	Stock	10.31	10.38	10.27	10.33	646908.0
2021-02-18	ABM	Stock	41.73	42.79	41.51	42.22	269600.0
2021-02-18	ABMD-DELISTED	Stock	312.14	326.0	311.89	321.21	202564.0
2021-02-18	ABNB	Stock	199.01	200.36	192.17	198.04	2791400.0
2021-02-18	ABR	Stock	15.45	15.74	15.24	15.37	1039200.0
2021-02-18	ABR.A-DELISTED	Stock	25.99	25.99	25.57	25.7325	1225.0

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

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