PREVIEW / stock_daily / 2007-09-24

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-24.parquet
  size:    178 KB
  rows:    5,516
  symbols: 3,324

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-09-24	AAPL	Stock	5.2404	5.3518	5.2375	5.2957	1052161600.0
2007-09-24	MSFT	Stock	28.81	29.61	28.8	29.08	104459800.0
2007-09-24	NVDA	Stock	0.8675	0.8975	0.8612	0.8842	456360000.0
2007-09-24	AMZN	Stock	4.565	4.6875	4.5405	4.6295	106436000.0
2007-09-24	TLT	Stock	88.03	88.28	87.91	88.14	1943590.0
2007-09-24	CL	Stock	34.775	34.97	34.555	34.835	4773600.0
2007-09-24	A	Stock	26.3019	26.4735	26.0014	26.1516	2374223.0
2007-09-24	AABA-DELISTED	Stock	26.15	26.4	25.02	25.75	27701265.0
2007-09-24	AACC-DELISTED	Stock	10.95	11.33	10.94	10.96	451230.0
2007-09-24	AAI-DELISTED	Stock	10.39	10.39	9.88	9.9	2104100.0
2007-09-24	AAIC-DELISTED	Stock	99.8	100.8	97.6	98.0	708885.0
2007-09-24	AAME	Stock	2.57	2.64	2.46	2.64	8800.0
2007-09-24	AAON	Stock	4.1244	4.2133	3.9901	4.0494	338681.0
2007-09-24	AAP	Stock	33.83	34.1	32.92	33.27	1023000.0
2007-09-24	AATI-DELISTED	Stock	10.65	10.756	10.37	10.5	453812.0
2007-09-24	AAU-DELISTED	Stock	2.4	2.45	2.28	2.3	100000.0
2007-09-24	AAUAF-DELISTED	Stock	2.4	2.45	2.28	2.3	100000.0
2007-09-24	AAV-DELISTED	Stock	11.58	12.2	11.49	12.15	1833600.0
2007-09-24	AAWW-DELISTED	Stock	53.55	54.11	52.68	52.97	191207.0
2007-09-24	AAXN-DELISTED	Stock	15.37	15.44	15.1	15.21	1212592.0
2007-09-24	AB	Stock	84.96	87.09	84.57	86.49	369600.0
2007-09-24	ABAX-DELISTED	Stock	20.79	21.17	20.73	21.04	290193.0
2007-09-24	ABB-DELISTED	Stock	25.75	25.99	25.71	25.85	2017400.0
2007-09-24	ABBC-DELISTED	Stock	9.75	9.83	9.71	9.78	32252.0
2007-09-24	ABBNY-DELISTED	Stock	25.75	25.99	25.71	25.84	2017400.0
2007-09-24	ABC-DELISTED	Stock	22.54	22.6	22.25	22.33	1694200.0
2007-09-24	ABCB	Stock	18.6844	19.2194	18.6164	18.7622	22105.0
2007-09-24	ABCO-DELISTED	Stock	29.3	29.49	28.91	29.09	76950.0
2007-09-24	ABCW-DELISTED	Stock	28.38	28.51	27.84	27.92	60020.0
2007-09-24	ABD-DELISTED	Stock	22.69	22.98	22.01	22.26	250770.0
2007-09-24	ABE-DELISTED	Stock	22.55	23.01	22.55	22.74	16500.0
2007-09-24	ABEO	Stock	5687.5	5787.5	5625.0	5625.0	6.0
2007-09-24	ABFS-DELISTED	Stock	33.4	33.63	32.27	32.36	386933.0
2007-09-24	ABG	Stock	20.89	20.94	19.86	20.05	744400.0
2007-09-24	ABK-DELISTED	Stock	64.64	65.66	63.46	63.63	1702900.0
2007-09-24	ABM	Stock	20.6	20.95	20.16	20.32	362700.0
2007-09-24	ABMD-DELISTED	Stock	11.87	11.87	11.5	11.63	116695.0
2007-09-24	ABP-DELISTED	Stock	3.57	3.7	3.55	3.55	92800.0
2007-09-24	ABR	Stock	20.05	20.1	19.46	19.69	196800.0
2007-09-24	ABT	Stock	26.01	26.0675	25.7749	25.842	12751146.0
2007-09-24	ABTL-DELISTED	Stock	16.125	16.275	15.925	16.125	4841.0
2007-09-24	ABV-DELISTED	Stock	72.46	72.46	71.13	71.2	688980.0
2007-09-24	ABX-DELISTED	Stock	39.85	40.57	39.66	39.91	5824461.0
2007-09-24	ACAD	Stock	15.71	16.13	15.62	15.7	151100.0
2007-09-24	ACAP-DELISTED	Stock	40.63	40.63	38.87	39.02	62933.0
2007-09-24	ACAS-DELISTED	Stock	41.29	41.5	40.82	40.9	1305446.0
2007-09-24	ACAT-DELISTED	Stock	16.49	16.56	16.16	16.16	91135.0
2007-09-24	ACC-DELISTED	Stock	28.88	29.56	28.88	29.36	209100.0
2007-09-24	ACCL-DELISTED	Stock	6.78	6.83	6.6	6.78	56853.0
2007-09-24	ACCO	Stock	22.69	22.98	22.01	22.26	250800.0

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

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