PREVIEW / stock_daily / 2019-03-14

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-14.parquet
  size:    219 KB
  rows:    6,516
  symbols: 2,607

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-03-14	AAPL	Stock	45.975	46.025	45.64	45.9325	94318000.0
2019-03-14	MSFT	Stock	114.54	115.2	114.33	114.59	30763400.0
2019-03-14	NVDA	Stock	4.2248	4.2368	4.1313	4.139	519384000.0
2019-03-14	AMZN	Stock	84.56	85.1	84.217	84.311	58932000.0
2019-03-14	GOOGL	Stock	59.951	60.235	59.5615	59.6265	27301440.0
2019-03-14	META	Stock	169.76	171.15	168.16	170.17	18037400.0
2019-03-14	TSLA	Stock	19.4967	19.6927	19.2193	19.3307	106551000.0
2019-03-14	TLT	Stock	121.69	121.76	120.92	120.95	8188564.0
2019-03-14	ES	Stock	70.75	71.27	70.38	70.92	1977800.0
2019-03-14	CL	Stock	66.44	66.65	66.06	66.25	3293700.0
2019-03-14	A	Stock	80.06	80.67	80.06	80.61	1268500.0
2019-03-14	AA	Stock	28.79	28.84	27.81	27.89	3701400.0
2019-03-14	AABA-DELISTED	Stock	73.31	73.79	72.82	73.5	3544996.0
2019-03-14	AAC-DELISTED	Stock	2.73	2.735	2.63	2.63	55521.0
2019-03-14	AACG	Stock	1.06	1.11	1.06	1.08	29900.0
2019-03-14	AAIC-DELISTED	Stock	8.24	8.32	8.226	8.25	396482.0
2019-03-14	AAIC.C-DELISTED	Stock	23.55	23.7299	23.49	23.52	27286.0
2019-03-14	AAL	Stock	31.96	32.47	31.88	32.13	6454500.0
2019-03-14	AAM.A-DELISTED	Stock	25.01	25.0446	24.95	24.9995	16486.0
2019-03-14	AAM.B-DELISTED	Stock	24.776	24.86	24.77	24.82	22363.0
2019-03-14	AAMC-DELISTED	Stock	10.2912	10.6912	10.2912	10.6912	3386.0
2019-03-14	AAME	Stock	2.7	2.7	2.7	2.7	200.0
2019-03-14	AAMI	Stock	13.68	13.79	13.495	13.53	264000.0
2019-03-14	AAOI	Stock	14.13	14.5	13.75	13.84	707100.0
2019-03-14	AAON	Stock	27.9467	28.0467	27.3733	27.46	146700.0
2019-03-14	AAP	Stock	155.06	155.2	153.04	154.0	683400.0
2019-03-14	AAT	Stock	46.49	46.62	45.92	46.12	206600.0
2019-03-14	AAU-DELISTED	Stock	0.62	0.6237	0.59	0.59	108627.0
2019-03-14	AAUAF-DELISTED	Stock	0.62	0.6237	0.59	0.6	116396.0
2019-03-14	AAWW-DELISTED	Stock	49.78	50.68	49.4474	50.43	149828.0
2019-03-14	AAXJ	Stock	69.46	69.48	69.155	69.36	698126.0
2019-03-14	AAXN-DELISTED	Stock	47.69	48.0307	47.01	47.05	504816.0
2019-03-14	AB	Stock	29.15	29.56	29.08	29.14	158200.0
2019-03-14	ABB-DELISTED	Stock	19.15	19.2438	19.07	19.185	1430529.0
2019-03-14	ABBNY-DELISTED	Stock	19.15	19.2438	19.07	19.18	1500627.0
2019-03-14	ABBV	Stock	79.0	80.4	78.41	79.95	6161800.0
2019-03-14	ABC-DELISTED	Stock	79.62	80.26	79.07	79.5	1110012.0
2019-03-14	ABCB	Stock	38.39	38.39	37.93	38.17	322400.0
2019-03-14	ABDC-DELISTED	Stock	7.69	7.73	7.59	7.63	36379.0
2019-03-14	ABEO	Stock	185.0	190.5	183.75	185.5	10936.0
2019-03-14	ABEV	Stock	4.32	4.38	4.27	4.29	23522900.0
2019-03-14	ABG	Stock	68.52	68.72	67.79	67.85	83500.0
2019-03-14	ABIL-DELISTED	Stock	1.83	2.05	1.81	1.98	657176.0
2019-03-14	ABM	Stock	33.86	34.18	33.56	33.91	332100.0
2019-03-14	ABMD-DELISTED	Stock	325.39	326.7674	322.44	325.7	148023.0
2019-03-14	ABR	Stock	12.8	12.85	12.69	12.74	1069700.0
2019-03-14	ABR.A-DELISTED	Stock	25.6	25.6	25.5	25.5985	700.0
2019-03-14	ABR.B-DELISTED	Stock	25.99	25.99	25.33	25.5232	6806.0
2019-03-14	ABR.C-DELISTED	Stock	25.85	25.85	25.76	25.76	500.0
2019-03-14	ABT	Stock	78.5	79.07	78.14	78.98	5734500.0

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

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