PREVIEW / stock_daily / 2020-06-01

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-01.parquet
  size:    219 KB
  rows:    6,621
  symbols: 2,347

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-01	AAPL	Stock	79.4375	80.5875	79.3025	80.4625	80791200.0
2020-06-01	MSFT	Stock	182.54	183.0	181.46	182.83	22622400.0
2020-06-01	NVDA	Stock	8.8332	8.8408	8.6895	8.8062	389876000.0
2020-06-01	AMZN	Stock	122.4	123.8465	122.2085	123.552	58578000.0
2020-06-01	GOOGL	Stock	71.285	72.079	71.114	71.7435	25185080.0
2020-06-01	META	Stock	224.59	232.44	223.5	231.91	18223800.0
2020-06-01	TSLA	Stock	57.2	59.9333	56.94	59.8733	224092500.0
2020-06-01	TLT	Stock	162.1	162.44	161.67	162.28	13353301.0
2020-06-01	ES	Stock	83.77	86.18	83.2	85.58	1931900.0
2020-06-01	CL	Stock	72.27	72.99	71.96	72.73	2640600.0
2020-06-01	A	Stock	88.04	89.98	87.94	89.91	2477600.0
2020-06-01	AA	Stock	9.21	9.645	9.15	9.49	5525200.0
2020-06-01	AACG	Stock	0.9	0.95	0.87	0.91	6200.0
2020-06-01	AAIC-DELISTED	Stock	2.36	2.562	2.35	2.5	454698.0
2020-06-01	AAIC.C-DELISTED	Stock	17.7	17.85	17.7	17.85	6086.0
2020-06-01	AAL	Stock	10.79	11.33	10.62	11.11	50313500.0
2020-06-01	AAM.A-DELISTED	Stock	26.21	26.5	26.06	26.5	4695.0
2020-06-01	AAM.B-DELISTED	Stock	26.25	26.5	26.25	26.49	6949.0
2020-06-01	AAMC-DELISTED	Stock	5.2882	5.2882	5.0	5.1471	8490.0
2020-06-01	AAME	Stock	1.83	1.83	1.83	1.83	800.0
2020-06-01	AAMI	Stock	8.43	8.62	8.25	8.55	695200.0
2020-06-01	AAOI	Stock	8.82	9.25	8.82	9.15	698600.0
2020-06-01	AAON	Stock	36.1133	37.0267	35.4467	36.18	460350.0
2020-06-01	AAP	Stock	139.56	140.63	138.49	139.79	841000.0
2020-06-01	AAT	Stock	26.15	27.08	26.15	26.59	271200.0
2020-06-01	AAU-DELISTED	Stock	0.474	0.4899	0.462	0.4858	267617.0
2020-06-01	AAUAF-DELISTED	Stock	0.474	0.4899	0.462	0.4858	282205.0
2020-06-01	AAWW-DELISTED	Stock	38.75	40.94	38.51	40.79	435155.0
2020-06-01	AAXJ	Stock	65.28	66.16	65.22	66.09	795566.0
2020-06-01	AAXN-DELISTED	Stock	83.66	92.0	82.8006	89.88	4045894.0
2020-06-01	AB	Stock	25.06	26.04	24.91	25.55	347100.0
2020-06-01	ABB-DELISTED	Stock	19.83	19.975	19.79	19.84	1322023.0
2020-06-01	ABBNY-DELISTED	Stock	19.83	19.975	19.79	19.84	1690861.0
2020-06-01	ABBV	Stock	92.05	93.06	90.69	90.7	8486500.0
2020-06-01	ABC-DELISTED	Stock	94.84	95.87	94.84	95.15	800480.0
2020-06-01	ABCB	Stock	24.41	25.36	23.98	24.06	444800.0
2020-06-01	ABEO	Stock	82.5	82.5	79.25	80.5	34136.0
2020-06-01	ABEV	Stock	2.34	2.4	2.31	2.37	50377400.0
2020-06-01	ABG	Stock	73.28	74.58	72.0	72.75	157100.0
2020-06-01	ABM	Stock	31.0	33.12	30.97	32.23	968300.0
2020-06-01	ABMD-DELISTED	Stock	223.71	226.85	220.8259	226.14	208202.0
2020-06-01	ABR	Stock	8.31	8.67	8.06	8.62	1795500.0
2020-06-01	ABR.A-DELISTED	Stock	24.98	24.98	24.43	24.43	524.0
2020-06-01	ABR.B-DELISTED	Stock	23.46	24.2	23.46	24.17	406.0
2020-06-01	ABR.C-DELISTED	Stock	24.44	24.96	24.35	24.96	4903.0
2020-06-01	ABT	Stock	92.95	93.96	92.04	93.01	5451600.0
2020-06-01	ABTC	Stock	273600.0	297870.0	271500.0	291300.0	2.68
2020-06-01	ABTS	Stock	8.7	9.75	8.7	9.15	2100.0
2020-06-01	ABTX-DELISTED	Stock	25.83	26.24	25.41	25.42	58232.0
2020-06-01	ABUS	Stock	2.12	2.23	2.03	2.16	686200.0

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

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