PREVIEW / stock_daily / 2019-07-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-12.parquet
  size:    220 KB
  rows:    6,557
  symbols: 2,529

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-07-12	AAPL	Stock	50.6125	51.0	50.55	50.825	70380800.0
2019-07-12	MSFT	Stock	138.85	139.13	138.01	138.9	18936800.0
2019-07-12	NVDA	Stock	4.185	4.2618	4.185	4.1903	506392000.0
2019-07-12	AMZN	Stock	100.4135	100.85	100.1935	100.55	50186000.0
2019-07-12	GOOGL	Stock	57.1465	57.375	56.928	57.267	21878660.0
2019-07-12	META	Stock	199.68	205.3	199.16	204.87	15366300.0
2019-07-12	TSLA	Stock	15.9833	16.3587	15.9807	16.3387	138007500.0
2019-07-12	TLT	Stock	129.92	130.45	129.68	130.22	6992095.0
2019-07-12	ES	Stock	77.96	78.06	77.27	77.54	1868300.0
2019-07-12	CL	Stock	73.99	74.43	73.56	74.38	2937500.0
2019-07-12	A	Stock	71.28	72.27	70.83	71.65	2542400.0
2019-07-12	AA	Stock	22.51	22.81	22.365	22.6	2217000.0
2019-07-12	AABA-DELISTED	Stock	69.37	69.9716	69.3	69.75	1931468.0
2019-07-12	AAC-DELISTED	Stock	1.29	1.2918	1.17	1.2	136188.0
2019-07-12	AACG	Stock	2.55	2.63	2.51	2.61	61400.0
2019-07-12	AAIC-DELISTED	Stock	6.47	6.53	6.47	6.48	318701.0
2019-07-12	AAIC.C-DELISTED	Stock	21.96	22.003	21.8766	21.96	6310.0
2019-07-12	AAL	Stock	33.12	33.9	33.0	33.78	5012200.0
2019-07-12	AAM.A-DELISTED	Stock	25.8285	25.93	25.8285	25.8483	19150.0
2019-07-12	AAM.B-DELISTED	Stock	25.9554	26.02	25.95	26.0	47443.0
2019-07-12	AAMC-DELISTED	Stock	3.5294	3.5294	3.3824	3.3824	2118.0
2019-07-12	AAME	Stock	2.39	2.39	2.29	2.29	1300.0
2019-07-12	AAMI	Stock	11.45	11.59	11.42	11.54	272100.0
2019-07-12	AAOI	Stock	9.92	10.055	9.815	9.97	424200.0
2019-07-12	AAON	Stock	33.2933	34.46	33.2933	34.16	230550.0
2019-07-12	AAP	Stock	156.24	159.11	155.89	158.58	648600.0
2019-07-12	AAT	Stock	47.6	47.71	47.22	47.45	259100.0
2019-07-12	AAU-DELISTED	Stock	0.6589	0.6589	0.64	0.6464	68442.0
2019-07-12	AAUAF-DELISTED	Stock	0.6589	0.6589	0.64	0.6464	72037.0
2019-07-12	AAWW-DELISTED	Stock	41.1	43.33	41.1	42.89	137375.0
2019-07-12	AAXJ	Stock	69.37	69.46	69.205	69.38	687808.0
2019-07-12	AAXN-DELISTED	Stock	62.9	64.73	61.88	64.51	760989.0
2019-07-12	AB	Stock	30.75	30.95	30.3	30.49	204000.0
2019-07-12	ABB-DELISTED	Stock	18.82	18.92	18.7931	18.9	1437748.0
2019-07-12	ABBNY-DELISTED	Stock	18.82	18.92	18.7931	18.91	1852572.0
2019-07-12	ABBV	Stock	70.3	70.3	68.54	70.28	12903000.0
2019-07-12	ABC-DELISTED	Stock	90.4	91.3	88.87	89.85	1206833.0
2019-07-12	ABCB	Stock	38.97	39.21	38.54	38.95	438400.0
2019-07-12	ABDC-DELISTED	Stock	8.31	8.35	8.3	8.3	12803.0
2019-07-12	ABEO	Stock	108.25	108.75	103.25	104.5	18784.0
2019-07-12	ABEV	Stock	4.9	4.93	4.83	4.84	50633800.0
2019-07-12	ABG	Stock	84.41	85.57	84.07	84.5	113800.0
2019-07-12	ABIL-DELISTED	Stock	0.9208	0.94	0.8894	0.9	37543.0
2019-07-12	ABM	Stock	40.84	41.39	40.8	41.19	271900.0
2019-07-12	ABMD-DELISTED	Stock	264.5	265.48	257.25	262.68	258929.0
2019-07-12	ABR	Stock	12.35	12.49	12.35	12.42	913400.0
2019-07-12	ABR.A-DELISTED	Stock	26.1051	26.1051	25.95	25.9517	2055.0
2019-07-12	ABR.C-DELISTED	Stock	26.0625	26.14	26.0	26.0494	4157.0
2019-07-12	ABT	Stock	85.28	85.44	83.06	83.92	5667200.0
2019-07-12	ABTC	Stock	425700.0	442200.0	394500.0	413700.0	18.133333333333333

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

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