PREVIEW / stock_daily / 2007-05-24

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-24.parquet
  size:    176 KB
  rows:    5,368
  symbols: 3,221

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-24	AAPL	Stock	4.0289	4.0879	3.9418	3.9532	887362000.0
2007-05-24	MSFT	Stock	30.54	30.8	29.96	30.17	64046400.0
2007-05-24	NVDA	Stock	0.5757	0.5773	0.55	0.5523	607800000.0
2007-05-24	AMZN	Stock	3.452	3.521	3.3855	3.4675	476492000.0
2007-05-24	TLT	Stock	86.46	86.5899	85.96	86.57	1598400.0
2007-05-24	CL	Stock	33.49	33.505	33.195	33.22	4787400.0
2007-05-24	A	Stock	27.0815	27.7897	26.8884	26.9528	4379095.0
2007-05-24	AABA-DELISTED	Stock	28.65	28.88	28.25	28.43	18496297.0
2007-05-24	AACC-DELISTED	Stock	18.68	18.9	18.528	18.6	155544.0
2007-05-24	AAI-DELISTED	Stock	12.15	12.19	11.88	11.9	1589600.0
2007-05-24	AAIC-DELISTED	Stock	124.8	126.4	121.0	126.2	2781700.0
2007-05-24	AAME	Stock	5.15	5.15	5.07	5.14	1000.0
2007-05-24	AAON	Stock	3.7939	3.9164	3.7044	3.7821	303750.0
2007-05-24	AAP	Stock	40.95	41.23	40.3	40.48	971400.0
2007-05-24	AATI-DELISTED	Stock	9.16	9.29	8.95	9.17	937763.0
2007-05-24	AAU-DELISTED	Stock	2.27	2.34	2.2	2.22	91000.0
2007-05-24	AAUAF-DELISTED	Stock	2.27	2.34	2.2	2.22	91000.0
2007-05-24	AAV-DELISTED	Stock	13.02	13.22	12.65	12.73	951600.0
2007-05-24	AAWW-DELISTED	Stock	58.34	58.82	57.49	57.51	100200.0
2007-05-24	AAXN-DELISTED	Stock	10.0	10.34	9.79	10.06	7404586.0
2007-05-24	AB	Stock	90.7	90.75	88.53	89.02	211400.0
2007-05-24	ABAX-DELISTED	Stock	22.24	22.44	21.87	21.9	160571.0
2007-05-24	ABB-DELISTED	Stock	21.18	21.26	20.76	20.81	2995975.0
2007-05-24	ABBC-DELISTED	Stock	18.47	18.7	18.14	18.14	4219.0
2007-05-24	ABBNY-DELISTED	Stock	21.18	21.26	20.76	20.83	2999075.0
2007-05-24	ABC-DELISTED	Stock	25.75	25.86	25.3	25.32	1998800.0
2007-05-24	ABCB	Stock	22.361	22.6042	21.6705	22.1859	42873.0
2007-05-24	ABCO-DELISTED	Stock	25.14	25.44	25.05	25.17	376386.0
2007-05-24	ABCW-DELISTED	Stock	28.48	28.77	28.09	28.27	56830.0
2007-05-24	ABD-DELISTED	Stock	23.79	24.18	23.56	24.04	552290.0
2007-05-24	ABE-DELISTED	Stock	22.2	22.2	21.34	21.59	44400.0
2007-05-24	ABEO	Stock	6362.5	6375.0	6262.5	6350.0	7.0
2007-05-24	ABFS-DELISTED	Stock	40.21	40.48	39.43	39.53	441315.0
2007-05-24	ABG	Stock	27.33	27.68	26.95	27.13	274800.0
2007-05-24	ABK-DELISTED	Stock	93.89	93.89	90.98	91.5	2621626.0
2007-05-24	ABM	Stock	28.98	29.2	28.4	28.55	204800.0
2007-05-24	ABMD-DELISTED	Stock	11.88	11.98	11.49	11.53	168641.0
2007-05-24	ABP-DELISTED	Stock	3.65	3.75	3.55	3.6	170300.0
2007-05-24	ABR	Stock	28.46	28.63	27.72	27.94	111800.0
2007-05-24	ABT	Stock	27.4158	27.5885	26.8736	27.0895	15207170.0
2007-05-24	ABTL-DELISTED	Stock	22.05	22.25	20.55	21.05	40677.0
2007-05-24	ABV-DELISTED	Stock	68.59	68.59	64.54	64.9	969140.0
2007-05-24	ABVA-DELISTED	Stock	13.53	13.62	13.38	13.4	21903.0
2007-05-24	ABX-DELISTED	Stock	29.72	29.88	28.99	29.0	4856290.0
2007-05-24	ACAD	Stock	13.21	13.4	12.8	13.0	304200.0
2007-05-24	ACAP-DELISTED	Stock	39.49	39.99	39.17	39.73	87968.0
2007-05-24	ACAS-DELISTED	Stock	47.1	47.43	46.28	46.44	1001872.0
2007-05-24	ACAT-DELISTED	Stock	19.16	19.62	19.16	19.21	88600.0
2007-05-24	ACC-DELISTED	Stock	27.88	28.08	27.62	27.8	225400.0
2007-05-24	ACCL-DELISTED	Stock	6.34	6.34	6.25	6.29	24282.0

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

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