PREVIEW / stock_daily / 2008-09-17

all stock daily files

  file:    by_date/stock_daily/2008/2008-09-17.parquet
  size:    184 KB
  rows:    5,811
  symbols: 3,514

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
2008-09-17	AAPL	Stock	4.9461	4.9468	4.5654	4.5654	1200455200.0
2008-09-17	MSFT	Stock	25.73	25.87	24.5	24.57	106972100.0
2008-09-17	NVDA	Stock	0.2342	0.2555	0.232	0.25	1392580000.0
2008-09-17	AMZN	Stock	3.884	3.912	3.562	3.577	263312000.0
2008-09-17	TLT	Stock	98.92	99.38	97.73	98.49	4371248.0
2008-09-17	CL	Stock	38.68	39.04	38.01	38.18	10422000.0
2008-09-17	A	Stock	21.8813	21.9671	21.1731	21.2804	5352942.0
2008-09-17	AABA-DELISTED	Stock	19.03	19.08	18.2	18.85	27680165.0
2008-09-17	AACC-DELISTED	Stock	10.33	10.57	10.1	10.34	248195.0
2008-09-17	AACG	Stock	9.9	10.05	9.66	9.98	14500.0
2008-09-17	AAI-DELISTED	Stock	2.93	3.0	2.41	2.7	5202580.0
2008-09-17	AAIC-DELISTED	Stock	34.0	34.6	30.2	30.6	776942.0
2008-09-17	AAME	Stock	1.4	1.4	1.4	1.4	600.0
2008-09-17	AAON	Stock	3.8775	3.9328	3.6188	3.6227	904162.0
2008-09-17	AAP	Stock	38.86	40.08	38.07	38.24	1800900.0
2008-09-17	AATI-DELISTED	Stock	4.11	4.52	4.08	4.3	396475.0
2008-09-17	AAU-DELISTED	Stock	1.01	1.19	1.01	1.18	211083.0
2008-09-17	AAUAF-DELISTED	Stock	1.01	1.19	1.01	1.18	212913.0
2008-09-17	AAV-DELISTED	Stock	9.16	9.4	8.86	9.18	904973.0
2008-09-17	AAWW-DELISTED	Stock	47.15	48.16	44.01	45.95	381337.0
2008-09-17	AAXJ	Stock	40.28	40.3	40.25	40.25	1700.0
2008-09-17	AAXN-DELISTED	Stock	6.04	6.34	6.0	6.14	1733452.0
2008-09-17	AB	Stock	41.75	41.75	32.0	33.82	1878600.0
2008-09-17	ABAX-DELISTED	Stock	19.67	19.67	18.19	19.05	478626.0
2008-09-17	ABB-DELISTED	Stock	20.36	20.4	19.32	19.63	8988816.0
2008-09-17	ABBC-DELISTED	Stock	9.93	10.1899	9.82	9.92	111958.0
2008-09-17	ABBNY-DELISTED	Stock	20.36	20.4	19.32	19.63	9145746.0
2008-09-17	ABC-DELISTED	Stock	19.66	19.92	18.92	18.97	4880986.0
2008-09-17	ABCB	Stock	12.7708	12.7708	10.9908	11.02	27040.0
2008-09-17	ABCO-DELISTED	Stock	15.552	15.552	14.858	15.183	384915.0
2008-09-17	ABCW-DELISTED	Stock	8.849	8.899	7.751	7.801	416860.0
2008-09-17	ABD-DELISTED	Stock	8.88	8.96	8.38	8.73	792230.0
2008-09-17	ABE-DELISTED	Stock	15.05	15.872	14.92	14.92	31082.0
2008-09-17	ABEO	Stock	3625.0	3750.0	3562.5	3650.0	15.0
2008-09-17	ABFS-DELISTED	Stock	37.08	37.31	35.48	36.47	1328850.0
2008-09-17	ABG	Stock	12.85	12.85	11.82	12.01	391600.0
2008-09-17	ABII-DELISTED	Stock	70.65	73.34	69.39	72.0	22485.0
2008-09-17	ABK-DELISTED	Stock	5.91	6.85	5.52	5.7	28373421.0
2008-09-17	ABM	Stock	21.05	21.09	20.25	20.57	560900.0
2008-09-17	ABMD-DELISTED	Stock	17.62	17.95	17.08	17.34	512253.0
2008-09-17	ABR	Stock	8.0	8.2	7.5	7.64	434800.0
2008-09-17	ABT	Stock	28.4138	28.5817	27.1087	27.4686	22637349.0
2008-09-17	ABTL-DELISTED	Stock	4.85	5.2	4.725	5.0	8164.0
2008-09-17	ABV-DELISTED	Stock	53.33	53.33	50.16	50.24	1159408.0
2008-09-17	ABVA-DELISTED	Stock	3.12	3.12	2.93	2.93	2076.0
2008-09-17	ABX-DELISTED	Stock	28.68	33.55	28.28	32.53	39187173.0
2008-09-17	ACAD	Stock	2.86	2.86	2.53	2.55	218900.0
2008-09-17	ACAP-DELISTED	Stock	43.03	43.98	42.11	42.11	77715.0
2008-09-17	ACAS-DELISTED	Stock	19.94	19.94	18.5	18.6	4517071.0
2008-09-17	ACAT-DELISTED	Stock	9.0	9.48	8.65	9.43	127389.0

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

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