PREVIEW / stock_daily / 2007-08-14

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-14.parquet
  size:    177 KB
  rows:    5,500
  symbols: 3,320

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-14	AAPL	Stock	4.5818	4.5821	4.4182	4.4296	739006800.0
2007-08-14	MSFT	Stock	28.77	28.89	28.2	28.27	42944100.0
2007-08-14	NVDA	Stock	0.7302	0.765	0.728	0.7533	1092174000.0
2007-08-14	AMZN	Stock	3.7395	3.7395	3.646	3.6725	118924000.0
2007-08-14	TLT	Stock	86.02	86.78	86.0123	86.56	1314700.0
2007-08-14	CL	Stock	33.05	33.13	32.69	32.725	4459800.0
2007-08-14	A	Stock	25.608	26.5379	25.608	25.9871	4101732.0
2007-08-14	AABA-DELISTED	Stock	24.69	24.7	23.69	23.71	18193322.0
2007-08-14	AACC-DELISTED	Stock	8.72	8.9	8.72	8.85	297327.0
2007-08-14	AAI-DELISTED	Stock	10.32	10.53	10.15	10.38	2343200.0
2007-08-14	AAIC-DELISTED	Stock	87.2	91.0	85.6	86.8	2767998.0
2007-08-14	AAME	Stock	3.21	3.21	2.95	3.06	3600.0
2007-08-14	AAON	Stock	4.185	4.2258	4.0494	4.0507	454866.0
2007-08-14	AAP	Stock	33.94	33.94	32.7	32.78	2189400.0
2007-08-14	AATI-DELISTED	Stock	8.64	8.64	8.28	8.32	102010.0
2007-08-14	AAU-DELISTED	Stock	2.64	2.67	2.47	2.48	68000.0
2007-08-14	AAUAF-DELISTED	Stock	2.64	2.67	2.47	2.48	68000.0
2007-08-14	AAV-DELISTED	Stock	12.18	12.25	12.0	12.1	347000.0
2007-08-14	AAWW-DELISTED	Stock	52.89	53.77	51.79	52.75	150310.0
2007-08-14	AAXN-DELISTED	Stock	15.0	15.1	14.2	14.29	2332910.0
2007-08-14	AB	Stock	83.94	84.25	79.98	80.18	389800.0
2007-08-14	ABAX-DELISTED	Stock	20.14	20.48	19.89	19.93	133116.0
2007-08-14	ABB-DELISTED	Stock	23.15	23.18	22.29	22.33	2511000.0
2007-08-14	ABBC-DELISTED	Stock	9.15	9.16	8.97	8.97	58612.0
2007-08-14	ABBNY-DELISTED	Stock	23.15	23.18	22.29	22.36	2514300.0
2007-08-14	ABC-DELISTED	Stock	23.34	23.52	22.81	22.84	3589800.0
2007-08-14	ABCB	Stock	19.5209	19.6765	18.986	18.986	24881.0
2007-08-14	ABCO-DELISTED	Stock	28.59	28.93	28.13	28.19	368289.0
2007-08-14	ABCW-DELISTED	Stock	24.28	24.41	23.83	23.9	80580.0
2007-08-14	ABD-DELISTED	Stock	24.22	24.32	22.57	22.81	645750.0
2007-08-14	ABE-DELISTED	Stock	20.25	20.25	19.39	19.39	45100.0
2007-08-14	ABEO	Stock	4175.0	4375.0	4062.5	4250.0	10.0
2007-08-14	ABFS-DELISTED	Stock	35.81	35.85	34.38	34.61	326525.0
2007-08-14	ABG	Stock	21.88	22.23	20.82	21.16	946900.0
2007-08-14	ABK-DELISTED	Stock	63.95	64.36	60.71	60.82	4329800.0
2007-08-14	ABM	Stock	23.0	23.25	22.23	22.4	407800.0
2007-08-14	ABMD-DELISTED	Stock	11.16	11.5	10.7	10.73	383877.0
2007-08-14	ABP-DELISTED	Stock	3.75	3.92	3.75	3.85	174000.0
2007-08-14	ABR	Stock	18.25	18.43	17.26	17.44	482600.0
2007-08-14	ABT	Stock	25.9812	26.0244	25.0791	25.1751	13823885.0
2007-08-14	ABTL-DELISTED	Stock	15.309	16.221	14.599	14.65	15709.0
2007-08-14	ABV-DELISTED	Stock	66.5	67.71	63.89	64.3	922300.0
2007-08-14	ABVA-DELISTED	Stock	10.0	10.024	9.8	9.8	14088.0
2007-08-14	ABVT-DELISTED	Stock	75.0	80.5	75.0	80.5	4100.0
2007-08-14	ABX-DELISTED	Stock	33.59	33.94	32.72	32.77	4625500.0
2007-08-14	ACAD	Stock	15.8	16.04	15.61	15.8	381200.0
2007-08-14	ACAP-DELISTED	Stock	37.52	37.74	36.45	36.61	120561.0
2007-08-14	ACAS-DELISTED	Stock	40.77	40.89	39.79	40.01	2988059.0
2007-08-14	ACAT-DELISTED	Stock	17.56	17.8	17.16	17.16	97872.0
2007-08-14	ACC-DELISTED	Stock	26.76	26.76	25.99	26.01	106308.0

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

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