PREVIEW / stock_daily / 2020-08-25

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-25.parquet
  size:    224 KB
  rows:    6,792
  symbols: 2,407

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-08-25	AAPL	Stock	124.6975	125.18	123.0525	124.825	211495600.0
2020-08-25	MSFT	Stock	213.1	216.61	213.1	216.47	23043700.0
2020-08-25	NVDA	Stock	12.6308	12.7612	12.5738	12.75	289076000.0
2020-08-25	AMZN	Stock	164.7495	167.87	163.35	167.3245	79856000.0
2020-08-25	GOOGL	Stock	79.005	80.444	78.894	80.2925	25149260.0
2020-08-25	META	Stock	272.41	283.09	270.26	280.82	42127200.0
2020-08-25	TSLA	Stock	131.6593	135.1967	131.2	134.8893	159883500.0
2020-08-25	TLT	Stock	164.35	165.09	163.83	164.66	10518301.0
2020-08-25	ES	Stock	86.27	86.31	84.74	84.93	1067500.0
2020-08-25	CL	Stock	79.3	79.31	78.47	78.59	2374100.0
2020-08-25	A	Stock	97.87	98.66	97.56	98.34	1061300.0
2020-08-25	AA	Stock	15.12	15.25	14.82	15.05	2363300.0
2020-08-25	AACG	Stock	1.09	1.13	1.09	1.09	3900.0
2020-08-25	AACQU-DELISTED	Stock	10.09	10.09	10.0	10.01	175329.0
2020-08-25	AAIC-DELISTED	Stock	2.85	2.85	2.765	2.78	177218.0
2020-08-25	AAIC.C-DELISTED	Stock	19.3998	19.3998	19.225	19.225	750.0
2020-08-25	AAL	Stock	13.69	14.02	12.77	13.14	79053400.0
2020-08-25	AAM.A-DELISTED	Stock	26.71	26.8582	26.59	26.78	9886.0
2020-08-25	AAM.B-DELISTED	Stock	27.35	27.485	27.35	27.48	10435.0
2020-08-25	AAMC-DELISTED	Stock	5.4485	6.6191	5.3676	6.1059	124362.0
2020-08-25	AAME	Stock	1.9	1.97	1.9	1.95	3000.0
2020-08-25	AAMI	Stock	13.88	13.919	13.47	13.72	870400.0
2020-08-25	AAOI	Stock	11.7	12.385	11.56	12.0	832400.0
2020-08-25	AAON	Stock	39.26	39.26	38.5067	38.8467	221400.0
2020-08-25	AAP	Stock	157.26	157.26	153.96	156.06	525200.0
2020-08-25	AAT	Stock	25.96	26.34	25.49	25.61	301700.0
2020-08-25	AAU-DELISTED	Stock	0.67	0.68	0.6	0.624	941225.0
2020-08-25	AAUAF-DELISTED	Stock	0.67	0.68	0.6	0.628	955920.0
2020-08-25	AAWW-DELISTED	Stock	57.4	57.9	56.63	57.36	422737.0
2020-08-25	AAXJ	Stock	78.12	78.87	78.03	78.87	1504379.0
2020-08-25	AAXN-DELISTED	Stock	83.26	87.51	82.8637	85.28	831406.0
2020-08-25	AB	Stock	29.01	29.08	28.38	28.82	208600.0
2020-08-25	ABB-DELISTED	Stock	26.18	26.2	25.85	25.92	1147136.0
2020-08-25	ABBNY-DELISTED	Stock	26.17	26.2	25.85	25.92	1212095.0
2020-08-25	ABBV	Stock	94.21	94.79	93.91	94.06	6710000.0
2020-08-25	ABC-DELISTED	Stock	97.93	98.28	97.02	98.28	422395.0
2020-08-25	ABCB	Stock	25.36	25.74	24.7	25.1	171600.0
2020-08-25	ABEO	Stock	60.0	62.25	58.75	60.0	17544.0
2020-08-25	ABEV	Stock	2.31	2.33	2.28	2.32	26074600.0
2020-08-25	ABG	Stock	105.18	105.3	102.65	103.88	115700.0
2020-08-25	ABM	Stock	38.24	38.25	37.33	37.55	195100.0
2020-08-25	ABMD-DELISTED	Stock	304.53	318.9608	303.77	311.47	153015.0
2020-08-25	ABR	Stock	11.58	11.67	11.26	11.45	824200.0
2020-08-25	ABR.A-DELISTED	Stock	25.15	25.29	25.03	25.2	9131.0
2020-08-25	ABR.B-DELISTED	Stock	25.0	25.1001	25.0	25.1001	2520.0
2020-08-25	ABR.C-DELISTED	Stock	25.48	25.55	25.435	25.4907	3142.0
2020-08-25	ABT	Stock	101.98	102.9	101.52	102.47	2626400.0
2020-08-25	ABTC	Stock	178200.0	183900.0	175500.0	180000.0	1.68
2020-08-25	ABTS	Stock	27.45	30.75	27.0	29.7	22240.0
2020-08-25	ABTX-DELISTED	Stock	26.28	26.3	25.235	25.89	24521.0

> showing 50 of 6,792 rows — these rows as CSV

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