PREVIEW / stock_daily / 2007-04-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-19.parquet
  size:    162 KB
  rows:    4,896
  symbols: 3,074

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-04-19	AAPL	Stock	3.2211	3.2589	3.2082	3.2239	425913600.0
2007-04-19	MSFT	Stock	28.34	28.89	28.26	28.69	43648800.0
2007-04-19	NVDA	Stock	0.514	0.5283	0.5125	0.5253	568056000.0
2007-04-19	AMZN	Stock	2.2305	2.2575	2.2205	2.232	96194000.0
2007-04-19	TLT	Stock	88.66	88.71	88.2	88.38	1305815.0
2007-04-19	CL	Stock	33.795	33.795	33.25	33.5	4226800.0
2007-04-19	A	Stock	25.3577	25.4936	25.1288	25.2074	3168008.0
2007-04-19	AABA-DELISTED	Stock	28.1000003814697	28.2299995422363	27.4599990844727	27.5100002288818	45664700.0
2007-04-19	AACC-DELISTED	Stock	16.05	16.309	15.94	16.06	104320.0
2007-04-19	AACQ-DELISTED	Stock	4.46	4.54	4.44	4.44	24124.0
2007-04-19	AACQU-DELISTED	Stock	5.7	5.7	5.7	5.7	500.0
2007-04-19	AACQW-DELISTED	Stock	0.63	0.63	0.63	0.63	10000.0
2007-04-19	AAI-DELISTED	Stock	11.84	12.0	11.64	11.66	1675900.0
2007-04-19	AAIC-DELISTED	Stock	117.4	119.4	116.0	119.2	882500.0
2007-04-19	AAME	Stock	4.48	4.55	4.34	4.5	6500.0
2007-04-19	AAON	Stock	3.3449	3.3449	3.2474	3.254	254391.0
2007-04-19	AAP	Stock	40.51	40.51	39.64	40.09	428200.0
2007-04-19	AATI-DELISTED	Stock	6.66	6.75	6.5	6.7	218378.0
2007-04-19	AAU-DELISTED	Stock	2.61	2.64	2.56	2.63	67300.0
2007-04-19	AAUAF-DELISTED	Stock	2.61	2.64	2.56	2.63	67300.0
2007-04-19	AAV-DELISTED	Stock	11.18	11.26	11.1	11.13	679700.0
2007-04-19	AAWW-DELISTED	Stock	58.25	58.8499	57.86	58.52	92836.0
2007-04-19	AAXN-DELISTED	Stock	8.5	8.59000015258789	8.34000015258789	8.36999988555908	1127300.0
2007-04-19	AB	Stock	92.0	93.3	91.9	92.82	92800.0
2007-04-19	ABAX-DELISTED	Stock	26.73	26.73	25.45	25.5	309021.0
2007-04-19	ABB-DELISTED	Stock	18.22	18.6	18.21	18.47	1971215.0
2007-04-19	ABBC-DELISTED	Stock	19.99	20.01	19.64	19.64	15271.0
2007-04-19	ABC-DELISTED	Stock	27.3	27.32	27.0	27.22	1558000.0
2007-04-19	ABCB	Stock	24.4036	24.5884	23.6935	24.1118	38863.0
2007-04-19	ABCO-DELISTED	Stock	25.74	25.77	25.35	25.45	218533.0
2007-04-19	ABCW-DELISTED	Stock	28.22	28.45	27.94	27.97	42920.0
2007-04-19	ABD-DELISTED	Stock	24.68	24.68	24.28	24.44	473700.0
2007-04-19	ABE-DELISTED	Stock	20.3	20.35	20.0	20.35	15800.0
2007-04-19	ABFS-DELISTED	Stock	37.38	38.28	37.16	38.02	459148.0
2007-04-19	ABG	Stock	27.99	28.47	27.99	28.45	576000.0
2007-04-19	ABK-DELISTED	Stock	89.11	90.07	88.6	90.0	1415397.0
2007-04-19	ABM	Stock	27.4	27.61	27.35	27.45	323000.0
2007-04-19	ABMD-DELISTED	Stock	13.64	13.75	13.5	13.67	176220.0
2007-04-19	ABP-DELISTED	Stock	3.05	3.07	3.02	3.05	84700.0
2007-04-19	ABR	Stock	31.32	31.74	31.19	31.6	89500.0
2007-04-19	ABT	Stock	27.7276	27.934	27.3102	27.4638	16780742.0
2007-04-19	ABTL-DELISTED	Stock	17.425	17.425	16.976	17.275	11248.0
2007-04-19	ABV-DELISTED	Stock	57.99	59.23	57.9601	59.15	564400.0
2007-04-19	ABVA-DELISTED	Stock	14.95	15.03	14.65	15.0	1989.0
2007-04-19	ABX-DELISTED	Stock	28.78	29.07	28.65	28.69	6925050.0
2007-04-19	ACAD	Stock	15.05	15.05	14.64	14.73	390900.0
2007-04-19	ACAP-DELISTED	Stock	38.38	39.59	37.92	39.16	85037.0
2007-04-19	ACAS-DELISTED	Stock	47.0	47.32	46.62	46.96	1023601.0
2007-04-19	ACAT-DELISTED	Stock	18.21	18.29	17.8	18.2	84184.0
2007-04-19	ACC-DELISTED	Stock	30.34	30.35	29.54	30.1	54200.0

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

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