PREVIEW / stock_daily / 2019-05-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-15.parquet
  size:    220 KB
  rows:    6,575
  symbols: 2,589

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-05-15	AAPL	Stock	46.5675	47.9375	46.505	47.73	106178800.0
2019-05-15	MSFT	Stock	124.26	126.71	123.7	126.02	24722700.0
2019-05-15	NVDA	Stock	3.995	4.0262	3.9352	3.9895	502320000.0
2019-05-15	AMZN	Stock	91.3975	93.7215	91.15	93.5575	93852000.0
2019-05-15	GOOGL	Stock	56.1275	58.915	56.07	58.54	59302340.0
2019-05-15	META	Stock	180.42	187.28	180.02	186.27	16746900.0
2019-05-15	TSLA	Stock	15.288	15.496	15.0167	15.4633	109440000.0
2019-05-15	TLT	Stock	126.21	126.27	125.77	126.13	9566544.0
2019-05-15	ES	Stock	72.67	73.04	72.41	72.6	1067100.0
2019-05-15	CL	Stock	71.18	71.43	70.99	71.34	4454400.0
2019-05-15	A	Stock	67.36	69.9	66.24	67.64	14523800.0
2019-05-15	AA	Stock	24.64	25.14	24.533	25.01	2739700.0
2019-05-15	AABA-DELISTED	Stock	71.0	72.29	69.625	71.35	6470582.0
2019-05-15	AAC-DELISTED	Stock	1.53	1.72	1.5	1.655	387582.0
2019-05-15	AACG	Stock	2.25	2.48	2.23	2.38	338300.0
2019-05-15	AAIC-DELISTED	Stock	7.57	7.64	7.505	7.61	195037.0
2019-05-15	AAIC.C-DELISTED	Stock	23.2903	23.63	23.0201	23.63	5669.0
2019-05-15	AAL	Stock	32.03	32.42	31.55	32.16	4518600.0
2019-05-15	AAM.A-DELISTED	Stock	25.55	25.7368	25.55	25.73	19520.0
2019-05-15	AAM.B-DELISTED	Stock	25.6694	25.76	25.611	25.76	14056.0
2019-05-15	AAME	Stock	2.45	2.45	2.45	2.45	100.0
2019-05-15	AAMI	Stock	12.41	12.42	12.055	12.19	830500.0
2019-05-15	AAOI	Stock	10.25	10.43	9.99	10.01	601800.0
2019-05-15	AAON	Stock	30.7467	31.1733	30.4733	31.0933	205800.0
2019-05-15	AAP	Stock	154.84	155.95	153.25	155.83	783000.0
2019-05-15	AAT	Stock	45.74	46.18	45.51	45.99	150500.0
2019-05-15	AAU-DELISTED	Stock	0.478	0.4995	0.4523	0.498	124741.0
2019-05-15	AAUAF-DELISTED	Stock	0.478	0.4995	0.4523	0.498	130227.0
2019-05-15	AAWW-DELISTED	Stock	40.34	40.3495	39.61	40.23	182598.0
2019-05-15	AAXJ	Stock	67.32	67.85	67.24	67.8	1285903.0
2019-05-15	AAXN-DELISTED	Stock	65.38	65.94	64.5	65.4	399537.0
2019-05-15	AB	Stock	29.07	29.25	28.77	28.96	213500.0
2019-05-15	ABB-DELISTED	Stock	18.51	18.8968	18.48	18.86	1339940.0
2019-05-15	ABBNY-DELISTED	Stock	18.51	18.8968	18.48	18.86	1415071.0
2019-05-15	ABBV	Stock	78.51	79.15	77.48	78.78	4795700.0
2019-05-15	ABC-DELISTED	Stock	76.29	77.96	75.18	77.86	1060831.0
2019-05-15	ABCB	Stock	36.33	36.61	35.82	36.02	331200.0
2019-05-15	ABDC-DELISTED	Stock	8.38	8.48	8.35	8.42	34682.0
2019-05-15	ABEO	Stock	180.5	187.75	176.75	182.0	24916.0
2019-05-15	ABEOW-DELISTED	Stock	2.75	2.75	2.74	2.74	1359.0
2019-05-15	ABEV	Stock	4.16	4.2	4.14	4.14	22853300.0
2019-05-15	ABG	Stock	78.98	80.13	78.73	79.62	76000.0
2019-05-15	ABIL-DELISTED	Stock	1.26	1.34	1.2408	1.2901	121390.0
2019-05-15	ABM	Stock	37.5	38.2	37.5	38.01	225300.0
2019-05-15	ABMD-DELISTED	Stock	254.5	261.385	252.17	259.62	239384.0
2019-05-15	ABR	Stock	13.24	13.47	13.17	13.45	1170200.0
2019-05-15	ABR.A-DELISTED	Stock	25.66	25.9118	25.4041	25.68	4200.0
2019-05-15	ABR.B-DELISTED	Stock	25.6519	25.89	25.6519	25.89	1035.0
2019-05-15	ABR.C-DELISTED	Stock	26.0167	26.1455	26.0	26.1455	1800.0
2019-05-15	ABT	Stock	75.5	77.02	75.22	76.51	4385500.0

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

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