PREVIEW / stock_daily / 2020-08-18

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-18.parquet
  size:    224 KB
  rows:    6,792
  symbols: 2,407

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-08-18	AAPL	Stock	114.3525	116.0	114.0075	115.5625	105633600.0
2020-08-18	MSFT	Stock	210.53	212.36	209.21	211.49	21336200.0
2020-08-18	NVDA	Stock	12.45	12.496	12.0862	12.2608	503448000.0
2020-08-18	AMZN	Stock	160.6	166.0	160.291	165.6245	106920000.0
2020-08-18	GOOGL	Stock	76.306	77.8685	76.0833	77.789	28377000.0
2020-08-18	META	Stock	260.95	265.15	259.26	262.34	18690400.0
2020-08-18	TSLA	Stock	126.5993	128.26	123.0073	125.806	247117500.0
2020-08-18	TLT	Stock	164.36	164.87	164.085	164.76	8140643.0
2020-08-18	ES	Stock	87.46	87.9	86.34	86.94	936800.0
2020-08-18	CL	Stock	77.23	78.19	76.94	77.65	4286200.0
2020-08-18	A	Stock	97.71	98.71	97.11	97.86	2008700.0
2020-08-18	AA	Stock	14.62	14.977	14.57	14.76	4570800.0
2020-08-18	AACG	Stock	1.16	1.27	1.12	1.19	176200.0
2020-08-18	AACQU-DELISTED	Stock	10.22	10.22	10.07	10.1249	488755.0
2020-08-18	AAIC-DELISTED	Stock	2.81	2.82	2.73	2.78	206285.0
2020-08-18	AAIC.C-DELISTED	Stock	19.3	19.45	19.16	19.45	1164.0
2020-08-18	AAL	Stock	12.6	12.88	12.51	12.6	33322300.0
2020-08-18	AAM.A-DELISTED	Stock	26.69	27.0	26.56	27.0	9857.0
2020-08-18	AAM.B-DELISTED	Stock	27.36	27.55	27.22	27.43	10703.0
2020-08-18	AAMC-DELISTED	Stock	6.3206	6.8824	6.0147	6.5588	139220.0
2020-08-18	AAME	Stock	2.08	2.23	2.05	2.14	6400.0
2020-08-18	AAMI	Stock	13.5	13.59	13.25	13.28	469100.0
2020-08-18	AAOI	Stock	13.24	13.3	12.64	13.02	682000.0
2020-08-18	AAON	Stock	39.68	40.04	39.5133	39.84	217800.0
2020-08-18	AAP	Stock	170.5	170.5	159.72	162.85	2563500.0
2020-08-18	AAT	Stock	26.78	26.88	26.04	26.16	198500.0
2020-08-18	AAU-DELISTED	Stock	0.8	0.81	0.75	0.7901	648142.0
2020-08-18	AAUAF-DELISTED	Stock	0.8	0.81	0.75	0.803	682063.0
2020-08-18	AAWW-DELISTED	Stock	59.09	59.09	57.02	58.565	392666.0
2020-08-18	AAXJ	Stock	77.61	77.74	77.08	77.62	560946.0
2020-08-18	AAXN-DELISTED	Stock	79.89	80.0	78.3601	79.32	330521.0
2020-08-18	AB	Stock	28.65	28.96	28.2	28.54	260000.0
2020-08-18	ABB-DELISTED	Stock	26.62	26.65	26.39	26.48	829175.0
2020-08-18	ABBNY-DELISTED	Stock	26.6	26.65	26.39	26.47	868221.0
2020-08-18	ABBV	Stock	96.62	96.7	95.15	95.65	4557400.0
2020-08-18	ABC-DELISTED	Stock	104.0	104.4	102.415	102.84	571600.0
2020-08-18	ABCB	Stock	25.71	25.73	24.77	24.86	240400.0
2020-08-18	ABEO	Stock	72.5	72.5	67.25	68.25	34868.0
2020-08-18	ABEV	Stock	2.43	2.45	2.38	2.39	17192200.0
2020-08-18	ABG	Stock	109.0	110.95	107.42	109.65	225600.0
2020-08-18	ABM	Stock	37.02	37.29	36.77	37.11	245700.0
2020-08-18	ABMD-DELISTED	Stock	311.99	314.56	306.5	312.82	124651.0
2020-08-18	ABR	Stock	11.12	11.14	10.72	10.92	1448600.0
2020-08-18	ABR.A-DELISTED	Stock	25.29	25.3978	25.01	25.2989	5920.0
2020-08-18	ABR.B-DELISTED	Stock	25.1248	25.1248	25.0	25.0	200.0
2020-08-18	ABR.C-DELISTED	Stock	25.45	25.6644	25.3501	25.64	8885.0
2020-08-18	ABT	Stock	101.09	101.72	100.43	100.96	3777600.0
2020-08-18	ABTC	Stock	169200.0	190800.0	169200.0	186000.0	2.96
2020-08-18	ABTS	Stock	22.65	23.25	21.15	21.75	9333.0
2020-08-18	ABTX-DELISTED	Stock	25.78	26.0	24.96	25.13	18138.0

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

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