PREVIEW / stock_daily / 2007-08-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-23.parquet
  size:    176 KB
  rows:    5,465
  symbols: 3,293

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-08-23	AAPL	Stock	4.7532	4.7621	4.6343	4.6811	866838000.0
2007-08-23	MSFT	Stock	28.28	28.33	28.1	28.3	33886600.0
2007-08-23	NVDA	Stock	0.8107	0.8202	0.7965	0.8	667986000.0
2007-08-23	AMZN	Stock	3.947	3.95	3.8255	3.865	113300000.0
2007-08-23	TLT	Stock	87.09	87.68	87.03	87.42	1618800.0
2007-08-23	CL	Stock	33.65	33.65	33.165	33.34	3103600.0
2007-08-23	A	Stock	24.6781	24.907	24.4206	24.7783	2991580.0
2007-08-23	AABA-DELISTED	Stock	23.35	23.36	22.95	23.12	14080596.0
2007-08-23	AACC-DELISTED	Stock	11.1	11.41	10.65	10.67	300324.0
2007-08-23	AAI-DELISTED	Stock	10.49	10.55	10.11	10.21	1958100.0
2007-08-23	AAIC-DELISTED	Stock	92.6	93.0	88.0	88.0	2500500.0
2007-08-23	AAME	Stock	2.78	3.17	2.77	2.93	6300.0
2007-08-23	AAON	Stock	4.2667	4.2667	3.9368	3.9723	884925.0
2007-08-23	AAP	Stock	33.83	34.05	33.54	34.0	1638800.0
2007-08-23	AATI-DELISTED	Stock	8.91	8.94	8.6	8.77	273930.0
2007-08-23	AAU-DELISTED	Stock	2.25	2.29	2.12	2.18	101300.0
2007-08-23	AAUAF-DELISTED	Stock	2.25	2.29	2.12	2.18	100000.0
2007-08-23	AAV-DELISTED	Stock	11.88	11.95	11.48	11.51	494700.0
2007-08-23	AAWW-DELISTED	Stock	51.51	51.59	50.52	50.8	75839.0
2007-08-23	AAXN-DELISTED	Stock	13.66	13.72	13.29	13.34	1140205.0
2007-08-23	AB	Stock	84.78	84.78	82.91	84.21	408400.0
2007-08-23	ABAX-DELISTED	Stock	20.96	20.97	20.1	20.16	69634.0
2007-08-23	ABB-DELISTED	Stock	23.21	23.21	22.92	23.05	1708500.0
2007-08-23	ABBC-DELISTED	Stock	9.64	9.64	9.4942	9.57	20175.0
2007-08-23	ABBNY-DELISTED	Stock	23.21	23.21	22.92	23.05	1818700.0
2007-08-23	ABC-DELISTED	Stock	23.66	24.3	23.45	24.25	4258400.0
2007-08-23	ABCB	Stock	21.6802	21.6802	19.9878	20.3087	36087.0
2007-08-23	ABCO-DELISTED	Stock	28.88	29.01	27.95	28.33	286737.0
2007-08-23	ABCW-DELISTED	Stock	27.44	27.69	26.64	26.68	73140.0
2007-08-23	ABD-DELISTED	Stock	23.98	23.98	23.14	23.43	298800.0
2007-08-23	ABE-DELISTED	Stock	21.04	21.04	20.55	20.75	26000.0
2007-08-23	ABEO	Stock	4187.5	4187.5	3625.0	3987.5	4.0
2007-08-23	ABFS-DELISTED	Stock	36.76	36.9	35.02	35.33	592946.0
2007-08-23	ABG	Stock	22.07	22.28	21.24	21.32	529000.0
2007-08-23	ABK-DELISTED	Stock	65.5	66.66	62.59	64.05	3042500.0
2007-08-23	ABM	Stock	23.6	23.79	22.86	23.45	249800.0
2007-08-23	ABMD-DELISTED	Stock	11.55	11.55	11.1	11.19	190791.0
2007-08-23	ABP-DELISTED	Stock	3.65	3.77	3.58	3.62	120700.0
2007-08-23	ABR	Stock	20.27	20.49	19.83	19.92	249500.0
2007-08-23	ABT	Stock	25.1991	25.2279	24.8632	25.0264	9213631.0
2007-08-23	ABTL-DELISTED	Stock	15.35	16.3	15.2	16.15	16287.0
2007-08-23	ABV-DELISTED	Stock	66.69	66.69	62.1	64.61	931700.0
2007-08-23	ABVA-DELISTED	Stock	9.99	9.99	9.44	9.8	42795.0
2007-08-23	ABX-DELISTED	Stock	33.66	33.9	32.11	32.64	4711400.0
2007-08-23	ACAD	Stock	14.81	14.84	14.63	14.8	244600.0
2007-08-23	ACAP-DELISTED	Stock	41.25	41.28	39.25	39.56	31504.0
2007-08-23	ACAS-DELISTED	Stock	41.115	41.115	40.03	40.32	1117755.0
2007-08-23	ACAT-DELISTED	Stock	18.11	18.72	17.72	18.23	110211.0
2007-08-23	ACC-DELISTED	Stock	28.42	28.49	27.56	27.75	166700.0
2007-08-23	ACCL-DELISTED	Stock	6.28	6.43	6.28	6.42	42129.0

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

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