PREVIEW / stock_daily / 2020-07-15

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-15.parquet
  size:    223 KB
  rows:    6,738
  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-07-15	AAPL	Stock	98.99	99.2475	96.49	97.725	153198000.0
2020-07-15	MSFT	Stock	209.56	211.33	205.03	208.04	32179400.0
2020-07-15	NVDA	Stock	10.4143	10.433	10.0558	10.2272	403984000.0
2020-07-15	AMZN	Stock	154.0115	154.9175	148.659	150.4435	115778000.0
2020-07-15	GOOGL	Stock	76.1615	76.8165	74.8915	75.844	31026500.0
2020-07-15	META	Stock	241.55	244.82	238.05	240.28	19133600.0
2020-07-15	TSLA	Stock	102.8667	103.3333	97.1333	103.0673	245517000.0
2020-07-15	TLT	Stock	165.92	166.945	165.8291	166.34	7840586.0
2020-07-15	ES	Stock	87.09	87.41	84.89	85.0	1696000.0
2020-07-15	CL	Stock	75.0	75.49	74.36	74.69	3270900.0
2020-07-15	A	Stock	91.74	93.06	91.08	92.88	1897100.0
2020-07-15	AA	Stock	12.85	12.97	12.125	12.69	11807600.0
2020-07-15	AACG	Stock	1.59	1.59	1.52	1.52	25100.0
2020-07-15	AACQU-DELISTED	Stock	10.4	10.41	10.34	10.36	2752505.0
2020-07-15	AAIC-DELISTED	Stock	2.98	3.09	2.96	3.07	366638.0
2020-07-15	AAIC.C-DELISTED	Stock	19.458	19.458	19.2	19.2	208.0
2020-07-15	AAL	Stock	12.45	13.48	12.21	13.44	135444400.0
2020-07-15	AAM.A-DELISTED	Stock	26.2	26.38	26.2	26.38	10688.0
2020-07-15	AAM.B-DELISTED	Stock	26.71	26.9	26.5915	26.89	11714.0
2020-07-15	AAMC-DELISTED	Stock	4.3088	4.3088	4.1412	4.2676	5991.0
2020-07-15	AAME	Stock	1.64	1.69	1.59	1.61	15000.0
2020-07-15	AAMI	Stock	12.4	12.66	12.18	12.47	716000.0
2020-07-15	AAOI	Stock	10.89	11.41	10.8	11.12	542000.0
2020-07-15	AAON	Stock	38.2267	38.9	37.8667	38.44	461700.0
2020-07-15	AAP	Stock	140.8	143.97	140.22	143.68	912000.0
2020-07-15	AAT	Stock	27.14	27.55	26.55	26.77	312400.0
2020-07-15	AAU-DELISTED	Stock	0.5325	0.5325	0.4931	0.4975	316285.0
2020-07-15	AAUAF-DELISTED	Stock	0.5325	0.5325	0.4931	0.5	344221.0
2020-07-15	AAWW-DELISTED	Stock	49.44	49.549	47.155	48.72	243440.0
2020-07-15	AAXJ	Stock	75.01	75.16	74.53	74.83	604350.0
2020-07-15	AAXN-DELISTED	Stock	94.0	94.59	91.56	92.63	300162.0
2020-07-15	AB	Stock	28.22	28.79	28.11	28.64	615200.0
2020-07-15	ABB-DELISTED	Stock	24.72	24.76	24.425	24.59	2020851.0
2020-07-15	ABBNY-DELISTED	Stock	24.72	24.76	24.425	24.6	2902231.0
2020-07-15	ABBV	Stock	100.0	100.48	98.82	100.48	5661600.0
2020-07-15	ABC-DELISTED	Stock	100.38	102.42	99.01	101.91	756719.0
2020-07-15	ABCB	Stock	21.69	22.8	21.46	22.58	528800.0
2020-07-15	ABEO	Stock	71.75	76.0	69.75	72.25	46376.0
2020-07-15	ABEV	Stock	2.67	2.72	2.66	2.69	30825400.0
2020-07-15	ABG	Stock	100.34	101.8	98.07	101.1	280900.0
2020-07-15	ABM	Stock	34.71	36.09	34.44	35.84	363600.0
2020-07-15	ABMD-DELISTED	Stock	265.2	277.28	262.82	276.93	233751.0
2020-07-15	ABR	Stock	8.39	8.79	8.27	8.74	1758300.0
2020-07-15	ABR.A-DELISTED	Stock	24.75	24.908	24.67	24.82	2399.0
2020-07-15	ABR.B-DELISTED	Stock	23.58	23.8	23.53	23.8	4200.0
2020-07-15	ABR.C-DELISTED	Stock	25.1	25.14	24.62	25.055	825.0
2020-07-15	ABT	Stock	95.9	97.13	95.77	96.73	6205000.0
2020-07-15	ABTC	Stock	227400.0	228000.0	211800.0	222600.0	2.746666666666667
2020-07-15	ABTS	Stock	15.75	16.35	15.6	16.35	3393.0
2020-07-15	ABTX-DELISTED	Stock	23.61	24.27	23.47	24.06	67485.0

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

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