PREVIEW / stock_daily / 2019-04-24

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-24.parquet
  size:    220 KB
  rows:    6,527
  symbols: 2,572

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-24	AAPL	Stock	51.84	52.12	51.7625	51.79	70162400.0
2019-04-24	MSFT	Stock	125.79	125.85	124.52	125.01	31257000.0
2019-04-24	NVDA	Stock	4.7773	4.8203	4.716	4.7792	318204000.0
2019-04-24	AMZN	Stock	96.25	96.4845	94.908	95.0875	73516000.0
2019-04-24	GOOGL	Stock	63.5295	63.7	62.9905	63.0025	23395940.0
2019-04-24	META	Stock	184.49	185.14	181.65	182.58	37289900.0
2019-04-24	TSLA	Stock	17.59	17.688	17.2	17.244	160912500.0
2019-04-24	TLT	Stock	123.11	123.59	123.09	123.57	7302206.0
2019-04-24	ES	Stock	70.4	71.08	70.4	70.86	1431700.0
2019-04-24	CL	Stock	68.59	69.48	68.21	68.86	3600900.0
2019-04-24	A	Stock	75.84	76.63	75.43	75.79	1942700.0
2019-04-24	AA	Stock	28.49	28.54	27.75	28.12	3391200.0
2019-04-24	AABA-DELISTED	Stock	75.96	76.04	75.09	75.43	2490109.0
2019-04-24	AAC-DELISTED	Stock	1.61	1.61	1.49	1.545	193537.0
2019-04-24	AACG	Stock	2.38	2.4	2.32	2.34	152700.0
2019-04-24	AAIC-DELISTED	Stock	7.74	7.93	7.73	7.92	237128.0
2019-04-24	AAIC.C-DELISTED	Stock	23.3	23.3	23.03	23.29	56098.0
2019-04-24	AAL	Stock	33.92	34.49	33.9	33.99	3739800.0
2019-04-24	AAM.A-DELISTED	Stock	25.06	25.15	25.05	25.11	18797.0
2019-04-24	AAM.B-DELISTED	Stock	25.1	25.15	25.06	25.1	78706.0
2019-04-24	AAMC-DELISTED	Stock	8.5206	8.6206	8.5206	8.6206	1115.0
2019-04-24	AAME	Stock	2.5	2.5	2.43	2.43	5100.0
2019-04-24	AAMI	Stock	14.69	14.72	14.53	14.59	193500.0
2019-04-24	AAOI	Stock	12.4	12.81	12.24	12.78	493500.0
2019-04-24	AAON	Stock	32.66	32.9667	32.2	32.7867	183600.0
2019-04-24	AAP	Stock	173.29	173.93	171.76	171.86	915700.0
2019-04-24	AAT	Stock	45.34	45.95	45.26	45.95	384300.0
2019-04-24	AAU-DELISTED	Stock	0.55	0.5649	0.55	0.5522	88931.0
2019-04-24	AAUAF-DELISTED	Stock	0.55	0.5649	0.55	0.5522	90825.0
2019-04-24	AAWW-DELISTED	Stock	49.69	50.1462	49.17	49.66	157042.0
2019-04-24	AAXJ	Stock	72.44	72.56	71.91	72.11	1663734.0
2019-04-24	AAXN-DELISTED	Stock	62.93	64.0	62.34	62.53	243516.0
2019-04-24	AB	Stock	30.14	30.24	29.84	30.01	246600.0
2019-04-24	ABB-DELISTED	Stock	20.69	20.73	20.6	20.6	1648600.0
2019-04-24	ABBNY-DELISTED	Stock	20.69	20.73	20.6	20.61	1728957.0
2019-04-24	ABBV	Stock	79.23	79.59	78.44	78.67	7056400.0
2019-04-24	ABC-DELISTED	Stock	73.61	74.66	73.34	74.09	968207.0
2019-04-24	ABCB	Stock	35.28	35.75	34.98	35.39	424300.0
2019-04-24	ABDC-DELISTED	Stock	8.11	8.11	7.96	8.06	44628.0
2019-04-24	ABEO	Stock	206.75	208.0	197.5	207.0	9168.0
2019-04-24	ABEV	Stock	4.44	4.47	4.35	4.45	21714600.0
2019-04-24	ABG	Stock	79.0	80.86	78.12	79.44	348800.0
2019-04-24	ABIL-DELISTED	Stock	1.54	1.57	1.52	1.5669	50312.0
2019-04-24	ABM	Stock	37.85	37.92	37.48	37.71	219900.0
2019-04-24	ABMD-DELISTED	Stock	260.06	276.77	258.02	270.83	790554.0
2019-04-24	ABR	Stock	13.76	13.93	13.74	13.9	934400.0
2019-04-24	ABR.A-DELISTED	Stock	26.0351	26.39	25.9484	26.39	3987.0
2019-04-24	ABR.B-DELISTED	Stock	25.53	25.7	25.5	25.7	2622.0
2019-04-24	ABR.C-DELISTED	Stock	26.33	26.35	26.33	26.35	500.0
2019-04-24	ABT	Stock	76.05	76.87	75.67	76.75	6238400.0

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

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