PREVIEW / stock_daily / 2021-12-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-16.parquet
  size:    261 KB
  rows:    7,992
  symbols: 2,622

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-12-16	AAPL	Stock	179.28	181.14	170.75	172.26	150185800.0
2021-12-16	MSFT	Stock	335.71	336.76	323.02	324.9	35034800.0
2021-12-16	NVDA	Stock	31.152	31.16	28.093	28.387	707366000.0
2021-12-16	AMZN	Stock	173.3685	174.166	168.1605	168.871	60876000.0
2021-12-16	GOOGL	Stock	147.1705	147.6768	143.607	144.445	33650380.0
2021-12-16	META	Stock	338.98	344.46	333.74	334.9	22635000.0
2021-12-16	TSLA	Stock	331.5	331.66	307.2833	308.9733	82771500.0
2021-12-16	TLT	Stock	148.75	149.88	148.73	149.14	18677893.0
2021-12-16	ES	Stock	90.27	91.17	89.78	90.91	1203500.0
2021-12-16	CL	Stock	82.71	84.06	82.49	83.95	5237600.0
2021-12-16	A	Stock	154.3	155.9	150.46	150.8	2085600.0
2021-12-16	AA	Stock	52.0	54.15	51.98	52.59	12482600.0
2021-12-16	AAC-DELISTED	Stock	9.79	9.79	9.765	9.77	140575.0
2021-12-16	AACG	Stock	1.39	1.39	1.25	1.3	25900.0
2021-12-16	AACIW-DELISTED	Stock	0.48	0.4899	0.4512	0.4899	4062.0
2021-12-16	AAIC-DELISTED	Stock	3.56	3.575	3.5	3.52	107534.0
2021-12-16	AAL	Stock	17.25	17.39	16.43	16.52	31751200.0
2021-12-16	AAM.A-DELISTED	Stock	25.47	25.47	25.43	25.46	15394.0
2021-12-16	AAM.B-DELISTED	Stock	26.35	26.7	26.26	26.6	7187.0
2021-12-16	AAME	Stock	3.51	3.6	3.42	3.42	5700.0
2021-12-16	AAMI	Stock	27.13	27.35	26.41	26.46	1133100.0
2021-12-16	AAN-DELISTED	Stock	23.94	24.22	23.44	23.55	362900.0
2021-12-16	AAOI	Stock	5.76	5.76	5.38	5.44	503800.0
2021-12-16	AAON	Stock	52.7533	53.18	51.4267	51.6067	219750.0
2021-12-16	AAP	Stock	239.73	242.29	236.64	239.16	820100.0
2021-12-16	AAQC-DELISTED	Stock	9.7799	9.7799	9.7	9.71	8425.0
2021-12-16	AAT	Stock	35.98	36.06	35.16	35.38	196100.0
2021-12-16	AATC	Stock	6.65	6.7	6.4001	6.49	10890.0
2021-12-16	AAU-DELISTED	Stock	0.295	0.318	0.295	0.3123	783430.0
2021-12-16	AAUAF-DELISTED	Stock	0.295	0.318	0.295	0.3124	788844.0
2021-12-16	AAWW-DELISTED	Stock	88.65	91.26	88.65	89.06	248857.0
2021-12-16	AAXJ	Stock	82.59	82.85	81.73	81.81	1200679.0
2021-12-16	AB	Stock	48.45	49.0	47.61	47.82	347300.0
2021-12-16	ABB-DELISTED	Stock	37.485	37.71	37.2088	37.38	1614112.0
2021-12-16	ABBNY-DELISTED	Stock	37.485	37.71	37.2088	37.39	1809916.0
2021-12-16	ABBV	Stock	130.1	133.28	129.91	131.78	9569000.0
2021-12-16	ABC-DELISTED	Stock	124.33	125.99	123.52	123.91	620322.0
2021-12-16	ABCB	Stock	49.27	49.92	48.3	48.8	681200.0
2021-12-16	ABCL	Stock	12.47	13.76	12.47	13.69	3896900.0
2021-12-16	ABCM-DELISTED	Stock	22.1	22.66	22.03	22.42	381689.0
2021-12-16	ABEO	Stock	13.0	13.75	12.0	12.25	164972.0
2021-12-16	ABEV	Stock	2.79	2.85	2.77	2.79	18111300.0
2021-12-16	ABG	Stock	175.0	175.52	165.09	165.9	221000.0
2021-12-16	ABGI-DELISTED	Stock	9.75	9.81	9.75	9.81	45026.0
2021-12-16	ABM	Stock	40.42	42.06	39.88	41.25	913000.0
2021-12-16	ABMD-DELISTED	Stock	316.46	319.3	307.8567	310.1999	173501.0
2021-12-16	ABNB	Stock	166.25	167.73	153.6	156.38	9415100.0
2021-12-16	ABOS	Stock	7.0	7.11	6.79	6.94	244500.0
2021-12-16	ABR	Stock	17.81	17.88	17.37	17.4	1374300.0
2021-12-16	ABR.D	Stock	25.13	25.2	25.105	25.2	4069.0

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

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