PREVIEW / stock_daily / 2020-05-13

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-13.parquet
  size:    216 KB
  rows:    6,606
  symbols: 2,349

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-05-13	AAPL	Stock	78.0375	78.9875	75.8025	76.9125	200622400.0
2020-05-13	MSFT	Stock	182.55	184.05	176.54	179.75	44711500.0
2020-05-13	NVDA	Stock	7.9175	8.0785	7.5948	7.78	625852000.0
2020-05-13	AMZN	Stock	118.34	120.385	116.89	118.396	95658000.0
2020-05-13	GOOGL	Stock	68.808	69.2665	66.4005	67.4165	40368080.0
2020-05-13	META	Stock	209.43	210.78	202.11	205.1	20684600.0
2020-05-13	TSLA	Stock	54.722	55.0667	50.8867	52.7307	285982500.0
2020-05-13	TLT	Stock	165.09	166.29	164.8272	165.52	13305576.0
2020-05-13	ES	Stock	75.07	76.96	74.88	76.64	1711400.0
2020-05-13	CL	Stock	69.01	69.55	67.84	68.3	3864200.0
2020-05-13	A	Stock	80.38	81.93	79.03	80.16	2664900.0
2020-05-13	AA	Stock	7.31	7.34	6.87	6.98	8751300.0
2020-05-13	AACG	Stock	0.7	0.76	0.7	0.76	25600.0
2020-05-13	AAIC-DELISTED	Stock	2.45	2.47	2.15	2.19	558029.0
2020-05-13	AAIC.C-DELISTED	Stock	16.0	16.2	15.5	16.2	6705.0
2020-05-13	AAL	Stock	9.52	9.53	8.83	9.11	68704600.0
2020-05-13	AAM.A-DELISTED	Stock	25.84	25.98	25.465	25.6	17559.0
2020-05-13	AAM.B-DELISTED	Stock	25.99	25.99	25.5	25.5398	36951.0
2020-05-13	AAMC-DELISTED	Stock	4.6471	4.6471	4.6471	4.6471	1095.0
2020-05-13	AAME	Stock	1.8	1.88	1.8	1.88	900.0
2020-05-13	AAMI	Stock	7.56	7.765	7.39	7.55	733500.0
2020-05-13	AAOI	Stock	9.21	9.3	8.31	8.7	1052500.0
2020-05-13	AAON	Stock	31.5	32.0933	30.1733	31.0067	350850.0
2020-05-13	AAP	Stock	123.76	125.05	118.68	119.24	1178700.0
2020-05-13	AAT	Stock	24.71	24.81	23.57	23.91	318300.0
2020-05-13	AAU-DELISTED	Stock	0.405	0.4194	0.4	0.4027	419966.0
2020-05-13	AAUAF-DELISTED	Stock	0.405	0.4194	0.4	0.4027	427525.0
2020-05-13	AAWW-DELISTED	Stock	37.25	37.25	34.73	36.34	508659.0
2020-05-13	AAXJ	Stock	64.71	64.92	63.63	64.1	1487276.0
2020-05-13	AAXN-DELISTED	Stock	84.0	84.91	79.095	80.19	647711.0
2020-05-13	AB	Stock	21.54	21.59	20.64	21.15	396300.0
2020-05-13	ABB-DELISTED	Stock	18.26	18.26	17.705	17.87	1861517.0
2020-05-13	ABBNY-DELISTED	Stock	18.26	18.26	17.705	17.86	1992125.0
2020-05-13	ABBV	Stock	90.74	92.24	87.73	88.87	23562600.0
2020-05-13	ABC-DELISTED	Stock	88.17	89.0	83.67	84.16	1195427.0
2020-05-13	ABCB	Stock	20.01	20.2	18.35	18.52	560800.0
2020-05-13	ABEO	Stock	76.0	83.75	72.75	81.75	79224.0
2020-05-13	ABEV	Stock	2.04	2.05	1.9	1.94	38274200.0
2020-05-13	ABG	Stock	63.05	63.05	57.1	58.54	330500.0
2020-05-13	ABM	Stock	31.69	31.74	29.39	29.66	460200.0
2020-05-13	ABMD-DELISTED	Stock	191.67	193.525	180.29	185.6	305080.0
2020-05-13	ABR	Stock	6.51	6.57	5.93	6.29	3827200.0
2020-05-13	ABR.A-DELISTED	Stock	24.28	24.8	23.6	23.7783	5742.0
2020-05-13	ABR.B-DELISTED	Stock	25.74	25.74	23.048	23.08	6008.0
2020-05-13	ABR.C-DELISTED	Stock	24.875	24.875	23.99	24.0914	6672.0
2020-05-13	ABT	Stock	93.27	94.67	90.84	92.16	11622500.0
2020-05-13	ABTC	Stock	222000.0	224100.0	210000.0	222900.0	2.08
2020-05-13	ABTS	Stock	11.7	11.7	11.25	11.295	820.0
2020-05-13	ABTX-DELISTED	Stock	22.26	22.585	21.5	22.38	138907.0
2020-05-13	ABUS	Stock	1.79	1.89	1.57	1.7	1115400.0

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

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