PREVIEW / stock_daily / 2022-10-13

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-13.parquet
  size:    251 KB
  rows:    7,883
  symbols: 2,168

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-10-13	AAPL	Stock	134.99	143.59	134.37	142.99	113224000.0
2022-10-13	MSFT	Stock	219.85	236.1	219.13	234.24	42551800.0
2022-10-13	NVDA	Stock	10.971	12.078	10.813	11.96	850103000.0
2022-10-13	AMZN	Stock	107.88	113.44	105.35	112.53	86868100.0
2022-10-13	GOOGL	Stock	95.15	99.775	94.3836	99.06	34574549.0
2022-10-13	META	Stock	123.53	131.14	122.53	130.29	34325700.0
2022-10-13	TSLA	Stock	208.3	222.99	206.22	221.72	91483000.0
2022-10-13	TLT	Stock	98.36	100.38	98.34	99.39	30292454.0
2022-10-13	ES	Stock	70.88	74.28	70.54	73.76	2311600.0
2022-10-13	CL	Stock	69.58	71.27	68.72	71.01	4459900.0
2022-10-13	A	Stock	123.0	128.83	122.35	127.9	1553600.0
2022-10-13	AA	Stock	38.64	40.97	38.29	40.88	8221700.0
2022-10-13	AAC-DELISTED	Stock	9.93	9.95	9.93	9.945	84805.0
2022-10-13	AACG	Stock	1.86	1.87	1.79	1.84	11100.0
2022-10-13	AAIC-DELISTED	Stock	2.75	2.9182	2.75	2.89	38830.0
2022-10-13	AAIC.C-DELISTED	Stock	19.31	19.77	19.26	19.35	3983.0
2022-10-13	AAL	Stock	12.5	13.2	12.18	13.05	53206100.0
2022-10-13	AAM.A-DELISTED	Stock	22.5	23.21	22.0915	23.13	32428.0
2022-10-13	AAM.B-DELISTED	Stock	22.59	22.76	22.16	22.4991	15363.0
2022-10-13	AAME	Stock	2.81	2.81	2.77	2.79	500.0
2022-10-13	AAMI	Stock	16.99	18.505	16.7	18.4	430700.0
2022-10-13	AAN-DELISTED	Stock	8.84	9.36	8.76	9.21	316700.0
2022-10-13	AAOI	Stock	2.62	2.76	2.522	2.73	192700.0
2022-10-13	AAON	Stock	35.1733	36.84	34.7	36.7867	179400.0
2022-10-13	AAP	Stock	166.84	173.22	165.98	171.58	682000.0
2022-10-13	AAQC-DELISTED	Stock	9.86	9.87	9.855	9.87	222741.0
2022-10-13	AAT	Stock	24.65	25.68	24.46	25.44	278400.0
2022-10-13	AATC	Stock	4.33	4.41	4.28	4.39	12877.0
2022-10-13	AAU-DELISTED	Stock	0.2362	0.2398	0.2276	0.238	233609.0
2022-10-13	AAUAF-DELISTED	Stock	0.2362	0.2398	0.2276	0.238	234750.0
2022-10-13	AAWW-DELISTED	Stock	98.94	99.81	98.44	99.4	351064.0
2022-10-13	AAXJ	Stock	56.26	57.94	55.94	57.72	1655413.0
2022-10-13	AB	Stock	31.67	33.32	31.31	32.98	383900.0
2022-10-13	ABB-DELISTED	Stock	24.47	25.945	24.325	25.78	2617358.0
2022-10-13	ABBNY-DELISTED	Stock	24.47	25.945	24.325	25.78	2795846.0
2022-10-13	ABBV	Stock	136.7	143.18	136.27	142.92	5066200.0
2022-10-13	ABC-DELISTED	Stock	136.85	142.565	136.07	142.05	666188.0
2022-10-13	ABCB	Stock	47.29	49.96	46.76	49.79	421900.0
2022-10-13	ABCL	Stock	10.32	10.8	10.05	10.73	1276500.0
2022-10-13	ABCM-DELISTED	Stock	14.34	15.2198	14.28	15.05	100000.0
2022-10-13	ABEO	Stock	5.42	5.73	4.96	5.2	433600.0
2022-10-13	ABEV	Stock	2.73	2.85	2.72	2.83	25779400.0
2022-10-13	ABG	Stock	153.71	160.7	151.71	158.89	129500.0
2022-10-13	ABGI-DELISTED	Stock	9.94	9.9415	9.9	9.94	23315.0
2022-10-13	ABM	Stock	39.4	41.2	38.95	41.04	270800.0
2022-10-13	ABMD-DELISTED	Stock	238.75	258.17	237.55	258.08	273102.0
2022-10-13	ABNB	Stock	107.3	113.13	105.3	112.65	6172500.0
2022-10-13	ABOS	Stock	8.27	8.41	7.95	8.14	224300.0
2022-10-13	ABR	Stock	11.94	12.53	11.76	12.46	2457000.0
2022-10-13	ABR.D	Stock	18.56	18.6006	17.9	17.93	33889.0

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

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