PREVIEW / stock_daily / 2022-04-06

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-06.parquet
  size:    261 KB
  rows:    8,048
  symbols: 2,482

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
2022-04-06	AAPL	Stock	172.36	173.63	170.13	171.83	89058800.0
2022-04-06	MSFT	Stock	305.19	307.0	296.71	299.5	40110400.0
2022-04-06	NVDA	Stock	24.934	25.3	24.003	24.407	703833000.0
2022-04-06	AMZN	Stock	161.6505	162.2	157.2545	158.756	79056000.0
2022-04-06	GOOGL	Stock	138.75	139.3605	135.517	136.548	32468480.0
2022-04-06	META	Stock	226.91	228.99	221.41	223.3	28995100.0
2022-04-06	TSLA	Stock	357.8233	359.6667	342.5667	348.5867	89348400.0
2022-04-06	TLT	Stock	126.43	128.3	126.4	127.45	22951954.0
2022-04-06	ES	Stock	90.58	92.35	90.15	92.25	1371600.0
2022-04-06	CL	Stock	77.18	78.88	76.72	78.81	9991400.0
2022-04-06	A	Stock	132.01	133.32	129.86	132.71	2249500.0
2022-04-06	AA	Stock	89.0	89.81	86.74	87.73	4531400.0
2022-04-06	AAC-DELISTED	Stock	9.84	9.85	9.8	9.82	1037811.0
2022-04-06	AACG	Stock	1.38	1.44	1.3	1.3	11000.0
2022-04-06	AACIU	Stock	9.88	9.9435	9.88	9.9435	600.0
2022-04-06	AACIW-DELISTED	Stock	0.3099	0.31	0.305	0.305	3852.0
2022-04-06	AAIC-DELISTED	Stock	3.48	3.55	3.47	3.48	91313.0
2022-04-06	AAIC.C-DELISTED	Stock	24.55	24.55	24.55	24.55	100.0
2022-04-06	AAL	Stock	17.26	17.67	16.83	17.38	40217800.0
2022-04-06	AAM.A-DELISTED	Stock	25.1201	25.14	25.0	25.0	18663.0
2022-04-06	AAM.B-DELISTED	Stock	25.52	25.56	25.33	25.5	12418.0
2022-04-06	AAMC-DELISTED	Stock	3.9118	3.9118	3.7353	3.75	10877.0
2022-04-06	AAME	Stock	3.31	3.41	3.2	3.35	9100.0
2022-04-06	AAMI	Stock	23.29	23.32	22.57	22.69	1182300.0
2022-04-06	AAN-DELISTED	Stock	20.62	20.74	19.62	20.15	277000.0
2022-04-06	AAOI	Stock	3.22	3.28	3.15	3.15	260400.0
2022-04-06	AAON	Stock	35.9267	36.5533	35.6733	35.7267	379800.0
2022-04-06	AAP	Stock	210.01	213.58	209.01	212.83	626500.0
2022-04-06	AAQC-DELISTED	Stock	9.74	9.76	9.74	9.76	16093.0
2022-04-06	AAT	Stock	36.76	37.26	36.47	37.08	329200.0
2022-04-06	AATC	Stock	6.18	6.335	6.15	6.16	13635.0
2022-04-06	AAU-DELISTED	Stock	0.337	0.3379	0.3211	0.3267	307511.0
2022-04-06	AAUAF-DELISTED	Stock	0.337	0.3379	0.3211	0.3269	313267.0
2022-04-06	AAWW-DELISTED	Stock	72.72	73.41	68.97	70.18	977787.0
2022-04-06	AAXJ	Stock	75.92	75.92	75.04	75.35	1645678.0
2022-04-06	AB	Stock	46.8	47.78	46.3	47.63	287100.0
2022-04-06	ABB-DELISTED	Stock	31.49	31.84	31.245	31.69	1911751.0
2022-04-06	ABBNY-DELISTED	Stock	31.49	31.84	31.245	31.69	2171561.0
2022-04-06	ABBV	Stock	164.49	169.27	163.8	168.91	8810800.0
2022-04-06	ABC-DELISTED	Stock	155.46	158.88	155.46	158.18	569584.0
2022-04-06	ABCB	Stock	41.9	41.9	40.56	40.76	728100.0
2022-04-06	ABCL	Stock	9.88	9.95	9.574	9.93	2045700.0
2022-04-06	ABCM-DELISTED	Stock	18.86	19.11	18.73	18.93	69355.0
2022-04-06	ABEO	Stock	8.75	8.75	8.0	8.25	90928.0
2022-04-06	ABEV	Stock	3.17	3.18	3.12	3.14	34587100.0
2022-04-06	ABG	Stock	152.96	159.0	152.96	156.78	494300.0
2022-04-06	ABGI-DELISTED	Stock	9.78	9.79	9.77	9.79	82073.0
2022-04-06	ABM	Stock	45.41	46.81	45.3	46.41	457700.0
2022-04-06	ABMD-DELISTED	Stock	317.69	318.7048	310.5	313.44	138405.0
2022-04-06	ABNB	Stock	167.05	168.77	161.58	164.66	4287700.0

> showing 50 of 8,048 rows — these rows as CSV

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