PREVIEW / stock_daily / 2020-08-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-21.parquet
  size:    224 KB
  rows:    6,786
  symbols: 2,406

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-21	AAPL	Stock	119.2625	124.8675	119.25	124.37	338054800.0
2020-08-21	MSFT	Stock	213.86	216.25	212.85	213.02	36249300.0
2020-08-21	NVDA	Stock	12.2018	12.8088	12.1953	12.6835	999868000.0
2020-08-21	AMZN	Stock	164.75	165.72	163.7695	164.236	71518000.0
2020-08-21	GOOGL	Stock	78.59	79.594	78.1155	78.7785	34845500.0
2020-08-21	META	Stock	268.69	270.49	266.42	267.01	15538600.0
2020-08-21	TSLA	Stock	136.3173	139.6993	135.0033	136.6653	322344000.0
2020-08-21	TLT	Stock	165.77	166.33	165.01	166.2	6836242.0
2020-08-21	ES	Stock	85.99	86.7	84.88	86.54	963800.0
2020-08-21	CL	Stock	78.36	78.84	77.88	78.69	3405200.0
2020-08-21	A	Stock	97.87	98.32	97.27	98.3	1269300.0
2020-08-21	AA	Stock	14.91	15.04	14.515	14.6	4326700.0
2020-08-21	AACG	Stock	1.2	1.2	1.09	1.13	22300.0
2020-08-21	AACQU-DELISTED	Stock	10.07	10.07	9.9695	10.0	436915.0
2020-08-21	AAIC-DELISTED	Stock	2.8	2.81	2.72	2.72	203464.0
2020-08-21	AAIC.C-DELISTED	Stock	19.3	19.3	19.3	19.3	174.0
2020-08-21	AAL	Stock	12.44	12.63	12.09	12.16	35822900.0
2020-08-21	AAM.A-DELISTED	Stock	26.83	26.8373	26.76	26.83	1903.0
2020-08-21	AAM.B-DELISTED	Stock	27.36	27.396	27.3	27.3	6447.0
2020-08-21	AAMC-DELISTED	Stock	5.75	5.75	5.2971	5.4412	36601.0
2020-08-21	AAME	Stock	2.03	2.28	2.03	2.04	14700.0
2020-08-21	AAMI	Stock	13.38	13.51	13.28	13.38	263400.0
2020-08-21	AAOI	Stock	12.52	12.61	11.57	11.65	1479000.0
2020-08-21	AAON	Stock	39.1333	39.2533	38.5333	39.0533	265800.0
2020-08-21	AAP	Stock	157.05	158.32	155.57	156.11	697100.0
2020-08-21	AAT	Stock	25.42	25.68	24.84	24.99	386700.0
2020-08-21	AAU-DELISTED	Stock	0.74	0.74	0.68	0.69	538220.0
2020-08-21	AAUAF-DELISTED	Stock	0.74	0.74	0.68	0.7099	554900.0
2020-08-21	AAWW-DELISTED	Stock	58.63	59.33	57.14	57.72	368620.0
2020-08-21	AAXJ	Stock	76.34	77.03	76.16	76.94	524096.0
2020-08-21	AAXN-DELISTED	Stock	81.54	82.68	80.65	82.61	416474.0
2020-08-21	AB	Stock	28.24	28.98	28.17	28.65	247000.0
2020-08-21	ABB-DELISTED	Stock	25.54	25.865	25.54	25.85	995321.0
2020-08-21	ABBNY-DELISTED	Stock	25.54	25.865	25.54	25.84	1107388.0
2020-08-21	ABBV	Stock	95.2	95.32	94.32	94.86	5269000.0
2020-08-21	ABC-DELISTED	Stock	99.0	99.02	97.17	98.15	721559.0
2020-08-21	ABCB	Stock	24.07	24.34	23.44	23.73	273900.0
2020-08-21	ABEO	Stock	64.25	64.5	61.25	61.75	24100.0
2020-08-21	ABEV	Stock	2.31	2.33	2.27	2.33	11948000.0
2020-08-21	ABG	Stock	104.23	104.7	102.47	103.09	248000.0
2020-08-21	ABM	Stock	37.06	37.49	36.01	37.22	710300.0
2020-08-21	ABMD-DELISTED	Stock	310.0	310.5	304.45	307.99	146524.0
2020-08-21	ABR	Stock	11.13	11.25	11.01	11.1	830100.0
2020-08-21	ABR.A-DELISTED	Stock	25.25	25.308	25.02	25.1385	14100.0
2020-08-21	ABR.B-DELISTED	Stock	25.2599	25.2599	24.94	24.9998	1250.0
2020-08-21	ABR.C-DELISTED	Stock	25.49	25.54	25.46	25.51	2955.0
2020-08-21	ABT	Stock	101.63	102.54	100.84	102.4	3585000.0
2020-08-21	ABTC	Stock	187500.0	189240.0	177000.0	177900.0	3.0133333333333336
2020-08-21	ABTS	Stock	24.0	28.14	22.65	27.45	34987.0
2020-08-21	ABTX-DELISTED	Stock	24.63	24.78	24.4501	24.67	48967.0

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

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