PREVIEW / stock_1hour / 2007-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-15.parquet
  size:    685 KB
  rows:    32,810
  symbols: 2,538

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-15 07:00:00	AAPL	Stock	3.2314	3.2346	3.2279	3.2321	303100.0
2007-03-15 08:00:00	AAPL	Stock	3.2332	3.2339	3.2114	3.215	4525500.0
2007-03-15 09:00:00	AAPL	Stock	3.2168	3.2268	3.1996	3.2261	82237176.0
2007-03-15 10:00:00	AAPL	Stock	3.2261	3.2271	3.2043	3.2096	94494988.0
2007-03-15 11:00:00	AAPL	Stock	3.2096	3.2268	3.1968	3.1996	97365912.0
2007-03-15 12:00:00	AAPL	Stock	3.2	3.2143	3.1936	3.2043	62568212.0
2007-03-15 13:00:00	AAPL	Stock	3.2039	3.2089	3.1896	3.1975	56515620.0
2007-03-15 14:00:00	AAPL	Stock	3.1975	3.2068	3.195	3.2046	42598192.0
2007-03-15 15:00:00	AAPL	Stock	3.205	3.2121	3.1968	3.1989	78580320.0
2007-03-15 16:00:00	AAPL	Stock	3.1971	3.1993	3.195	3.195	3805368.0
2007-03-15 17:00:00	AAPL	Stock	3.1957	3.1989	3.1957	3.1964	27826904.0
2007-03-15 18:00:00	AAPL	Stock	3.1964	3.1964	3.1954	3.1964	122444.0
2007-03-15 19:00:00	AAPL	Stock	3.1964	3.2011	3.1964	3.1986	370356.0
2007-03-15 07:00:00	MSFT	Stock	27.37	27.46	27.37	27.46	400.0
2007-03-15 08:00:00	MSFT	Stock	27.46	27.46	27.37	27.38	69300.0
2007-03-15 09:00:00	MSFT	Stock	27.37	27.47	27.2	27.39	5616568.0
2007-03-15 10:00:00	MSFT	Stock	27.39	27.47	27.3	27.35	7514135.0
2007-03-15 11:00:00	MSFT	Stock	27.34	27.46	27.21	27.25	8052585.0
2007-03-15 12:00:00	MSFT	Stock	27.25	27.32	27.21	27.28	4820684.0
2007-03-15 13:00:00	MSFT	Stock	27.272	27.36	27.2	27.27	7115114.0
2007-03-15 14:00:00	MSFT	Stock	27.26	27.35	27.23	27.27	5373385.0
2007-03-15 15:00:00	MSFT	Stock	27.26	27.31	27.23	27.28	8778786.0
2007-03-15 16:00:00	MSFT	Stock	27.27	27.3	27.25	27.25	479174.0
2007-03-15 17:00:00	MSFT	Stock	27.28	27.28	27.26	27.26	1858311.0
2007-03-15 18:00:00	MSFT	Stock	27.26	27.26	27.16	27.26	9439.0
2007-03-15 19:00:00	MSFT	Stock	27.19	27.24	27.17	27.24	1210.0
2007-03-15 08:00:00	NVDA	Stock	0.4833	0.4838	0.4833	0.4833	142200.0
2007-03-15 09:00:00	NVDA	Stock	0.4795	0.485	0.4772	0.4832	54949140.0
2007-03-15 10:00:00	NVDA	Stock	0.483	0.4833	0.4785	0.479	78939420.0
2007-03-15 11:00:00	NVDA	Stock	0.479	0.4848	0.472	0.4737	103505400.0
2007-03-15 12:00:00	NVDA	Stock	0.4737	0.4752	0.4715	0.473	77661720.0
2007-03-15 13:00:00	NVDA	Stock	0.4732	0.475	0.4697	0.4722	110870040.0
2007-03-15 14:00:00	NVDA	Stock	0.4722	0.4743	0.4717	0.4733	91212840.0
2007-03-15 15:00:00	NVDA	Stock	0.4733	0.4778	0.4727	0.477	111846900.0
2007-03-15 16:00:00	NVDA	Stock	0.4767	0.4817	0.4767	0.477	8426760.0
2007-03-15 17:00:00	NVDA	Stock	0.477	0.477	0.4767	0.4767	9970800.0
2007-03-15 18:00:00	NVDA	Stock	0.4772	0.4777	0.4772	0.4772	154500.0
2007-03-15 09:00:00	AMZN	Stock	1.9	1.9105	1.8825	1.9	15386220.0
2007-03-15 10:00:00	AMZN	Stock	1.8995	1.9145	1.8955	1.902	23404440.0
2007-03-15 11:00:00	AMZN	Stock	1.902	1.9145	1.8825	1.889	17812720.0
2007-03-15 12:00:00	AMZN	Stock	1.889	1.8945	1.886	1.8885	14142620.0
2007-03-15 13:00:00	AMZN	Stock	1.8885	1.892	1.8794	1.8825	16949080.0
2007-03-15 14:00:00	AMZN	Stock	1.8825	1.889	1.8775	1.8875	21759620.0
2007-03-15 15:00:00	AMZN	Stock	1.887	1.893	1.8795	1.889	29784800.0
2007-03-15 16:00:00	AMZN	Stock	1.889	1.89	1.881	1.8875	420100.0
2007-03-15 17:00:00	AMZN	Stock	1.889	1.889	1.885	1.885	2580720.0
2007-03-15 09:00:00	CL	Stock	32.665	32.81	32.62	32.8	629000.0
2007-03-15 10:00:00	CL	Stock	32.81	32.81	32.665	32.675	874200.0
2007-03-15 11:00:00	CL	Stock	32.675	32.7	32.575	32.615	381000.0
2007-03-15 12:00:00	CL	Stock	32.61	32.695	32.59	32.65	420600.0

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

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