PREVIEW / stock_daily / 2020-08-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-27.parquet
  size:    224 KB
  rows:    6,791
  symbols: 2,410

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-27	AAPL	Stock	127.1425	127.485	123.8325	125.01	155552400.0
2020-08-27	MSFT	Stock	222.89	231.15	219.4	226.58	57602200.0
2020-08-27	NVDA	Stock	12.7815	12.85	12.5665	12.6283	317604000.0
2020-08-27	AMZN	Stock	172.5025	172.65	168.9	170.0	85296000.0
2020-08-27	GOOGL	Stock	82.3305	82.3995	80.9407	81.426	31350060.0
2020-08-27	META	Stock	300.16	301.23	292.02	293.22	30301300.0
2020-08-27	TSLA	Stock	145.364	153.04	142.8333	149.25	355395000.0
2020-08-27	TLT	Stock	164.76	164.82	161.16	161.24	19860113.0
2020-08-27	ES	Stock	84.41	84.82	83.19	84.28	1202600.0
2020-08-27	CL	Stock	78.99	79.48	78.83	79.06	2208900.0
2020-08-27	A	Stock	99.19	99.66	97.56	99.02	1236900.0
2020-08-27	AA	Stock	15.22	15.33	14.672	14.84	3246900.0
2020-08-27	AACG	Stock	1.08	1.09	1.06	1.06	13600.0
2020-08-27	AACQU-DELISTED	Stock	10.04	10.04	10.02	10.03	48347.0
2020-08-27	AAIC-DELISTED	Stock	2.79	2.84	2.79	2.8	246489.0
2020-08-27	AAIC.C-DELISTED	Stock	19.0	19.172	19.0	19.13	763.0
2020-08-27	AAL	Stock	13.43	14.26	13.12	13.28	108835700.0
2020-08-27	AAM.A-DELISTED	Stock	26.95	27.03	26.84	26.84	10959.0
2020-08-27	AAM.B-DELISTED	Stock	27.35	27.6546	27.35	27.57	10675.0
2020-08-27	AAMC-DELISTED	Stock	6.6393	6.8529	6.5233	6.6206	34962.0
2020-08-27	AAME	Stock	2.05	2.05	1.97	1.97	1500.0
2020-08-27	AAMI	Stock	14.07	14.52	14.01	14.02	442700.0
2020-08-27	AAOI	Stock	11.64	11.86	11.45	11.55	663200.0
2020-08-27	AAON	Stock	38.8	39.0133	38.2667	38.6467	307950.0
2020-08-27	AAP	Stock	156.95	156.95	154.54	154.72	473200.0
2020-08-27	AAT	Stock	25.5	26.24	25.5	25.85	176200.0
2020-08-27	AAU-DELISTED	Stock	0.68	0.68	0.65	0.6571	241623.0
2020-08-27	AAUAF-DELISTED	Stock	0.68	0.75	0.65	0.6573	248051.0
2020-08-27	AAWW-DELISTED	Stock	56.36	56.7	55.29	56.39	230708.0
2020-08-27	AAXJ	Stock	79.03	79.12	78.07	78.4	1030164.0
2020-08-27	AAXN-DELISTED	Stock	86.2	86.73	85.265	85.38	379591.0
2020-08-27	AB	Stock	28.35	28.82	28.28	28.54	265900.0
2020-08-27	ABB-DELISTED	Stock	26.04	26.05	25.62	25.63	1249627.0
2020-08-27	ABBNY-DELISTED	Stock	26.04	26.05	25.62	25.63	1331663.0
2020-08-27	ABBV	Stock	94.33	95.06	93.67	94.3	5271500.0
2020-08-27	ABC-DELISTED	Stock	97.72	98.97	96.33	98.13	487902.0
2020-08-27	ABCB	Stock	24.55	25.36	24.55	25.02	278400.0
2020-08-27	ABEO	Stock	59.25	59.25	54.75	56.75	22020.0
2020-08-27	ABEV	Stock	2.31	2.32	2.26	2.29	27054900.0
2020-08-27	ABG	Stock	101.43	104.13	101.21	103.74	163100.0
2020-08-27	ABM	Stock	37.58	38.09	37.34	37.88	218400.0
2020-08-27	ABMD-DELISTED	Stock	309.38	314.09	304.88	311.01	123688.0
2020-08-27	ABR	Stock	11.35	11.59	11.34	11.44	1004700.0
2020-08-27	ABR.A-DELISTED	Stock	25.56	25.56	25.1006	25.3325	2720.0
2020-08-27	ABR.B-DELISTED	Stock	25.0305	25.0893	24.9943	25.07	3922.0
2020-08-27	ABR.C-DELISTED	Stock	25.47	25.587	25.386	25.5801	3256.0
2020-08-27	ABT	Stock	111.01	114.0	109.52	111.29	36319000.0
2020-08-27	ABTC	Stock	184800.0	186000.0	180000.0	180600.0	1.2666666666666666
2020-08-27	ABTS	Stock	49.5	51.6	29.4	35.4	2820880.0
2020-08-27	ABTX-DELISTED	Stock	25.34	26.36	22.85	26.19	40525.0

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

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