PREVIEW / stock_daily / 2021-08-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-12.parquet
  size:    256 KB
  rows:    7,885
  symbols: 2,789

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-08-12	AAPL	Stock	146.19	149.05	145.84	148.89	72282600.0
2021-08-12	MSFT	Stock	286.63	289.97	286.34	289.81	14561300.0
2021-08-12	NVDA	Stock	19.87	20.029	19.62	19.905	151652000.0
2021-08-12	AMZN	Stock	164.5	165.7255	163.4835	165.175	46282000.0
2021-08-12	GOOGL	Stock	135.9755	137.3	135.4255	137.194	16518860.0
2021-08-12	META	Stock	358.45	363.0	357.11	362.65	7170700.0
2021-08-12	TSLA	Stock	235.4467	240.9333	233.1333	240.75	52377300.0
2021-08-12	TLT	Stock	146.09	146.44	145.43	146.24	14710931.0
2021-08-12	ES	Stock	89.93	90.42	89.56	89.6	1197800.0
2021-08-12	CL	Stock	79.6	79.64	78.78	78.79	3595500.0
2021-08-12	A	Stock	156.51	158.52	156.12	158.15	1376100.0
2021-08-12	AA	Stock	44.29	45.4	43.77	45.15	6666600.0
2021-08-12	AAC-DELISTED	Stock	9.7	9.74	9.68	9.69	53168.0
2021-08-12	AACG	Stock	2.9	2.97	2.76	2.8	122900.0
2021-08-12	AAIC-DELISTED	Stock	3.84	3.86	3.825	3.83	42411.0
2021-08-12	AAIC.C-DELISTED	Stock	25.0	25.09	25.0	25.03	10147.0
2021-08-12	AAL	Stock	21.03	21.11	20.31	20.43	30369400.0
2021-08-12	AAM.A-DELISTED	Stock	26.25	26.4463	26.25	26.35	4639.0
2021-08-12	AAM.B-DELISTED	Stock	27.0	27.0599	26.96	27.0	30890.0
2021-08-12	AAMC-DELISTED	Stock	4.2235	4.3441	4.1059	4.1618	38706.0
2021-08-12	AAME	Stock	4.04	4.15	4.04	4.09	21400.0
2021-08-12	AAMI	Stock	26.73	26.8	26.45	26.77	314700.0
2021-08-12	AAN-DELISTED	Stock	28.84	29.67	28.28	29.46	292500.0
2021-08-12	AAOI	Stock	7.0	7.09	6.815	7.0	534500.0
2021-08-12	AAON	Stock	46.1733	46.56	45.8667	46.18	143850.0
2021-08-12	AAP	Stock	212.01	212.31	208.22	209.3	390400.0
2021-08-12	AAQC-DELISTED	Stock	9.65	9.65	9.65	9.65	125100.0
2021-08-12	AAT	Stock	38.41	38.61	37.76	38.27	198000.0
2021-08-12	AATC	Stock	6.61	6.686	6.46	6.59	12308.0
2021-08-12	AAU-DELISTED	Stock	0.422	0.425	0.407	0.41	499810.0
2021-08-12	AAUAF-DELISTED	Stock	0.422	0.425	0.407	0.41	507136.0
2021-08-12	AAWW-DELISTED	Stock	73.5	74.87	72.4655	74.42	235051.0
2021-08-12	AAXJ	Stock	88.07	88.15	87.575	87.93	1144084.0
2021-08-12	AB	Stock	49.97	50.16	49.31	50.01	226200.0
2021-08-12	ABB-DELISTED	Stock	37.43	37.58	37.36	37.51	733597.0
2021-08-12	ABBNY-DELISTED	Stock	37.43	37.58	37.36	37.52	820576.0
2021-08-12	ABBV	Stock	113.96	115.73	113.91	115.64	4863600.0
2021-08-12	ABC-DELISTED	Stock	119.55	120.52	118.2295	120.07	621221.0
2021-08-12	ABCB	Stock	50.66	51.46	50.66	50.99	331600.0
2021-08-12	ABCL	Stock	15.28	15.95	15.11	15.19	1844700.0
2021-08-12	ABCM-DELISTED	Stock	20.42	20.5959	20.24	20.37	44627.0
2021-08-12	ABEO	Stock	31.0	31.5	30.75	31.25	11948.0
2021-08-12	ABEV	Stock	3.15	3.18	3.11	3.12	14087300.0
2021-08-12	ABG	Stock	198.59	200.17	194.48	198.99	110000.0
2021-08-12	ABGI-DELISTED	Stock	9.7	9.72	9.64	9.68	17879.0
2021-08-12	ABM	Stock	47.99	47.99	47.15	47.36	241700.0
2021-08-12	ABMD-DELISTED	Stock	318.28	326.18	318.28	322.14	124798.0
2021-08-12	ABNB	Stock	148.86	151.68	146.55	151.15	8794100.0
2021-08-12	ABOS	Stock	14.79	15.09	14.79	14.9	64400.0
2021-08-12	ABR	Stock	18.76	18.77	18.37	18.71	2020000.0

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

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