PREVIEW / stock_daily / 2007-04-18

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-18.parquet
  size:    162 KB
  rows:    4,905
  symbols: 3,088

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-18	AAPL	Stock	3.22	3.2446	3.2	3.2286	464044000.0
2007-04-18	MSFT	Stock	28.61	28.67	28.36	28.6	41778400.0
2007-04-18	NVDA	Stock	0.511	0.5227	0.5083	0.5182	683802000.0
2007-04-18	AMZN	Stock	2.24	2.2575	2.2315	2.2495	99928000.0
2007-04-18	TLT	Stock	88.37	88.56	88.36	88.53	451076.0
2007-04-18	CL	Stock	33.5	33.76	33.225	33.37	3096400.0
2007-04-18	A	Stock	25.1788	25.5007	25.0644	25.3791	4027778.0
2007-04-18	AABA-DELISTED	Stock	28.4200000762939	28.8999996185303	27.8899993896484	28.3099994659424	127875300.0
2007-04-18	AACC-DELISTED	Stock	16.0	16.34	16.0	16.14	78887.0
2007-04-18	AACQ-DELISTED	Stock	4.4	4.47	4.4	4.47	53400.0
2007-04-18	AACQW-DELISTED	Stock	0.63	0.63	0.59	0.59	49500.0
2007-04-18	AAI-DELISTED	Stock	11.79	12.1	11.68	11.94	2450200.0
2007-04-18	AAIC-DELISTED	Stock	117.4	119.2	116.0	118.4	965500.0
2007-04-18	AAME	Stock	4.3	4.74	4.24	4.45	16900.0
2007-04-18	AAON	Stock	3.3778	3.437	3.3067	3.3672	217941.0
2007-04-18	AAP	Stock	40.0	40.3	39.69	40.0	410000.0
2007-04-18	AATI-DELISTED	Stock	6.79	6.8025	6.66	6.75	231990.0
2007-04-18	AAU-DELISTED	Stock	2.63	2.64	2.6	2.64	69500.0
2007-04-18	AAUAF-DELISTED	Stock	2.63	2.64	2.6	2.64	69500.0
2007-04-18	AAV-DELISTED	Stock	11.16	11.2	11.06	11.17	782200.0
2007-04-18	AAWW-DELISTED	Stock	59.06	59.6499	58.42	58.42	92714.0
2007-04-18	AAXN-DELISTED	Stock	8.19999980926514	8.64999961853027	8.19999980926514	8.59000015258789	1902800.0
2007-04-18	AB	Stock	93.42	94.13	92.82	93.26	201400.0
2007-04-18	ABAX-DELISTED	Stock	26.89	26.91	26.46	26.79	326565.0
2007-04-18	ABB-DELISTED	Stock	18.23	18.43	18.22	18.34	2544000.0
2007-04-18	ABBC-DELISTED	Stock	20.0	20.1	19.72	19.75	9608.0
2007-04-18	ABC-DELISTED	Stock	27.26	27.58	27.16	27.44	1894000.0
2007-04-18	ABCB	Stock	24.8802	24.9385	24.4814	24.5009	23441.0
2007-04-18	ABCO-DELISTED	Stock	25.93	25.98	25.76	25.83	135071.0
2007-04-18	ABCW-DELISTED	Stock	28.43	28.62	28.32	28.32	30690.0
2007-04-18	ABD-DELISTED	Stock	24.76	24.97	24.62	24.83	373880.0
2007-04-18	ABE-DELISTED	Stock	20.5	20.5	20.38	20.39	14200.0
2007-04-18	ABFS-DELISTED	Stock	37.51	38.13	37.39	37.42	488802.0
2007-04-18	ABG	Stock	27.74	28.0	27.44	27.99	531600.0
2007-04-18	ABK-DELISTED	Stock	88.21	90.26	88.21	89.2	1410500.0
2007-04-18	ABM	Stock	27.55	27.79	27.4	27.62	281000.0
2007-04-18	ABMD-DELISTED	Stock	13.7	13.91	13.7	13.75	154990.0
2007-04-18	ABP-DELISTED	Stock	3.07	3.09	3.02	3.08	80300.0
2007-04-18	ABR	Stock	31.76	32.07	31.33	31.4	83800.0
2007-04-18	ABT	Stock	27.4925	28.1163	27.3486	27.8428	25099416.0
2007-04-18	ABTL-DELISTED	Stock	17.85	17.85	17.3	17.5	16715.0
2007-04-18	ABV-DELISTED	Stock	57.83	58.88	57.83	58.74	419300.0
2007-04-18	ABVA-DELISTED	Stock	14.9	14.9	14.66	14.75	25844.0
2007-04-18	ABX-DELISTED	Stock	29.59	29.62	29.25	29.36	4691680.0
2007-04-18	ACAD	Stock	15.49	15.49	14.6	14.98	656900.0
2007-04-18	ACAP-DELISTED	Stock	39.1	39.15	38.35	38.35	41879.0
2007-04-18	ACAS-DELISTED	Stock	46.95	47.64	46.89	47.27	1077568.0
2007-04-18	ACAT-DELISTED	Stock	18.99	19.06	18.29	18.29	103517.0
2007-04-18	ACC-DELISTED	Stock	30.63	30.83	30.45	30.58	99100.0
2007-04-18	ACCL-DELISTED	Stock	6.49	6.53	6.41	6.47	18196.0

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

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