PREVIEW / stock_daily / 2020-07-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-28.parquet
  size:    221 KB
  rows:    6,710
  symbols: 2,382

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-28	AAPL	Stock	94.3675	94.55	93.2475	93.2525	103625600.0
2020-07-28	MSFT	Stock	203.61	204.7	201.74	202.02	23251400.0
2020-07-28	NVDA	Stock	10.3743	10.382	10.2093	10.2155	271636000.0
2020-07-28	AMZN	Stock	152.7135	153.8545	149.788	150.0165	62534000.0
2020-07-28	GOOGL	Stock	76.25	76.3005	75.026	75.1825	30910680.0
2020-07-28	META	Stock	234.63	234.96	229.83	230.12	14170100.0
2020-07-28	TSLA	Stock	100.2667	104.3133	98.2947	98.4327	237130500.0
2020-07-28	TLT	Stock	169.54	170.34	169.43	170.28	8520714.0
2020-07-28	ES	Stock	88.56	91.13	88.56	90.14	1297400.0
2020-07-28	CL	Stock	74.92	75.99	74.75	75.71	4035900.0
2020-07-28	A	Stock	96.98	97.25	95.2	95.3	1373700.0
2020-07-28	AA	Stock	12.97	13.12	12.8	12.91	3546400.0
2020-07-28	AACG	Stock	1.11	1.18	1.1	1.12	8700.0
2020-07-28	AACQU-DELISTED	Stock	10.37	10.45	10.37	10.4	537219.0
2020-07-28	AAIC-DELISTED	Stock	2.95	3.0099	2.93	2.93	208797.0
2020-07-28	AAIC.C-DELISTED	Stock	19.0	19.0	19.0	19.0	200.0
2020-07-28	AAL	Stock	11.37	12.0	11.36	11.77	62356600.0
2020-07-28	AAM.A-DELISTED	Stock	26.38	26.631	26.38	26.631	6471.0
2020-07-28	AAM.B-DELISTED	Stock	27.157	27.215	27.15	27.2	6589.0
2020-07-28	AAMC-DELISTED	Stock	5.0265	5.0265	4.1941	4.2882	13831.0
2020-07-28	AAME	Stock	1.9	1.9	1.79	1.83	2200.0
2020-07-28	AAMI	Stock	14.07	14.47	13.53	13.86	1171000.0
2020-07-28	AAOI	Stock	13.92	13.92	13.14	13.24	693800.0
2020-07-28	AAON	Stock	38.36	38.8133	37.7067	38.0267	307800.0
2020-07-28	AAP	Stock	147.06	148.06	145.95	146.19	808500.0
2020-07-28	AAT	Stock	25.55	26.96	25.55	26.84	354700.0
2020-07-28	AAU-DELISTED	Stock	0.62	0.71	0.5953	0.6807	3837561.0
2020-07-28	AAUAF-DELISTED	Stock	0.62	0.71	0.5953	0.689	3876051.0
2020-07-28	AAWW-DELISTED	Stock	49.71	49.71	48.66	48.83	200256.0
2020-07-28	AAXJ	Stock	75.05	75.13	74.49	74.58	1333452.0
2020-07-28	AAXN-DELISTED	Stock	86.04	86.81	84.96	85.76	279640.0
2020-07-28	AB	Stock	28.68	29.12	28.5	28.58	217100.0
2020-07-28	ABB-DELISTED	Stock	25.92	25.97	25.825	25.85	974652.0
2020-07-28	ABBNY-DELISTED	Stock	25.92	25.97	25.825	25.85	1064823.0
2020-07-28	ABBV	Stock	97.0	97.62	96.46	96.71	5941800.0
2020-07-28	ABC-DELISTED	Stock	104.0	104.54	101.93	102.11	512925.0
2020-07-28	ABCB	Stock	23.76	23.97	23.31	23.45	474400.0
2020-07-28	ABEO	Stock	75.25	75.5	71.25	71.75	18020.0
2020-07-28	ABEV	Stock	2.94	2.99	2.92	2.93	35456300.0
2020-07-28	ABG	Stock	107.54	108.2	103.0	103.54	392400.0
2020-07-28	ABM	Stock	35.24	35.79	35.19	35.27	391400.0
2020-07-28	ABMD-DELISTED	Stock	299.46	299.56	294.14	294.91	139340.0
2020-07-28	ABR	Stock	9.18	9.49	9.09	9.37	1520800.0
2020-07-28	ABR.A-DELISTED	Stock	24.88	24.9317	24.82	24.9317	1081.0
2020-07-28	ABR.B-DELISTED	Stock	23.6099	23.7	23.45	23.63	1695.0
2020-07-28	ABR.C-DELISTED	Stock	24.7531	24.85	24.7531	24.8	4093.0
2020-07-28	ABT	Stock	100.14	100.79	99.27	99.86	4114200.0
2020-07-28	ABTC	Stock	187500.0	207000.0	186000.0	198900.0	4.413333333333333
2020-07-28	ABTS	Stock	14.37	14.85	13.2	13.86	11680.0
2020-07-28	ABTX-DELISTED	Stock	23.32	23.765	23.32	23.4	15201.0

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

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