PREVIEW / stock_daily / 2019-02-14

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-14.parquet
  size:    219 KB
  rows:    6,506
  symbols: 2,605

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-14	AAPL	Stock	42.4275	42.815	42.345	42.7	87342800.0
2019-02-14	MSFT	Stock	106.31	107.29	105.66	106.9	21784700.0
2019-02-14	NVDA	Stock	3.821	3.8918	3.7775	3.8632	827264000.0
2019-02-14	AMZN	Stock	81.225	81.895	80.303	81.1325	82410000.0
2019-02-14	GOOGL	Stock	56.25	56.8065	55.8545	56.46	21105940.0
2019-02-14	META	Stock	163.19	164.87	162.25	163.95	12755200.0
2019-02-14	TSLA	Stock	20.2253	20.4513	20.0667	20.2513	78012000.0
2019-02-14	TLT	Stock	122.14	122.2	121.58	121.79	5868918.0
2019-02-14	ES	Stock	70.19	70.48	69.73	70.1	1735000.0
2019-02-14	CL	Stock	65.63	65.86	65.33	65.45	2501500.0
2019-02-14	A	Stock	77.0	77.28	76.52	77.02	1618100.0
2019-02-14	AA	Stock	28.73	28.75	28.15	28.2	3196600.0
2019-02-14	AABA-DELISTED	Stock	68.54	68.8	68.18	68.62	5256541.0
2019-02-14	AAC-DELISTED	Stock	3.01	3.09	2.9	2.9652	188688.0
2019-02-14	AACG	Stock	1.02	1.04	1.02	1.03	48100.0
2019-02-14	AAIC-DELISTED	Stock	8.82	8.87	8.65	8.82	283688.0
2019-02-14	AAL	Stock	35.91	36.53	35.67	36.11	4070000.0
2019-02-14	AAM.A-DELISTED	Stock	24.89	24.96	24.8374	24.89	19302.0
2019-02-14	AAM.B-DELISTED	Stock	24.55	24.65	24.528	24.528	24705.0
2019-02-14	AAMC-DELISTED	Stock	10.1294	10.1382	10.1294	10.1382	1404.0
2019-02-14	AAME	Stock	2.74	2.74	2.73	2.73	2900.0
2019-02-14	AAMI	Stock	14.19	14.29	13.86	13.87	752400.0
2019-02-14	AAOI	Stock	14.83	14.98	14.37	14.72	820700.0
2019-02-14	AAON	Stock	25.9333	26.0333	25.3467	25.64	239400.0
2019-02-14	AAP	Stock	165.92	169.75	164.25	168.74	720000.0
2019-02-14	AAT	Stock	43.89	44.15	43.16	43.73	211400.0
2019-02-14	AAU-DELISTED	Stock	0.7	0.7087	0.69	0.7084	138019.0
2019-02-14	AAUAF-DELISTED	Stock	0.7	0.7103	0.69	0.7103	143841.0
2019-02-14	AAWW-DELISTED	Stock	53.63	54.66	52.88	54.28	214013.0
2019-02-14	AAXJ	Stock	68.37	68.795	68.16	68.59	753962.0
2019-02-14	AAXN-DELISTED	Stock	53.36	54.77	53.35	54.6	237907.0
2019-02-14	AB	Stock	29.96	30.19	29.4	29.84	914200.0
2019-02-14	ABB-DELISTED	Stock	19.34	19.51	19.29	19.34	2511848.0
2019-02-14	ABBNY-DELISTED	Stock	19.34	19.51	19.29	19.35	2811794.0
2019-02-14	ABBV	Stock	80.45	80.68	79.72	80.52	3436300.0
2019-02-14	ABC-DELISTED	Stock	86.02	86.97	85.52	86.45	601411.0
2019-02-14	ABCB	Stock	38.68	38.9	38.16	38.29	297200.0
2019-02-14	ABDC-DELISTED	Stock	7.33	7.53	7.33	7.37	35908.0
2019-02-14	ABEO	Stock	164.5	167.75	158.25	162.5	14740.0
2019-02-14	ABEV	Stock	4.82	4.98	4.8	4.95	54849400.0
2019-02-14	ABG	Stock	69.83	70.67	69.2	69.99	211200.0
2019-02-14	ABIL-DELISTED	Stock	1.91	1.9432	1.87	1.918	51977.0
2019-02-14	ABM	Stock	36.35	36.4	35.85	35.96	349100.0
2019-02-14	ABMD-DELISTED	Stock	357.61	361.02	353.95	357.89	194760.0
2019-02-14	ABR	Stock	11.91	11.97	11.86	11.86	647800.0
2019-02-14	ABR.A-DELISTED	Stock	25.25	25.25	25.075	25.17	2947.0
2019-02-14	ABR.C-DELISTED	Stock	25.3	25.3	25.1	25.12	7513.0
2019-02-14	ABT	Stock	74.08	74.36	73.74	73.97	4864500.0
2019-02-14	ABTC	Stock	304200.0	304200.0	303000.0	303330.0	0.5866666666666667
2019-02-14	ABTS	Stock	41.25	41.25	33.75	37.5	977.0

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

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