PREVIEW / stock_daily / 2021-10-27

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-27.parquet
  size:    259 KB
  rows:    7,934
  symbols: 2,685

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-10-27	AAPL	Stock	149.36	149.73	148.49	148.85	56094900.0
2021-10-27	MSFT	Stock	316.0	326.1	316.0	323.17	52588700.0
2021-10-27	NVDA	Stock	24.474	25.09	24.282	24.451	245990000.0
2021-10-27	AMZN	Stock	169.4	171.85	168.5725	169.6245	54044000.0
2021-10-27	GOOGL	Stock	139.405	148.65	139.405	146.2175	85781400.0
2021-10-27	META	Stock	314.19	319.25	312.06	312.22	29971800.0
2021-10-27	TSLA	Stock	346.5533	356.96	343.5933	345.9533	115579500.0
2021-10-27	TLT	Stock	146.4	148.18	145.93	147.74	22092262.0
2021-10-27	ES	Stock	86.57	86.69	85.11	85.58	1145500.0
2021-10-27	CL	Stock	76.31	76.61	75.61	75.9	4583100.0
2021-10-27	A	Stock	158.3	158.5	154.83	155.26	1472600.0
2021-10-27	AA	Stock	47.48	47.92	45.45	45.89	12864700.0
2021-10-27	AAC-DELISTED	Stock	9.83	9.83	9.78	9.83	152477.0
2021-10-27	AACG	Stock	2.34	2.47	2.27	2.28	75900.0
2021-10-27	AAIC-DELISTED	Stock	3.9	3.91	3.8636	3.91	89332.0
2021-10-27	AAIC.C-DELISTED	Stock	25.25	25.25	25.2409	25.25	1504.0
2021-10-27	AAL	Stock	19.45	19.57	18.97	19.03	22215000.0
2021-10-27	AAM.A-DELISTED	Stock	26.0	26.0	25.93	25.95	8261.0
2021-10-27	AAM.B-DELISTED	Stock	27.06	27.205	26.999	27.06	37534.0
2021-10-27	AAMC-DELISTED	Stock	7.7735	7.8529	7.2206	7.3382	108423.0
2021-10-27	AAME	Stock	4.0	4.08	3.98	3.98	14900.0
2021-10-27	AAMI	Stock	26.97	27.12	26.71	26.76	488200.0
2021-10-27	AAN-DELISTED	Stock	23.76	24.11	22.264	23.2	663000.0
2021-10-27	AAOI	Stock	7.5	7.88	7.5	7.69	385900.0
2021-10-27	AAON	Stock	46.52	47.1667	46.1133	46.1267	116850.0
2021-10-27	AAP	Stock	232.63	233.8	230.34	230.35	485800.0
2021-10-27	AAQC-DELISTED	Stock	9.73	9.74	9.73	9.74	1929.0
2021-10-27	AAT	Stock	39.21	39.21	37.85	38.21	146200.0
2021-10-27	AATC	Stock	6.7782	7.0	6.75	6.79	37875.0
2021-10-27	AAU-DELISTED	Stock	0.39	0.3987	0.38	0.3914	1075022.0
2021-10-27	AAUAF-DELISTED	Stock	0.39	0.3986	0.38	0.3914	1089157.0
2021-10-27	AAWW-DELISTED	Stock	81.45	82.19	79.64	79.9	178108.0
2021-10-27	AAXJ	Stock	87.61	87.85	87.23	87.23	538352.0
2021-10-27	AB	Stock	55.55	56.12	55.0	55.74	201400.0
2021-10-27	ABB-DELISTED	Stock	33.27	33.31	33.06	33.06	1553057.0
2021-10-27	ABBNY-DELISTED	Stock	33.27	33.31	33.05	33.05	1696586.0
2021-10-27	ABBV	Stock	109.58	109.72	108.17	108.4	4875300.0
2021-10-27	ABC-DELISTED	Stock	122.56	122.56	119.54	119.57	407922.0
2021-10-27	ABCB	Stock	53.8	53.8	52.38	52.58	336300.0
2021-10-27	ABCL	Stock	15.54	15.73	15.03	15.37	1068900.0
2021-10-27	ABCM-DELISTED	Stock	22.77	22.99	22.67	22.83	18002.0
2021-10-27	ABEO	Stock	22.0	22.0	21.0	21.25	17068.0
2021-10-27	ABEV	Stock	2.76	2.78	2.68	2.68	29668400.0
2021-10-27	ABG	Stock	208.27	208.27	198.06	198.63	232500.0
2021-10-27	ABGI-DELISTED	Stock	9.77	9.78	9.74	9.78	81413.0
2021-10-27	ABM	Stock	43.81	43.86	42.94	43.1	280000.0
2021-10-27	ABMD-DELISTED	Stock	348.71	350.34	343.12	344.21	101182.0
2021-10-27	ABNB	Stock	170.74	172.65	168.88	169.1	3009800.0
2021-10-27	ABOS	Stock	15.13	15.34	14.44	14.59	59300.0
2021-10-27	ABR	Stock	19.9	19.92	19.76	19.82	798200.0

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

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