PREVIEW / stock_daily / 2021-09-24

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-24.parquet
  size:    256 KB
  rows:    7,807
  symbols: 2,652

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-09-24	AAPL	Stock	145.66	147.47	145.56	146.92	53477900.0
2021-09-24	MSFT	Stock	298.23	299.8	296.93	299.35	14999000.0
2021-09-24	NVDA	Stock	22.07	22.149	21.861	22.081	217655000.0
2021-09-24	AMZN	Stock	170.1005	171.463	169.67	171.276	42324000.0
2021-09-24	GOOGL	Stock	140.5385	142.3302	140.241	142.215	22983900.0
2021-09-24	META	Stock	343.24	354.35	342.37	352.96	18801900.0
2021-09-24	TSLA	Stock	248.63	258.2667	248.1867	258.13	64119000.0
2021-09-24	TLT	Stock	147.84	147.85	146.735	146.91	20203937.0
2021-09-24	ES	Stock	82.24	83.02	82.24	82.67	1359100.0
2021-09-24	CL	Stock	76.6	76.95	76.5	76.63	2214000.0
2021-09-24	A	Stock	172.09	173.08	171.2	172.4	1041900.0
2021-09-24	AA	Stock	47.87	49.08	47.75	48.49	5168100.0
2021-09-24	AAC-DELISTED	Stock	9.74	9.75	9.73	9.74	34966.0
2021-09-24	AACG	Stock	2.34	2.43	2.34	2.4	16700.0
2021-09-24	AACIU	Stock	9.913	9.913	9.88	9.9	41545.0
2021-09-24	AAIC-DELISTED	Stock	3.75	3.79	3.75	3.78	44825.0
2021-09-24	AAIC.C-DELISTED	Stock	25.1838	25.2385	24.8801	25.09	6529.0
2021-09-24	AAL	Stock	20.89	21.62	20.81	21.39	39971700.0
2021-09-24	AAM.A-DELISTED	Stock	25.73	25.75	25.62	25.73	13137.0
2021-09-24	AAM.B-DELISTED	Stock	26.87	26.87	26.7	26.75	5336.0
2021-09-24	AAMC-DELISTED	Stock	7.2941	7.7029	6.6324	7.2029	535361.0
2021-09-24	AAME	Stock	3.79	4.08	3.79	3.98	65600.0
2021-09-24	AAMI	Stock	26.88	27.11	26.65	26.68	290500.0
2021-09-24	AAN-DELISTED	Stock	27.44	27.87	27.33	27.52	133200.0
2021-09-24	AAOI	Stock	7.17	7.33	7.08	7.24	242800.0
2021-09-24	AAON	Stock	45.2867	45.3267	44.5733	44.5867	162000.0
2021-09-24	AAP	Stock	213.89	215.91	213.76	215.66	464300.0
2021-09-24	AAT	Stock	38.55	39.13	38.51	38.58	173200.0
2021-09-24	AATC	Stock	7.61	7.85	7.61	7.81	10483.0
2021-09-24	AAU-DELISTED	Stock	0.397	0.4	0.39	0.3965	239425.0
2021-09-24	AAUAF-DELISTED	Stock	0.397	0.4	0.39	0.3965	254222.0
2021-09-24	AAWW-DELISTED	Stock	77.28	79.205	76.3	78.58	267810.0
2021-09-24	AAXJ	Stock	85.87	85.93	85.46	85.52	1287912.0
2021-09-24	AB	Stock	52.0	52.24	51.71	52.18	127300.0
2021-09-24	ABB-DELISTED	Stock	34.91	35.13	34.87	34.95	1072897.0
2021-09-24	ABBNY-DELISTED	Stock	34.91	35.13	34.87	34.94	1213892.0
2021-09-24	ABBV	Stock	106.87	108.05	106.44	107.07	5836100.0
2021-09-24	ABC-DELISTED	Stock	122.63	123.04	121.93	122.31	296918.0
2021-09-24	ABCB	Stock	49.47	51.15	49.35	50.66	386700.0
2021-09-24	ABCL	Stock	21.0	21.31	20.76	21.15	1663200.0
2021-09-24	ABCM-DELISTED	Stock	20.8	20.82	20.51	20.77	17207.0
2021-09-24	ABEO	Stock	30.0	30.5	29.25	29.5	17292.0
2021-09-24	ABEV	Stock	2.92	2.94	2.88	2.92	20551000.0
2021-09-24	ABG	Stock	190.82	197.21	189.98	196.03	133100.0
2021-09-24	ABM	Stock	44.68	45.13	44.51	44.81	190000.0
2021-09-24	ABMD-DELISTED	Stock	348.82	352.02	345.255	350.36	133210.0
2021-09-24	ABNB	Stock	174.53	176.96	173.61	175.88	4084900.0
2021-09-24	ABOS	Stock	15.96	16.5	15.29	16.14	227600.0
2021-09-24	ABR	Stock	18.31	18.43	18.24	18.37	680400.0
2021-09-24	ABR.D	Stock	25.5	25.53	25.48	25.52	12826.0

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

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