PREVIEW / stock_1hour / 2007-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-13.parquet
  size:    694 KB
  rows:    32,425
  symbols: 2,552

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-13 07:00:00	AAPL	Stock	3.2046	3.2125	3.2	3.2018	75600.0
2007-03-13 08:00:00	AAPL	Stock	3.1982	3.2068	3.1939	3.1964	1575700.0
2007-03-13 09:00:00	AAPL	Stock	3.1964	3.2086	3.1893	3.2057	92507632.0
2007-03-13 10:00:00	AAPL	Stock	3.2057	3.2357	3.2014	3.2239	180722164.0
2007-03-13 11:00:00	AAPL	Stock	3.2239	3.2282	3.2029	3.2071	91489888.0
2007-03-13 12:00:00	AAPL	Stock	3.2071	3.2139	3.1807	3.1875	139897940.0
2007-03-13 13:00:00	AAPL	Stock	3.1875	3.1957	3.1804	3.1868	89773964.0
2007-03-13 14:00:00	AAPL	Stock	3.1868	3.1893	3.1718	3.1761	104845272.0
2007-03-13 15:00:00	AAPL	Stock	3.1761	3.1836	3.1571	3.1571	152146204.0
2007-03-13 16:00:00	AAPL	Stock	3.1571	3.1625	3.1536	3.1571	3395112.0
2007-03-13 17:00:00	AAPL	Stock	3.1571	3.1604	3.1571	3.1604	313712.0
2007-03-13 18:00:00	AAPL	Stock	3.1589	3.1607	3.1571	3.1604	154280.0
2007-03-13 19:00:00	AAPL	Stock	3.1604	3.1604	3.1571	3.1571	163240.0
2007-03-13 08:00:00	MSFT	Stock	27.36	27.36	27.29	27.3	7861.0
2007-03-13 09:00:00	MSFT	Stock	27.29	27.4	27.07	27.3	6074677.0
2007-03-13 10:00:00	MSFT	Stock	27.298	27.31	27.17	27.25	9150464.0
2007-03-13 11:00:00	MSFT	Stock	27.25	27.29	27.12	27.17	7072255.0
2007-03-13 12:00:00	MSFT	Stock	27.18	27.18	26.95	27.058	10629932.0
2007-03-13 13:00:00	MSFT	Stock	27.06	27.13	26.99	27.1	8062941.0
2007-03-13 14:00:00	MSFT	Stock	27.11	27.13	26.93	26.95	9923571.0
2007-03-13 15:00:00	MSFT	Stock	26.95	26.99	26.71	26.71	19903421.0
2007-03-13 16:00:00	MSFT	Stock	26.71	27.13	26.65	26.72	2087353.0
2007-03-13 17:00:00	MSFT	Stock	26.73	26.74	26.71	26.74	16533.0
2007-03-13 18:00:00	MSFT	Stock	26.74	26.78	26.72	26.75	177159.0
2007-03-13 19:00:00	MSFT	Stock	26.76	26.77	26.74	26.76	12000.0
2007-03-13 08:00:00	NVDA	Stock	0.5017	0.5017	0.5017	0.5017	12000.0
2007-03-13 09:00:00	NVDA	Stock	0.5017	0.5032	0.496	0.5017	53109240.0
2007-03-13 10:00:00	NVDA	Stock	0.5017	0.5033	0.4975	0.503	70522620.0
2007-03-13 11:00:00	NVDA	Stock	0.5032	0.5033	0.4963	0.4973	57728100.0
2007-03-13 12:00:00	NVDA	Stock	0.4973	0.4977	0.4893	0.4917	91470900.0
2007-03-13 13:00:00	NVDA	Stock	0.4917	0.4925	0.4887	0.4897	68779860.0
2007-03-13 14:00:00	NVDA	Stock	0.4897	0.49	0.4847	0.487	99993840.0
2007-03-13 15:00:00	NVDA	Stock	0.487	0.4887	0.4838	0.4842	126709200.0
2007-03-13 16:00:00	NVDA	Stock	0.4842	0.4855	0.4842	0.4842	15100500.0
2007-03-13 17:00:00	NVDA	Stock	0.4843	0.4845	0.4842	0.4842	40140.0
2007-03-13 18:00:00	NVDA	Stock	0.4845	0.485	0.4845	0.485	66000.0
2007-03-13 19:00:00	NVDA	Stock	0.4845	0.485	0.484	0.485	219300.0
2007-03-13 08:00:00	AMZN	Stock	1.934	1.934	1.9155	1.9155	69000.0
2007-03-13 09:00:00	AMZN	Stock	1.9155	1.944	1.9105	1.9315	12377660.0
2007-03-13 10:00:00	AMZN	Stock	1.931	1.936	1.9225	1.926	6136420.0
2007-03-13 11:00:00	AMZN	Stock	1.9265	1.93	1.9235	1.9235	6452760.0
2007-03-13 12:00:00	AMZN	Stock	1.9235	1.926	1.889	1.8965	19853080.0
2007-03-13 13:00:00	AMZN	Stock	1.897	1.8995	1.8845	1.896	14511960.0
2007-03-13 14:00:00	AMZN	Stock	1.8965	1.901	1.8865	1.8945	15329760.0
2007-03-13 15:00:00	AMZN	Stock	1.8945	1.906	1.8915	1.892	24976360.0
2007-03-13 16:00:00	AMZN	Stock	1.891	1.8955	1.8905	1.8905	203100.0
2007-03-13 18:00:00	AMZN	Stock	1.8905	1.893	1.8905	1.893	36000.0
2007-03-13 09:00:00	CL	Stock	33.21	33.25	33.125	33.14	240800.0
2007-03-13 10:00:00	CL	Stock	33.155	33.16	33.045	33.11	302200.0
2007-03-13 11:00:00	CL	Stock	33.11	33.15	33.065	33.125	233200.0

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

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