PREVIEW / stock_daily / 2020-06-04

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-04.parquet
  size:    220 KB
  rows:    6,647
  symbols: 2,366

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-06-04	AAPL	Stock	81.0975	81.405	80.195	80.58	87560400.0
2020-06-04	MSFT	Stock	184.3	185.84	182.3	182.92	28761800.0
2020-06-04	NVDA	Stock	8.728	8.9433	8.6775	8.7665	424280000.0
2020-06-04	AMZN	Stock	123.8715	125.377	122.5005	123.03	58974000.0
2020-06-04	GOOGL	Stock	71.839	72.066	70.3005	70.715	26982100.0
2020-06-04	META	Stock	229.56	231.63	224.61	226.29	17041500.0
2020-06-04	TSLA	Stock	59.3253	59.7167	57.2293	57.6253	133315500.0
2020-06-04	TLT	Stock	158.92	159.01	157.185	157.23	14038570.0
2020-06-04	ES	Stock	86.27	86.74	84.32	85.53	1203800.0
2020-06-04	CL	Stock	71.42	72.35	70.59	70.75	4985800.0
2020-06-04	A	Stock	89.82	91.74	89.82	91.14	2227500.0
2020-06-04	AA	Stock	10.85	11.65	10.575	11.64	11430600.0
2020-06-04	AACG	Stock	0.88	0.91	0.84	0.86	7900.0
2020-06-04	AAIC-DELISTED	Stock	2.5	3.14	2.5	2.83	942550.0
2020-06-04	AAIC.C-DELISTED	Stock	17.7275	18.25	17.7275	18.2499	2310.0
2020-06-04	AAL	Stock	12.85	18.18	12.63	16.72	399432600.0
2020-06-04	AAM.A-DELISTED	Stock	25.99	26.0599	25.86	25.985	27262.0
2020-06-04	AAM.B-DELISTED	Stock	26.2	26.2	26.01	26.1	15023.0
2020-06-04	AAMC-DELISTED	Stock	5.2647	5.3529	4.9294	5.1485	14827.0
2020-06-04	AAME	Stock	1.73	1.81	1.73	1.81	1300.0
2020-06-04	AAMI	Stock	9.2	9.42	9.13	9.31	262300.0
2020-06-04	AAOI	Stock	9.45	9.975	9.39	9.81	645800.0
2020-06-04	AAON	Stock	36.4667	37.5667	36.38	37.3667	236250.0
2020-06-04	AAP	Stock	141.08	142.69	140.59	142.2	498400.0
2020-06-04	AAT	Stock	29.39	31.12	28.53	31.11	542000.0
2020-06-04	AAU-DELISTED	Stock	0.4677	0.47	0.45	0.47	295348.0
2020-06-04	AAUAF-DELISTED	Stock	0.4677	0.47	0.45	0.47	302287.0
2020-06-04	AAWW-DELISTED	Stock	46.01	46.49	44.26	45.67	502253.0
2020-06-04	AAXJ	Stock	68.25	68.675	67.87	68.13	1687318.0
2020-06-04	AAXN-DELISTED	Stock	91.0	93.5889	90.4	93.35	810207.0
2020-06-04	AB	Stock	26.25	26.53	25.54	26.28	298200.0
2020-06-04	ABB-DELISTED	Stock	21.43	21.6	21.335	21.44	1733415.0
2020-06-04	ABBNY-DELISTED	Stock	21.4	21.6	21.335	21.45	1854933.0
2020-06-04	ABBV	Stock	90.28	93.48	90.25	93.04	9525700.0
2020-06-04	ABC-DELISTED	Stock	98.65	99.99	98.2	99.43	1234909.0
2020-06-04	ABCB	Stock	25.49	26.75	25.04	26.64	550900.0
2020-06-04	ABEO	Stock	73.5	76.75	72.25	72.5	32408.0
2020-06-04	ABEV	Stock	2.64	2.67	2.59	2.64	28859300.0
2020-06-04	ABG	Stock	77.55	81.79	76.98	80.65	183800.0
2020-06-04	ABM	Stock	32.95	34.89	32.59	34.4	459100.0
2020-06-04	ABMD-DELISTED	Stock	235.45	238.94	234.04	235.84	329049.0
2020-06-04	ABR	Stock	9.43	9.57	9.07	9.33	3826500.0
2020-06-04	ABR.A-DELISTED	Stock	24.82	24.82	24.5	24.6	3200.0
2020-06-04	ABR.B-DELISTED	Stock	23.81	23.81	23.7	23.7	400.0
2020-06-04	ABR.C-DELISTED	Stock	24.76	25.135	24.76	24.8043	3222.0
2020-06-04	ABT	Stock	91.05	91.34	88.24	88.25	9113600.0
2020-06-04	ABTC	Stock	277200.0	285000.0	269400.0	276900.0	2.24
2020-06-04	ABTS	Stock	13.2	13.2	11.25	11.4	5447.0
2020-06-04	ABTX-DELISTED	Stock	26.03	27.22	25.835	27.16	59550.0
2020-06-04	ABUS	Stock	2.04	2.18	2.01	2.04	2108100.0

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

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