PREVIEW / stock_daily / 2020-03-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-02.parquet
  size:    222 KB
  rows:    6,637
  symbols: 2,398

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-02	AAPL	Stock	70.57	75.36	69.43	74.7025	341397200.0
2020-03-02	MSFT	Stock	165.31	172.92	162.31	172.79	71030800.0
2020-03-02	NVDA	Stock	6.9225	6.9398	6.525	6.9108	890744000.0
2020-03-02	AMZN	Stock	95.3245	97.7255	93.5	97.6975	135234000.0
2020-03-02	GOOGL	Stock	67.5695	69.3735	66.26	69.316	55429260.0
2020-03-02	META	Stock	194.03	196.57	188.85	196.44	24949000.0
2020-03-02	TSLA	Stock	47.4173	49.5793	45.778	49.5747	302925000.0
2020-03-02	TLT	Stock	155.3	156.5	153.76	153.94	28152383.0
2020-03-02	ES	Stock	86.61	93.71	86.61	93.62	3191500.0
2020-03-02	CL	Stock	68.51	72.56	68.51	72.44	7940800.0
2020-03-02	A	Stock	77.31	82.0	77.24	81.97	3407500.0
2020-03-02	AA	Stock	14.02	14.03	13.11	13.73	6784800.0
2020-03-02	AACG	Stock	1.0	1.0	0.98	0.98	13500.0
2020-03-02	AAIC-DELISTED	Stock	5.7	5.96	5.67	5.93	478404.0
2020-03-02	AAIC.C-DELISTED	Stock	22.2	22.88	22.18	22.88	2693.0
2020-03-02	AAL	Stock	19.05	19.06	17.51	18.86	38738000.0
2020-03-02	AAM.A-DELISTED	Stock	25.72	26.0	25.5701	26.0	36985.0
2020-03-02	AAM.B-DELISTED	Stock	25.78	26.32	25.75	26.3	28628.0
2020-03-02	AAMC-DELISTED	Stock	6.1176	6.1176	6.1176	6.1176	1571.0
2020-03-02	AAME	Stock	2.48	2.61	2.16	2.61	1700.0
2020-03-02	AAMI	Stock	9.38	9.38	8.945	9.16	935500.0
2020-03-02	AAOI	Stock	8.95	9.28	8.65	9.03	934700.0
2020-03-02	AAON	Stock	36.7667	38.6533	35.9	38.5933	341400.0
2020-03-02	AAP	Stock	133.45	133.45	128.04	132.99	1403000.0
2020-03-02	AAT	Stock	40.91	42.97	40.91	42.91	599000.0
2020-03-02	AAU-DELISTED	Stock	0.38	0.4	0.3726	0.387	438217.0
2020-03-02	AAUAF-DELISTED	Stock	0.38	0.4	0.3726	0.3869	445340.0
2020-03-02	AAWW-DELISTED	Stock	26.97	27.17	25.41	26.58	622851.0
2020-03-02	AAXJ	Stock	68.32	69.31	67.86	69.31	3489603.0
2020-03-02	AAXN-DELISTED	Stock	77.93	82.68	75.75	82.34	1147924.0
2020-03-02	AB	Stock	30.4	32.79	30.4	32.64	949500.0
2020-03-02	ABB-DELISTED	Stock	21.7	22.01	21.32	22.0	2978645.0
2020-03-02	ABBNY-DELISTED	Stock	21.69	22.01	21.32	22.01	3205747.0
2020-03-02	ABBV	Stock	86.0	88.78	83.55	88.69	12171100.0
2020-03-02	ABC-DELISTED	Stock	84.53	88.32	83.89	87.11	3620456.0
2020-03-02	ABCB	Stock	34.26	35.29	33.68	35.27	535600.0
2020-03-02	ABEO	Stock	77.0	85.0	72.5	84.0	107112.0
2020-03-02	ABEV	Stock	3.27	3.33	3.25	3.31	41766600.0
2020-03-02	ABG	Stock	88.9	93.11	86.55	93.03	364000.0
2020-03-02	ABM	Stock	33.0	34.77	32.6	34.72	691000.0
2020-03-02	ABMD-DELISTED	Stock	151.09	155.49	148.03	155.1	536180.0
2020-03-02	ABR	Stock	12.19	13.01	12.1	12.99	2428800.0
2020-03-02	ABR.A-DELISTED	Stock	25.9	25.9	25.64	25.64	2774.0
2020-03-02	ABR.B-DELISTED	Stock	25.25	25.66	25.25	25.66	2641.0
2020-03-02	ABR.C-DELISTED	Stock	25.31	25.91	25.31	25.91	5433.0
2020-03-02	ABT	Stock	77.88	81.68	77.25	81.61	11483600.0
2020-03-02	ABTC	Stock	228000.0	250500.0	225300.0	248100.0	3.8800000000000003
2020-03-02	ABTS	Stock	23.22	23.22	23.22	23.22	60.0
2020-03-02	ABTX-DELISTED	Stock	33.24	34.2	32.89	34.13	65021.0
2020-03-02	ABUS	Stock	2.88	2.96	2.77	2.85	247700.0

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

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