PREVIEW / stock_daily / 2019-07-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-22.parquet
  size:    221 KB
  rows:    6,605
  symbols: 2,552

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-22	AAPL	Stock	50.9125	51.8075	50.9025	51.805	89111600.0
2019-07-22	MSFT	Stock	137.41	139.19	137.33	138.43	25074900.0
2019-07-22	NVDA	Stock	4.2325	4.296	4.225	4.283	315940000.0
2019-07-22	AMZN	Stock	98.557	99.45	97.913	99.2815	58000000.0
2019-07-22	GOOGL	Stock	56.7735	57.001	56.2605	56.9605	28935140.0
2019-07-22	META	Stock	199.91	202.57	198.81	202.32	13589000.0
2019-07-22	TSLA	Stock	17.25	17.4767	16.946	17.0453	102636000.0
2019-07-22	TLT	Stock	132.47	132.49	131.7439	131.94	5204504.0
2019-07-22	ES	Stock	76.95	77.17	75.93	76.91	1117300.0
2019-07-22	CL	Stock	72.84	72.98	72.1	72.35	2945000.0
2019-07-22	A	Stock	68.91	69.47	68.46	69.09	3103300.0
2019-07-22	AA	Stock	23.18	23.39	22.695	22.98	3719200.0
2019-07-22	AABA-DELISTED	Stock	70.3	70.78	70.15	70.54	1912944.0
2019-07-22	AAC-DELISTED	Stock	0.97	1.02	0.88	0.9055	122303.0
2019-07-22	AACG	Stock	2.62	2.78	2.62	2.62	55400.0
2019-07-22	AAIC-DELISTED	Stock	6.59	6.65	6.52	6.64	356766.0
2019-07-22	AAIC.C-DELISTED	Stock	22.6896	22.84	22.59	22.7795	3883.0
2019-07-22	AAL	Stock	33.22	33.42	32.85	32.9	4005600.0
2019-07-22	AAM.A-DELISTED	Stock	26.18	26.18	26.09	26.12	9625.0
2019-07-22	AAM.B-DELISTED	Stock	26.34	26.3857	26.295	26.33	7295.0
2019-07-22	AAMC-DELISTED	Stock	3.4164	3.4971	3.0915	3.2647	13828.0
2019-07-22	AAME	Stock	2.43	2.48	2.43	2.48	1500.0
2019-07-22	AAMI	Stock	11.06	11.18	10.73	10.91	307200.0
2019-07-22	AAOI	Stock	9.63	9.65	9.01	9.09	795400.0
2019-07-22	AAON	Stock	34.2667	34.6133	33.6667	33.7333	136950.0
2019-07-22	AAP	Stock	157.28	160.17	157.24	158.9	840800.0
2019-07-22	AAT	Stock	45.85	46.12	45.47	45.82	305000.0
2019-07-22	AAU-DELISTED	Stock	0.63	0.75	0.63	0.75	828307.0
2019-07-22	AAUAF-DELISTED	Stock	0.63	0.75	0.63	0.75	873749.0
2019-07-22	AAWW-DELISTED	Stock	42.9	43.0	42.16	42.44	97606.0
2019-07-22	AAXJ	Stock	69.75	69.84	69.62	69.73	953069.0
2019-07-22	AAXN-DELISTED	Stock	65.8	66.44	65.1	65.37	245133.0
2019-07-22	AB	Stock	30.13	30.3	29.78	29.89	173200.0
2019-07-22	ABB-DELISTED	Stock	18.9	19.0	18.89	18.99	1415814.0
2019-07-22	ABBNY-DELISTED	Stock	18.9	19.0	18.89	18.99	3309884.0
2019-07-22	ABBV	Stock	68.5	68.75	67.84	68.0	9961800.0
2019-07-22	ABC-DELISTED	Stock	85.85	86.18	84.93	85.04	623252.0
2019-07-22	ABCB	Stock	37.76	37.93	37.09	37.3	272700.0
2019-07-22	ABDC-DELISTED	Stock	8.35	8.35	8.3001	8.33	3037.0
2019-07-22	ABEO	Stock	93.0	94.5	91.0	93.0	11184.0
2019-07-22	ABEOW-DELISTED	Stock	0.5	0.5	0.5	0.5	500.0
2019-07-22	ABEV	Stock	4.85	4.86	4.76	4.77	20402300.0
2019-07-22	ABG	Stock	84.43	85.43	83.82	84.49	65000.0
2019-07-22	ABIL-DELISTED	Stock	0.87	0.8725	0.85	0.8699	19193.0
2019-07-22	ABM	Stock	41.47	41.64	40.95	41.05	238600.0
2019-07-22	ABMD-DELISTED	Stock	260.7	270.25	260.7	263.97	299917.0
2019-07-22	ABR	Stock	12.11	12.14	12.04	12.07	762900.0
2019-07-22	ABR.A-DELISTED	Stock	26.13	26.13	26.0449	26.0925	3491.0
2019-07-22	ABR.B-DELISTED	Stock	25.79	25.79	25.73	25.73	1143.0
2019-07-22	ABR.C-DELISTED	Stock	26.4223	26.4659	26.4223	26.4605	515.0

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

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