PREVIEW / stock_1hour / 2008-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-10.parquet
  size:    814 KB
  rows:    41,152
  symbols: 3,290

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
2008-03-10 05:00:00	AAPL	Stock	4.3746	4.3746	4.3746	4.3746	14000.0
2008-03-10 06:00:00	AAPL	Stock	4.3921	4.3921	4.3921	4.3921	2800.0
2008-03-10 07:00:00	AAPL	Stock	4.39	4.4118	4.39	4.3964	254072.0
2008-03-10 08:00:00	AAPL	Stock	4.3964	4.4025	4.3396	4.3607	2084936.0
2008-03-10 09:00:00	AAPL	Stock	4.3607	4.4011	4.3261	4.3771	115272052.0
2008-03-10 10:00:00	AAPL	Stock	4.3771	4.4093	4.345	4.3896	181229944.0
2008-03-10 11:00:00	AAPL	Stock	4.3896	4.4021	4.3332	4.3496	141699656.0
2008-03-10 12:00:00	AAPL	Stock	4.3504	4.3568	4.2932	4.3243	139699504.0
2008-03-10 13:00:00	AAPL	Stock	4.3246	4.3321	4.2986	4.3	89637240.0
2008-03-10 14:00:00	AAPL	Stock	4.2996	4.3121	4.2632	4.2921	142088744.0
2008-03-10 15:00:00	AAPL	Stock	4.2921	4.315	4.2721	4.2759	165189276.0
2008-03-10 16:00:00	AAPL	Stock	4.2757	4.3661	4.25	4.2536	21491036.0
2008-03-10 17:00:00	AAPL	Stock	4.2525	4.332	4.2518	4.2704	1118544.0
2008-03-10 18:00:00	AAPL	Stock	4.2682	4.275	4.2625	4.2661	633304.0
2008-03-10 19:00:00	AAPL	Stock	4.2632	4.2654	4.2554	4.2639	281568.0
2008-03-10 07:00:00	MSFT	Stock	28.09	28.1	28.09	28.1	800.0
2008-03-10 08:00:00	MSFT	Stock	28.0	28.0	27.81	27.88	2221.0
2008-03-10 09:00:00	MSFT	Stock	27.83	28.2	27.75	28.16	5789284.0
2008-03-10 10:00:00	MSFT	Stock	28.16	28.26	27.99	28.09	11657890.0
2008-03-10 11:00:00	MSFT	Stock	28.08	28.2	27.95	28.09	9023601.0
2008-03-10 12:00:00	MSFT	Stock	28.082	28.22	27.98	28.182	9134478.0
2008-03-10 13:00:00	MSFT	Stock	28.19	28.19	27.99	28.095	7177766.0
2008-03-10 14:00:00	MSFT	Stock	28.09	28.1	27.87	28.04	8914009.0
2008-03-10 15:00:00	MSFT	Stock	28.04	28.152	27.98	28.06	16633104.0
2008-03-10 16:00:00	MSFT	Stock	28.09	28.09	27.87	28.0	3383731.0
2008-03-10 17:00:00	MSFT	Stock	28.073	28.073	27.99	28.0	495142.0
2008-03-10 18:00:00	MSFT	Stock	28.068	28.068	27.99	27.99	322518.0
2008-03-10 19:00:00	MSFT	Stock	27.99	27.99	27.98	27.98	3726.0
2008-03-10 07:00:00	NVDA	Stock	0.4885	0.4885	0.4885	0.4885	20000.0
2008-03-10 08:00:00	NVDA	Stock	0.4875	0.49	0.4862	0.4862	128000.0
2008-03-10 09:00:00	NVDA	Stock	0.4865	0.4888	0.4775	0.481	50017960.0
2008-03-10 10:00:00	NVDA	Stock	0.4812	0.484	0.4735	0.4778	163584640.0
2008-03-10 11:00:00	NVDA	Stock	0.4775	0.4795	0.4692	0.4736	78816440.0
2008-03-10 12:00:00	NVDA	Stock	0.4738	0.477	0.4702	0.4744	86905080.0
2008-03-10 13:00:00	NVDA	Stock	0.4748	0.4758	0.4675	0.4678	66574120.0
2008-03-10 14:00:00	NVDA	Stock	0.4678	0.4688	0.4605	0.4615	127762640.0
2008-03-10 15:00:00	NVDA	Stock	0.4615	0.4665	0.46	0.4608	185576760.0
2008-03-10 16:00:00	NVDA	Stock	0.4615	0.4888	0.4575	0.4588	6517080.0
2008-03-10 17:00:00	NVDA	Stock	0.4575	0.4608	0.4572	0.4575	320400.0
2008-03-10 18:00:00	NVDA	Stock	0.4572	0.4707	0.4555	0.4555	394400.0
2008-03-10 19:00:00	NVDA	Stock	0.4532	0.4532	0.4532	0.4532	40000.0
2008-03-10 08:00:00	AMZN	Stock	3.195	3.195	3.195	3.195	20000.0
2008-03-10 09:00:00	AMZN	Stock	3.1925	3.2345	3.1455	3.2331	19159960.0
2008-03-10 10:00:00	AMZN	Stock	3.233	3.2575	3.2125	3.218	34160100.0
2008-03-10 11:00:00	AMZN	Stock	3.218	3.2315	3.156	3.187	20791700.0
2008-03-10 12:00:00	AMZN	Stock	3.187	3.212	3.1695	3.209	21301920.0
2008-03-10 13:00:00	AMZN	Stock	3.2095	3.218	3.1685	3.1705	16948580.0
2008-03-10 14:00:00	AMZN	Stock	3.1705	3.177	3.1525	3.1665	18912740.0
2008-03-10 15:00:00	AMZN	Stock	3.166	3.203	3.16	3.1735	39999380.0
2008-03-10 16:00:00	AMZN	Stock	3.178	3.2045	3.172	3.1735	15098000.0

> showing 50 of 41,152 rows — these rows as CSV

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