PREVIEW / stock_daily / 2019-01-29

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-29.parquet
  size:    219 KB
  rows:    6,532
  symbols: 2,653

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-01-29	AAPL	Stock	39.0625	39.5325	38.5275	38.67	166348800.0
2019-01-29	MSFT	Stock	104.88	104.97	102.17	102.94	31490500.0
2019-01-29	NVDA	Stock	3.4038	3.4525	3.2752	3.29	1153932000.0
2019-01-29	AMZN	Stock	81.5635	81.619	79.536	79.694	92656000.0
2019-01-29	GOOGL	Stock	54.052	54.2365	53.301	53.503	19704960.0
2019-01-29	META	Stock	148.09	148.1	143.43	144.19	17632100.0
2019-01-29	TSLA	Stock	19.6847	19.904	19.4533	19.8307	69325500.0
2019-01-29	TLT	Stock	120.53	121.04	120.39	121.02	5750177.0
2019-01-29	ES	Stock	67.33	67.77	67.11	67.35	1490100.0
2019-01-29	CL	Stock	62.7	63.8	62.7	63.69	4593100.0
2019-01-29	A	Stock	73.7	74.06	73.2	73.56	1684500.0
2019-01-29	AA	Stock	28.27	29.565	28.163	28.75	3565700.0
2019-01-29	AABA-DELISTED	Stock	65.08	65.61	64.32	64.81	5464125.0
2019-01-29	AAC-DELISTED	Stock	2.22	2.34	2.02	2.26	278010.0
2019-01-29	AACG	Stock	1.03	1.05	1.0	1.05	9100.0
2019-01-29	AAIC-DELISTED	Stock	8.5	8.595	8.4599	8.54	226609.0
2019-01-29	AAL	Stock	36.76	37.08	36.07	36.29	8744300.0
2019-01-29	AAM.A-DELISTED	Stock	24.57	24.57	24.46	24.485	23515.0
2019-01-29	AAM.B-DELISTED	Stock	24.46	24.49	24.4272	24.45	18927.0
2019-01-29	AAMC-DELISTED	Stock	7.9412	7.9412	7.8824	7.9412	6195.0
2019-01-29	AAME	Stock	2.66	2.66	2.66	2.66	200.0
2019-01-29	AAMI	Stock	12.42	12.52	12.23	12.46	735200.0
2019-01-29	AAOI	Stock	16.93	17.19	16.79	16.85	411800.0
2019-01-29	AAON	Stock	23.74	24.1	23.5733	23.9867	92250.0
2019-01-29	AAP	Stock	154.15	155.45	151.75	155.39	1076200.0
2019-01-29	AAT	Stock	41.83	42.26	41.57	42.23	269000.0
2019-01-29	AAU-DELISTED	Stock	0.7762	0.7762	0.7434	0.7528	119344.0
2019-01-29	AAUAF-DELISTED	Stock	0.7762	0.7762	0.7434	0.7528	120362.0
2019-01-29	AAWW-DELISTED	Stock	51.49	51.5	50.835	51.28	133634.0
2019-01-29	AAXJ	Stock	67.41	67.42	66.99	67.09	1692731.0
2019-01-29	AAXN-DELISTED	Stock	49.14	49.96	48.92	49.06	200261.0
2019-01-29	AB	Stock	30.37	30.5	30.13	30.14	182300.0
2019-01-29	ABB-DELISTED	Stock	19.17	19.25	19.02	19.025	3526256.0
2019-01-29	ABBNY-DELISTED	Stock	19.17	19.25	19.02	19.02	4735585.0
2019-01-29	ABBV	Stock	77.03	78.16	75.77	77.47	13909000.0
2019-01-29	ABC-DELISTED	Stock	80.04	80.11	78.52	79.54	846124.0
2019-01-29	ABCB	Stock	38.63	39.11	37.91	37.91	664500.0
2019-01-29	ABDC-DELISTED	Stock	6.85	7.04	6.8009	7.015	92365.0
2019-01-29	ABEO	Stock	173.25	174.75	161.25	161.5	21124.0
2019-01-29	ABEOW-DELISTED	Stock	2.51	2.51	2.51	2.51	200.0
2019-01-29	ABEV	Stock	4.77	4.79	4.69	4.75	37650100.0
2019-01-29	ABG	Stock	69.68	69.68	68.64	69.1	79100.0
2019-01-29	ABIL-DELISTED	Stock	2.09	2.12	2.0	2.02	291301.0
2019-01-29	ABM	Stock	33.86	33.99	33.19	33.35	521500.0
2019-01-29	ABMD-DELISTED	Stock	338.38	339.55	326.4844	330.4	265186.0
2019-01-29	ABR	Stock	11.57	11.72	11.52	11.65	852700.0
2019-01-29	ABR.A-DELISTED	Stock	25.79	25.79	25.65	25.65	353.0
2019-01-29	ABR.B-DELISTED	Stock	25.5492	25.5492	25.5492	25.5492	1000.0
2019-01-29	ABR.C-DELISTED	Stock	25.8608	25.8608	25.5524	25.648	4450.0
2019-01-29	ABT	Stock	69.09	69.94	68.8	69.69	5981600.0

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

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