PREVIEW / stock_1hour / 2007-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-14.parquet
  size:    705 KB
  rows:    32,846
  symbols: 2,547

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-14 06:00:00	AAPL	Stock	3.1389	3.1389	3.1389	3.1389	22400.0
2007-03-14 07:00:00	AAPL	Stock	3.1404	3.1746	3.1404	3.1625	1481984.0
2007-03-14 08:00:00	AAPL	Stock	3.1625	3.1679	3.1468	3.1611	2620296.0
2007-03-14 09:00:00	AAPL	Stock	3.1611	3.1761	3.1575	3.1668	93571576.0
2007-03-14 10:00:00	AAPL	Stock	3.1668	3.1932	3.1604	3.1746	139971888.0
2007-03-14 11:00:00	AAPL	Stock	3.1746	3.1779	3.1536	3.16	79067016.0
2007-03-14 12:00:00	AAPL	Stock	3.16	3.1607	3.14	3.1511	110822012.0
2007-03-14 13:00:00	AAPL	Stock	3.1507	3.1889	3.1496	3.1754	119604744.0
2007-03-14 14:00:00	AAPL	Stock	3.1757	3.2011	3.1682	3.1918	103880224.0
2007-03-14 15:00:00	AAPL	Stock	3.1921	3.2143	3.1882	3.2139	119185528.0
2007-03-14 16:00:00	AAPL	Stock	3.2143	3.225	3.2139	3.2214	4031692.0
2007-03-14 17:00:00	AAPL	Stock	3.2218	3.2218	3.2164	3.2207	1356908.0
2007-03-14 18:00:00	AAPL	Stock	3.2211	3.225	3.2182	3.2232	435456.0
2007-03-14 19:00:00	AAPL	Stock	3.2214	3.225	3.22	3.2232	87472.0
2007-03-14 07:00:00	MSFT	Stock	26.63	26.71	26.63	26.65	6300.0
2007-03-14 08:00:00	MSFT	Stock	26.57	26.76	26.57	26.76	33791.0
2007-03-14 09:00:00	MSFT	Stock	26.74	26.96	26.73	26.85	6094048.0
2007-03-14 10:00:00	MSFT	Stock	26.859	27.22	26.75	27.1	13729510.0
2007-03-14 11:00:00	MSFT	Stock	27.1	27.12	26.97	27.0	8357059.0
2007-03-14 12:00:00	MSFT	Stock	27.0	27.06	26.88	26.97	11199865.0
2007-03-14 13:00:00	MSFT	Stock	26.97	27.26	26.96	27.12	9696499.0
2007-03-14 14:00:00	MSFT	Stock	27.12	27.3	27.04	27.207	8380925.0
2007-03-14 15:00:00	MSFT	Stock	27.203	27.4	27.18	27.39	15787432.0
2007-03-14 16:00:00	MSFT	Stock	27.39	27.4	27.088	27.38	775761.0
2007-03-14 17:00:00	MSFT	Stock	27.39	27.4	27.38	27.38	12103.0
2007-03-14 18:00:00	MSFT	Stock	27.4	27.41	27.4	27.41	12784.0
2007-03-14 19:00:00	MSFT	Stock	27.42	27.46	27.42	27.46	2250.0
2007-03-14 08:00:00	NVDA	Stock	0.4835	0.4835	0.4833	0.4835	90000.0
2007-03-14 09:00:00	NVDA	Stock	0.4837	0.4883	0.4792	0.4807	95199240.0
2007-03-14 10:00:00	NVDA	Stock	0.4805	0.4847	0.4767	0.4787	120203100.0
2007-03-14 11:00:00	NVDA	Stock	0.4787	0.4823	0.4768	0.4778	81392760.0
2007-03-14 12:00:00	NVDA	Stock	0.4777	0.478	0.4673	0.4697	159423840.0
2007-03-14 13:00:00	NVDA	Stock	0.4698	0.4788	0.4695	0.4767	168104220.0
2007-03-14 14:00:00	NVDA	Stock	0.4768	0.4842	0.475	0.48	139911000.0
2007-03-14 15:00:00	NVDA	Stock	0.4802	0.4827	0.478	0.4815	164659380.0
2007-03-14 16:00:00	NVDA	Stock	0.482	0.4838	0.4818	0.482	527760.0
2007-03-14 17:00:00	NVDA	Stock	0.4822	0.4825	0.4817	0.4825	126360.0
2007-03-14 18:00:00	NVDA	Stock	0.484	0.484	0.4818	0.4833	106080.0
2007-03-14 19:00:00	NVDA	Stock	0.4828	0.4828	0.4828	0.4828	30000.0
2007-03-14 09:00:00	AMZN	Stock	1.887	1.897	1.8745	1.8815	18272500.0
2007-03-14 10:00:00	AMZN	Stock	1.8815	1.885	1.867	1.8775	28574500.0
2007-03-14 11:00:00	AMZN	Stock	1.878	1.883	1.8715	1.8735	16875760.0
2007-03-14 12:00:00	AMZN	Stock	1.8735	1.877	1.863	1.8759	22247100.0
2007-03-14 13:00:00	AMZN	Stock	1.8755	1.894	1.8735	1.8865	28118820.0
2007-03-14 14:00:00	AMZN	Stock	1.8865	1.905	1.8835	1.8955	16333700.0
2007-03-14 15:00:00	AMZN	Stock	1.8955	1.911	1.8955	1.903	37976480.0
2007-03-14 16:00:00	AMZN	Stock	1.904	1.911	1.904	1.904	177040.0
2007-03-14 17:00:00	AMZN	Stock	1.9085	1.909	1.908	1.909	14000.0
2007-03-14 18:00:00	AMZN	Stock	1.904	1.904	1.904	1.904	5220.0
2007-03-14 09:00:00	CL	Stock	33.0	33.075	32.95	33.009	411000.0

> showing 50 of 32,846 rows — these rows as CSV

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