PREVIEW / stock_daily / 2019-04-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-22.parquet
  size:    220 KB
  rows:    6,553
  symbols: 2,591

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-04-22	AAPL	Stock	50.7075	51.235	50.585	51.1325	77758000.0
2019-04-22	MSFT	Stock	122.62	124.0	122.57	123.76	15648700.0
2019-04-22	NVDA	Stock	4.6338	4.7275	4.602	4.7118	279936000.0
2019-04-22	AMZN	Stock	92.77	94.421	92.282	94.3655	67476000.0
2019-04-22	GOOGL	Stock	61.8335	62.717	61.6685	62.688	19088380.0
2019-04-22	META	Stock	178.25	181.67	178.25	181.44	13389900.0
2019-04-22	TSLA	Stock	17.9333	17.9787	17.4987	17.5167	182206500.0
2019-04-22	TLT	Stock	122.47	122.57	122.235	122.31	6241353.0
2019-04-22	ES	Stock	69.88	70.27	69.78	69.99	1880600.0
2019-04-22	CL	Stock	69.37	70.06	69.35	69.6	3901700.0
2019-04-22	A	Stock	75.93	76.72	75.13	75.57	2016000.0
2019-04-22	AA	Stock	26.52	28.24	26.52	28.14	6241200.0
2019-04-22	AABA-DELISTED	Stock	74.71	75.8	74.71	75.36	3100554.0
2019-04-22	AAC-DELISTED	Stock	1.61	1.63	1.4001	1.46	236534.0
2019-04-22	AACG	Stock	2.64	2.72	2.2	2.3	600700.0
2019-04-22	AAIC-DELISTED	Stock	7.59	7.69	7.55	7.69	400417.0
2019-04-22	AAIC.C-DELISTED	Stock	23.3	23.35	23.1835	23.3	13324.0
2019-04-22	AAL	Stock	34.1	34.2	33.42	33.48	3884200.0
2019-04-22	AAM.A-DELISTED	Stock	24.97	25.09	24.96	25.04	25308.0
2019-04-22	AAM.B-DELISTED	Stock	25.0	25.04	24.9	24.94	101224.0
2019-04-22	AAMC-DELISTED	Stock	8.6765	8.6765	8.6765	8.6765	2271.0
2019-04-22	AAME	Stock	2.5	2.58	2.5	2.57	2900.0
2019-04-22	AAMI	Stock	14.48	14.55	14.39	14.45	225700.0
2019-04-22	AAOI	Stock	12.46	12.54	12.06	12.37	630400.0
2019-04-22	AAON	Stock	31.5267	31.88	31.2733	31.86	143100.0
2019-04-22	AAP	Stock	174.45	175.39	169.73	170.08	878800.0
2019-04-22	AAT	Stock	44.55	44.67	43.13	43.69	222600.0
2019-04-22	AAU-DELISTED	Stock	0.55	0.5555	0.5305	0.5521	85157.0
2019-04-22	AAUAF-DELISTED	Stock	0.55	0.5555	0.5305	0.5521	88196.0
2019-04-22	AAWW-DELISTED	Stock	49.79	49.89	48.65	49.08	147808.0
2019-04-22	AAXJ	Stock	72.41	72.725	72.34	72.71	810453.0
2019-04-22	AAXN-DELISTED	Stock	59.82	61.02	59.59	60.78	260375.0
2019-04-22	AB	Stock	30.03	30.05	29.7	29.74	240300.0
2019-04-22	ABB-DELISTED	Stock	20.87	20.87	20.68	20.745	1687731.0
2019-04-22	ABBNY-DELISTED	Stock	20.87	20.87	20.68	20.74	1758069.0
2019-04-22	ABBV	Stock	77.6	79.1	77.5	78.15	5358600.0
2019-04-22	ABC-DELISTED	Stock	72.43	72.97	70.55	71.05	1095711.0
2019-04-22	ABCB	Stock	35.12	35.34	34.6	34.77	289300.0
2019-04-22	ABDC-DELISTED	Stock	7.85	8.12	7.8	8.02	68103.0
2019-04-22	ABEO	Stock	196.5	203.75	196.0	199.75	12348.0
2019-04-22	ABEV	Stock	4.33	4.48	4.33	4.43	24187500.0
2019-04-22	ABG	Stock	75.64	75.64	72.64	73.3	143300.0
2019-04-22	ABIL-DELISTED	Stock	1.57	1.601	1.28	1.5232	82978.0
2019-04-22	ABM	Stock	37.28	37.58	37.22	37.5	202400.0
2019-04-22	ABMD-DELISTED	Stock	255.7	263.785	254.5	261.015	654635.0
2019-04-22	ABR	Stock	13.69	13.69	13.58	13.6	1047800.0
2019-04-22	ABR.A-DELISTED	Stock	25.8582	25.98	25.8582	25.98	11550.0
2019-04-22	ABR.B-DELISTED	Stock	25.6285	25.6285	25.5647	25.5647	960.0
2019-04-22	ABR.C-DELISTED	Stock	26.39	26.59	26.347	26.59	6301.0
2019-04-22	ABT	Stock	73.13	74.6	73.0	74.51	5810700.0

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

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