PREVIEW / stock_daily / 2019-04-01

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-01.parquet
  size:    220 KB
  rows:    6,540
  symbols: 2,595

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-01	AAPL	Stock	47.91	47.92	47.095	47.81	111448000.0
2019-04-01	MSFT	Stock	118.95	119.11	118.1	119.02	22789100.0
2019-04-01	NVDA	Stock	4.5815	4.5875	4.5093	4.557	483824000.0
2019-04-01	AMZN	Stock	90.0055	90.7835	89.9365	90.7095	84776000.0
2019-04-01	GOOGL	Stock	59.377	60.01	59.318	59.949	27711900.0
2019-04-01	META	Stock	167.83	168.9	167.28	168.7	10381500.0
2019-04-01	TSLA	Stock	18.8413	19.28	18.752	19.2787	121656000.0
2019-04-01	TLT	Stock	125.29	125.3565	124.19	124.37	16501475.0
2019-04-01	ES	Stock	70.94	70.97	70.0	70.68	2113300.0
2019-04-01	CL	Stock	68.38	68.52	67.83	68.3	4139300.0
2019-04-01	A	Stock	80.96	81.77	80.96	81.56	1522700.0
2019-04-01	AA	Stock	28.68	29.67	28.53	29.46	3880400.0
2019-04-01	AABA-DELISTED	Stock	74.95	75.17	73.56	73.57	4495136.0
2019-04-01	AAC-DELISTED	Stock	1.89	2.14	1.89	2.11	282636.0
2019-04-01	AACG	Stock	1.01	1.02	1.0	1.0	31600.0
2019-04-01	AAIC-DELISTED	Stock	7.97	7.99	7.89	7.95	403802.0
2019-04-01	AAIC.C-DELISTED	Stock	23.2085	23.35	23.1658	23.35	26399.0
2019-04-01	AAL	Stock	31.98	32.73	31.7	32.35	7438200.0
2019-04-01	AAM.A-DELISTED	Stock	24.95	25.1	24.86	25.075	35267.0
2019-04-01	AAM.B-DELISTED	Stock	24.7	24.9	24.65	24.75	46503.0
2019-04-01	AAMC-DELISTED	Stock	9.7824	9.7824	8.2676	8.4559	72570.0
2019-04-01	AAME	Stock	2.6	2.61	2.6	2.61	5700.0
2019-04-01	AAMI	Stock	13.63	13.82	13.54	13.82	646400.0
2019-04-01	AAOI	Stock	12.31	12.746	12.266	12.6	566000.0
2019-04-01	AAON	Stock	31.0	31.1533	30.4733	30.98	207900.0
2019-04-01	AAP	Stock	172.79	174.18	171.13	173.63	957500.0
2019-04-01	AAT	Stock	46.06	46.22	45.59	46.22	281600.0
2019-04-01	AAU-DELISTED	Stock	0.588	0.5993	0.58	0.5925	181964.0
2019-04-01	AAUAF-DELISTED	Stock	0.588	0.5993	0.58	0.5925	231137.0
2019-04-01	AAWW-DELISTED	Stock	51.21	51.7962	51.015	51.39	162252.0
2019-04-01	AAXJ	Stock	71.5	71.74	71.35	71.71	952270.0
2019-04-01	AAXN-DELISTED	Stock	54.99	55.75	54.35	55.28	285119.0
2019-04-01	AB	Stock	29.08	29.23	28.95	29.07	187300.0
2019-04-01	ABB-DELISTED	Stock	19.12	19.22	19.07	19.14	2010685.0
2019-04-01	ABBNY-DELISTED	Stock	19.12	19.22	19.07	19.14	2105202.0
2019-04-01	ABBV	Stock	80.98	81.11	79.97	80.78	4759400.0
2019-04-01	ABC-DELISTED	Stock	80.04	80.25	79.0	79.1	1187521.0
2019-04-01	ABCB	Stock	34.7	35.67	34.7	35.49	317300.0
2019-04-01	ABDC-DELISTED	Stock	7.57	7.63	7.5	7.55	41113.0
2019-04-01	ABEO	Stock	186.0	189.75	183.75	184.25	7252.0
2019-04-01	ABEV	Stock	4.35	4.4	4.32	4.34	14764000.0
2019-04-01	ABG	Stock	69.91	71.09	69.37	70.95	148200.0
2019-04-01	ABIL-DELISTED	Stock	1.69	1.72	1.66	1.67	87146.0
2019-04-01	ABM	Stock	36.47	37.07	36.17	36.99	390800.0
2019-04-01	ABMD-DELISTED	Stock	290.01	293.44	275.36	277.76	762211.0
2019-04-01	ABR	Stock	13.01	13.14	13.0	13.07	1042900.0
2019-04-01	ABR.A-DELISTED	Stock	25.78	25.825	25.78	25.78	1356.0
2019-04-01	ABR.C-DELISTED	Stock	26.07	26.07	26.0	26.049	1150.0
2019-04-01	ABT	Stock	80.67	80.74	79.21	79.66	4842000.0
2019-04-01	ABTC	Stock	304200.0	304200.0	301500.0	302010.0	1.5066666666666668

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

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