PREVIEW / stock_daily / 2007-03-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-19.parquet
  size:    161 KB
  rows:    4,888
  symbols: 3,082

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-03-19	AAPL	Stock	3.2229	3.2696	3.1996	3.2546	712961200.0
2007-03-19	MSFT	Stock	27.34	27.83	27.2	27.83	49412000.0
2007-03-19	NVDA	Stock	0.475	0.4825	0.4733	0.4748	461508000.0
2007-03-19	AMZN	Stock	1.9	1.927	1.9	1.9225	84532000.0
2007-03-19	TLT	Stock	89.58	89.7	89.52	89.66	693900.0
2007-03-19	CL	Stock	32.56	32.905	32.53	32.69	3244600.0
2007-03-19	A	Stock	22.8755	23.0186	22.7325	22.7825	1962093.0
2007-03-19	AABA-DELISTED	Stock	30.0	30.1900005340576	29.9200000762939	30.0300006866455	9983800.0
2007-03-19	AACC-DELISTED	Stock	15.19	15.4	15.13	15.25	129324.0
2007-03-19	AAI-DELISTED	Stock	10.01	10.04	9.82	9.9	1725200.0
2007-03-19	AAIC-DELISTED	Stock	106.0	106.6	102.2	104.2	3043100.0
2007-03-19	AAME	Stock	3.81	3.99	3.8	3.94	2300.0
2007-03-19	AAON	Stock	3.5384	3.6161	3.5042	3.5384	246797.0
2007-03-19	AAP	Stock	38.18	39.31	38.17	39.3	1564400.0
2007-03-19	AATI-DELISTED	Stock	6.99	7.15	6.84	6.86	587949.0
2007-03-19	AAU-DELISTED	Stock	2.15	2.15	2.05	2.06	89500.0
2007-03-19	AAUAF-DELISTED	Stock	2.15	2.15	2.05	2.06	89500.0
2007-03-19	AAV-DELISTED	Stock	9.87	9.95	9.82	9.91	618600.0
2007-03-19	AAWW-DELISTED	Stock	53.25	53.84	52.71	53.03	125928.0
2007-03-19	AAXN-DELISTED	Stock	8.0	8.11999988555908	7.90999984741211	8.02999973297119	1348600.0
2007-03-19	AB	Stock	83.25	83.6	83.03	83.38	208800.0
2007-03-19	ABAX-DELISTED	Stock	23.09	23.46	22.89	23.1	143629.0
2007-03-19	ABB-DELISTED	Stock	16.99	17.17	16.95	17.0	2085500.0
2007-03-19	ABBC-DELISTED	Stock	20.02	20.21	19.63	19.74	60960.0
2007-03-19	ABC-DELISTED	Stock	26.06	26.69	26.0	26.65	2302600.0
2007-03-19	ABCB	Stock	22.8376	23.5866	22.5263	22.7598	46369.0
2007-03-19	ABCO-DELISTED	Stock	25.66	25.87	25.56	25.73	88618.0
2007-03-19	ABCW-DELISTED	Stock	27.89	28.25	27.89	28.11	55260.0
2007-03-19	ABD-DELISTED	Stock	21.72	22.42	21.72	22.21	434100.0
2007-03-19	ABE-DELISTED	Stock	17.4	17.6689	17.231	17.65	41400.0
2007-03-19	ABFS-DELISTED	Stock	36.33	36.34	35.92	36.12	347049.0
2007-03-19	ABG	Stock	28.2	28.54	28.18	28.29	178200.0
2007-03-19	ABK-DELISTED	Stock	87.25	87.41	86.68	86.9	675500.0
2007-03-19	ABM	Stock	26.25	26.31	25.94	26.0	499400.0
2007-03-19	ABMD-DELISTED	Stock	12.35	12.37	12.12	12.14	261309.0
2007-03-19	ABP-DELISTED	Stock	3.02	3.08	2.95	3.05	167800.0
2007-03-19	ABR	Stock	29.86	30.19	29.63	29.87	113000.0
2007-03-19	ABT	Stock	25.439	25.5637	25.3718	25.5158	12307628.0
2007-03-19	ABTL-DELISTED	Stock	16.975	17.175	16.226	17.125	66193.0
2007-03-19	ABV-DELISTED	Stock	52.06	52.65	51.68	52.03	246700.0
2007-03-19	ABVA-DELISTED	Stock	15.4	15.75	15.02	15.03	3035.0
2007-03-19	ABVT-DELISTED	Stock	55.0	56.0	55.0	56.0	10400.0
2007-03-19	ABX-DELISTED	Stock	28.11	28.61	28.1	28.49	5193500.0
2007-03-19	ACAD	Stock	11.11	14.51	10.57	13.61	21592800.0
2007-03-19	ACAP-DELISTED	Stock	36.48	37.94	36.48	37.92	65452.0
2007-03-19	ACAS-DELISTED	Stock	44.19	44.71	43.92	44.48	923354.0
2007-03-19	ACAT-DELISTED	Stock	18.7	19.25	18.7	19.15	59603.0
2007-03-19	ACC-DELISTED	Stock	29.46	30.26	29.11	30.26	271600.0
2007-03-19	ACCL-DELISTED	Stock	6.35	6.44	6.35	6.42	59317.0
2007-03-19	ACCO	Stock	21.72	22.42	21.72	22.21	435100.0

> showing 50 of 4,888 rows — these rows as CSV

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