PREVIEW / stock_daily / 2021-02-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-12.parquet
  size:    249 KB
  rows:    7,521
  symbols: 2,792

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-02-12	AAPL	Stock	134.35	135.53	133.69	135.37	60145100.0
2021-02-12	MSFT	Stock	243.93	245.3	242.73	244.99	16561100.0
2021-02-12	NVDA	Stock	15.05	15.2912	14.775	14.9613	374756000.0
2021-02-12	AMZN	Stock	162.5	164.0125	161.6655	163.8855	46706000.0
2021-02-12	GOOGL	Stock	103.9885	104.975	103.6785	104.7515	18990500.0
2021-02-12	META	Stock	270.52	271.18	268.34	270.5	9097600.0
2021-02-12	TSLA	Stock	267.0867	272.4433	261.7767	272.04	71304900.0
2021-02-12	TLT	Stock	147.7	148.08	147.03	147.11	14088379.0
2021-02-12	ES	Stock	86.0	86.13	84.81	85.17	1019000.0
2021-02-12	CL	Stock	78.33	78.5	77.78	78.43	2732400.0
2021-02-12	A	Stock	126.93	128.6	126.32	127.98	1278000.0
2021-02-12	AA	Stock	21.09	21.755	20.96	21.66	3306000.0
2021-02-12	AACG	Stock	5.97	6.3	5.57	5.72	1613600.0
2021-02-12	AACQ-DELISTED	Stock	11.3	11.32	11.12	11.27	3184235.0
2021-02-12	AACQU-DELISTED	Stock	12.08	12.1599	11.9713	12.13	164582.0
2021-02-12	AACQW-DELISTED	Stock	2.6	2.62	2.41	2.5	1190647.0
2021-02-12	AAIC-DELISTED	Stock	3.7	3.89	3.68	3.89	224949.0
2021-02-12	AAIC.C-DELISTED	Stock	22.5545	22.5545	22.4	22.4	2010.0
2021-02-12	AAL	Stock	17.01	17.49	16.92	17.27	27522500.0
2021-02-12	AAM.A-DELISTED	Stock	26.15	26.2	26.03	26.17	12409.0
2021-02-12	AAM.B-DELISTED	Stock	26.84	26.84	26.59	26.82	12219.0
2021-02-12	AAMC-DELISTED	Stock	8.2505	8.5294	7.7471	7.7529	12594.0
2021-02-12	AAME	Stock	5.35	6.88	5.3	5.71	2251700.0
2021-02-12	AAMI	Stock	19.59	19.99	19.3	19.84	330700.0
2021-02-12	AAN-DELISTED	Stock	19.78	20.2	19.57	19.97	250200.0
2021-02-12	AAOI	Stock	12.59	12.64	12.02	12.25	455300.0
2021-02-12	AAON	Stock	53.1	53.72	52.5267	52.8067	189300.0
2021-02-12	AAP	Stock	154.95	155.67	152.66	152.81	847100.0
2021-02-12	AAT	Stock	30.18	30.46	29.89	30.08	414600.0
2021-02-12	AAU-DELISTED	Stock	0.89	0.9289	0.85	0.8973	5085291.0
2021-02-12	AAUAF-DELISTED	Stock	0.89	0.9289	0.85	0.9	5219063.0
2021-02-12	AAWW-DELISTED	Stock	53.62	57.49	53.62	56.14	790275.0
2021-02-12	AAXJ	Stock	101.33	101.92	101.13	101.7	674292.0
2021-02-12	AB	Stock	37.8	38.4	37.28	37.66	597000.0
2021-02-12	ABB-DELISTED	Stock	29.27	29.55	29.23	29.52	974591.0
2021-02-12	ABBNY-DELISTED	Stock	29.27	29.55	29.23	29.52	1050056.0
2021-02-12	ABBV	Stock	103.76	104.57	103.15	104.44	3738400.0
2021-02-12	ABC-DELISTED	Stock	103.75	105.45	103.61	105.19	728300.0
2021-02-12	ABCB	Stock	45.37	46.16	45.02	45.93	162300.0
2021-02-12	ABCL	Stock	46.2	46.2	42.66	42.97	714700.0
2021-02-12	ABCM-DELISTED	Stock	23.28	23.79	23.2	23.76	17409.0
2021-02-12	ABEO	Stock	83.0	93.75	71.75	74.0	679596.0
2021-02-12	ABEV	Stock	2.78	2.82	2.76	2.79	11766800.0
2021-02-12	ABG	Stock	157.13	161.68	156.84	157.99	141200.0
2021-02-12	ABM	Stock	40.5	41.92	40.5	41.24	364800.0
2021-02-12	ABMD-DELISTED	Stock	324.54	328.98	321.9	328.17	145839.0
2021-02-12	ABNB	Stock	214.458	216.94	209.0	212.68	3041700.0
2021-02-12	ABR	Stock	15.27	15.45	15.23	15.35	686000.0
2021-02-12	ABR.A-DELISTED	Stock	25.6599	25.66	25.6599	25.66	500.0
2021-02-12	ABR.B-DELISTED	Stock	25.4499	25.4499	25.4499	25.4499	115.0

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

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