PREVIEW / stock_daily / 2021-01-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-12.parquet
  size:    242 KB
  rows:    7,306
  symbols: 2,659

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
2021-01-12	AAPL	Stock	128.5	129.69	126.86	128.8	91951100.0
2021-01-12	MSFT	Stock	216.5	217.1	213.32	214.93	23249300.0
2021-01-12	NVDA	Stock	13.7525	13.7545	13.345	13.4848	291476000.0
2021-01-12	AMZN	Stock	156.0	157.107	154.3	156.0415	70292000.0
2021-01-12	GOOGL	Stock	87.268	88.395	85.8188	86.8715	29534300.0
2021-01-12	META	Stock	256.63	259.72	250.3	251.09	26383500.0
2021-01-12	TSLA	Stock	277.0	289.3333	275.78	283.1467	138812100.0
2021-01-12	TLT	Stock	150.79	151.16	149.925	150.95	12186305.0
2021-01-12	ES	Stock	89.07	90.0	88.4	89.49	1197600.0
2021-01-12	CL	Stock	81.88	82.75	81.85	82.26	4359800.0
2021-01-12	A	Stock	128.33	128.39	126.2	126.97	1826400.0
2021-01-12	AA	Stock	24.78	25.45	24.54	25.08	2843600.0
2021-01-12	AACG	Stock	1.25	1.26	1.2	1.25	63600.0
2021-01-12	AACQ-DELISTED	Stock	10.56	11.1	10.56	11.0	2676263.0
2021-01-12	AACQU-DELISTED	Stock	11.3	11.9	11.24	11.8	179719.0
2021-01-12	AACQW-DELISTED	Stock	2.2	2.62	2.15	2.32	924807.0
2021-01-12	AAIC-DELISTED	Stock	3.93	3.97	3.9	3.97	125389.0
2021-01-12	AAIC.C-DELISTED	Stock	21.1424	21.22	21.1424	21.22	750.0
2021-01-12	AAL	Stock	15.08	15.43	14.88	15.38	45742400.0
2021-01-12	AAM.A-DELISTED	Stock	26.32	26.44	26.15	26.44	31765.0
2021-01-12	AAM.B-DELISTED	Stock	26.83	26.83	26.49	26.75	26698.0
2021-01-12	AAMC-DELISTED	Stock	6.5647	6.5912	6.0882	6.2294	30114.0
2021-01-12	AAME	Stock	2.25	2.37	2.22	2.22	23400.0
2021-01-12	AAMI	Stock	20.9	21.08	20.52	21.0	293000.0
2021-01-12	AAN-DELISTED	Stock	20.57	20.9	20.25	20.85	548000.0
2021-01-12	AAOI	Stock	10.34	10.56	10.235	10.4	897900.0
2021-01-12	AAON	Stock	46.74	47.7067	46.0467	47.5733	213150.0
2021-01-12	AAP	Stock	170.84	177.92	170.7	176.67	1101000.0
2021-01-12	AAT	Stock	27.78	28.3	27.6	28.16	140500.0
2021-01-12	AAU-DELISTED	Stock	0.5204	0.62	0.514	0.5813	7264954.0
2021-01-12	AAUAF-DELISTED	Stock	0.5204	0.62	0.514	0.59	7355789.0
2021-01-12	AAWW-DELISTED	Stock	51.19	52.93	50.75	52.36	319188.0
2021-01-12	AAXJ	Stock	94.71	95.035	94.36	94.68	1776816.0
2021-01-12	AAXN-DELISTED	Stock	126.36	135.05	126.36	135.03	1023730.0
2021-01-12	AB	Stock	35.79	36.07	35.5	35.9	344700.0
2021-01-12	ABB-DELISTED	Stock	30.06	30.37	30.01	30.33	1387649.0
2021-01-12	ABBNY-DELISTED	Stock	30.06	30.37	30.01	30.34	1468025.0
2021-01-12	ABBV	Stock	109.22	110.78	109.12	109.78	6106900.0
2021-01-12	ABC-DELISTED	Stock	107.49	107.77	106.15	106.53	1108809.0
2021-01-12	ABCB	Stock	43.8	44.89	43.48	44.17	541500.0
2021-01-12	ABCL	Stock	37.0	40.35	36.77	39.95	1447400.0
2021-01-12	ABCM-DELISTED	Stock	21.93	23.96	21.75	23.54	195427.0
2021-01-12	ABEO	Stock	46.0	48.75	44.5	45.5	90076.0
2021-01-12	ABEV	Stock	3.01	3.2	3.0	3.19	22136800.0
2021-01-12	ABG	Stock	163.52	172.32	162.57	167.55	157900.0
2021-01-12	ABM	Stock	40.91	41.88	40.52	41.63	207000.0
2021-01-12	ABMD-DELISTED	Stock	323.23	328.59	322.06	324.27	181800.0
2021-01-12	ABNB	Stock	148.08	163.88	143.61	160.8	8123600.0
2021-01-12	ABR	Stock	14.25	14.37	14.05	14.26	1039300.0
2021-01-12	ABR.A-DELISTED	Stock	25.6002	25.6002	25.6002	25.6002	200.0

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

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