PREVIEW / stock_daily / 2007-10-10

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-10.parquet
  size:    179 KB
  rows:    5,527
  symbols: 3,345

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-10	AAPL	Stock	5.9839	5.9957	5.9143	5.9568	667590000.0
2007-10-10	MSFT	Stock	30.04	30.37	30.03	30.23	32251500.0
2007-10-10	NVDA	Stock	0.928	0.928	0.9005	0.9228	389136000.0
2007-10-10	AMZN	Stock	4.775	4.7875	4.7185	4.733	111356000.0
2007-10-10	TLT	Stock	87.98	88.4325	87.79	88.18	855500.0
2007-10-10	CL	Stock	36.43	36.55	36.0	36.385	7857600.0
2007-10-10	A	Stock	27.2318	27.3176	26.9599	27.0887	1658587.0
2007-10-10	AABA-DELISTED	Stock	28.43	28.7	27.9	28.36	14847071.0
2007-10-10	AACC-DELISTED	Stock	11.49	11.89	11.47	11.56	553749.0
2007-10-10	AAI-DELISTED	Stock	10.45	10.45	10.22	10.3	1530300.0
2007-10-10	AAIC-DELISTED	Stock	95.8	97.8	94.6	96.0	1102800.0
2007-10-10	AAME	Stock	2.69	2.69	2.69	2.69	300.0
2007-10-10	AAON	Stock	4.1007	4.1007	4.0217	4.0593	211612.0
2007-10-10	AAP	Stock	34.79	35.19	34.3	35.13	693500.0
2007-10-10	AATI-DELISTED	Stock	12.06	12.66	12.01	12.61	1403474.0
2007-10-10	AAU-DELISTED	Stock	2.7	2.79	2.68	2.77	228900.0
2007-10-10	AAUAF-DELISTED	Stock	2.7	2.79	2.68	2.77	228900.0
2007-10-10	AAV-DELISTED	Stock	12.2	12.34	12.2	12.23	433000.0
2007-10-10	AAWW-DELISTED	Stock	53.96	54.84	53.71	54.54	73935.0
2007-10-10	AAXN-DELISTED	Stock	18.61	18.7	17.95	18.0	3025802.0
2007-10-10	AB	Stock	90.92	91.65	90.0	91.47	216000.0
2007-10-10	ABAX-DELISTED	Stock	25.57	25.71	25.18	25.37	168936.0
2007-10-10	ABB-DELISTED	Stock	27.31	27.58	27.24	27.46	2072700.0
2007-10-10	ABBC-DELISTED	Stock	9.79	9.81	9.6	9.67	99297.0
2007-10-10	ABBNY-DELISTED	Stock	27.31	27.58	27.24	27.43	2072700.0
2007-10-10	ABC-DELISTED	Stock	22.49	23.11	22.49	23.01	3174739.0
2007-10-10	ABCB	Stock	18.2565	18.2565	18.0036	18.1397	21693.0
2007-10-10	ABCO-DELISTED	Stock	31.32	31.32	30.61	30.83	154922.0
2007-10-10	ABCW-DELISTED	Stock	27.78	27.78	27.4	27.58	67500.0
2007-10-10	ABD-DELISTED	Stock	25.07	25.11	24.67	24.8	362280.0
2007-10-10	ABE-DELISTED	Stock	25.88	27.17	25.21	26.3	87600.0
2007-10-10	ABEO	Stock	5000.0	5000.0	5000.0	5000.0	2.0
2007-10-10	ABFS-DELISTED	Stock	34.23	34.23	33.6	33.63	326899.0
2007-10-10	ABG	Stock	20.76	20.8	20.35	20.53	397500.0
2007-10-10	ABK-DELISTED	Stock	68.49	69.06	67.17	67.85	1348100.0
2007-10-10	ABM	Stock	23.17	23.47	23.09	23.32	413100.0
2007-10-10	ABMD-DELISTED	Stock	13.34	13.42	13.14	13.27	165006.0
2007-10-10	ABP-DELISTED	Stock	4.04	4.14	4.03	4.13	131400.0
2007-10-10	ABR	Stock	19.9	20.43	19.9	20.07	156000.0
2007-10-10	ABT	Stock	26.461	26.5905	25.866	26.0244	14849312.0
2007-10-10	ABTL-DELISTED	Stock	16.037	16.037	15.263	15.613	6087.0
2007-10-10	ABV-DELISTED	Stock	80.39	80.78	77.87	79.02	603273.0
2007-10-10	ABVA-DELISTED	Stock	9.95	10.04	9.95	10.04	1500.0
2007-10-10	ABVT-DELISTED	Stock	80.0	80.5	77.0	80.5	132981.0
2007-10-10	ABX-DELISTED	Stock	42.37	42.77	41.83	42.06	9106500.0
2007-10-10	ACAD	Stock	15.98	16.14	15.53	15.74	237600.0
2007-10-10	ACAP-DELISTED	Stock	41.72	41.9	40.92	41.57	24393.0
2007-10-10	ACAS-DELISTED	Stock	45.43	45.53	45.0	45.36	1612817.0
2007-10-10	ACAT-DELISTED	Stock	17.79	17.8	17.26	17.52	77359.0
2007-10-10	ACC-DELISTED	Stock	29.91	30.52	29.49	30.12	487100.0

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

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