PREVIEW / stock_daily / 2020-03-05

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-05.parquet
  size:    222 KB
  rows:    6,618
  symbols: 2,389

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-03-05	AAPL	Stock	73.88	74.8875	72.8525	73.23	187572800.0
2020-03-05	MSFT	Stock	166.05	170.87	165.69	166.27	47817300.0
2020-03-05	NVDA	Stock	6.9125	7.08	6.7875	6.8323	540328000.0
2020-03-05	AMZN	Stock	96.65	98.036	95.5	96.2015	94964000.0
2020-03-05	GOOGL	Stock	67.2775	67.6815	65.082	65.738	54379640.0
2020-03-05	META	Stock	186.78	188.99	183.89	185.17	19333400.0
2020-03-05	TSLA	Stock	48.2513	49.7167	47.8713	48.3027	162790500.0
2020-03-05	TLT	Stock	157.13	158.82	156.81	158.52	17786220.0
2020-03-05	ES	Stock	97.25	98.92	96.44	97.44	1990400.0
2020-03-05	CL	Stock	73.71	74.33	71.8	72.34	5877500.0
2020-03-05	A	Stock	82.14	83.25	79.7	80.46	2322600.0
2020-03-05	AA	Stock	12.47	12.61	11.675	11.89	12865900.0
2020-03-05	AACG	Stock	1.0	1.0	0.96	0.96	2600.0
2020-03-05	AAIC-DELISTED	Stock	5.94	5.9425	5.71	5.82	378001.0
2020-03-05	AAIC.C-DELISTED	Stock	22.55	22.5501	22.0	22.01	8051.0
2020-03-05	AAL	Stock	17.54	17.65	15.98	16.04	44656800.0
2020-03-05	AAM.A-DELISTED	Stock	26.15	26.22	26.06	26.12	25317.0
2020-03-05	AAM.B-DELISTED	Stock	26.68	26.85	26.5	26.8	28086.0
2020-03-05	AAMC-DELISTED	Stock	6.2941	6.9353	6.1765	6.9353	10214.0
2020-03-05	AAME	Stock	2.25	2.57	2.25	2.52	2200.0
2020-03-05	AAMI	Stock	8.15	8.24	7.57	8.06	912500.0
2020-03-05	AAOI	Stock	9.19	9.25	8.86	9.04	558300.0
2020-03-05	AAON	Stock	38.6	39.7667	38.1067	39.0733	334650.0
2020-03-05	AAP	Stock	129.19	129.77	126.0	126.92	1157100.0
2020-03-05	AAT	Stock	42.3	42.59	41.72	42.25	287000.0
2020-03-05	AAU-DELISTED	Stock	0.415	0.415	0.372	0.3831	297965.0
2020-03-05	AAUAF-DELISTED	Stock	0.415	0.415	0.372	0.3831	306732.0
2020-03-05	AAWW-DELISTED	Stock	25.55	25.87	23.77	23.88	520087.0
2020-03-05	AAXJ	Stock	69.81	70.11	68.98	69.0	1652889.0
2020-03-05	AAXN-DELISTED	Stock	78.24	79.64	73.85	75.18	620114.0
2020-03-05	AB	Stock	32.35	32.35	30.92	31.15	628500.0
2020-03-05	ABB-DELISTED	Stock	21.41	21.635	21.18	21.36	2651698.0
2020-03-05	ABBNY-DELISTED	Stock	21.41	21.635	21.18	21.36	2842958.0
2020-03-05	ABBV	Stock	90.06	91.71	89.43	90.61	9688400.0
2020-03-05	ABC-DELISTED	Stock	88.0	90.08	85.25	86.99	989521.0
2020-03-05	ABCB	Stock	33.95	34.87	33.71	34.16	619000.0
2020-03-05	ABEO	Stock	80.0	82.25	74.5	74.75	45200.0
2020-03-05	ABEV	Stock	3.24	3.34	3.24	3.31	66466000.0
2020-03-05	ABG	Stock	92.01	92.17	87.51	88.62	183600.0
2020-03-05	ABM	Stock	35.5	36.42	33.95	35.06	737500.0
2020-03-05	ABMD-DELISTED	Stock	152.58	154.78	150.0	154.7	419700.0
2020-03-05	ABR	Stock	12.71	12.76	12.16	12.23	1721600.0
2020-03-05	ABR.A-DELISTED	Stock	25.49	25.98	25.4005	25.76	2117.0
2020-03-05	ABR.B-DELISTED	Stock	25.5291	25.74	25.4885	25.4885	1555.0
2020-03-05	ABR.C-DELISTED	Stock	25.75	25.8988	25.65	25.65	3867.0
2020-03-05	ABT	Stock	80.29	81.47	79.13	80.52	9288700.0
2020-03-05	ABTC	Stock	228300.0	236430.0	217500.0	223500.0	0.8533333333333334
2020-03-05	ABTS	Stock	18.45	18.45	18.0	18.0	513.0
2020-03-05	ABTX-DELISTED	Stock	33.13	33.13	31.68	32.16	75074.0
2020-03-05	ABUS	Stock	3.01	3.09	2.91	3.0	253200.0

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

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