PREVIEW / stock_daily / 2007-05-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-23.parquet
  size:    176 KB
  rows:    5,373
  symbols: 3,230

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
2007-05-23	AAPL	Stock	4.0721	4.1071	4.0211	4.0318	911374800.0
2007-05-23	MSFT	Stock	30.84	30.84	30.57	30.58	46322500.0
2007-05-23	NVDA	Stock	0.589	0.5925	0.5713	0.573	448248000.0
2007-05-23	AMZN	Stock	3.4605	3.6655	3.4395	3.45	851650000.0
2007-05-23	TLT	Stock	86.84	86.84	86.31	86.49	914447.0
2007-05-23	CL	Stock	33.485	33.56	33.125	33.415	5803800.0
2007-05-23	A	Stock	27.7682	27.8755	27.5322	27.5966	3648081.0
2007-05-23	AABA-DELISTED	Stock	29.1	29.37	28.53	28.57	27344950.0
2007-05-23	AACC-DELISTED	Stock	18.7	18.98	18.68	18.73	89139.0
2007-05-23	AAI-DELISTED	Stock	12.36	12.65	12.1	12.13	1015388.0
2007-05-23	AAIC-DELISTED	Stock	120.0	128.2	118.6	125.2	2863825.0
2007-05-23	AAME	Stock	5.2	5.2	5.14	5.14	3000.0
2007-05-23	AAON	Stock	3.9111	3.9374	3.7399	3.7821	389559.0
2007-05-23	AAP	Stock	41.14	41.69	40.97	41.04	1669700.0
2007-05-23	AATI-DELISTED	Stock	9.24	9.9	9.0	9.32	3858744.0
2007-05-23	AAU-DELISTED	Stock	2.37	2.37	2.3	2.35	76200.0
2007-05-23	AAUAF-DELISTED	Stock	2.37	2.37	2.3	2.35	76300.0
2007-05-23	AAV-DELISTED	Stock	12.92	13.26	12.92	13.02	859700.0
2007-05-23	AAWW-DELISTED	Stock	59.22	59.31	58.25	58.3	63332.0
2007-05-23	AAXN-DELISTED	Stock	9.33	9.63	9.33	9.54	2379194.0
2007-05-23	AB	Stock	90.3	91.5	90.3	90.35	235200.0
2007-05-23	ABAX-DELISTED	Stock	22.33	22.49	22.05	22.28	233140.0
2007-05-23	ABB-DELISTED	Stock	21.12	21.38	21.12	21.26	3728500.0
2007-05-23	ABBC-DELISTED	Stock	18.35	18.56	18.28	18.3299	2787.0
2007-05-23	ABBNY-DELISTED	Stock	21.12	21.38	21.12	21.24	3765300.0
2007-05-23	ABC-DELISTED	Stock	25.76	25.8	25.47	25.58	2525102.0
2007-05-23	ABCB	Stock	23.0905	23.0905	22.3902	22.4291	38452.0
2007-05-23	ABCO-DELISTED	Stock	25.05	25.39	24.92	25.15	375245.0
2007-05-23	ABCW-DELISTED	Stock	28.97	29.0	28.44	28.54	83270.0
2007-05-23	ABD-DELISTED	Stock	23.37	23.86	23.2	23.86	1104400.0
2007-05-23	ABE-DELISTED	Stock	22.1	22.2	21.98	22.2	40000.0
2007-05-23	ABEO	Stock	6187.5	6375.0	6187.5	6375.0	4.0
2007-05-23	ABFS-DELISTED	Stock	39.8	40.71	39.71	40.14	407450.0
2007-05-23	ABG	Stock	27.55	27.71	27.25	27.33	412500.0
2007-05-23	ABK-DELISTED	Stock	94.98	95.4	94.11	94.34	825104.0
2007-05-23	ABM	Stock	29.22	29.45	28.94	28.97	204800.0
2007-05-23	ABMD-DELISTED	Stock	11.95	12.05	11.82	11.91	120548.0
2007-05-23	ABP-DELISTED	Stock	3.65	3.84	3.5	3.67	467400.0
2007-05-23	ABR	Stock	28.54	28.98	28.31	28.38	71700.0
2007-05-23	ABT	Stock	27.6845	27.8572	27.411	27.4494	10562943.0
2007-05-23	ABTL-DELISTED	Stock	22.3	22.4	21.9	22.15	22753.0
2007-05-23	ABV-DELISTED	Stock	68.5	68.5	66.6	66.64	872480.0
2007-05-23	ABVA-DELISTED	Stock	13.75	13.75	13.5	13.55	22118.0
2007-05-23	ABVT-DELISTED	Stock	61.0	61.0	61.0	61.0	1031.0
2007-05-23	ABX-DELISTED	Stock	29.96	30.01	29.48	29.74	4817530.0
2007-05-23	ACAD	Stock	13.4	13.67	13.23	13.25	150900.0
2007-05-23	ACAP-DELISTED	Stock	39.56	40.09	39.12	39.41	101710.0
2007-05-23	ACAS-DELISTED	Stock	47.59	47.79	47.04	47.15	916650.0
2007-05-23	ACAT-DELISTED	Stock	19.55	19.6	19.17	19.2	121680.0
2007-05-23	ACC-DELISTED	Stock	27.78	28.1	27.78	27.98	141600.0

> showing 50 of 5,373 rows — these rows as CSV

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