PREVIEW / stock_daily / 2020-05-07

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-07.parquet
  size:    215 KB
  rows:    6,546
  symbols: 2,316

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-05-07	AAPL	Stock	75.805	76.2925	75.4925	75.935	115215200.0
2020-05-07	MSFT	Stock	184.17	184.55	182.58	183.6	28316000.0
2020-05-07	NVDA	Stock	7.5845	7.6853	7.533	7.6218	373732000.0
2020-05-07	AMZN	Stock	118.739	118.8	117.1555	118.3805	67928000.0
2020-05-07	GOOGL	Stock	68.0655	68.8	67.627	68.464	30716380.0
2020-05-07	META	Stock	211.16	211.6	209.04	211.26	15152000.0
2020-05-07	TSLA	Stock	51.814	53.0933	51.49	52.0027	172915500.0
2020-05-07	TLT	Stock	163.56	166.37	163.34	166.14	9165455.0
2020-05-07	ES	Stock	78.92	81.33	77.12	77.64	1849600.0
2020-05-07	CL	Stock	68.9	69.65	68.16	68.8	3985800.0
2020-05-07	A	Stock	78.77	79.33	77.54	78.5	1190600.0
2020-05-07	AA	Stock	7.84	8.01	7.36	7.49	10984200.0
2020-05-07	AACG	Stock	0.8	0.8	0.75	0.8	12000.0
2020-05-07	AAIC-DELISTED	Stock	2.59	2.7	2.5521	2.58	243511.0
2020-05-07	AAIC.C-DELISTED	Stock	17.2999	17.3	17.05	17.3	900.0
2020-05-07	AAL	Stock	9.3	9.8	9.29	9.54	61817000.0
2020-05-07	AAM.A-DELISTED	Stock	25.82	25.92	25.73	25.73	13033.0
2020-05-07	AAM.B-DELISTED	Stock	25.634	25.94	25.634	25.802	12984.0
2020-05-07	AAMC-DELISTED	Stock	4.2676	4.5161	4.2676	4.3603	7354.0
2020-05-07	AAME	Stock	1.79	1.79	1.79	1.79	1000.0
2020-05-07	AAMI	Stock	7.75	8.5	7.62	8.18	772800.0
2020-05-07	AAOI	Stock	11.0	12.563	10.97	12.2	1642500.0
2020-05-07	AAON	Stock	33.4067	33.92	31.8867	32.3867	698550.0
2020-05-07	AAP	Stock	122.5	124.91	118.94	119.61	904500.0
2020-05-07	AAT	Stock	27.13	27.59	26.42	26.74	567400.0
2020-05-07	AAU-DELISTED	Stock	0.41	0.4364	0.4051	0.43	358440.0
2020-05-07	AAUAF-DELISTED	Stock	0.41	0.4364	0.4051	0.4344	369009.0
2020-05-07	AAWW-DELISTED	Stock	39.5	39.5	36.0	38.46	1244866.0
2020-05-07	AAXJ	Stock	63.41	63.53	63.0575	63.4	860547.0
2020-05-07	AAXN-DELISTED	Stock	67.54	71.57	67.0	70.25	602950.0
2020-05-07	AB	Stock	22.55	23.27	22.14	22.6	364300.0
2020-05-07	ABB-DELISTED	Stock	17.7	17.995	17.7	17.86	1830036.0
2020-05-07	ABBNY-DELISTED	Stock	17.7	17.995	17.7	17.86	2165020.0
2020-05-07	ABBV	Stock	86.52	86.84	83.56	84.22	11941800.0
2020-05-07	ABC-DELISTED	Stock	86.6	89.83	86.6	88.78	1279369.0
2020-05-07	ABCB	Stock	22.28	22.89	21.68	21.8	353100.0
2020-05-07	ABEO	Stock	60.0	61.0	57.5	58.25	41416.0
2020-05-07	ABEV	Stock	2.1	2.13	1.98	2.0	51914200.0
2020-05-07	ABG	Stock	66.08	67.42	64.98	65.4	278200.0
2020-05-07	ABM	Stock	31.58	31.87	31.4	31.58	363900.0
2020-05-07	ABMD-DELISTED	Stock	188.16	192.33	187.03	188.35	478184.0
2020-05-07	ABR	Stock	6.75	7.09	6.71	6.94	2528700.0
2020-05-07	ABR.A-DELISTED	Stock	23.4	23.4	22.71	23.07	825.0
2020-05-07	ABR.B-DELISTED	Stock	22.1	22.1001	21.8166	22.0	1700.0
2020-05-07	ABR.C-DELISTED	Stock	23.25	24.3999	23.25	23.75	2979.0
2020-05-07	ABT	Stock	92.14	94.54	91.81	93.99	7255000.0
2020-05-07	ABTC	Stock	222000.0	239700.0	222000.0	233400.0	1.48
2020-05-07	ABTS	Stock	10.8	14.7	10.8	12.6	9527.0
2020-05-07	ABTX-DELISTED	Stock	22.37	23.34	22.07	22.85	69836.0
2020-05-07	ABUS	Stock	1.49	1.5	1.38	1.44	821200.0

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

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