PREVIEW / stock_daily / 2007-05-07

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-07.parquet
  size:    169 KB
  rows:    5,097
  symbols: 3,141

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-05-07	AAPL	Stock	3.61	3.7268	3.6075	3.7114	861557200.0
2007-05-07	MSFT	Stock	30.52	30.76	30.48	30.71	59889100.0
2007-05-07	NVDA	Stock	0.57	0.5763	0.55	0.5507	557100000.0
2007-05-07	AMZN	Stock	3.1215	3.1615	3.0355	3.041	296166000.0
2007-05-07	TLT	Stock	88.7	88.85	88.67	88.84	210175.0
2007-05-07	CL	Stock	33.96	34.1	33.68	33.71	6238400.0
2007-05-07	A	Stock	26.4306	26.7239	26.3662	26.6309	3363868.0
2007-05-07	AABA-DELISTED	Stock	30.13	30.51	29.86	30.37	35865441.0
2007-05-07	AACC-DELISTED	Stock	18.71	19.19	18.5	18.69	426038.0
2007-05-07	AAI-DELISTED	Stock	11.76	11.96	11.51	11.55	1059429.0
2007-05-07	AAIC-DELISTED	Stock	110.4	113.8	110.2	111.6	1186415.0
2007-05-07	AAME	Stock	5.21	5.34	4.89	5.14	20000.0
2007-05-07	AAON	Stock	3.3975	3.4081	3.3488	3.3751	147319.0
2007-05-07	AAP	Stock	40.35	40.48	40.07	40.41	717100.0
2007-05-07	AATI-DELISTED	Stock	7.96	8.15	7.93	8.06	357512.0
2007-05-07	AAU-DELISTED	Stock	2.54	2.5424	2.49	2.537	56149.0
2007-05-07	AAUAF-DELISTED	Stock	2.54	2.54	2.49	2.535	56200.0
2007-05-07	AAV-DELISTED	Stock	11.65	11.81	11.63	11.75	621310.0
2007-05-07	AAWW-DELISTED	Stock	60.0	60.94	59.1	59.5	285480.0
2007-05-07	AAXN-DELISTED	Stock	9.97	10.25	9.68	9.93	6664224.0
2007-05-07	AB	Stock	92.32	92.79	91.75	92.42	178000.0
2007-05-07	ABAX-DELISTED	Stock	23.18	23.3	22.88	23.0	223645.0
2007-05-07	ABB-DELISTED	Stock	20.1	20.21	20.04	20.16	1186050.0
2007-05-07	ABBC-DELISTED	Stock	18.66	18.99	18.66	18.81	5657.0
2007-05-07	ABBNY-DELISTED	Stock	20.1	20.2174	20.0399	20.17	1188350.0
2007-05-07	ABC-DELISTED	Stock	25.86	25.94	25.62	25.68	2358888.0
2007-05-07	ABCB	Stock	23.5088	23.7033	22.9057	22.9057	27143.0
2007-05-07	ABCO-DELISTED	Stock	23.75	24.87	23.69	24.78	519418.0
2007-05-07	ABCW-DELISTED	Stock	28.57	28.68	28.13	28.39	57170.0
2007-05-07	ABD-DELISTED	Stock	22.34	22.83	22.34	22.66	502000.0
2007-05-07	ABE-DELISTED	Stock	20.85	20.97	20.5	20.67	24600.0
2007-05-07	ABFS-DELISTED	Stock	39.82	39.85	39.35	39.57	212993.0
2007-05-07	ABG	Stock	28.7	28.7	28.28	28.5	287300.0
2007-05-07	ABK-DELISTED	Stock	94.21	94.99	93.78	94.66	493200.0
2007-05-07	ABM	Stock	28.88	29.0	28.78	28.89	215200.0
2007-05-07	ABMD-DELISTED	Stock	12.94	13.11	12.82	12.97	96618.0
2007-05-07	ABP-DELISTED	Stock	3.69	3.93	3.63	3.81	322800.0
2007-05-07	ABR	Stock	30.85	31.22	30.32	30.48	117900.0
2007-05-07	ABT	Stock	28.217	28.3754	28.0971	28.2842	11937057.0
2007-05-07	ABTL-DELISTED	Stock	18.104	20.021	17.197	17.6	34161.0
2007-05-07	ABV-DELISTED	Stock	61.25	61.7	60.42	60.6	323780.0
2007-05-07	ABVA-DELISTED	Stock	14.2	14.2	13.85	13.9	13608.0
2007-05-07	ABX-DELISTED	Stock	30.97	31.37	30.88	31.04	7389050.0
2007-05-07	ACAD	Stock	13.5	13.5	13.01	13.06	579400.0
2007-05-07	ACAP-DELISTED	Stock	40.35	41.03	40.2	40.7	35322.0
2007-05-07	ACAS-DELISTED	Stock	45.6	46.06	45.59	45.76	1112753.0
2007-05-07	ACAT-DELISTED	Stock	18.34	18.631	18.33	18.51	110215.0
2007-05-07	ACC-DELISTED	Stock	29.5	29.62	29.25	29.3	90000.0
2007-05-07	ACCL-DELISTED	Stock	6.49	6.54	6.41	6.45	127307.0
2007-05-07	ACCO	Stock	22.34	22.83	22.34	22.66	549200.0

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

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