PREVIEW / stock_daily / 2007-04-13

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-13.parquet
  size:    162 KB
  rows:    4,891
  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-13	AAPL	Stock	3.2464	3.2643	3.2164	3.2229	719941600.0
2007-04-13	MSFT	Stock	28.43	28.7	28.1	28.61	36002900.0
2007-04-13	NVDA	Stock	0.5038	0.5107	0.4977	0.5097	638694000.0
2007-04-13	AMZN	Stock	2.1095	2.125	2.0965	2.1205	72200000.0
2007-04-13	TLT	Stock	87.41	87.47	87.01	87.12	557800.0
2007-04-13	CL	Stock	33.145	33.3	33.085	33.205	3616800.0
2007-04-13	A	Stock	25.1073	25.1073	24.4921	24.6567	4574815.0
2007-04-13	AABA-DELISTED	Stock	31.1499996185303	31.5	30.9599990844727	31.4099998474121	12006300.0
2007-04-13	AACC-DELISTED	Stock	15.2	15.72	15.2	15.45	164387.0
2007-04-13	AACQ-DELISTED	Stock	4.34	4.34	4.34	4.34	2800.0
2007-04-13	AACQU-DELISTED	Stock	5.55	5.55	5.55	5.55	1100.0
2007-04-13	AAI-DELISTED	Stock	11.69	11.83	11.42	11.59	2205200.0
2007-04-13	AAIC-DELISTED	Stock	112.0	114.8	106.0	114.0	1937100.0
2007-04-13	AAME	Stock	3.98	4.15	3.91	4.05	12000.0
2007-04-13	AAON	Stock	3.3449	3.3449	3.2211	3.2922	311344.0
2007-04-13	AAP	Stock	40.02	40.13	39.42	39.65	626000.0
2007-04-13	AATI-DELISTED	Stock	6.7	6.92	6.7	6.87	399478.0
2007-04-13	AAU-DELISTED	Stock	2.45	2.52	2.41	2.52	80400.0
2007-04-13	AAUAF-DELISTED	Stock	2.45	2.52	2.41	2.52	80400.0
2007-04-13	AAV-DELISTED	Stock	10.42	10.54	10.4	10.52	527178.0
2007-04-13	AAWW-DELISTED	Stock	57.05	58.38	56.8	58.34	257166.0
2007-04-13	AAXN-DELISTED	Stock	8.05000019073486	8.18000030517578	8.0	8.14999961853027	689100.0
2007-04-13	AB	Stock	93.29	93.79	92.45	92.56	295400.0
2007-04-13	ABAX-DELISTED	Stock	26.05	26.54	25.99	26.4	296535.0
2007-04-13	ABB-DELISTED	Stock	18.15	18.15	18.01	18.08	1404500.0
2007-04-13	ABBC-DELISTED	Stock	19.96	19.96	19.75	19.96	8648.0
2007-04-13	ABC-DELISTED	Stock	26.88	27.21	26.86	27.18	1647548.0
2007-04-13	ABCB	Stock	24.0924	24.2674	23.6546	24.2188	13366.0
2007-04-13	ABCO-DELISTED	Stock	25.62	25.67	25.43	25.67	287643.0
2007-04-13	ABCW-DELISTED	Stock	27.65	27.86	27.53	27.85	41870.0
2007-04-13	ABD-DELISTED	Stock	24.85	24.85	24.63	24.8	651960.0
2007-04-13	ABE-DELISTED	Stock	19.9	20.0	19.7	19.99	16800.0
2007-04-13	ABFS-DELISTED	Stock	37.44	37.68	37.15	37.67	475995.0
2007-04-13	ABG	Stock	27.63	27.71	26.91	27.05	696500.0
2007-04-13	ABK-DELISTED	Stock	85.76	87.21	85.6	87.15	1486500.0
2007-04-13	ABM	Stock	27.0	27.14	26.8	27.08	709700.0
2007-04-13	ABMD-DELISTED	Stock	13.35	13.47	13.21	13.47	122018.0
2007-04-13	ABP-DELISTED	Stock	3.05	3.16	3.02	3.16	152200.0
2007-04-13	ABR	Stock	30.56	31.16	30.51	30.98	93200.0
2007-04-13	ABT	Stock	27.5597	28.1451	27.5549	28.0635	14888704.0
2007-04-13	ABTL-DELISTED	Stock	16.625	17.025	16.575	16.775	12222.0
2007-04-13	ABV-DELISTED	Stock	57.06	57.95	57.06	57.93	246600.0
2007-04-13	ABVA-DELISTED	Stock	15.38	15.38	14.82	14.82	2000.0
2007-04-13	ABX-DELISTED	Stock	29.1	29.45	28.9	29.34	8025400.0
2007-04-13	ACAD	Stock	15.6	15.74	15.44	15.47	226900.0
2007-04-13	ACAP-DELISTED	Stock	38.59	38.59	37.89	38.15	40101.0
2007-04-13	ACAS-DELISTED	Stock	45.5	45.92	45.38	45.92	752572.0
2007-04-13	ACAT-DELISTED	Stock	18.84	18.84	18.46	18.61	59208.0
2007-04-13	ACC-DELISTED	Stock	29.93	29.96	29.45	29.83	255400.0
2007-04-13	ACCL-DELISTED	Stock	6.51	6.6	6.5	6.54	29128.0

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

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