PREVIEW / stock_daily / 2019-07-10

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-10.parquet
  size:    222 KB
  rows:    6,590
  symbols: 2,551

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-10	AAPL	Stock	50.4625	50.9325	50.39	50.8075	71588400.0
2019-07-10	MSFT	Stock	137.13	138.58	137.02	137.85	24204400.0
2019-07-10	NVDA	Stock	3.9765	4.0593	3.9625	4.0015	452076000.0
2019-07-10	AMZN	Stock	99.8255	101.247	99.77	100.8705	98638000.0
2019-07-10	GOOGL	Stock	56.616	57.117	56.533	57.0455	30710920.0
2019-07-10	META	Stock	200.0	202.96	199.67	202.73	20571700.0
2019-07-10	TSLA	Stock	15.61	15.9293	15.5427	15.928	137185500.0
2019-07-10	TLT	Stock	132.35	132.435	131.51	131.83	9470193.0
2019-07-10	ES	Stock	77.22	77.92	76.9	77.67	1334600.0
2019-07-10	CL	Stock	73.42	74.08	73.4	73.49	2392300.0
2019-07-10	A	Stock	73.58	73.94	73.13	73.37	1785200.0
2019-07-10	AA	Stock	22.46	22.955	22.14	22.61	3425000.0
2019-07-10	AABA-DELISTED	Stock	70.03	70.09	69.18	69.29	2269114.0
2019-07-10	AAC-DELISTED	Stock	1.26	1.31	1.18	1.25	240400.0
2019-07-10	AACG	Stock	2.45	2.64	2.45	2.57	93600.0
2019-07-10	AAIC-DELISTED	Stock	6.3	6.37	6.24	6.36	553528.0
2019-07-10	AAIC.C-DELISTED	Stock	21.85	22.02	21.749	21.83	13462.0
2019-07-10	AAL	Stock	32.93	33.69	32.59	32.94	8869700.0
2019-07-10	AAM.A-DELISTED	Stock	25.93	25.93	25.75	25.76	25137.0
2019-07-10	AAM.B-DELISTED	Stock	26.05	26.05	25.87	25.87	27348.0
2019-07-10	AAMC-DELISTED	Stock	3.5765	3.8235	3.5206	3.5206	10469.0
2019-07-10	AAME	Stock	2.34	2.41	2.26	2.29	2400.0
2019-07-10	AAMI	Stock	11.91	11.98	11.585	11.62	388500.0
2019-07-10	AAOI	Stock	10.84	11.095	10.18	10.31	1013400.0
2019-07-10	AAON	Stock	33.5333	34.22	33.4533	34.02	190650.0
2019-07-10	AAP	Stock	155.59	156.81	154.59	156.43	833700.0
2019-07-10	AAT	Stock	48.06	48.3	47.85	48.22	459700.0
2019-07-10	AAU-DELISTED	Stock	0.65	0.661	0.6301	0.661	310618.0
2019-07-10	AAUAF-DELISTED	Stock	0.65	0.661	0.6301	0.661	319894.0
2019-07-10	AAWW-DELISTED	Stock	41.85	42.6238	41.0	41.35	96171.0
2019-07-10	AAXJ	Stock	69.49	69.67	69.21	69.3	2141000.0
2019-07-10	AAXN-DELISTED	Stock	63.32	64.16	63.22	63.31	695795.0
2019-07-10	AB	Stock	30.13	30.5	29.8	30.37	213600.0
2019-07-10	ABB-DELISTED	Stock	18.87	18.96	18.71	18.73	1742576.0
2019-07-10	ABBNY-DELISTED	Stock	18.87	18.96	18.71	18.73	2109144.0
2019-07-10	ABBV	Stock	71.58	71.74	70.96	71.65	9170400.0
2019-07-10	ABC-DELISTED	Stock	88.83	89.77	88.1	89.3	1219618.0
2019-07-10	ABCB	Stock	38.89	38.99	38.47	38.66	515000.0
2019-07-10	ABDC-DELISTED	Stock	8.35	8.39	8.29	8.32	16191.0
2019-07-10	ABEO	Stock	108.75	110.0	104.0	107.25	21284.0
2019-07-10	ABEV	Stock	5.07	5.07	4.98	5.05	36500500.0
2019-07-10	ABG	Stock	84.83	85.59	83.45	83.83	106500.0
2019-07-10	ABIL-DELISTED	Stock	0.915	0.9298	0.892	0.92	15107.0
2019-07-10	ABM	Stock	40.62	40.93	40.43	40.59	167300.0
2019-07-10	ABMD-DELISTED	Stock	257.67	262.15	255.56	255.77	272603.0
2019-07-10	ABR	Stock	12.36	12.43	12.33	12.33	824700.0
2019-07-10	ABR.A-DELISTED	Stock	25.9909	26.0037	25.97	25.97	3862.0
2019-07-10	ABR.B-DELISTED	Stock	25.81	25.81	25.681	25.785	3100.0
2019-07-10	ABR.C-DELISTED	Stock	26.25	26.25	26.25	26.25	100.0
2019-07-10	ABT	Stock	85.68	85.88	85.15	85.38	4315900.0

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

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