PREVIEW / stock_daily / 2007-08-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-20.parquet
  size:    177 KB
  rows:    5,508
  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-08-20	AAPL	Stock	4.4271	4.4464	4.3036	4.365	803317200.0
2007-08-20	MSFT	Stock	28.18	28.49	28.08	28.26	49952000.0
2007-08-20	NVDA	Stock	0.7518	0.76	0.7392	0.7483	519684000.0
2007-08-20	AMZN	Stock	3.749	3.764	3.69	3.735	118322000.0
2007-08-20	TLT	Stock	86.96	87.27	86.83	86.84	1048680.0
2007-08-20	CL	Stock	33.565	33.935	33.025	33.3	5067400.0
2007-08-20	A	Stock	24.1202	24.2418	23.6767	24.0343	4957308.0
2007-08-20	AABA-DELISTED	Stock	23.65	23.74	23.18	23.3	12510791.0
2007-08-20	AACC-DELISTED	Stock	9.98	10.06	9.58	9.75	391344.0
2007-08-20	AAI-DELISTED	Stock	10.16	10.28	9.86	9.9	1704600.0
2007-08-20	AAIC-DELISTED	Stock	91.0	92.6	87.8	90.0	1643700.0
2007-08-20	AAME	Stock	3.38	3.39	3.1	3.15	5000.0
2007-08-20	AAON	Stock	4.2206	4.2206	4.0494	4.0849	373612.0
2007-08-20	AAP	Stock	31.94	33.47	31.75	33.21	1852300.0
2007-08-20	AATI-DELISTED	Stock	8.52	8.59	8.22	8.35	294579.0
2007-08-20	AAU-DELISTED	Stock	2.37	2.38	2.27	2.29	66200.0
2007-08-20	AAUAF-DELISTED	Stock	2.37	2.38	2.27	2.29	66200.0
2007-08-20	AAV-DELISTED	Stock	11.52	11.74	11.45	11.63	536000.0
2007-08-20	AAWW-DELISTED	Stock	50.76	50.99	49.35	50.4	133401.0
2007-08-20	AAXN-DELISTED	Stock	14.34	14.36	13.49	13.59	2455390.0
2007-08-20	AB	Stock	81.9	81.9	78.75	80.67	298600.0
2007-08-20	ABAX-DELISTED	Stock	20.9	21.2	20.35	20.58	92053.0
2007-08-20	ABB-DELISTED	Stock	22.15	22.5	22.01	22.39	3313300.0
2007-08-20	ABBC-DELISTED	Stock	9.28	9.3	9.06	9.3	45736.0
2007-08-20	ABBNY-DELISTED	Stock	22.15	22.5	22.01	22.39	3490500.0
2007-08-20	ABC-DELISTED	Stock	23.06	23.28	22.55	23.02	2702800.0
2007-08-20	ABCB	Stock	21.4079	21.7483	21.1161	21.6608	28582.0
2007-08-20	ABCO-DELISTED	Stock	29.21	29.6	28.76	29.29	116434.0
2007-08-20	ABCW-DELISTED	Stock	27.39	27.39	26.49	27.0	138290.0
2007-08-20	ABD-DELISTED	Stock	24.0	24.08	23.51	23.98	346200.0
2007-08-20	ABE-DELISTED	Stock	20.0	20.0	19.15	19.696	13500.0
2007-08-20	ABEO	Stock	4125.0	4312.5	4125.0	4250.0	12.0
2007-08-20	ABFS-DELISTED	Stock	35.97	36.96	35.74	36.14	277352.0
2007-08-20	ABG	Stock	22.01	22.94	21.88	22.77	777800.0
2007-08-20	ABK-DELISTED	Stock	66.65	66.89	63.5	65.5	3891700.0
2007-08-20	ABM	Stock	22.82	23.39	22.5	22.93	286300.0
2007-08-20	ABMD-DELISTED	Stock	12.52	12.8	12.16	12.32	157858.0
2007-08-20	ABP-DELISTED	Stock	3.82	3.86	3.7	3.79	129500.0
2007-08-20	ABR	Stock	19.01	19.65	19.01	19.11	250000.0
2007-08-20	ABT	Stock	25.2663	25.5302	24.9592	25.1367	8661317.0
2007-08-20	ABTL-DELISTED	Stock	15.3	15.3	14.999	15.2	40832.0
2007-08-20	ABV-DELISTED	Stock	61.02	62.37	59.58	62.13	1004150.0
2007-08-20	ABVA-DELISTED	Stock	9.72	9.72	9.4	9.58	16800.0
2007-08-20	ABVT-DELISTED	Stock	74.0	74.0	74.0	74.0	3100.0
2007-08-20	ABX-DELISTED	Stock	30.9	32.36	30.75	31.87	6798700.0
2007-08-20	ACAD	Stock	15.01	15.23	14.62	15.07	315900.0
2007-08-20	ACAP-DELISTED	Stock	40.94	41.0	39.2	40.26	46099.0
2007-08-20	ACAS-DELISTED	Stock	40.67	40.77	39.02	39.58	1671899.0
2007-08-20	ACAT-DELISTED	Stock	17.44	17.57	17.0	17.43	158372.0
2007-08-20	ACC-DELISTED	Stock	27.19	28.03	26.95	27.97	233380.0

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

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