PREVIEW / stock_daily / 2020-05-12

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-12.parquet
  size:    216 KB
  rows:    6,591
  symbols: 2,336

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-05-12	AAPL	Stock	79.4575	79.9225	77.7275	77.8525	162301200.0
2020-05-12	MSFT	Stock	186.8	187.04	182.3	182.51	32038200.0
2020-05-12	NVDA	Stock	8.1235	8.1725	7.7928	7.8025	493060000.0
2020-05-12	AMZN	Stock	120.5925	120.95	117.75	117.8475	61498000.0
2020-05-12	GOOGL	Stock	70.411	70.7165	68.7255	68.759	33917480.0
2020-05-12	META	Stock	213.29	215.28	210.0	210.1	14704600.0
2020-05-12	TSLA	Stock	55.1333	56.2193	53.8667	53.9607	238603500.0
2020-05-12	TLT	Stock	163.16	164.93	163.13	164.37	10057348.0
2020-05-12	ES	Stock	78.47	78.98	75.3	75.67	2278900.0
2020-05-12	CL	Stock	69.74	69.98	68.5	68.73	3961400.0
2020-05-12	A	Stock	81.58	82.3	79.78	79.85	2278900.0
2020-05-12	AA	Stock	7.81	7.96	7.27	7.29	8639700.0
2020-05-12	AACG	Stock	0.72	0.79	0.7	0.71	7900.0
2020-05-12	AAIC-DELISTED	Stock	2.5	2.69	2.38	2.39	693079.0
2020-05-12	AAIC.C-DELISTED	Stock	16.85	16.85	16.25	16.59	6083.0
2020-05-12	AAL	Stock	10.01	10.2	9.6	9.65	46833100.0
2020-05-12	AAM.A-DELISTED	Stock	25.8288	25.98	25.8288	25.95	8324.0
2020-05-12	AAM.B-DELISTED	Stock	25.88	25.99	25.76	25.99	17784.0
2020-05-12	AAME	Stock	1.87	1.92	1.87	1.88	900.0
2020-05-12	AAMI	Stock	8.46	8.47	7.6	7.64	539600.0
2020-05-12	AAOI	Stock	9.77	10.01	9.28	9.28	667900.0
2020-05-12	AAON	Stock	32.3933	32.84	31.5933	31.6933	370350.0
2020-05-12	AAP	Stock	126.7	126.94	124.01	124.5	1010600.0
2020-05-12	AAT	Stock	26.38	26.6	24.84	25.03	418800.0
2020-05-12	AAU-DELISTED	Stock	0.425	0.43	0.415	0.4175	242652.0
2020-05-12	AAUAF-DELISTED	Stock	0.425	0.43	0.415	0.4175	250658.0
2020-05-12	AAWW-DELISTED	Stock	37.92	38.5	36.89	37.09	478467.0
2020-05-12	AAXJ	Stock	64.6	65.175	64.09	64.12	3183167.0
2020-05-12	AAXN-DELISTED	Stock	84.01	85.99	83.41	83.5	773462.0
2020-05-12	AB	Stock	22.58	22.75	21.38	21.44	342900.0
2020-05-12	ABB-DELISTED	Stock	18.41	18.44	18.06	18.06	1427805.0
2020-05-12	ABBNY-DELISTED	Stock	18.41	18.44	18.06	18.06	1549142.0
2020-05-12	ABBV	Stock	90.0	92.23	88.47	90.46	23492300.0
2020-05-12	ABC-DELISTED	Stock	91.46	91.99	88.53	88.58	916343.0
2020-05-12	ABCB	Stock	21.97	22.24	20.1	20.16	453600.0
2020-05-12	ABEO	Stock	83.5	89.25	75.0	75.75	105528.0
2020-05-12	ABEV	Stock	2.11	2.16	2.01	2.02	24936300.0
2020-05-12	ABG	Stock	67.3	67.89	63.7	63.7	246200.0
2020-05-12	ABM	Stock	33.83	33.83	32.06	32.07	325200.0
2020-05-12	ABMD-DELISTED	Stock	192.79	197.79	190.52	191.23	395155.0
2020-05-12	ABR	Stock	7.01	7.1	6.57	6.58	2670200.0
2020-05-12	ABR.A-DELISTED	Stock	24.5	24.98	24.32	24.8	6215.0
2020-05-12	ABR.B-DELISTED	Stock	24.3998	24.7795	24.0235	24.5	8938.0
2020-05-12	ABR.C-DELISTED	Stock	24.75	25.21	24.665	24.86	7045.0
2020-05-12	ABT	Stock	96.46	96.68	93.73	93.8	5384200.0
2020-05-12	ABTC	Stock	237000.0	245700.0	222300.0	223500.0	3.48
2020-05-12	ABTS	Stock	12.18	12.18	11.325	11.325	1407.0
2020-05-12	ABTX-DELISTED	Stock	23.58	23.58	22.39	22.4	82587.0
2020-05-12	ABUS	Stock	1.48	1.87	1.45	1.65	2157300.0
2020-05-12	ACA	Stock	33.91	33.91	32.74	32.89	381783.0

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

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