PREVIEW / stock_1hour / 2007-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-07.parquet
  size:    687 KB
  rows:    32,474
  symbols: 2,532

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2007-03-07 09:00:00	AAPL	Stock	3.1429	3.1775	3.1393	3.1589	108900148.0
2007-03-07 10:00:00	AAPL	Stock	3.1589	3.1768	3.1511	3.1571	104190632.0
2007-03-07 11:00:00	AAPL	Stock	3.1571	3.1586	3.1454	3.1521	88403812.0
2007-03-07 12:00:00	AAPL	Stock	3.1525	3.1668	3.1486	3.1579	73578764.0
2007-03-07 13:00:00	AAPL	Stock	3.1579	3.1671	3.1543	3.1647	49722372.0
2007-03-07 14:00:00	AAPL	Stock	3.165	3.1661	3.1464	3.1496	58369668.0
2007-03-07 15:00:00	AAPL	Stock	3.1493	3.1554	3.1232	3.1332	118806072.0
2007-03-07 16:00:00	AAPL	Stock	3.1325	3.1357	3.1304	3.1343	3020892.0
2007-03-07 17:00:00	AAPL	Stock	3.1343	3.1375	3.1339	3.135	345156.0
2007-03-07 18:00:00	AAPL	Stock	3.135	3.135	3.1329	3.1339	81396.0
2007-03-07 19:00:00	AAPL	Stock	3.1325	3.1382	3.1325	3.1382	63140.0
2007-03-07 09:00:00	MSFT	Stock	27.81	27.9	27.7	27.742	3910627.0
2007-03-07 10:00:00	MSFT	Stock	27.742	27.77	27.65	27.66	7110954.0
2007-03-07 11:00:00	MSFT	Stock	27.66	27.68	27.59	27.62	8083454.0
2007-03-07 12:00:00	MSFT	Stock	27.627	27.75	27.62	27.65	7461773.0
2007-03-07 13:00:00	MSFT	Stock	27.65	27.75	27.63	27.66	5041054.0
2007-03-07 14:00:00	MSFT	Stock	27.66	27.72	27.61	27.69	5243439.0
2007-03-07 15:00:00	MSFT	Stock	27.68	27.69	27.55	27.6	11852152.0
2007-03-07 16:00:00	MSFT	Stock	27.6	27.68	27.58	27.61	1257429.0
2007-03-07 17:00:00	MSFT	Stock	27.61	27.61	27.61	27.61	1198.0
2007-03-07 18:00:00	MSFT	Stock	27.61	27.61	27.61	27.61	1500.0
2007-03-07 19:00:00	MSFT	Stock	27.65	27.65	27.65	27.65	180.0
2007-03-07 09:00:00	NVDA	Stock	0.5067	0.5077	0.5	0.5037	74727180.0
2007-03-07 10:00:00	NVDA	Stock	0.5037	0.5068	0.4992	0.4992	100581720.0
2007-03-07 11:00:00	NVDA	Stock	0.4993	0.5007	0.4963	0.4983	121800540.0
2007-03-07 12:00:00	NVDA	Stock	0.4985	0.5062	0.4952	0.4958	144893580.0
2007-03-07 13:00:00	NVDA	Stock	0.4958	0.4997	0.4952	0.499	88571760.0
2007-03-07 14:00:00	NVDA	Stock	0.499	0.5	0.497	0.4978	67393020.0
2007-03-07 15:00:00	NVDA	Stock	0.4977	0.4987	0.4912	0.4933	149955600.0
2007-03-07 16:00:00	NVDA	Stock	0.4928	0.4947	0.4923	0.4938	1523820.0
2007-03-07 17:00:00	NVDA	Stock	0.4942	0.4942	0.494	0.494	78000.0
2007-03-07 18:00:00	NVDA	Stock	0.4935	0.494	0.4922	0.494	210000.0
2007-03-07 19:00:00	NVDA	Stock	0.4927	0.4927	0.4922	0.4922	72000.0
2007-03-07 09:00:00	AMZN	Stock	1.9345	1.9375	1.92	1.9315	20854840.0
2007-03-07 10:00:00	AMZN	Stock	1.9315	1.9365	1.9275	1.9285	16858860.0
2007-03-07 11:00:00	AMZN	Stock	1.928	1.946	1.9265	1.9435	25700340.0
2007-03-07 12:00:00	AMZN	Stock	1.944	1.9445	1.9355	1.9405	16103880.0
2007-03-07 13:00:00	AMZN	Stock	1.9405	1.966	1.94	1.956	30025960.0
2007-03-07 14:00:00	AMZN	Stock	1.9555	1.961	1.9425	1.9425	20739920.0
2007-03-07 15:00:00	AMZN	Stock	1.943	1.9435	1.914	1.9175	37772040.0
2007-03-07 16:00:00	AMZN	Stock	1.918	1.918	1.915	1.917	332760.0
2007-03-07 17:00:00	AMZN	Stock	1.9175	1.9175	1.9175	1.9175	2000.0
2007-03-07 09:00:00	CL	Stock	33.31	33.31	33.18	33.205	319400.0
2007-03-07 10:00:00	CL	Stock	33.205	33.24	33.125	33.135	389200.0
2007-03-07 11:00:00	CL	Stock	33.13	33.17	33.035	33.065	469600.0
2007-03-07 12:00:00	CL	Stock	33.07	33.115	33.055	33.075	414000.0
2007-03-07 13:00:00	CL	Stock	33.07	33.085	33.03	33.045	549800.0
2007-03-07 14:00:00	CL	Stock	33.04	33.05	32.96	33.015	674200.0
2007-03-07 15:00:00	CL	Stock	33.006	33.27	32.935	32.935	1312200.0

> showing 49 of 32,474 rows — these rows as CSV

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