PREVIEW / stock_daily / 2007-01-03

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-03.parquet
  size:    162 KB
  rows:    4,843
  symbols: 3,052

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-03	AAPL	Stock	3.0818	3.0921	2.925	2.9929	1238319600.0
2007-01-03	MSFT	Stock	29.91	30.25	29.4	29.86	76935100.0
2007-01-03	NVDA	Stock	0.6178	0.6253	0.5798	0.6013	1154820000.0
2007-01-03	AMZN	Stock	1.934	1.953	1.9025	1.935	248102000.0
2007-01-03	TLT	Stock	89.22	89.46	88.66	89.07	1870400.0
2007-01-03	CL	Stock	32.975	33.07	32.71	32.84	3206600.0
2007-01-03	A	Stock	25.0286	25.3791	24.3562	24.5351	3599291.0
2007-01-03	AABA-DELISTED	Stock	25.8500003814697	26.2600002288818	25.2600002288818	25.6100006103516	26352700.0
2007-01-03	AACC-DELISTED	Stock	16.91	17.0347	16.29	16.52	85911.0
2007-01-03	AACQ-DELISTED	Stock	5.5	5.5	5.45	5.45	45900.0
2007-01-03	AACQU-DELISTED	Stock	6.38	6.38	6.38	6.38	1500.0
2007-01-03	AACQW-DELISTED	Stock	0.5	0.53	0.49	0.53	137500.0
2007-01-03	AAI-DELISTED	Stock	11.89	12.31	11.77	12.05	2627700.0
2007-01-03	AAIC-DELISTED	Stock	160.0	163.8	159.2	162.2	1621800.0
2007-01-03	AAME	Stock	3.1	3.18	3.05	3.05	5500.0
2007-01-03	AAON	Stock	3.4923	3.5108	3.437	3.5068	220219.0
2007-01-03	AAP	Stock	35.71	36.2	35.09	35.58	764200.0
2007-01-03	AATI-DELISTED	Stock	5.43	5.55	5.358	5.46	216872.0
2007-01-03	AAU-DELISTED	Stock	2.32	2.32	2.26	2.26	35400.0
2007-01-03	AAUAF-DELISTED	Stock	2.32	2.32	2.26	2.26	35400.0
2007-01-03	AAV-DELISTED	Stock	10.61	10.65	10.22	10.32	974100.0
2007-01-03	AAWW-DELISTED	Stock	44.71	45.24	43.69	43.98	202672.0
2007-01-03	AAXN-DELISTED	Stock	7.94999980926514	8.05000019073486	7.75	7.90000009536743	2169200.0
2007-01-03	AB	Stock	80.15	81.5	79.9	81.25	352900.0
2007-01-03	ABAX-DELISTED	Stock	19.29	19.82	19.25	19.53	154325.0
2007-01-03	ABB-DELISTED	Stock	18.12	18.14	17.7	17.81	2633600.0
2007-01-03	ABBC-DELISTED	Stock	19.25	19.25	18.95	19.2	16210.0
2007-01-03	ABC-DELISTED	Stock	22.58	23.08	22.54	23.01	4752200.0
2007-01-03	ABCB	Stock	27.5453	27.5453	26.9519	27.234	31049.0
2007-01-03	ABCO-DELISTED	Stock	26.93	27.14	26.74	26.99	307547.0
2007-01-03	ABCW-DELISTED	Stock	29.0	29.3	28.59	28.88	49680.0
2007-01-03	ABD-DELISTED	Stock	26.55	26.83	26.07	26.44	289000.0
2007-01-03	ABE-DELISTED	Stock	18.34	18.5	18.31	18.5	72700.0
2007-01-03	ABFS-DELISTED	Stock	36.52	37.65	36.5	37.07	540955.0
2007-01-03	ABG	Stock	23.77	23.85	23.32	23.64	282800.0
2007-01-03	ABK-DELISTED	Stock	89.66	90.49	89.32	89.75	434300.0
2007-01-03	ABM	Stock	22.9	23.26	22.75	23.12	520700.0
2007-01-03	ABMD-DELISTED	Stock	14.22	14.46	13.95	14.05	186614.0
2007-01-03	ABP-DELISTED	Stock	3.09	3.15	3.0	3.15	289100.0
2007-01-03	ABR	Stock	30.3	30.5	29.57	29.89	65600.0
2007-01-03	ABT	Stock	23.4286	23.7453	23.3903	23.4958	11214881.0
2007-01-03	ABTL-DELISTED	Stock	17.475	18.124	17.475	18.025	32145.0
2007-01-03	ABV-DELISTED	Stock	49.05	49.39	48.81	49.1	380100.0
2007-01-03	ABVA-DELISTED	Stock	15.709	16.16	15.7	15.89	172287.0
2007-01-03	ABVT-DELISTED	Stock	60.0	60.0	60.0	60.0	68.0
2007-01-03	ABX-DELISTED	Stock	30.99	31.09	29.72	29.87	4396700.0
2007-01-03	ACAD	Stock	8.89	8.91	8.69	8.77	92500.0
2007-01-03	ACAP-DELISTED	Stock	40.44	40.88	40.44	40.75	101810.0
2007-01-03	ACAS-DELISTED	Stock	46.46	47.0	46.38	46.69	898109.0
2007-01-03	ACAT-DELISTED	Stock	17.64	17.64	16.92	17.04	98595.0

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

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