PREVIEW / stock_daily / 2019-04-05

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-05.parquet
  size:    221 KB
  rows:    6,543
  symbols: 2,610

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
2019-04-05	AAPL	Stock	49.1125	49.275	48.9825	49.25	74106400.0
2019-04-05	MSFT	Stock	119.39	120.23	119.37	119.89	15826200.0
2019-04-05	NVDA	Stock	4.75	4.7913	4.7133	4.7738	481744000.0
2019-04-05	AMZN	Stock	91.45	91.929	91.2595	91.864	72810000.0
2019-04-05	GOOGL	Stock	60.965	61.0195	60.5015	60.5725	20020880.0
2019-04-05	META	Stock	176.88	177.0	175.1	175.72	9594100.0
2019-04-05	TSLA	Stock	17.9907	18.4067	17.7407	18.3307	195574500.0
2019-04-05	TLT	Stock	123.62	124.17	123.58	124.03	6322026.0
2019-04-05	ES	Stock	69.83	71.12	69.09	71.08	1147300.0
2019-04-05	CL	Stock	67.54	67.92	67.46	67.92	1981000.0
2019-04-05	A	Stock	81.19	81.92	81.05	81.47	1502900.0
2019-04-05	AA	Stock	29.4	29.69	29.09	29.55	3018600.0
2019-04-05	AABA-DELISTED	Stock	73.47	74.51	73.47	74.05	11837386.0
2019-04-05	AAC-DELISTED	Stock	2.01	2.15	2.0002	2.05	47389.0
2019-04-05	AACG	Stock	1.02	1.02	1.0	1.0	52700.0
2019-04-05	AAIC-DELISTED	Stock	7.86	7.94	7.86	7.93	247991.0
2019-04-05	AAIC.C-DELISTED	Stock	23.9087	23.95	23.75	23.85	3076.0
2019-04-05	AAL	Stock	33.97	34.4	33.88	34.06	5164700.0
2019-04-05	AAM.A-DELISTED	Stock	24.7838	24.88	24.778	24.85	39147.0
2019-04-05	AAM.B-DELISTED	Stock	24.63	24.81	24.63	24.81	69667.0
2019-04-05	AAMI	Stock	14.02	14.07	13.88	14.05	468300.0
2019-04-05	AAOI	Stock	12.77	13.0	12.69	12.72	404400.0
2019-04-05	AAON	Stock	30.5667	30.98	30.2067	30.66	147300.0
2019-04-05	AAP	Stock	174.31	176.83	174.31	176.78	741300.0
2019-04-05	AAT	Stock	46.48	46.83	46.24	46.77	238000.0
2019-04-05	AAU-DELISTED	Stock	0.58	0.5896	0.57	0.583	84361.0
2019-04-05	AAUAF-DELISTED	Stock	0.58	0.5896	0.57	0.583	86131.0
2019-04-05	AAWW-DELISTED	Stock	50.88	51.115	50.14	50.435	221570.0
2019-04-05	AAXJ	Stock	72.79	73.21	72.76	73.16	2707382.0
2019-04-05	AAXN-DELISTED	Stock	56.61	57.85	55.8652	57.74	563163.0
2019-04-05	AB	Stock	29.5	29.57	29.34	29.49	116700.0
2019-04-05	ABB-DELISTED	Stock	19.64	19.69	19.535	19.58	1380966.0
2019-04-05	ABBNY-DELISTED	Stock	19.64	19.69	19.535	19.58	1453783.0
2019-04-05	ABBV	Stock	82.82	84.18	82.67	83.45	3996300.0
2019-04-05	ABC-DELISTED	Stock	76.37	78.17	76.16	77.27	1152378.0
2019-04-05	ABCB	Stock	35.84	36.11	35.35	35.79	312300.0
2019-04-05	ABDC-DELISTED	Stock	7.67	8.075	7.67	7.97	101509.0
2019-04-05	ABEO	Stock	191.5	194.5	190.0	191.25	10576.0
2019-04-05	ABEV	Stock	4.54	4.56	4.47	4.49	20772600.0
2019-04-05	ABG	Stock	73.11	73.4	71.35	71.61	109400.0
2019-04-05	ABIL-DELISTED	Stock	1.67	1.71	1.67	1.696	37271.0
2019-04-05	ABM	Stock	36.47	37.19	36.14	37.12	425300.0
2019-04-05	ABMD-DELISTED	Stock	282.87	288.09	282.13	284.92	395266.0
2019-04-05	ABR	Stock	13.65	13.65	13.49	13.54	1989200.0
2019-04-05	ABR.A-DELISTED	Stock	25.82	25.9053	25.75	25.75	4750.0
2019-04-05	ABR.B-DELISTED	Stock	25.45	25.5687	25.45	25.5687	500.0
2019-04-05	ABR.C-DELISTED	Stock	26.19	26.38	26.06	26.3156	2474.0
2019-04-05	ABT	Stock	78.9	79.36	78.39	79.0	3434500.0
2019-04-05	ABTC	Stock	303000.0	304500.0	303000.0	304050.0	0.38666666666666666
2019-04-05	ABTS	Stock	52.5	57.825	52.5	57.15	1363.0

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

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