PREVIEW / stock_daily / 2019-06-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-18.parquet
  size:    221 KB
  rows:    6,584
  symbols: 2,564

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-06-18	AAPL	Stock	49.0125	50.0725	48.8025	49.6125	106204000.0
2019-06-18	MSFT	Stock	134.19	135.24	133.57	135.16	25934500.0
2019-06-18	NVDA	Stock	3.6875	3.8778	3.6765	3.822	581920000.0
2019-06-18	AMZN	Stock	95.0675	96.0835	94.9895	95.0685	77914000.0
2019-06-18	GOOGL	Stock	55.575	55.939	55.0395	55.262	34526240.0
2019-06-18	META	Stock	194.0	194.53	187.28	188.47	37571400.0
2019-06-18	TSLA	Stock	15.248	15.6493	14.8373	14.9827	190737000.0
2019-06-18	TLT	Stock	132.74	132.86	131.945	132.35	10320696.0
2019-06-18	ES	Stock	77.22	77.22	75.88	76.29	1494500.0
2019-06-18	CL	Stock	73.98	74.06	72.68	72.89	2677100.0
2019-06-18	A	Stock	70.8	72.22	70.57	71.91	2350400.0
2019-06-18	AA	Stock	22.03	23.09	21.68	22.54	4550800.0
2019-06-18	AABA-DELISTED	Stock	68.0	69.76	67.79	68.64	5932464.0
2019-06-18	AAC-DELISTED	Stock	0.7121	0.8	0.6401	0.69	814528.0
2019-06-18	AACG	Stock	2.11	2.35	2.11	2.24	169400.0
2019-06-18	AAIC-DELISTED	Stock	6.96	7.025	6.84	6.96	493446.0
2019-06-18	AAIC.C-DELISTED	Stock	21.6	21.79	21.51	21.58	12491.0
2019-06-18	AAL	Stock	32.78	33.3	32.42	32.52	3789300.0
2019-06-18	AAM.A-DELISTED	Stock	25.78	25.9	25.78	25.84	22793.0
2019-06-18	AAM.B-DELISTED	Stock	25.94	25.9861	25.84	25.84	20455.0
2019-06-18	AAME	Stock	2.46	2.46	2.24	2.45	6200.0
2019-06-18	AAMI	Stock	10.76	11.01	10.74	10.75	169500.0
2019-06-18	AAOI	Stock	8.97	9.25	8.893	8.92	494400.0
2019-06-18	AAON	Stock	32.2067	32.7733	32.2067	32.3933	119250.0
2019-06-18	AAP	Stock	152.42	155.05	152.32	154.83	1194500.0
2019-06-18	AAT	Stock	47.7	47.81	46.6	46.96	648800.0
2019-06-18	AAU-DELISTED	Stock	0.55	0.55	0.5397	0.5498	86709.0
2019-06-18	AAUAF-DELISTED	Stock	0.55	0.55	0.5397	0.5498	90054.0
2019-06-18	AAWW-DELISTED	Stock	40.73	42.22	40.63	41.42	218547.0
2019-06-18	AAXJ	Stock	67.05	68.17	67.05	67.97	734139.0
2019-06-18	AAXN-DELISTED	Stock	69.58	71.22	65.51	66.0396	1406569.0
2019-06-18	AB	Stock	29.13	29.55	29.05	29.34	148800.0
2019-06-18	ABB-DELISTED	Stock	18.92	19.19	18.9	19.15	1535513.0
2019-06-18	ABBNY-DELISTED	Stock	18.92	19.19	18.9	19.15	1616830.0
2019-06-18	ABBV	Stock	78.88	79.2	77.01	78.25	5433500.0
2019-06-18	ABC-DELISTED	Stock	85.94	87.1	85.14	85.44	665763.0
2019-06-18	ABCB	Stock	37.73	38.82	37.73	38.19	465000.0
2019-06-18	ABDC-DELISTED	Stock	8.4001	8.5	8.4001	8.49	24757.0
2019-06-18	ABEO	Stock	139.0	140.0	124.5	125.25	50680.0
2019-06-18	ABEOW-DELISTED	Stock	1.19	1.19	1.16	1.16	2200.0
2019-06-18	ABEV	Stock	4.6	4.7	4.6	4.69	16551600.0
2019-06-18	ABG	Stock	81.03	82.9	81.03	82.73	125800.0
2019-06-18	ABIL-DELISTED	Stock	1.08	1.13	1.05	1.11	42763.0
2019-06-18	ABM	Stock	40.39	40.63	39.77	39.88	212300.0
2019-06-18	ABMD-DELISTED	Stock	258.12	262.67	256.24	256.39	282906.0
2019-06-18	ABR	Stock	12.39	12.48	12.31	12.34	1556000.0
2019-06-18	ABR.A-DELISTED	Stock	26.38	26.38	26.08	26.2121	4114.0
2019-06-18	ABR.B-DELISTED	Stock	26.22	26.22	25.87	25.87	1875.0
2019-06-18	ABR.C-DELISTED	Stock	26.1304	26.24	25.94	26.22	1900.0
2019-06-18	ABT	Stock	82.45	83.59	81.92	83.42	6253000.0

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

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