PREVIEW / stock_daily / 2019-08-09

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-09.parquet
  size:    220 KB
  rows:    6,590
  symbols: 2,510

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-08-09	AAPL	Stock	50.325	50.69	49.8225	50.2475	98478800.0
2019-08-09	MSFT	Stock	138.61	139.38	136.46	137.71	23466700.0
2019-08-09	NVDA	Stock	3.9152	3.9188	3.8038	3.8545	341816000.0
2019-08-09	AMZN	Stock	91.4475	91.5545	90.111	90.379	57596000.0
2019-08-09	GOOGL	Stock	59.9998	60.223	59.2445	59.445	20418900.0
2019-08-09	META	Stock	190.0	190.98	187.12	187.85	11058800.0
2019-08-09	TSLA	Stock	15.7367	15.9307	15.5873	15.6673	58473000.0
2019-08-09	TLT	Stock	140.67	141.55	139.87	140.05	10625972.0
2019-08-09	ES	Stock	78.64	78.88	78.15	78.43	1155000.0
2019-08-09	CL	Stock	71.8	72.09	70.96	71.52	2993200.0
2019-08-09	A	Stock	68.94	68.94	67.82	68.64	1866200.0
2019-08-09	AA	Stock	19.85	19.96	19.16	19.21	3068400.0
2019-08-09	AABA-DELISTED	Stock	69.67	70.16	69.66	70.02	2955852.0
2019-08-09	AAC-DELISTED	Stock	1.0	1.0	0.85	0.8756	145238.0
2019-08-09	AACG	Stock	2.38	2.39	2.1	2.18	184500.0
2019-08-09	AAIC-DELISTED	Stock	5.95	5.99	5.92	5.95	335819.0
2019-08-09	AAIC.C-DELISTED	Stock	22.72	22.72	22.215	22.2418	21396.0
2019-08-09	AAL	Stock	28.85	29.07	28.56	28.78	4031300.0
2019-08-09	AAM.A-DELISTED	Stock	26.25	26.28	26.1519	26.28	5704.0
2019-08-09	AAM.B-DELISTED	Stock	26.52	26.66	26.52	26.66	5279.0
2019-08-09	AAMC-DELISTED	Stock	3.1706	3.1706	3.1706	3.1706	1571.0
2019-08-09	AAME	Stock	2.25	2.42	2.25	2.4	1200.0
2019-08-09	AAMI	Stock	9.08	9.09	8.81	8.82	512000.0
2019-08-09	AAOI	Stock	10.78	10.86	10.27	10.57	535100.0
2019-08-09	AAON	Stock	30.1533	30.2333	29.2667	29.32	189900.0
2019-08-09	AAP	Stock	144.54	146.94	143.21	144.33	1332600.0
2019-08-09	AAT	Stock	47.29	47.59	46.86	47.25	340900.0
2019-08-09	AAU-DELISTED	Stock	0.78	0.8	0.7671	0.783	237147.0
2019-08-09	AAUAF-DELISTED	Stock	0.78	0.8	0.7671	0.782	258026.0
2019-08-09	AAWW-DELISTED	Stock	30.79	30.89	29.0	29.05	196195.0
2019-08-09	AAXJ	Stock	64.49	64.57	63.99	64.29	1739395.0
2019-08-09	AAXN-DELISTED	Stock	60.25	61.98	56.11	58.085	3255758.0
2019-08-09	AB	Stock	27.82	28.01	27.62	27.73	165100.0
2019-08-09	ABB-DELISTED	Stock	17.96	18.14	17.9	18.06	1313591.0
2019-08-09	ABBNY-DELISTED	Stock	17.96	18.14	17.9	18.06	1400478.0
2019-08-09	ABBV	Stock	65.37	66.87	64.29	65.58	10893500.0
2019-08-09	ABC-DELISTED	Stock	87.94	88.17	86.54	87.47	638785.0
2019-08-09	ABCB	Stock	37.69	37.87	37.44	37.63	259300.0
2019-08-09	ABDC-DELISTED	Stock	8.23	8.255	8.15	8.15	33156.0
2019-08-09	ABEO	Stock	57.75	58.75	56.5	57.25	16352.0
2019-08-09	ABEV	Stock	5.11	5.12	5.05	5.05	27518200.0
2019-08-09	ABG	Stock	92.13	93.2	91.2	92.56	68800.0
2019-08-09	ABIL-DELISTED	Stock	0.7243	0.7299	0.589	0.68	86543.0
2019-08-09	ABM	Stock	40.94	41.02	40.37	40.59	189100.0
2019-08-09	ABMD-DELISTED	Stock	191.3	196.47	189.9	191.18	343702.0
2019-08-09	ABR	Stock	12.67	12.67	12.51	12.61	801600.0
2019-08-09	ABR.A-DELISTED	Stock	26.3	26.3	26.12	26.25	1750.0
2019-08-09	ABR.C-DELISTED	Stock	26.9	26.9	26.52	26.6946	3384.0
2019-08-09	ABT	Stock	85.63	87.05	85.43	86.62	5102700.0
2019-08-09	ABTC	Stock	300000.0	304500.0	288000.0	300600.0	2.3333333333333335

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

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