PREVIEW / stock_daily / 2020-07-20

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-20.parquet
  size:    222 KB
  rows:    6,737
  symbols: 2,399

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-07-20	AAPL	Stock	96.4175	98.5	96.0625	98.3575	90318000.0
2020-07-20	MSFT	Stock	205.0	212.3	203.01	211.6	36884800.0
2020-07-20	NVDA	Stock	10.2743	10.5312	10.1568	10.5108	284852000.0
2020-07-20	AMZN	Stock	150.01	160.068	149.701	159.842	151964000.0
2020-07-20	GOOGL	Stock	75.75	78.4505	75.1348	78.192	30165540.0
2020-07-20	META	Stock	240.06	246.05	235.64	245.42	20872200.0
2020-07-20	TSLA	Stock	101.2673	110.0	99.2	109.5333	256821000.0
2020-07-20	TLT	Stock	167.51	167.62	166.8	167.19	6907518.0
2020-07-20	ES	Stock	87.4	87.73	86.2	86.61	1471500.0
2020-07-20	CL	Stock	74.97	75.18	73.89	74.2	2134600.0
2020-07-20	A	Stock	94.91	96.22	94.76	95.21	1236800.0
2020-07-20	AA	Stock	12.9	13.092	12.71	12.72	4678600.0
2020-07-20	AACG	Stock	1.7	1.7	1.31	1.38	111800.0
2020-07-20	AACQU-DELISTED	Stock	10.37	10.45	10.37	10.44	446930.0
2020-07-20	AAIC-DELISTED	Stock	3.02	3.07	2.96	2.97	257906.0
2020-07-20	AAIC.C-DELISTED	Stock	18.64	18.92	18.52	18.92	1350.0
2020-07-20	AAL	Stock	11.93	12.51	11.35	11.47	64109600.0
2020-07-20	AAM.A-DELISTED	Stock	26.376	26.51	26.376	26.47	12286.0
2020-07-20	AAM.B-DELISTED	Stock	26.82	27.02	26.774	26.9942	10165.0
2020-07-20	AAMC-DELISTED	Stock	4.25	4.25	4.1412	4.2059	11200.0
2020-07-20	AAME	Stock	1.71	1.84	1.71	1.71	4900.0
2020-07-20	AAMI	Stock	12.33	12.59	12.24	12.52	441700.0
2020-07-20	AAOI	Stock	11.22	12.2	11.16	12.015	862800.0
2020-07-20	AAON	Stock	38.52	38.8533	38.3133	38.34	153150.0
2020-07-20	AAP	Stock	145.2	145.66	142.97	144.9	417700.0
2020-07-20	AAT	Stock	26.04	26.05	24.96	25.1	180700.0
2020-07-20	AAU-DELISTED	Stock	0.51	0.55	0.492	0.5367	1082085.0
2020-07-20	AAUAF-DELISTED	Stock	0.492	0.55	0.492	0.5456	1106961.0
2020-07-20	AAWW-DELISTED	Stock	49.92	51.0	49.51	50.1	226856.0
2020-07-20	AAXJ	Stock	74.37	74.91	74.11	74.82	680516.0
2020-07-20	AAXN-DELISTED	Stock	91.0	93.4	90.7601	92.23	528917.0
2020-07-20	AB	Stock	28.26	28.33	27.9	28.04	272400.0
2020-07-20	ABB-DELISTED	Stock	24.82	24.905	24.67	24.89	1350379.0
2020-07-20	ABBNY-DELISTED	Stock	24.82	24.905	24.67	24.89	1443385.0
2020-07-20	ABBV	Stock	100.76	101.25	99.26	99.54	4823300.0
2020-07-20	ABC-DELISTED	Stock	104.4	104.87	101.68	102.21	555874.0
2020-07-20	ABCB	Stock	21.31	21.65	20.79	21.0	214900.0
2020-07-20	ABEO	Stock	74.75	78.75	73.25	78.5	28728.0
2020-07-20	ABEV	Stock	2.62	2.7	2.62	2.66	36173200.0
2020-07-20	ABG	Stock	99.3	99.76	96.71	98.24	100200.0
2020-07-20	ABM	Stock	35.6	35.82	34.99	35.18	375900.0
2020-07-20	ABMD-DELISTED	Stock	285.0	292.28	283.14	290.76	337160.0
2020-07-20	ABR	Stock	8.6	8.63	8.43	8.56	1184900.0
2020-07-20	ABR.A-DELISTED	Stock	24.89	24.97	24.68	24.76	5074.0
2020-07-20	ABR.B-DELISTED	Stock	23.676	23.89	23.452	23.52	3773.0
2020-07-20	ABR.C-DELISTED	Stock	24.965	24.9814	24.1222	24.69	2744.0
2020-07-20	ABT	Stock	100.0	100.71	98.72	99.08	5677900.0
2020-07-20	ABTC	Stock	207000.0	207870.0	200400.0	203100.0	2.466666666666667
2020-07-20	ABTS	Stock	16.8	17.25	16.65	16.875	4840.0
2020-07-20	ABTX-DELISTED	Stock	22.76	22.99	22.42	22.46	28799.0

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

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