PREVIEW / stock_daily / 2020-06-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-02.parquet
  size:    219 KB
  rows:    6,650
  symbols: 2,374

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-02	AAPL	Stock	80.1875	80.86	79.7325	80.835	87642800.0
2020-06-02	MSFT	Stock	184.25	185.0	181.35	184.91	30794600.0
2020-06-02	NVDA	Stock	8.7962	8.8373	8.658	8.8252	391320000.0
2020-06-02	AMZN	Stock	123.35	123.6765	122.2655	123.6205	50598000.0
2020-06-02	GOOGL	Stock	71.75	72.15	71.0805	72.1155	23441380.0
2020-06-02	META	Stock	230.94	233.0	226.56	232.72	20919000.0
2020-06-02	TSLA	Stock	59.6467	60.5773	58.0667	58.7707	203484000.0
2020-06-02	TLT	Stock	161.67	162.093	161.25	161.69	11517053.0
2020-06-02	ES	Stock	86.14	86.46	84.61	85.77	1813900.0
2020-06-02	CL	Stock	72.65	73.11	71.63	72.44	3751300.0
2020-06-02	A	Stock	90.0	90.63	89.11	90.29	1682800.0
2020-06-02	AA	Stock	9.62	10.04	9.62	9.92	6267100.0
2020-06-02	AACG	Stock	0.87	0.92	0.87	0.88	4100.0
2020-06-02	AAIC-DELISTED	Stock	2.53	2.55	2.45	2.45	272885.0
2020-06-02	AAIC.C-DELISTED	Stock	17.8262	18.23	17.77	18.23	10261.0
2020-06-02	AAL	Stock	11.4	11.64	10.97	11.22	49148600.0
2020-06-02	AAM.A-DELISTED	Stock	26.5	26.56	26.45	26.55	9828.0
2020-06-02	AAM.B-DELISTED	Stock	26.49	26.69	26.49	26.69	7125.0
2020-06-02	AAMC-DELISTED	Stock	5.1971	5.1971	5.0559	5.1412	4893.0
2020-06-02	AAME	Stock	1.88	1.88	1.87	1.87	700.0
2020-06-02	AAMI	Stock	8.68	8.8	8.59	8.68	229300.0
2020-06-02	AAOI	Stock	9.19	9.34	9.0	9.05	813300.0
2020-06-02	AAON	Stock	36.2733	36.42	35.42	36.1733	370950.0
2020-06-02	AAP	Stock	141.21	141.35	138.93	139.49	540300.0
2020-06-02	AAT	Stock	27.04	27.28	26.63	26.98	373400.0
2020-06-02	AAU-DELISTED	Stock	0.49	0.5	0.477	0.4812	260786.0
2020-06-02	AAUAF-DELISTED	Stock	0.49	0.5	0.477	0.4812	268591.0
2020-06-02	AAWW-DELISTED	Stock	41.01	45.5	41.01	45.45	864483.0
2020-06-02	AAXJ	Stock	66.9	67.77	66.87	67.66	1072297.0
2020-06-02	AAXN-DELISTED	Stock	91.8	99.615	91.01	97.87	2982573.0
2020-06-02	AB	Stock	25.69	26.19	25.69	26.0	318800.0
2020-06-02	ABB-DELISTED	Stock	20.47	20.53	20.3	20.4	1982926.0
2020-06-02	ABBNY-DELISTED	Stock	20.46	20.53	20.3	20.41	2238240.0
2020-06-02	ABBV	Stock	90.97	91.7	90.05	91.04	9413300.0
2020-06-02	ABC-DELISTED	Stock	94.85	98.74	94.31	98.68	1518492.0
2020-06-02	ABCB	Stock	24.51	24.62	23.49	23.71	286000.0
2020-06-02	ABEO	Stock	81.25	82.25	75.25	76.5	52112.0
2020-06-02	ABEV	Stock	2.44	2.58	2.4	2.51	43352500.0
2020-06-02	ABG	Stock	73.84	75.45	73.34	74.25	154400.0
2020-06-02	ABM	Stock	32.63	32.85	32.03	32.16	401400.0
2020-06-02	ABMD-DELISTED	Stock	226.62	231.42	222.85	230.74	334230.0
2020-06-02	ABR	Stock	8.74	8.93	8.68	8.75	2006300.0
2020-06-02	ABR.A-DELISTED	Stock	24.9	24.9	24.45	24.53	3371.0
2020-06-02	ABR.B-DELISTED	Stock	24.4065	24.4065	23.272	23.272	529.0
2020-06-02	ABR.C-DELISTED	Stock	24.9283	25.0	24.6712	24.8015	2425.0
2020-06-02	ABT	Stock	92.92	93.15	91.76	92.62	6394100.0
2020-06-02	ABTC	Stock	288600.0	288600.0	275400.0	279900.0	1.4
2020-06-02	ABTS	Stock	8.73	9.51	8.715	9.3	1500.0
2020-06-02	ABTX-DELISTED	Stock	25.77	25.96	25.01	25.26	34341.0
2020-06-02	ABUS	Stock	2.13	2.25	2.0	2.09	1058700.0

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

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