PREVIEW / stock_daily / 2020-12-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-10.parquet
  size:    238 KB
  rows:    7,220
  symbols: 2,625

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-12-10	AAPL	Stock	120.5	123.87	120.15	123.24	81312200.0
2020-12-10	MSFT	Stock	211.77	213.08	210.36	210.52	26733300.0
2020-12-10	NVDA	Stock	12.869	13.0688	12.8495	12.9722	207764000.0
2020-12-10	AMZN	Stock	154.4495	157.105	153.8	155.0745	60604000.0
2020-12-10	GOOGL	Stock	88.13	88.7495	86.6764	88.3825	28688320.0
2020-12-10	META	Stock	275.54	278.73	271.86	277.12	20065100.0
2020-12-10	TSLA	Stock	191.4567	209.25	188.78	209.0233	201249600.0
2020-12-10	TLT	Stock	157.24	158.29	156.83	158.21	10025124.0
2020-12-10	ES	Stock	86.19	86.84	85.1	85.69	1432400.0
2020-12-10	CL	Stock	84.89	85.35	84.39	84.59	2856500.0
2020-12-10	A	Stock	116.94	119.9	116.34	118.81	1630500.0
2020-12-10	AA	Stock	22.625	24.098	22.53	24.01	4988100.0
2020-12-10	AACG	Stock	1.15	1.19	1.15	1.18	4600.0
2020-12-10	AACQ-DELISTED	Stock	10.35	10.36	10.22	10.26	1532047.0
2020-12-10	AACQU-DELISTED	Stock	10.94	10.98	10.87	10.9	77341.0
2020-12-10	AACQW-DELISTED	Stock	1.95	1.99	1.82	1.9	181116.0
2020-12-10	AAIC-DELISTED	Stock	3.69	3.72	3.6218	3.71	124792.0
2020-12-10	AAIC.C-DELISTED	Stock	21.26	21.41	21.26	21.3635	1700.0
2020-12-10	AAL	Stock	16.75	18.04	16.67	17.99	86395200.0
2020-12-10	AAM.A-DELISTED	Stock	26.35	26.3779	26.26	26.365	16221.0
2020-12-10	AAM.B-DELISTED	Stock	27.19	27.3	27.0126	27.14	28156.0
2020-12-10	AAMC-DELISTED	Stock	6.7647	6.7647	6.6912	6.6912	2285.0
2020-12-10	AAME	Stock	2.23	2.27	2.19	2.2	9700.0
2020-12-10	AAMI	Stock	19.23	19.55	18.7	19.49	373900.0
2020-12-10	AAN-DELISTED	Stock	17.1	17.7	17.09	17.62	728800.0
2020-12-10	AAOI	Stock	7.97	8.04	7.76	7.9	489400.0
2020-12-10	AAON	Stock	41.92	42.3333	41.0333	41.6667	193050.0
2020-12-10	AAP	Stock	156.25	158.62	154.56	158.22	841400.0
2020-12-10	AAT	Stock	29.04	29.69	29.04	29.43	169200.0
2020-12-10	AAU-DELISTED	Stock	0.69	0.71	0.6863	0.6968	574781.0
2020-12-10	AAUAF-DELISTED	Stock	0.69	0.71	0.6863	0.7093	605011.0
2020-12-10	AAWW-DELISTED	Stock	55.14	56.2	54.45	56.11	289035.0
2020-12-10	AAXJ	Stock	87.2	88.23	87.08	88.11	1340198.0
2020-12-10	AAXN-DELISTED	Stock	122.02	126.25	121.1	125.45	612157.0
2020-12-10	AB	Stock	31.22	32.65	31.18	32.03	680300.0
2020-12-10	ABB-DELISTED	Stock	26.88	27.185	26.76	26.85	2497011.0
2020-12-10	ABBNY-DELISTED	Stock	26.88	27.185	26.76	26.86	2619571.0
2020-12-10	ABBV	Stock	109.06	109.07	106.67	107.49	6285700.0
2020-12-10	ABC-DELISTED	Stock	100.49	101.565	99.29	99.34	519433.0
2020-12-10	ABCB	Stock	37.31	37.84	35.14	37.62	309200.0
2020-12-10	ABCM-DELISTED	Stock	18.61	18.945	18.4642	18.84	30655.0
2020-12-10	ABEO	Stock	36.25	38.75	35.25	38.25	82636.0
2020-12-10	ABEV	Stock	3.04	3.18	3.03	3.15	38045400.0
2020-12-10	ABG	Stock	142.1	143.9	140.82	141.63	215200.0
2020-12-10	ABM	Stock	40.28	40.97	40.07	40.83	264800.0
2020-12-10	ABMD-DELISTED	Stock	265.68	268.85	261.87	267.93	110793.0
2020-12-10	ABR	Stock	14.01	14.24	13.93	14.21	782900.0
2020-12-10	ABR.A-DELISTED	Stock	25.4895	25.531	25.39	25.496	22140.0
2020-12-10	ABR.B-DELISTED	Stock	25.421	25.421	25.32	25.32	1960.0
2020-12-10	ABR.C-DELISTED	Stock	25.75	25.9	25.75	25.77	1424.0

> showing 50 of 7,220 rows — these rows as CSV

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