PREVIEW / stock_daily / 2020-10-15

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-15.parquet
  size:    227 KB
  rows:    6,902
  symbols: 2,452

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-10-15	AAPL	Stock	118.72	121.2	118.15	120.71	112559200.0
2020-10-15	MSFT	Stock	217.1	220.36	216.01	219.66	22733100.0
2020-10-15	NVDA	Stock	13.8108	14.0058	13.7678	13.97	267224000.0
2020-10-15	AMZN	Stock	164.6005	167.794	164.0	166.9325	104468000.0
2020-10-15	GOOGL	Stock	77.225	78.5698	77.0565	77.7735	31229700.0
2020-10-15	META	Stock	267.6	269.04	263.67	266.72	15416100.0
2020-10-15	TSLA	Stock	150.1033	152.19	147.5	149.6267	107017200.0
2020-10-15	TLT	Stock	163.04	163.19	161.64	161.84	9458911.0
2020-10-15	ES	Stock	91.32	91.88	90.4	91.02	1399800.0
2020-10-15	CL	Stock	79.42	80.14	79.28	79.71	3375800.0
2020-10-15	A	Stock	104.1	105.72	103.88	105.32	723000.0
2020-10-15	AA	Stock	11.45	12.44	11.41	12.3	13471700.0
2020-10-15	AACG	Stock	1.1	1.18	1.1	1.17	59900.0
2020-10-15	AACQ-DELISTED	Stock	9.85	9.85	9.72	9.79	329671.0
2020-10-15	AACQU-DELISTED	Stock	10.35	10.37	10.34	10.35	8608.0
2020-10-15	AACQW-DELISTED	Stock	1.36	1.37	1.3301	1.35	156467.0
2020-10-15	AAIC-DELISTED	Stock	2.8	2.82	2.75	2.79	114039.0
2020-10-15	AAIC.C-DELISTED	Stock	18.7	18.7	18.7	18.7	1242.0
2020-10-15	AAL	Stock	12.22	12.3	11.97	12.23	33776100.0
2020-10-15	AAM.A-DELISTED	Stock	26.316	26.41	26.29	26.3824	5056.0
2020-10-15	AAM.B-DELISTED	Stock	27.25	27.401	27.25	27.35	13342.0
2020-10-15	AAMC-DELISTED	Stock	5.5882	5.7588	5.5882	5.7353	9136.0
2020-10-15	AAME	Stock	1.97	2.28	1.9	2.15	10200.0
2020-10-15	AAMI	Stock	15.49	15.89	15.38	15.82	340500.0
2020-10-15	AAOI	Stock	11.0	11.28	10.77	11.22	283500.0
2020-10-15	AAON	Stock	42.3267	42.4533	41.6067	42.1933	233250.0
2020-10-15	AAP	Stock	154.98	157.91	154.08	157.52	697300.0
2020-10-15	AAT	Stock	24.11	24.86	24.05	24.6	116600.0
2020-10-15	AAU-DELISTED	Stock	1.03	1.03	0.945	0.9975	740166.0
2020-10-15	AAUAF-DELISTED	Stock	1.03	1.03	0.945	1.01	837116.0
2020-10-15	AAWW-DELISTED	Stock	67.3	67.45	64.21	67.22	228183.0
2020-10-15	AAXJ	Stock	78.81	79.44	78.64	79.3	1392648.0
2020-10-15	AAXN-DELISTED	Stock	100.05	106.55	99.0001	105.775	711898.0
2020-10-15	AB	Stock	32.71	33.45	32.43	33.17	469900.0
2020-10-15	ABB-DELISTED	Stock	26.37	26.69	26.33	26.65	1041339.0
2020-10-15	ABBNY-DELISTED	Stock	26.37	26.69	26.33	26.65	1105593.0
2020-10-15	ABBV	Stock	85.41	85.74	84.96	85.23	6190900.0
2020-10-15	ABC-DELISTED	Stock	97.89	100.61	97.25	99.35	828372.0
2020-10-15	ABCB	Stock	24.9	26.26	24.5	26.06	309700.0
2020-10-15	ABEO	Stock	33.0	34.0	32.0	33.25	45696.0
2020-10-15	ABEV	Stock	2.44	2.46	2.42	2.42	10224600.0
2020-10-15	ABG	Stock	111.38	117.56	109.79	116.64	172100.0
2020-10-15	ABM	Stock	35.76	35.82	34.91	34.98	400500.0
2020-10-15	ABMD-DELISTED	Stock	275.09	285.92	270.03	283.82	183689.0
2020-10-15	ABR	Stock	11.74	11.94	11.7	11.85	906700.0
2020-10-15	ABR.A-DELISTED	Stock	25.2	25.38	25.2	25.23	1075.0
2020-10-15	ABR.C-DELISTED	Stock	25.44	25.5425	25.33	25.5425	6404.0
2020-10-15	ABT	Stock	106.85	107.74	106.31	107.32	3518500.0
2020-10-15	ABTC	Stock	135300.0	137100.0	128100.0	133800.0	6.733333333333333
2020-10-15	ABTS	Stock	14.7	16.8	14.4	15.93	21413.0

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

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