PREVIEW / stock_daily / 2007-10-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-05.parquet
  size:    178 KB
  rows:    5,517
  symbols: 3,334

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-10-05	AAPL	Stock	5.6561	5.7707	5.6321	5.7661	943471200.0
2007-10-05	MSFT	Stock	29.89	29.99	29.73	29.84	45012300.0
2007-10-05	NVDA	Stock	0.9138	0.9283	0.904	0.9232	344840000.0
2007-10-05	AMZN	Stock	4.6775	4.6855	4.617	4.6715	110470000.0
2007-10-05	TLT	Stock	88.31	88.44	87.71	88.28	2184700.0
2007-10-05	CL	Stock	35.9	36.155	35.72	36.065	4766400.0
2007-10-05	A	Stock	26.7525	27.1316	26.7167	27.0315	2162706.0
2007-10-05	AABA-DELISTED	Stock	27.84	28.16	27.75	27.91	28499452.0
2007-10-05	AACC-DELISTED	Stock	11.97	12.04	11.74	11.992	160545.0
2007-10-05	AAI-DELISTED	Stock	10.23	10.63	10.17	10.37	1638200.0
2007-10-05	AAIC-DELISTED	Stock	96.8	97.4	95.8	96.4	1162600.0
2007-10-05	AAME	Stock	2.96	2.96	2.63	2.63	7700.0
2007-10-05	AAON	Stock	4.0909	4.1481	4.0316	4.0909	384750.0
2007-10-05	AAP	Stock	34.15	35.8	34.15	35.54	1520300.0
2007-10-05	AATI-DELISTED	Stock	11.84	11.89	11.64	11.7691	614580.0
2007-10-05	AAU-DELISTED	Stock	2.6	2.65	2.6	2.61	47000.0
2007-10-05	AAUAF-DELISTED	Stock	2.6	2.65	2.6	2.6101	47000.0
2007-10-05	AAV-DELISTED	Stock	12.19	12.25	12.13	12.16	514300.0
2007-10-05	AAWW-DELISTED	Stock	52.35	54.93	52.15	54.38	58377.0
2007-10-05	AAXN-DELISTED	Stock	18.15	18.42	17.75	17.87	3395783.0
2007-10-05	AB	Stock	91.5	92.87	91.43	92.46	173800.0
2007-10-05	ABAX-DELISTED	Stock	24.57	25.48	24.47	25.25	467134.0
2007-10-05	ABB-DELISTED	Stock	26.81	27.11	26.8	27.0	2095800.0
2007-10-05	ABBC-DELISTED	Stock	9.81	9.84	9.71	9.8	130075.0
2007-10-05	ABBNY-DELISTED	Stock	26.81	27.11	26.8	26.97	2095800.0
2007-10-05	ABC-DELISTED	Stock	22.32	23.02	22.32	22.93	1706400.0
2007-10-05	ABCB	Stock	18.0425	18.0425	17.7215	17.9355	42153.0
2007-10-05	ABCO-DELISTED	Stock	31.07	31.15	30.85	30.86	160308.0
2007-10-05	ABCW-DELISTED	Stock	27.73	28.36	27.29	28.13	83450.0
2007-10-05	ABD-DELISTED	Stock	24.05	25.46	23.92	24.72	527450.0
2007-10-05	ABE-DELISTED	Stock	25.13	25.13	24.5101	24.92	30000.0
2007-10-05	ABEO	Stock	5125.0	5150.0	4812.5	5000.0	26.0
2007-10-05	ABFS-DELISTED	Stock	33.33	35.03	33.2	34.79	348712.0
2007-10-05	ABG	Stock	20.41	21.76	20.29	21.27	657900.0
2007-10-05	ABK-DELISTED	Stock	68.15	71.37	68.07	69.97	3385600.0
2007-10-05	ABM	Stock	20.39	21.01	20.22	20.77	178000.0
2007-10-05	ABMD-DELISTED	Stock	13.27	13.38	13.12	13.29	212947.0
2007-10-05	ABP-DELISTED	Stock	4.1	4.12	4.02	4.1	85400.0
2007-10-05	ABR	Stock	20.98	21.12	19.97	20.29	197900.0
2007-10-05	ABT	Stock	26.8208	26.8592	26.3122	26.389	13983535.0
2007-10-05	ABTL-DELISTED	Stock	16.9	17.0	16.45	17.0	19650.0
2007-10-05	ABV-DELISTED	Stock	79.35	81.05	78.94	80.5	521382.0
2007-10-05	ABVA-DELISTED	Stock	10.24	10.34	10.05	10.07	15518.0
2007-10-05	ABVT-DELISTED	Stock	76.5	78.0	76.5	76.5	11283.0
2007-10-05	ABX-DELISTED	Stock	40.14	41.18	40.02	40.89	9009700.0
2007-10-05	ACAD	Stock	15.08	15.67	15.0	15.29	188600.0
2007-10-05	ACAP-DELISTED	Stock	41.51	41.51	40.07	40.81	51380.0
2007-10-05	ACAS-DELISTED	Stock	44.28	44.98	44.09	44.89	1464602.0
2007-10-05	ACAT-DELISTED	Stock	17.42	17.9	17.38	17.87	101262.0
2007-10-05	ACC-DELISTED	Stock	28.86	29.8	28.67	29.76	462680.0

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

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