PREVIEW / stock_daily / 2020-06-18

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-18.parquet
  size:    222 KB
  rows:    6,714
  symbols: 2,394

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-06-18	AAPL	Stock	87.8525	88.3625	87.305	87.9325	96820400.0
2020-06-18	MSFT	Stock	194.0	196.49	194.0	196.32	23061600.0
2020-06-18	NVDA	Stock	9.227	9.2825	9.1145	9.218	254408000.0
2020-06-18	AMZN	Stock	132.3505	132.982	131.8055	132.699	49756000.0
2020-06-18	GOOGL	Stock	72.4925	72.6485	71.3118	71.706	34861420.0
2020-06-18	META	Stock	234.99	236.14	232.15	235.94	15782500.0
2020-06-18	TSLA	Stock	66.8667	67.9467	66.298	66.9307	146278500.0
2020-06-18	TLT	Stock	162.04	162.48	161.61	162.26	7691375.0
2020-06-18	ES	Stock	84.55	85.25	83.66	84.72	1240200.0
2020-06-18	CL	Stock	73.74	73.99	73.19	73.61	2975800.0
2020-06-18	A	Stock	87.43	88.5	87.26	88.21	1491500.0
2020-06-18	AA	Stock	11.26	11.935	11.13	11.65	6059700.0
2020-06-18	AACG	Stock	1.08	1.13	0.93	1.0	113400.0
2020-06-18	AAIC-DELISTED	Stock	2.92	3.0	2.85	2.93	521309.0
2020-06-18	AAIC.C-DELISTED	Stock	19.59	20.13	19.59	20.13	800.0
2020-06-18	AAL	Stock	16.37	17.07	16.28	16.49	64265300.0
2020-06-18	AAM.A-DELISTED	Stock	26.08	26.24	25.71	26.24	24420.0
2020-06-18	AAM.B-DELISTED	Stock	25.75	25.98	25.7117	25.98	16338.0
2020-06-18	AAMC-DELISTED	Stock	4.9397	5.0647	4.8926	5.0647	2618.0
2020-06-18	AAME	Stock	1.98	2.78	1.77	1.85	270200.0
2020-06-18	AAMI	Stock	10.36	10.63	10.28	10.39	1186400.0
2020-06-18	AAOI	Stock	10.09	10.14	9.52	9.9	792600.0
2020-06-18	AAON	Stock	35.4733	36.14	35.3533	35.5867	199950.0
2020-06-18	AAP	Stock	147.4	148.84	145.62	147.71	588200.0
2020-06-18	AAT	Stock	29.23	30.09	29.23	29.73	316800.0
2020-06-18	AAU-DELISTED	Stock	0.4983	0.515	0.4833	0.4895	207479.0
2020-06-18	AAUAF-DELISTED	Stock	0.4983	0.515	0.4833	0.4913	223073.0
2020-06-18	AAWW-DELISTED	Stock	39.78	41.38	39.58	40.32	204058.0
2020-06-18	AAXJ	Stock	68.64	69.06	68.64	68.91	2335072.0
2020-06-18	AAXN-DELISTED	Stock	94.36	96.3499	91.8	91.81	848489.0
2020-06-18	AB	Stock	26.76	27.63	26.52	27.6	532300.0
2020-06-18	ABB-DELISTED	Stock	21.36	21.46	21.245	21.32	1459215.0
2020-06-18	ABBNY-DELISTED	Stock	21.36	21.46	21.245	21.32	1536346.0
2020-06-18	ABBV	Stock	95.56	96.45	95.26	96.23	4571600.0
2020-06-18	ABC-DELISTED	Stock	99.68	100.825	98.735	100.24	666585.0
2020-06-18	ABCB	Stock	24.08	25.33	23.72	24.77	295500.0
2020-06-18	ABEO	Stock	75.75	81.75	75.25	78.0	40368.0
2020-06-18	ABEV	Stock	2.6	2.64	2.54	2.59	29712700.0
2020-06-18	ABG	Stock	76.62	79.58	76.62	78.03	178500.0
2020-06-18	ABM	Stock	35.4	39.45	35.01	39.03	2574500.0
2020-06-18	ABMD-DELISTED	Stock	254.0	255.34	250.04	253.37	195989.0
2020-06-18	ABR	Stock	9.5	9.8	9.48	9.66	1380500.0
2020-06-18	ABR.A-DELISTED	Stock	25.02	25.05	24.3388	24.77	2300.0
2020-06-18	ABR.B-DELISTED	Stock	23.2	24.0	23.2	23.5247	5000.0
2020-06-18	ABR.C-DELISTED	Stock	24.9	25.305	24.9	25.19	2958.0
2020-06-18	ABT	Stock	90.5	91.34	89.57	90.28	6022900.0
2020-06-18	ABTC	Stock	291300.0	292590.0	256800.0	270000.0	8.0
2020-06-18	ABTS	Stock	15.0	16.5	14.025	14.55	9660.0
2020-06-18	ABTX-DELISTED	Stock	24.44	25.18	24.44	24.95	78224.0
2020-06-18	ABUS	Stock	1.9	2.08	1.88	1.96	671300.0

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

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