PREVIEW / stock_daily / 2007-08-06

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-06.parquet
  size:    178 KB
  rows:    5,495
  symbols: 3,304

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-06	AAPL	Stock	4.7464	4.8311	4.5821	4.8304	925170400.0
2007-08-06	MSFT	Stock	29.05	29.54	28.75	29.54	59530500.0
2007-08-06	NVDA	Stock	0.715	0.7203	0.695	0.715	524724000.0
2007-08-06	AMZN	Stock	3.853	3.95	3.83	3.95	180058000.0
2007-08-06	TLT	Stock	87.7	87.72	87.17	87.29	1298400.0
2007-08-06	CL	Stock	33.235	33.935	33.205	33.925	5341400.0
2007-08-06	A	Stock	27.3677	27.4034	26.8813	27.4034	3780332.0
2007-08-06	AABA-DELISTED	Stock	23.03	23.15	22.44	22.94	27912563.0
2007-08-06	AACC-DELISTED	Stock	10.15	10.34	9.61	10.32	689155.0
2007-08-06	AAI-DELISTED	Stock	9.42	9.67	9.0	9.63	3038800.0
2007-08-06	AAIC-DELISTED	Stock	86.0	92.6	81.0	92.4	4980100.0
2007-08-06	AAME	Stock	3.1	3.1	2.4	2.73	14200.0
2007-08-06	AAON	Stock	4.2693	4.3984	4.2272	4.3957	1042622.0
2007-08-06	AAP	Stock	33.67	34.57	32.9	34.03	2644500.0
2007-08-06	AATI-DELISTED	Stock	8.2	8.2	7.85	8.06	504689.0
2007-08-06	AAU-DELISTED	Stock	2.69	2.69	2.56	2.56	23000.0
2007-08-06	AAUAF-DELISTED	Stock	2.69	2.7	2.56	2.56	27000.0
2007-08-06	AAV-DELISTED	Stock	12.03	12.06	11.03	11.71	1996300.0
2007-08-06	AAWW-DELISTED	Stock	54.17	54.61	52.06	53.72	218963.0
2007-08-06	AAXN-DELISTED	Stock	14.46	14.57	13.5	14.14	4055190.0
2007-08-06	AB	Stock	82.13	86.4	81.89	86.15	419100.0
2007-08-06	ABAX-DELISTED	Stock	18.25	19.04	17.97	18.91	378682.0
2007-08-06	ABB-DELISTED	Stock	23.5	23.58	22.95	23.58	3759400.0
2007-08-06	ABBC-DELISTED	Stock	8.91	8.91	8.75	8.83	317083.0
2007-08-06	ABBNY-DELISTED	Stock	23.5	23.58	22.95	23.58	3775300.0
2007-08-06	ABC-DELISTED	Stock	23.13	23.84	23.06	23.78	4024000.0
2007-08-06	ABCB	Stock	17.634	18.3829	17.0213	18.2565	98186.0
2007-08-06	ABCO-DELISTED	Stock	26.1	27.43	26.1	27.26	485145.0
2007-08-06	ABCW-DELISTED	Stock	21.49	23.35	21.41	23.3	323030.0
2007-08-06	ABD-DELISTED	Stock	22.5	24.58	21.84	24.25	2303600.0
2007-08-06	ABE-DELISTED	Stock	21.5	21.622	20.19	20.639	45000.0
2007-08-06	ABEO	Stock	5312.5	5312.5	5312.5	5312.5	2.0
2007-08-06	ABFS-DELISTED	Stock	35.63	35.82	34.55	35.79	554245.0
2007-08-06	ABG	Stock	19.76	21.22	19.76	20.83	626000.0
2007-08-06	ABK-DELISTED	Stock	62.42	64.58	57.8	64.32	7536400.0
2007-08-06	ABM	Stock	23.15	23.33	22.06	22.66	525200.0
2007-08-06	ABMD-DELISTED	Stock	10.53	11.0299	10.21	10.99	360193.0
2007-08-06	ABP-DELISTED	Stock	4.0	4.02	3.6	3.71	330300.0
2007-08-06	ABR	Stock	19.32	19.4	17.75	19.2	650900.0
2007-08-06	ABT	Stock	25.0072	25.6117	24.585	25.487	18783868.0
2007-08-06	ABTL-DELISTED	Stock	15.4	15.45	14.551	15.15	24387.0
2007-08-06	ABV-DELISTED	Stock	65.13	66.27	64.75	66.09	726300.0
2007-08-06	ABVA-DELISTED	Stock	9.67	9.94	9.52	9.8	18161.0
2007-08-06	ABVT-DELISTED	Stock	85.0	85.0	80.0	83.5	186385.0
2007-08-06	ABX-DELISTED	Stock	33.01	33.45	32.34	33.34	5868100.0
2007-08-06	ACAD	Stock	14.99	15.35	14.57	15.23	707400.0
2007-08-06	ACAP-DELISTED	Stock	35.79	37.1299	35.13	36.95	104032.0
2007-08-06	ACAS-DELISTED	Stock	38.59	40.5	37.8	40.31	4504690.0
2007-08-06	ACAT-DELISTED	Stock	17.83	17.83	17.04	17.53	210935.0
2007-08-06	ACC-DELISTED	Stock	25.59	26.14	25.0	25.98	677900.0

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

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