PREVIEW / stock_daily / 2007-01-04

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-04.parquet
  size:    161 KB
  rows:    4,810
  symbols: 3,014

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-01-04	AAPL	Stock	3.0018	3.0696	2.9936	3.0593	847260400.0
2007-01-04	MSFT	Stock	29.7	29.97	29.44	29.81	45774500.0
2007-01-04	NVDA	Stock	0.5992	0.6013	0.5838	0.5985	797298000.0
2007-01-04	AMZN	Stock	1.9295	1.957	1.913	1.945	126368000.0
2007-01-04	TLT	Stock	89.22	89.65	89.22	89.6	1696900.0
2007-01-04	CL	Stock	32.725	32.98	32.505	32.88	3025200.0
2007-01-04	A	Stock	24.5351	24.7496	23.9342	24.6137	2899033.0
2007-01-04	AABA-DELISTED	Stock	25.6399993896484	26.9200000762939	25.5200004577637	26.8500003814697	32512200.0
2007-01-04	AACC-DELISTED	Stock	16.46	16.9	16.23	16.82	62513.0
2007-01-04	AACQ-DELISTED	Stock	5.45	5.45	5.45	5.45	2000.0
2007-01-04	AACQU-DELISTED	Stock	6.52	6.52	6.5	6.5	1500.0
2007-01-04	AACQW-DELISTED	Stock	0.54	0.56	0.54	0.56	80700.0
2007-01-04	AAI-DELISTED	Stock	11.46	12.06	11.3	11.88	2935800.0
2007-01-04	AAIC-DELISTED	Stock	162.4	163.0	159.2	163.0	1549300.0
2007-01-04	AAME	Stock	3.12	3.2	3.1	3.11	20000.0
2007-01-04	AAON	Stock	3.4937	3.5819	3.4239	3.5503	149597.0
2007-01-04	AAP	Stock	35.63	35.88	35.31	35.81	800900.0
2007-01-04	AATI-DELISTED	Stock	5.4	5.5	5.4	5.45	108875.0
2007-01-04	AAU-DELISTED	Stock	2.29	2.35	2.27	2.32	106600.0
2007-01-04	AAUAF-DELISTED	Stock	2.29	2.35	2.27	2.32	106600.0
2007-01-04	AAV-DELISTED	Stock	10.21	10.24	9.95	10.02	1040800.0
2007-01-04	AAWW-DELISTED	Stock	43.97	45.25	43.75	45.24	134638.0
2007-01-04	AAXN-DELISTED	Stock	7.94999980926514	8.09000015258789	7.90999984741211	7.98999977111816	1143100.0
2007-01-04	AB	Stock	81.01	81.41	80.01	81.25	183900.0
2007-01-04	ABAX-DELISTED	Stock	19.52	19.9	19.21	19.62	150481.0
2007-01-04	ABB-DELISTED	Stock	17.35	17.4	17.08	17.26	5682500.0
2007-01-04	ABBC-DELISTED	Stock	19.17	19.35	19.04	19.35	10829.0
2007-01-04	ABC-DELISTED	Stock	23.12	23.15	22.99	23.13	2194600.0
2007-01-04	ABCB	Stock	27.2437	28.1093	27.1172	27.6814	81222.0
2007-01-04	ABCO-DELISTED	Stock	26.95	27.39	26.85	27.25	176214.0
2007-01-04	ABCW-DELISTED	Stock	28.84	29.06	28.54	29.0	23420.0
2007-01-04	ABD-DELISTED	Stock	26.44	26.51	26.18	26.39	248790.0
2007-01-04	ABE-DELISTED	Stock	18.49	18.49	18.3	18.49	33500.0
2007-01-04	ABFS-DELISTED	Stock	38.17	41.06	37.29	41.04	1278916.0
2007-01-04	ABG	Stock	23.71	23.71	23.23	23.26	207200.0
2007-01-04	ABK-DELISTED	Stock	89.81	90.0	89.1	89.4	482700.0
2007-01-04	ABM	Stock	23.1	23.77	22.9	23.7	442200.0
2007-01-04	ABMD-DELISTED	Stock	14.01	14.49	13.96	14.41	141408.0
2007-01-04	ABP-DELISTED	Stock	3.15	3.15	3.04	3.05	138400.0
2007-01-04	ABR	Stock	30.0	30.19	29.65	30.19	77400.0
2007-01-04	ABT	Stock	23.539	24.1052	23.4958	23.942	21185494.0
2007-01-04	ABTL-DELISTED	Stock	18.075	18.525	18.075	18.525	30796.0
2007-01-04	ABV-DELISTED	Stock	49.14	49.32	48.63	49.04	599100.0
2007-01-04	ABVA-DELISTED	Stock	15.89	15.99	15.85	15.93	4750.0
2007-01-04	ABX-DELISTED	Stock	30.1	30.1	29.51	29.67	3273065.0
2007-01-04	ACAD	Stock	8.77	8.77	8.53	8.64	126100.0
2007-01-04	ACAP-DELISTED	Stock	40.64	40.67	39.32	39.51	65812.0
2007-01-04	ACAS-DELISTED	Stock	46.0	46.51	45.85	46.41	788851.0
2007-01-04	ACAT-DELISTED	Stock	17.0	17.36	16.93	17.23	88886.0
2007-01-04	ACC-DELISTED	Stock	29.41	29.53	29.0	29.3	196600.0

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

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