PREVIEW / stock_daily / 2020-02-20

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-20.parquet
  size:    222 KB
  rows:    6,616
  symbols: 2,387

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-02-20	AAPL	Stock	80.6575	81.1625	79.5525	80.075	100566000.0
2020-02-20	MSFT	Stock	186.95	187.25	181.1	184.42	36862400.0
2020-02-20	NVDA	Stock	7.8192	7.908	7.4088	7.7175	810052000.0
2020-02-20	AMZN	Stock	108.6535	108.8395	106.3725	107.655	62626000.0
2020-02-20	GOOGL	Stock	75.9505	76.3535	75.2128	75.8495	25967720.0
2020-02-20	META	Stock	216.52	218.77	212.95	214.58	13109200.0
2020-02-20	TSLA	Stock	60.7967	60.8	57.3293	59.9607	264523500.0
2020-02-20	TLT	Stock	146.08	146.94	145.9985	146.67	9332916.0
2020-02-20	ES	Stock	97.07	99.42	94.77	95.65	2063200.0
2020-02-20	CL	Stock	75.46	75.65	74.25	75.16	3350900.0
2020-02-20	A	Stock	84.9	84.99	83.36	84.34	2543600.0
2020-02-20	AA	Stock	16.65	16.72	16.07	16.1	7682000.0
2020-02-20	AACG	Stock	1.22	1.3	1.17	1.24	29300.0
2020-02-20	AAIC-DELISTED	Stock	6.63	6.76	6.62	6.69	563772.0
2020-02-20	AAIC.C-DELISTED	Stock	23.507	23.708	23.507	23.7	18875.0
2020-02-20	AAL	Stock	28.24	28.9	28.2	28.51	10093400.0
2020-02-20	AAM.A-DELISTED	Stock	26.93	26.98	26.88	26.9	18956.0
2020-02-20	AAM.B-DELISTED	Stock	27.69	27.83	27.69	27.69	18458.0
2020-02-20	AAMC-DELISTED	Stock	6.0088	6.4706	5.5882	6.4609	96903.0
2020-02-20	AAME	Stock	2.51	2.6	2.21	2.25	2900.0
2020-02-20	AAMI	Stock	10.4	11.0	10.4	10.9	334800.0
2020-02-20	AAOI	Stock	12.02	12.299	11.587	11.82	827500.0
2020-02-20	AAON	Stock	37.8467	38.3667	37.3467	37.66	137100.0
2020-02-20	AAP	Stock	140.15	142.86	139.54	142.48	671600.0
2020-02-20	AAT	Stock	45.49	45.62	45.16	45.39	410800.0
2020-02-20	AAU-DELISTED	Stock	0.42	0.44	0.42	0.4308	407016.0
2020-02-20	AAUAF-DELISTED	Stock	0.42	0.44	0.42	0.4308	471260.0
2020-02-20	AAWW-DELISTED	Stock	32.04	33.85	31.51	33.245	965252.0
2020-02-20	AAXJ	Stock	72.48	72.505	71.66	71.84	3066418.0
2020-02-20	AAXN-DELISTED	Stock	86.15	87.89	82.33	86.46	652668.0
2020-02-20	AB	Stock	35.63	36.06	35.45	35.82	718200.0
2020-02-20	ABB-DELISTED	Stock	24.4	24.54	24.145	24.3	1061636.0
2020-02-20	ABBNY-DELISTED	Stock	24.4	24.54	24.145	24.3	1131380.0
2020-02-20	ABBV	Stock	93.93	94.39	92.59	94.23	5446200.0
2020-02-20	ABC-DELISTED	Stock	95.0	96.99	93.95	96.53	1602897.0
2020-02-20	ABCB	Stock	40.41	41.14	40.21	41.05	363500.0
2020-02-20	ABEO	Stock	100.75	103.0	92.75	100.5	92480.0
2020-02-20	ABEV	Stock	3.68	3.71	3.65	3.69	32074200.0
2020-02-20	ABG	Stock	98.55	100.03	98.35	99.74	236400.0
2020-02-20	ABM	Stock	38.57	39.21	38.43	38.99	267500.0
2020-02-20	ABMD-DELISTED	Stock	168.45	169.18	165.17	167.95	497663.0
2020-02-20	ABR	Stock	14.69	14.79	14.62	14.75	823700.0
2020-02-20	ABR.A-DELISTED	Stock	26.12	26.2505	26.12	26.2505	200.0
2020-02-20	ABR.B-DELISTED	Stock	25.8	25.82	25.8	25.82	1300.0
2020-02-20	ABR.C-DELISTED	Stock	26.409	26.49	26.409	26.49	700.0
2020-02-20	ABT	Stock	89.1	89.56	88.04	88.46	3657500.0
2020-02-20	ABTC	Stock	208800.0	217500.0	204930.0	211800.0	2.546666666666667
2020-02-20	ABTS	Stock	28.35	28.35	26.4	27.0	280.0
2020-02-20	ABTX-DELISTED	Stock	37.6	38.13	37.36	37.82	43597.0
2020-02-20	ABUS	Stock	3.47	3.56	3.25	3.42	1333400.0

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

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