PREVIEW / stock_daily / 2019-07-05

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-05.parquet
  size:    218 KB
  rows:    6,548
  symbols: 2,519

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-05	AAPL	Stock	50.8375	51.27	50.725	51.0575	69062000.0
2019-07-05	MSFT	Stock	135.94	137.33	135.72	137.06	18141100.0
2019-07-05	NVDA	Stock	4.01	4.0145	3.942	4.0058	396552000.0
2019-07-05	AMZN	Stock	96.43	97.295	96.265	97.1455	52568000.0
2019-07-05	GOOGL	Stock	55.9685	56.7325	55.875	56.6332	29793560.0
2019-07-05	META	Stock	196.18	197.07	194.17	196.4	11164100.0
2019-07-05	TSLA	Stock	15.638	15.6967	15.3867	15.54	105985500.0
2019-07-05	TLT	Stock	132.54	132.55	131.67	132.43	12180126.0
2019-07-05	ES	Stock	76.43	77.15	75.69	76.99	1487700.0
2019-07-05	CL	Stock	73.49	73.66	72.34	73.14	3771900.0
2019-07-05	A	Stock	76.34	76.47	75.3	75.75	1493100.0
2019-07-05	AA	Stock	22.25	23.245	22.22	23.13	2291900.0
2019-07-05	AABA-DELISTED	Stock	70.04	70.46	70.04	70.24	1692448.0
2019-07-05	AAC-DELISTED	Stock	1.09	1.14	0.9779	1.03	335846.0
2019-07-05	AACG	Stock	2.44	2.59	2.41	2.53	114300.0
2019-07-05	AAIC-DELISTED	Stock	6.43	6.48	6.365	6.44	377463.0
2019-07-05	AAIC.C-DELISTED	Stock	21.93	21.93	21.745	21.745	5500.0
2019-07-05	AAL	Stock	32.54	32.83	31.95	32.46	2583900.0
2019-07-05	AAM.A-DELISTED	Stock	25.76	25.796	25.66	25.75	10733.0
2019-07-05	AAM.B-DELISTED	Stock	26.04	26.04	25.8935	25.94	2381.0
2019-07-05	AAMC-DELISTED	Stock	3.5471	3.9999	3.5471	3.7059	28965.0
2019-07-05	AAME	Stock	2.27	2.4	2.27	2.39	3200.0
2019-07-05	AAMI	Stock	11.84	11.975	11.76	11.96	278100.0
2019-07-05	AAOI	Stock	9.88	9.93	9.62	9.85	265800.0
2019-07-05	AAON	Stock	32.5867	33.14	32.2	33.14	94950.0
2019-07-05	AAP	Stock	160.14	161.01	159.25	160.62	604400.0
2019-07-05	AAT	Stock	47.48	47.66	46.92	47.62	373300.0
2019-07-05	AAU-DELISTED	Stock	0.65	0.65	0.6	0.6126	166006.0
2019-07-05	AAUAF-DELISTED	Stock	0.65	0.65	0.6	0.6126	172649.0
2019-07-05	AAWW-DELISTED	Stock	41.43	42.54	41.35	42.32	122191.0
2019-07-05	AAXJ	Stock	69.85	69.89	69.53	69.88	3751374.0
2019-07-05	AAXN-DELISTED	Stock	63.9	64.48	63.18	64.06	394324.0
2019-07-05	AB	Stock	30.3	30.45	29.76	30.21	204500.0
2019-07-05	ABB-DELISTED	Stock	19.24	19.48	19.05	19.44	3284050.0
2019-07-05	ABBNY-DELISTED	Stock	19.24	19.48	19.05	19.44	4767310.0
2019-07-05	ABBV	Stock	74.65	74.79	72.61	72.99	10854900.0
2019-07-05	ABC-DELISTED	Stock	87.4	88.86	86.58	88.0	537782.0
2019-07-05	ABCB	Stock	39.38	39.63	38.98	39.36	359200.0
2019-07-05	ABDC-DELISTED	Stock	8.28	8.4126	8.2787	8.39	11082.0
2019-07-05	ABEO	Stock	115.5	117.75	113.0	114.0	32872.0
2019-07-05	ABEOW-DELISTED	Stock	0.95	0.95	0.95	0.95	1000.0
2019-07-05	ABEV	Stock	4.91	4.98	4.86	4.97	32598500.0
2019-07-05	ABG	Stock	84.93	85.03	83.79	83.91	59200.0
2019-07-05	ABIL-DELISTED	Stock	0.93	0.96	0.915	0.929	29553.0
2019-07-05	ABM	Stock	40.05	40.78	39.92	40.73	260500.0
2019-07-05	ABMD-DELISTED	Stock	260.31	262.66	257.63	261.45	228484.0
2019-07-05	ABR	Stock	12.18	12.33	12.15	12.33	1359900.0
2019-07-05	ABR.A-DELISTED	Stock	26.1227	26.13	26.06	26.074	1782.0
2019-07-05	ABR.B-DELISTED	Stock	25.82	25.85	25.8	25.8382	3700.0
2019-07-05	ABR.C-DELISTED	Stock	26.1107	26.15	26.1107	26.15	500.0

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

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