PREVIEW / stock_daily / 2023-01-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-03.parquet
  size:    247 KB
  rows:    7,690
  symbols: 1,935

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
2023-01-03	AAPL	Stock	130.28	130.9	124.17	125.07	112117500.0
2023-01-03	MSFT	Stock	243.08	245.75	237.4	239.58	25740000.0
2023-01-03	NVDA	Stock	14.851	14.996	14.096	14.315	401277000.0
2023-01-03	AMZN	Stock	85.46	86.96	84.21	85.82	76706000.0
2023-01-03	GOOGL	Stock	89.585	91.05	88.52	89.12	28131224.0
2023-01-03	META	Stock	122.82	126.37	122.28	124.74	35528500.0
2023-01-03	TSLA	Stock	118.47	118.8	104.64	108.1	231402800.0
2023-01-03	TLT	Stock	102.2	102.34	100.84	101.46	25313228.0
2023-01-03	ES	Stock	84.51	84.72	83.05	84.22	1266800.0
2023-01-03	CL	Stock	78.79	79.17	77.72	79.13	2920200.0
2023-01-03	A	Stock	151.96	153.13	148.47	150.04	1414300.0
2023-01-03	AA	Stock	45.77	46.67	44.44	44.58	2880000.0
2023-01-03	AAC-DELISTED	Stock	10.07	10.12	10.07	10.11	4734541.0
2023-01-03	AACG	Stock	1.22	1.3	1.22	1.26	7000.0
2023-01-03	AACIW-DELISTED	Stock	0.05	0.05	0.0499	0.0499	802.0
2023-01-03	AAIC-DELISTED	Stock	2.95	2.97	2.94	2.95	32117.0
2023-01-03	AAIC.C-DELISTED	Stock	20.92	20.92	20.92	20.92	282.0
2023-01-03	AAL	Stock	12.91	13.0	12.53	12.74	21865100.0
2023-01-03	AAM.A-DELISTED	Stock	22.03	22.3536	21.87	21.96	11170.0
2023-01-03	AAM.B-DELISTED	Stock	21.9	22.6016	21.9	21.97	18210.0
2023-01-03	AAMC-DELISTED	Stock	5.8824	5.8824	5.8824	5.8824	918.0
2023-01-03	AAME	Stock	2.1	2.42	2.1	2.42	11100.0
2023-01-03	AAMI	Stock	20.75	21.23	20.47	20.49	425500.0
2023-01-03	AAN-DELISTED	Stock	12.16	12.36	11.8	11.85	343000.0
2023-01-03	AAOI	Stock	1.94	1.99	1.86	1.88	133400.0
2023-01-03	AAON	Stock	50.64	50.9867	49.3333	49.8867	237750.0
2023-01-03	AAP	Stock	146.16	151.66	146.0	151.54	1307400.0
2023-01-03	AAT	Stock	26.87	27.15	26.27	26.51	253400.0
2023-01-03	AATC	Stock	3.62	3.69	3.38	3.49	430306.0
2023-01-03	AAU-DELISTED	Stock	0.2455	0.255	0.2399	0.2509	296231.0
2023-01-03	AAUAF-DELISTED	Stock	0.2455	0.255	0.2399	0.2509	303426.0
2023-01-03	AAWW-DELISTED	Stock	100.87	101.2799	100.87	101.16	243209.0
2023-01-03	AAXJ	Stock	65.78	66.26	65.42	65.67	654283.0
2023-01-03	AB	Stock	34.73	35.36	34.43	35.33	306700.0
2023-01-03	ABB-DELISTED	Stock	30.78	30.97	30.54	30.77	975666.0
2023-01-03	ABBNY-DELISTED	Stock	30.78	30.97	30.54	30.78	1290040.0
2023-01-03	ABBV	Stock	162.04	163.02	160.81	162.38	4937500.0
2023-01-03	ABC-DELISTED	Stock	164.74	164.99	162.84	164.25	1278933.0
2023-01-03	ABCB	Stock	47.35	48.77	45.86	46.3	301000.0
2023-01-03	ABCL	Stock	10.3	10.37	9.47	9.49	1799600.0
2023-01-03	ABCM-DELISTED	Stock	15.86	16.31	15.24	15.62	394073.0
2023-01-03	ABEO	Stock	3.09	3.15	2.83	2.86	115300.0
2023-01-03	ABEV	Stock	2.67	2.69	2.58	2.59	50074200.0
2023-01-03	ABG	Stock	180.06	182.95	174.21	174.3	238900.0
2023-01-03	ABGI-DELISTED	Stock	10.09	10.09	10.09	10.09	3010.0
2023-01-03	ABLV	Stock	10.16	10.17	10.16	10.17	156807.0
2023-01-03	ABM	Stock	44.71	45.17	44.21	44.9	297100.0
2023-01-03	ABNB	Stock	87.385	88.14	84.3	84.9	3901200.0
2023-01-03	ABOS	Stock	5.13	5.63	5.02	5.26	72300.0
2023-01-03	ABR	Stock	13.38	13.62	13.29	13.55	1416500.0

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

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