PREVIEW / stock_daily / 2020-09-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-30.parquet
  size:    227 KB
  rows:    6,919
  symbols: 2,466

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-09-30	AAPL	Stock	113.79	117.26	113.62	115.81	142675200.0
2020-09-30	MSFT	Stock	207.73	211.98	206.54	210.33	33829100.0
2020-09-30	NVDA	Stock	13.1575	13.6225	13.1502	13.5305	689184000.0
2020-09-30	AMZN	Stock	157.057	160.644	156.6995	157.4365	97922000.0
2020-09-30	GOOGL	Stock	73.0468	74.3099	72.7878	73.28	40923400.0
2020-09-30	META	Stock	261.98	266.08	260.1	261.9	20142500.0
2020-09-30	TSLA	Stock	140.44	144.6433	140.1567	143.0033	144436800.0
2020-09-30	TLT	Stock	164.0	164.0	162.55	163.26	12970989.0
2020-09-30	ES	Stock	83.49	84.17	82.64	83.55	1561300.0
2020-09-30	CL	Stock	76.58	77.45	76.41	77.15	3962100.0
2020-09-30	A	Stock	100.54	101.89	100.31	100.94	1362200.0
2020-09-30	AA	Stock	11.68	12.1	11.56	11.63	5513100.0
2020-09-30	AACG	Stock	1.12	1.13	1.09	1.11	18700.0
2020-09-30	AACQ-DELISTED	Stock	10.0	10.0	9.92	9.94	57761.0
2020-09-30	AACQU-DELISTED	Stock	10.37	10.47	10.23	10.39	18501.0
2020-09-30	AACQW-DELISTED	Stock	1.61	1.675	1.56	1.61	226166.0
2020-09-30	AAIC-DELISTED	Stock	2.84	2.9	2.8	2.84	166939.0
2020-09-30	AAIC.C-DELISTED	Stock	18.75	19.04	18.75	19.04	2144.0
2020-09-30	AAL	Stock	12.32	12.92	12.22	12.29	65428100.0
2020-09-30	AAM.A-DELISTED	Stock	26.19	26.33	25.8	25.9	90884.0
2020-09-30	AAM.B-DELISTED	Stock	27.2	27.31	26.67	26.67	44024.0
2020-09-30	AAMC-DELISTED	Stock	5.7353	6.5588	5.7353	6.1	18380.0
2020-09-30	AAME	Stock	1.99	2.0	1.88	2.0	3000.0
2020-09-30	AAMI	Stock	12.84	13.105	12.84	12.9	492100.0
2020-09-30	AAOI	Stock	11.23	11.6	11.1	11.25	443300.0
2020-09-30	AAON	Stock	39.84	40.8267	39.84	40.1667	442350.0
2020-09-30	AAP	Stock	151.48	154.87	151.45	153.5	546700.0
2020-09-30	AAT	Stock	24.15	24.54	23.65	24.09	325500.0
2020-09-30	AAU-DELISTED	Stock	0.83	0.8374	0.82	0.8226	232314.0
2020-09-30	AAUAF-DELISTED	Stock	0.83	0.8374	0.82	0.8252	247669.0
2020-09-30	AAWW-DELISTED	Stock	61.43	62.3049	60.41	60.9	366637.0
2020-09-30	AAXJ	Stock	76.5	77.39	76.49	77.17	848122.0
2020-09-30	AAXN-DELISTED	Stock	89.36	91.8325	89.17	90.71	715469.0
2020-09-30	AB	Stock	26.94	27.57	26.94	27.04	372300.0
2020-09-30	ABB-DELISTED	Stock	25.52	25.695	25.325	25.44	1292686.0
2020-09-30	ABBNY-DELISTED	Stock	25.52	25.695	25.325	25.45	1482063.0
2020-09-30	ABBV	Stock	87.0	88.44	86.81	87.59	8209300.0
2020-09-30	ABC-DELISTED	Stock	96.18	97.85	95.69	96.93	817285.0
2020-09-30	ABCB	Stock	23.08	23.35	22.53	22.78	386200.0
2020-09-30	ABEO	Stock	27.75	28.25	25.0	25.5	267116.0
2020-09-30	ABEV	Stock	2.23	2.28	2.22	2.26	23762000.0
2020-09-30	ABG	Stock	95.92	98.55	95.51	97.45	225800.0
2020-09-30	ABM	Stock	36.95	37.47	36.36	36.66	420000.0
2020-09-30	ABMD-DELISTED	Stock	275.12	280.875	272.22	277.06	208153.0
2020-09-30	ABR	Stock	11.6	11.77	11.38	11.47	824200.0
2020-09-30	ABR.B-DELISTED	Stock	25.13	25.13	25.03	25.03	1275.0
2020-09-30	ABR.C-DELISTED	Stock	25.6	25.6	25.5475	25.59	700.0
2020-09-30	ABT	Stock	105.99	109.48	105.74	108.83	9487000.0
2020-09-30	ABTC	Stock	112200.0	114600.0	105600.0	109200.0	3.0266666666666664
2020-09-30	ABTS	Stock	20.7	22.185	19.05	20.25	18093.0

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

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