PREVIEW / stock_daily / 2020-07-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-30.parquet
  size:    222 KB
  rows:    6,739
  symbols: 2,393

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-30	AAPL	Stock	94.1875	96.2975	93.7675	96.19	158130000.0
2020-07-30	MSFT	Stock	201.0	204.46	199.57	203.9	25079600.0
2020-07-30	NVDA	Stock	10.375	10.623	10.2953	10.614	308880000.0
2020-07-30	AMZN	Stock	150.7	154.6	150.25	152.594	122566000.0
2020-07-30	GOOGL	Stock	74.8985	77.0445	74.7585	76.9185	36042420.0
2020-07-30	META	Stock	230.22	234.89	229.0	234.5	20615300.0
2020-07-30	TSLA	Stock	99.2	100.8827	98.0667	99.166	114315000.0
2020-07-30	TLT	Stock	171.05	171.26	170.75	171.11	9376128.0
2020-07-30	ES	Stock	89.68	90.78	89.35	90.58	1114600.0
2020-07-30	CL	Stock	75.87	77.19	75.72	76.87	4858400.0
2020-07-30	A	Stock	96.12	96.36	94.97	95.93	1663300.0
2020-07-30	AA	Stock	12.83	13.25	12.47	13.18	6615900.0
2020-07-30	AACG	Stock	1.02	1.11	1.01	1.05	46300.0
2020-07-30	AACQU-DELISTED	Stock	10.365	10.4	10.23	10.3	717161.0
2020-07-30	AAIC-DELISTED	Stock	2.93	2.96	2.85	2.92	329138.0
2020-07-30	AAIC.C-DELISTED	Stock	18.88	19.0	18.88	19.0	1424.0
2020-07-30	AAL	Stock	11.22	11.39	11.12	11.18	40525100.0
2020-07-30	AAM.A-DELISTED	Stock	26.7872	26.92	26.75	26.7948	10880.0
2020-07-30	AAM.B-DELISTED	Stock	27.43	27.6238	27.4	27.42	19410.0
2020-07-30	AAMC-DELISTED	Stock	4.3029	4.3029	4.2574	4.2574	7432.0
2020-07-30	AAME	Stock	1.89	1.89	1.85	1.85	6600.0
2020-07-30	AAMI	Stock	13.51	13.78	13.22	13.76	688700.0
2020-07-30	AAOI	Stock	13.25	14.05	13.07	13.87	803500.0
2020-07-30	AAON	Stock	38.6667	39.26	38.2	38.8267	271050.0
2020-07-30	AAP	Stock	154.11	154.77	148.73	152.87	1350800.0
2020-07-30	AAT	Stock	26.39	26.69	25.9	26.33	200400.0
2020-07-30	AAU-DELISTED	Stock	0.73	0.74	0.6526	0.708	1472938.0
2020-07-30	AAUAF-DELISTED	Stock	0.73	0.74	0.6526	0.7177	1564144.0
2020-07-30	AAWW-DELISTED	Stock	50.65	51.965	50.34	51.405	333528.0
2020-07-30	AAXJ	Stock	75.03	75.22	74.34	75.17	1319073.0
2020-07-30	AAXN-DELISTED	Stock	84.06	85.71	83.48	84.87	346901.0
2020-07-30	AB	Stock	29.14	29.39	28.76	29.15	257700.0
2020-07-30	ABB-DELISTED	Stock	25.34	25.585	25.06	25.58	1744471.0
2020-07-30	ABBNY-DELISTED	Stock	25.34	25.585	25.06	25.57	1832798.0
2020-07-30	ABBV	Stock	96.31	96.74	95.41	96.04	6411500.0
2020-07-30	ABC-DELISTED	Stock	102.17	102.49	101.11	102.17	480812.0
2020-07-30	ABCB	Stock	23.37	23.52	22.75	23.36	330700.0
2020-07-30	ABEO	Stock	69.0	72.75	68.25	72.25	18908.0
2020-07-30	ABEV	Stock	3.0	3.06	2.84	2.84	38836100.0
2020-07-30	ABG	Stock	102.11	103.32	100.24	101.58	219000.0
2020-07-30	ABM	Stock	35.34	35.77	34.8	35.2	264300.0
2020-07-30	ABMD-DELISTED	Stock	298.41	300.94	292.29	299.14	179653.0
2020-07-30	ABR	Stock	9.22	9.6	9.18	9.58	1290700.0
2020-07-30	ABR.A-DELISTED	Stock	24.9799	25.5	24.6534	25.19	4663.0
2020-07-30	ABR.B-DELISTED	Stock	23.72	24.4	23.72	24.01	2400.0
2020-07-30	ABR.C-DELISTED	Stock	24.85	25.0995	24.8	25.0995	3200.0
2020-07-30	ABT	Stock	100.98	101.58	100.24	101.53	3176900.0
2020-07-30	ABTC	Stock	190500.0	194400.0	184800.0	189600.0	1.16
2020-07-30	ABTS	Stock	13.41	13.47	13.05	13.185	2027.0
2020-07-30	ABTX-DELISTED	Stock	24.5	25.47	23.3	25.05	41291.0

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

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