PREVIEW / stock_daily / 2020-09-04

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-04.parquet
  size:    226 KB
  rows:    6,829
  symbols: 2,427

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-09-04	AAPL	Stock	120.07	123.7	110.89	120.96	332607200.0
2020-09-04	MSFT	Stock	215.1	218.36	205.19	214.25	59664100.0
2020-09-04	NVDA	Stock	12.7838	13.175	11.7048	12.6225	1463684000.0
2020-09-04	AMZN	Stock	165.9	169.075	155.5565	164.731	175636000.0
2020-09-04	GOOGL	Stock	80.45	81.7495	76.8985	79.0605	55850660.0
2020-09-04	META	Stock	287.25	289.0	271.14	282.73	30333700.0
2020-09-04	TSLA	Stock	134.27	142.6667	124.0067	139.44	330965700.0
2020-09-04	TLT	Stock	164.41	164.6984	162.45	162.74	13780313.0
2020-09-04	ES	Stock	85.94	86.51	84.54	86.08	1097000.0
2020-09-04	CL	Stock	77.53	78.42	76.34	77.21	3643800.0
2020-09-04	A	Stock	100.07	100.11	95.66	96.84	1753900.0
2020-09-04	AA	Stock	14.52	14.67	13.9	14.4	3929600.0
2020-09-04	AACG	Stock	1.09	1.11	1.07	1.1	27200.0
2020-09-04	AACQ-DELISTED	Stock	10.0	10.0	9.95	10.0	11506.0
2020-09-04	AACQU-DELISTED	Stock	10.2	10.45	10.17	10.38	327737.0
2020-09-04	AACQW-DELISTED	Stock	1.75	1.75	1.75	1.75	43306.0
2020-09-04	AAIC-DELISTED	Stock	2.72	2.77	2.66	2.72	283739.0
2020-09-04	AAIC.C-DELISTED	Stock	19.31	19.31	19.3	19.3	590.0
2020-09-04	AAL	Stock	13.65	13.82	12.96	13.61	64937000.0
2020-09-04	AAM.A-DELISTED	Stock	26.47	26.47	26.07	26.21	19154.0
2020-09-04	AAM.B-DELISTED	Stock	27.145	27.22	26.66	26.82	13717.0
2020-09-04	AAMC-DELISTED	Stock	6.2412	6.2441	5.7868	6.1588	31450.0
2020-09-04	AAME	Stock	2.03	2.03	1.97	2.02	4500.0
2020-09-04	AAMI	Stock	13.83	13.92	13.2	13.53	381200.0
2020-09-04	AAOI	Stock	11.0	11.07	9.88	10.52	948600.0
2020-09-04	AAON	Stock	38.54	38.6067	37.6067	37.62	192000.0
2020-09-04	AAP	Stock	155.89	156.01	150.76	153.75	589100.0
2020-09-04	AAT	Stock	26.32	26.48	25.55	26.15	295500.0
2020-09-04	AAU-DELISTED	Stock	0.68	0.6899	0.64	0.6736	445507.0
2020-09-04	AAUAF-DELISTED	Stock	0.68	0.6899	0.64	0.681	456562.0
2020-09-04	AAWW-DELISTED	Stock	55.46	56.54	53.09	55.73	284391.0
2020-09-04	AAXJ	Stock	77.43	77.77	75.96	77.38	1675271.0
2020-09-04	AAXN-DELISTED	Stock	84.98	85.52	81.15	82.72	368277.0
2020-09-04	AB	Stock	28.5	28.69	27.4	28.1	325700.0
2020-09-04	ABB-DELISTED	Stock	25.64	25.89	25.17	25.74	4339355.0
2020-09-04	ABBNY-DELISTED	Stock	25.64	25.89	25.17	25.74	4527382.0
2020-09-04	ABBV	Stock	92.08	93.13	90.58	91.87	9444800.0
2020-09-04	ABC-DELISTED	Stock	97.5	97.66	95.49	96.58	543094.0
2020-09-04	ABCB	Stock	25.43	25.63	24.84	25.22	228200.0
2020-09-04	ABEO	Stock	52.5	53.0	47.0	49.5	28692.0
2020-09-04	ABEV	Stock	2.41	2.43	2.35	2.37	15147900.0
2020-09-04	ABG	Stock	107.57	108.05	103.21	106.32	123100.0
2020-09-04	ABM	Stock	38.5	38.83	37.84	38.33	274700.0
2020-09-04	ABMD-DELISTED	Stock	295.26	295.26	271.06	275.63	334041.0
2020-09-04	ABR	Stock	11.25	11.47	10.89	11.32	923100.0
2020-09-04	ABR.A-DELISTED	Stock	25.0673	25.15	25.0	25.15	2510.0
2020-09-04	ABR.B-DELISTED	Stock	25.12	25.44	25.0	25.41	684.0
2020-09-04	ABR.C-DELISTED	Stock	25.49	25.577	25.15	25.515	7760.0
2020-09-04	ABT	Stock	105.45	106.04	102.42	104.16	5027700.0
2020-09-04	ABTC	Stock	148200.0	149400.0	139200.0	141300.0	3.3066666666666666

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

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