PREVIEW / stock_daily / 2019-05-24

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-24.parquet
  size:    218 KB
  rows:    6,509
  symbols: 2,550

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
2019-05-24	AAPL	Stock	45.05	45.535	44.655	44.7425	94858800.0
2019-05-24	MSFT	Stock	126.91	127.42	125.97	126.24	14123400.0
2019-05-24	NVDA	Stock	3.702	3.7375	3.622	3.6288	357584000.0
2019-05-24	AMZN	Stock	91.7945	92.088	90.8925	91.164	67394000.0
2019-05-24	GOOGL	Stock	57.6	57.718	56.8355	56.9305	18553020.0
2019-05-24	META	Stock	182.33	183.63	180.83	181.06	8807700.0
2019-05-24	TSLA	Stock	13.322	13.332	12.5833	12.7087	212049000.0
2019-05-24	TLT	Stock	127.56	127.78	127.39	127.78	4981893.0
2019-05-24	ES	Stock	74.92	75.43	74.74	74.88	889800.0
2019-05-24	CL	Stock	71.9	72.0	71.14	71.2	2267800.0
2019-05-24	A	Stock	68.14	69.89	68.08	68.36	3852900.0
2019-05-24	AA	Stock	23.45	23.6	22.97	23.01	3783400.0
2019-05-24	AABA-DELISTED	Stock	62.67	63.23	61.73	61.92	4049056.0
2019-05-24	AAC-DELISTED	Stock	1.3	1.31	1.05	1.0989	762092.0
2019-05-24	AACG	Stock	2.0	2.09	1.94	2.0	49200.0
2019-05-24	AAIC-DELISTED	Stock	7.08	7.11	7.0	7.1	244915.0
2019-05-24	AAIC.C-DELISTED	Stock	23.49	23.4995	23.25	23.25	3913.0
2019-05-24	AAL	Stock	29.69	29.94	28.98	29.17	5764000.0
2019-05-24	AAM.A-DELISTED	Stock	25.79	25.79	25.71	25.75	9856.0
2019-05-24	AAM.B-DELISTED	Stock	25.8	25.8	25.75	25.7785	22381.0
2019-05-24	AAMC-DELISTED	Stock	5.6647	5.9692	5.6647	5.9692	3733.0
2019-05-24	AAME	Stock	2.42	2.51	2.42	2.51	700.0
2019-05-24	AAMI	Stock	11.56	11.75	11.53	11.71	397600.0
2019-05-24	AAOI	Stock	8.92	9.16	8.891	9.03	297000.0
2019-05-24	AAON	Stock	30.9	31.26	30.6933	31.1	178650.0
2019-05-24	AAP	Stock	159.72	160.41	155.48	158.09	2127800.0
2019-05-24	AAT	Stock	45.83	46.24	45.6	45.97	275300.0
2019-05-24	AAU-DELISTED	Stock	0.448	0.4638	0.4455	0.4465	40527.0
2019-05-24	AAUAF-DELISTED	Stock	0.448	0.4638	0.4455	0.4465	62777.0
2019-05-24	AAWW-DELISTED	Stock	38.73	39.14	38.59	39.0	148442.0
2019-05-24	AAXJ	Stock	65.78	65.87	65.35	65.43	1140641.0
2019-05-24	AAXN-DELISTED	Stock	67.09	67.48	66.29	67.16	372492.0
2019-05-24	AB	Stock	28.24	28.63	28.21	28.55	133100.0
2019-05-24	ABB-DELISTED	Stock	18.77	18.87	18.71	18.83	1192567.0
2019-05-24	ABBNY-DELISTED	Stock	18.77	18.87	18.71	18.83	1256928.0
2019-05-24	ABBV	Stock	81.09	81.1	79.87	80.06	3872700.0
2019-05-24	ABC-DELISTED	Stock	80.44	81.29	79.94	80.72	570907.0
2019-05-24	ABCB	Stock	35.53	36.29	35.53	36.16	165200.0
2019-05-24	ABDC-DELISTED	Stock	8.51	8.5715	8.45	8.49	30469.0
2019-05-24	ABEO	Stock	163.25	169.5	162.25	163.75	13700.0
2019-05-24	ABEV	Stock	4.25	4.28	4.18	4.26	20154200.0
2019-05-24	ABG	Stock	77.84	79.19	77.84	78.58	53400.0
2019-05-24	ABIL-DELISTED	Stock	1.23	1.29	1.23	1.255	17816.0
2019-05-24	ABM	Stock	37.12	37.4	36.7	37.1	184400.0
2019-05-24	ABMD-DELISTED	Stock	262.97	272.79	262.83	270.39	456597.0
2019-05-24	ABR	Stock	12.97	13.05	12.92	12.94	1252900.0
2019-05-24	ABR.A-DELISTED	Stock	25.88	25.88	25.84	25.84	300.0
2019-05-24	ABR.C-DELISTED	Stock	26.0	26.1735	25.95	26.14	3600.0
2019-05-24	ABT	Stock	76.02	77.08	75.96	76.98	4866300.0
2019-05-24	ABTC	Stock	306600.0	306600.0	306000.0	306300.0	0.16

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

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