PREVIEW / stock_daily / 2008-04-18

all stock daily files

  file:    by_date/stock_daily/2008/2008-04-18.parquet
  size:    183 KB
  rows:    5,694
  symbols: 3,445

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-04-18	AAPL	Stock	5.6829	5.795	5.6564	5.7514	1026765600.0
2008-04-18	MSFT	Stock	30.01	30.1	29.61	30.0	73658900.0
2008-04-18	NVDA	Stock	0.4788	0.483	0.469	0.4755	573540000.0
2008-04-18	AMZN	Stock	3.824	4.1	3.816	4.005	335826000.0
2008-04-18	TLT	Stock	92.0	92.88	91.82	92.55	2199677.0
2008-04-18	CL	Stock	39.42	39.42	38.6	38.705	6704600.0
2008-04-18	A	Stock	21.9099	22.3891	21.8455	22.1531	3037574.0
2008-04-18	AABA-DELISTED	Stock	28.45	28.67	28.17	28.43	23784344.0
2008-04-18	AACC-DELISTED	Stock	11.5	11.86	11.5	11.71	153371.0
2008-04-18	AACG	Stock	10.79	11.0	10.44	10.6	4900.0
2008-04-18	AAI-DELISTED	Stock	4.85	4.97	4.83	4.85	1685399.0
2008-04-18	AAIC-DELISTED	Stock	33.4	34.8	31.8	33.8	2507610.0
2008-04-18	AAME	Stock	1.72	2.07	1.71	2.07	20400.0
2008-04-18	AAON	Stock	3.7906	3.8321	3.7689	3.8202	283500.0
2008-04-18	AAP	Stock	34.83	35.5	34.83	34.98	585600.0
2008-04-18	AATI-DELISTED	Stock	6.51	6.59	6.33	6.44	402519.0
2008-04-18	AAU-DELISTED	Stock	2.2	2.25	2.16	2.23	71217.0
2008-04-18	AAUAF-DELISTED	Stock	2.2	2.25	2.16	2.23	74567.0
2008-04-18	AAV-DELISTED	Stock	12.32	12.39	12.23	12.36	549011.0
2008-04-18	AAWW-DELISTED	Stock	59.66	60.2	58.93	59.26	156913.0
2008-04-18	AAXN-DELISTED	Stock	9.64	9.73	9.45	9.5719	1011465.0
2008-04-18	AB	Stock	60.2	61.41	60.17	60.8	447200.0
2008-04-18	ABAX-DELISTED	Stock	24.56	25.14	24.55	25.06	248734.0
2008-04-18	ABB-DELISTED	Stock	27.7	28.05	27.63	28.01	2516492.0
2008-04-18	ABBC-DELISTED	Stock	10.39	10.4	10.34	10.34	119716.0
2008-04-18	ABBNY-DELISTED	Stock	27.7	28.049	27.63	27.97	2523301.0
2008-04-18	ABC-DELISTED	Stock	20.18	20.44	20.07	20.4	3497222.0
2008-04-18	ABCB	Stock	14.2978	14.648	14.0644	14.3951	66417.0
2008-04-18	ABCO-DELISTED	Stock	24.29	24.49	23.78	24.14	320033.0
2008-04-18	ABCW-DELISTED	Stock	17.31	17.35	16.83	17.19	110350.0
2008-04-18	ABD-DELISTED	Stock	13.67	14.12	13.67	13.8	229770.0
2008-04-18	ABE-DELISTED	Stock	23.85	23.85	23.42	23.42	8038.0
2008-04-18	ABEO	Stock	2375.0	2812.5	2375.0	2812.5	6.0
2008-04-18	ABFS-DELISTED	Stock	31.98	32.585	31.67	32.3	566706.0
2008-04-18	ABG	Stock	14.2	14.38	14.03	14.17	317500.0
2008-04-18	ABII-DELISTED	Stock	60.15	60.84	59.99	60.06	5843.0
2008-04-18	ABK-DELISTED	Stock	6.23	6.29	5.87	5.98	5942161.0
2008-04-18	ABM	Stock	20.73	21.3	20.68	21.13	257000.0
2008-04-18	ABMD-DELISTED	Stock	14.49	15.0	14.3	14.88	225821.0
2008-04-18	ABP-DELISTED	Stock	3.91	4.18	3.9	4.15	446941.0
2008-04-18	ABR	Stock	17.4	17.49	17.15	17.25	78700.0
2008-04-18	ABT	Stock	24.6089	24.7193	24.2251	24.3355	28168404.0
2008-04-18	ABTL-DELISTED	Stock	8.548	8.647	8.351	8.4	3643.0
2008-04-18	ABV-DELISTED	Stock	77.57	77.65	76.47	76.84	890546.0
2008-04-18	ABVA-DELISTED	Stock	5.74	5.83	5.07	5.5	50925.0
2008-04-18	ABX-DELISTED	Stock	44.31	44.32	42.8	43.72	8962998.0
2008-04-18	ACAD	Stock	8.19	8.54	7.98	8.22	225300.0
2008-04-18	ACAP-DELISTED	Stock	47.7	47.7	46.91	47.12	52252.0
2008-04-18	ACAS-DELISTED	Stock	33.22	33.3	32.22	32.33	2329059.0
2008-04-18	ACAT-DELISTED	Stock	7.17	7.19	6.58	6.67	103723.0

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

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