PREVIEW / stock_daily / 2020-08-07

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-07.parquet
  size:    224 KB
  rows:    6,766
  symbols: 2,401

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-08-07	AAPL	Stock	113.205	113.675	110.2925	111.1125	198045600.0
2020-08-07	MSFT	Stock	214.85	215.7	210.93	212.48	27820400.0
2020-08-07	NVDA	Stock	11.3125	11.5048	11.0375	11.1995	342516000.0
2020-08-07	AMZN	Stock	161.2005	162.0405	157.0335	158.373	78722000.0
2020-08-07	GOOGL	Stock	75.452	76.0045	74.3135	74.9185	27725880.0
2020-08-07	META	Stock	264.08	278.89	263.43	268.44	72766400.0
2020-08-07	TSLA	Stock	99.9693	99.9833	94.334	96.8473	133446000.0
2020-08-07	TLT	Stock	171.28	171.5	169.58	169.88	8176856.0
2020-08-07	ES	Stock	87.95	89.8	87.8	89.02	1524500.0
2020-08-07	CL	Stock	75.83	76.27	75.6	76.24	2968000.0
2020-08-07	A	Stock	97.07	97.84	96.87	97.78	897900.0
2020-08-07	AA	Stock	14.64	14.84	14.23	14.67	6573600.0
2020-08-07	AACG	Stock	1.27	1.28	1.2	1.26	17900.0
2020-08-07	AACQU-DELISTED	Stock	10.1	10.17	10.05	10.13	149150.0
2020-08-07	AAIC-DELISTED	Stock	2.73	2.79	2.65	2.77	245911.0
2020-08-07	AAIC.C-DELISTED	Stock	19.49	19.49	19.49	19.49	120.0
2020-08-07	AAL	Stock	12.86	13.16	12.58	13.03	61700700.0
2020-08-07	AAM.A-DELISTED	Stock	26.93	26.99	26.7479	26.81	7279.0
2020-08-07	AAM.B-DELISTED	Stock	27.41	27.41	27.35	27.41	5979.0
2020-08-07	AAMC-DELISTED	Stock	3.8235	3.8529	3.7411	3.8529	6144.0
2020-08-07	AAME	Stock	1.88	1.94	1.82	1.85	1900.0
2020-08-07	AAMI	Stock	13.78	13.99	13.4	13.59	723000.0
2020-08-07	AAOI	Stock	17.31	17.57	15.63	15.8	4356400.0
2020-08-07	AAON	Stock	38.0333	39.3733	37.5733	39.06	328500.0
2020-08-07	AAP	Stock	150.91	153.21	150.78	151.97	1424500.0
2020-08-07	AAT	Stock	26.92	27.44	26.87	27.33	488500.0
2020-08-07	AAU-DELISTED	Stock	0.78	0.78	0.68	0.7119	1051009.0
2020-08-07	AAUAF-DELISTED	Stock	0.78	0.78	0.68	0.7183	1072746.0
2020-08-07	AAWW-DELISTED	Stock	56.21	59.45	55.74	59.07	1047959.0
2020-08-07	AAXJ	Stock	76.24	76.49	75.62	76.01	1107554.0
2020-08-07	AAXN-DELISTED	Stock	85.5	88.0	82.5	83.97	1841147.0
2020-08-07	AB	Stock	27.3	28.08	27.26	28.08	220000.0
2020-08-07	ABB-DELISTED	Stock	26.0	26.04	25.86	25.985	793000.0
2020-08-07	ABBNY-DELISTED	Stock	26.0	26.04	25.86	25.99	847237.0
2020-08-07	ABBV	Stock	92.69	93.0	92.2	92.92	5226600.0
2020-08-07	ABC-DELISTED	Stock	101.25	102.2	100.53	102.12	541031.0
2020-08-07	ABCB	Stock	24.1	25.84	23.92	25.82	312200.0
2020-08-07	ABEO	Stock	71.0	73.25	70.0	71.5	22936.0
2020-08-07	ABEV	Stock	2.45	2.5	2.44	2.46	26933500.0
2020-08-07	ABG	Stock	102.88	104.27	101.78	102.51	154700.0
2020-08-07	ABM	Stock	37.67	38.8	37.67	38.77	244800.0
2020-08-07	ABMD-DELISTED	Stock	310.48	316.88	307.44	310.82	283164.0
2020-08-07	ABR	Stock	10.74	11.43	10.62	11.4	2384600.0
2020-08-07	ABR.A-DELISTED	Stock	25.42	25.77	25.42	25.77	1350.0
2020-08-07	ABR.B-DELISTED	Stock	24.6185	25.13	24.6185	25.13	13896.0
2020-08-07	ABR.C-DELISTED	Stock	25.65	26.07	25.6432	26.07	5318.0
2020-08-07	ABT	Stock	101.7	102.3	100.56	101.23	3141900.0
2020-08-07	ABTC	Stock	199500.0	205350.0	195900.0	196500.0	1.0133333333333332
2020-08-07	ABTS	Stock	16.95	18.75	16.95	18.3	10073.0
2020-08-07	ABTX-DELISTED	Stock	24.46	26.34	24.46	26.34	36043.0

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

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