PREVIEW / stock_daily / 2019-02-05

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-05.parquet
  size:    220 KB
  rows:    6,530
  symbols: 2,646

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-02-05	AAPL	Stock	43.215	43.77	43.0875	43.545	144406400.0
2019-02-05	MSFT	Stock	106.06	107.27	105.96	107.22	27325400.0
2019-02-05	NVDA	Stock	3.7415	3.7858	3.7075	3.7488	542424000.0
2019-02-05	AMZN	Stock	82.167	83.263	82.125	82.9405	89062000.0
2019-02-05	GOOGL	Stock	56.4815	57.6385	56.18	57.5935	82295800.0
2019-02-05	META	Stock	169.15	171.98	168.69	171.16	22557000.0
2019-02-05	TSLA	Stock	20.8327	21.496	20.8167	21.4233	101142000.0
2019-02-05	TLT	Stock	120.73	121.23	120.66	120.97	6983255.0
2019-02-05	ES	Stock	69.05	69.46	68.64	69.31	1305900.0
2019-02-05	CL	Stock	65.27	65.55	64.64	64.74	4255300.0
2019-02-05	A	Stock	75.8	76.51	75.79	76.31	1593500.0
2019-02-05	AA	Stock	29.0	29.497	28.91	29.07	2749600.0
2019-02-05	AABA-DELISTED	Stock	68.96	70.28	68.74	70.06	7092841.0
2019-02-05	AAC-DELISTED	Stock	2.6	2.794	2.55	2.74	313548.0
2019-02-05	AACG	Stock	1.17	1.17	1.05	1.08	54000.0
2019-02-05	AAIC-DELISTED	Stock	8.76	8.76	8.6501	8.72	287751.0
2019-02-05	AAL	Stock	36.81	37.23	36.7	36.93	6003200.0
2019-02-05	AAM.A-DELISTED	Stock	24.5553	24.64	24.5553	24.6198	23136.0
2019-02-05	AAM.B-DELISTED	Stock	24.4	24.48	24.4	24.45	28814.0
2019-02-05	AAMC-DELISTED	Stock	7.8588	8.4985	7.6779	8.2353	43812.0
2019-02-05	AAME	Stock	2.8	2.8	2.8	2.8	100.0
2019-02-05	AAMI	Stock	12.53	12.555	12.37	12.4	678100.0
2019-02-05	AAOI	Stock	17.78	18.0	17.12	17.29	539000.0
2019-02-05	AAON	Stock	25.1733	25.26	24.8467	24.8933	130200.0
2019-02-05	AAP	Stock	162.39	162.98	159.63	161.46	932600.0
2019-02-05	AAT	Stock	43.24	43.29	42.69	43.2	117700.0
2019-02-05	AAU-DELISTED	Stock	0.7635	0.7685	0.71	0.715	118956.0
2019-02-05	AAUAF-DELISTED	Stock	0.7635	0.7685	0.71	0.715	120998.0
2019-02-05	AAWW-DELISTED	Stock	54.5	54.5	53.05	54.05	165856.0
2019-02-05	AAXJ	Stock	69.1	69.83	69.055	69.76	585359.0
2019-02-05	AAXN-DELISTED	Stock	53.0	53.82	52.2201	52.48	213530.0
2019-02-05	AB	Stock	30.68	30.75	29.96	30.08	453300.0
2019-02-05	ABB-DELISTED	Stock	19.47	19.6659	19.46	19.615	2343795.0
2019-02-05	ABBNY-DELISTED	Stock	19.47	19.6659	19.46	19.61	2841738.0
2019-02-05	ABBV	Stock	78.56	80.06	78.22	79.69	7965500.0
2019-02-05	ABC-DELISTED	Stock	84.75	86.35	84.48	85.78	1326515.0
2019-02-05	ABCB	Stock	38.23	38.23	37.49	37.82	329500.0
2019-02-05	ABDC-DELISTED	Stock	7.69	7.81	7.64	7.72	37129.0
2019-02-05	ABEO	Stock	195.0	200.0	178.25	180.75	23716.0
2019-02-05	ABEV	Stock	5.06	5.1	4.96	5.03	29620600.0
2019-02-05	ABG	Stock	72.49	72.86	71.38	72.46	139600.0
2019-02-05	ABIL-DELISTED	Stock	2.03	2.05	1.95	2.0	104400.0
2019-02-05	ABM	Stock	34.66	35.26	34.39	35.08	471900.0
2019-02-05	ABMD-DELISTED	Stock	334.16	350.49	333.995	344.255	596596.0
2019-02-05	ABR	Stock	12.0	12.0	11.91	11.94	1049900.0
2019-02-05	ABR.A-DELISTED	Stock	25.601	25.75	25.601	25.75	4600.0
2019-02-05	ABR.C-DELISTED	Stock	25.6	25.7	25.57	25.57	4940.0
2019-02-05	ABT	Stock	72.9	73.29	72.68	73.11	4302400.0
2019-02-05	ABTC	Stock	304500.0	305100.0	304200.0	304350.0	0.4266666666666667
2019-02-05	ABTS	Stock	40.725	48.75	40.5	41.625	748.0

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

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