PREVIEW / stock_daily / 2020-07-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-09.parquet
  size:    221 KB
  rows:    6,704
  symbols: 2,388

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
2020-07-09	AAPL	Stock	96.2625	96.3175	94.6725	95.7525	125642800.0
2020-07-09	MSFT	Stock	216.33	216.38	211.47	214.32	33121700.0
2020-07-09	NVDA	Stock	10.3802	10.57	10.2335	10.509	494548000.0
2020-07-09	AMZN	Stock	155.7995	159.694	153.7	159.1315	127774000.0
2020-07-09	GOOGL	Stock	75.4965	76.4571	74.7795	75.933	41836660.0
2020-07-09	META	Stock	245.0	246.53	239.24	244.5	22174900.0
2020-07-09	TSLA	Stock	93.1327	93.904	90.0853	92.952	175764000.0
2020-07-09	TLT	Stock	164.66	167.45	164.6	167.17	13373095.0
2020-07-09	ES	Stock	84.41	84.95	83.05	84.57	1174300.0
2020-07-09	CL	Stock	74.06	74.62	73.23	73.32	2916700.0
2020-07-09	A	Stock	89.65	90.4	88.56	89.92	1133800.0
2020-07-09	AA	Stock	11.03	11.061	10.46	10.52	8074300.0
2020-07-09	AACG	Stock	1.5	1.5	1.45	1.49	67200.0
2020-07-09	AAIC-DELISTED	Stock	2.8	2.84	2.725	2.76	313213.0
2020-07-09	AAIC.C-DELISTED	Stock	19.65	19.8531	19.6001	19.748	3005.0
2020-07-09	AAL	Stock	11.94	11.94	11.15	11.18	77131200.0
2020-07-09	AAM.A-DELISTED	Stock	26.095	26.161	25.958	26.08	14287.0
2020-07-09	AAM.B-DELISTED	Stock	26.19	26.19	26.02	26.0966	20574.0
2020-07-09	AAMC-DELISTED	Stock	5.1794	5.1794	4.7882	4.7882	17993.0
2020-07-09	AAME	Stock	1.63	1.65	1.63	1.63	2100.0
2020-07-09	AAMI	Stock	12.67	12.69	12.23	12.28	991100.0
2020-07-09	AAOI	Stock	11.29	12.25	11.16	12.0	1474700.0
2020-07-09	AAON	Stock	36.0333	36.8667	35.3533	35.6267	276600.0
2020-07-09	AAP	Stock	135.68	136.81	132.32	133.75	543000.0
2020-07-09	AAT	Stock	25.84	26.46	25.43	26.43	562100.0
2020-07-09	AAU-DELISTED	Stock	0.53	0.53	0.49	0.508	479436.0
2020-07-09	AAUAF-DELISTED	Stock	0.53	0.53	0.49	0.5046	498845.0
2020-07-09	AAWW-DELISTED	Stock	45.98	46.61	45.5	46.2	269208.0
2020-07-09	AAXJ	Stock	76.24	76.38	74.99	75.65	2798867.0
2020-07-09	AAXN-DELISTED	Stock	97.17	98.04	95.18	96.43	331002.0
2020-07-09	AB	Stock	27.39	27.4	26.35	26.82	108700.0
2020-07-09	ABB-DELISTED	Stock	24.6	24.61	24.1101	24.25	2218177.0
2020-07-09	ABBNY-DELISTED	Stock	24.56	24.61	24.1101	24.24	2519812.0
2020-07-09	ABBV	Stock	99.08	99.78	96.81	97.94	5817300.0
2020-07-09	ABC-DELISTED	Stock	97.21	97.27	94.76	96.4	539364.0
2020-07-09	ABCB	Stock	21.33	21.48	19.91	20.37	507400.0
2020-07-09	ABEO	Stock	83.5	87.75	82.25	83.75	41964.0
2020-07-09	ABEV	Stock	2.83	2.86	2.75	2.78	38317100.0
2020-07-09	ABG	Stock	91.5	92.35	86.39	88.16	277800.0
2020-07-09	ABM	Stock	32.89	32.93	31.36	31.98	495900.0
2020-07-09	ABMD-DELISTED	Stock	267.3	268.72	261.01	265.66	143175.0
2020-07-09	ABR	Stock	8.04	8.04	7.52	7.55	2815600.0
2020-07-09	ABR.A-DELISTED	Stock	24.81	24.81	24.1805	24.38	5745.0
2020-07-09	ABR.B-DELISTED	Stock	23.81	23.909	22.86	23.31	9100.0
2020-07-09	ABR.C-DELISTED	Stock	24.99	25.0001	24.61	24.7937	5902.0
2020-07-09	ABT	Stock	92.74	94.88	91.85	93.67	4576800.0
2020-07-09	ABTC	Stock	218400.0	229500.0	212100.0	218100.0	5.786666666666666
2020-07-09	ABTS	Stock	16.5	16.95	13.8	15.6	5093.0
2020-07-09	ABTX-DELISTED	Stock	22.5	22.72	21.63	21.74	38423.0
2020-07-09	ABUS	Stock	1.88	1.91	1.81	1.86	443200.0

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

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