PREVIEW / stock_1hour / 2007-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-09.parquet
  size:    648 KB
  rows:    30,702
  symbols: 2,504

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-02-09 06:00:00	AAPL	Stock	3.0646	3.0786	3.0625	3.075	44800.0
2007-02-09 07:00:00	AAPL	Stock	3.0754	3.0754	3.0607	3.0607	222600.0
2007-02-09 08:00:00	AAPL	Stock	3.0693	3.0707	3.0536	3.0607	3961496.0
2007-02-09 09:00:00	AAPL	Stock	3.0621	3.0786	3.0475	3.05	92174376.0
2007-02-09 10:00:00	AAPL	Stock	3.0493	3.0554	3.0111	3.0154	189289940.0
2007-02-09 11:00:00	AAPL	Stock	3.0154	3.035	3.015	3.0271	96513116.0
2007-02-09 12:00:00	AAPL	Stock	3.0271	3.0289	3.0011	3.0029	86748172.0
2007-02-09 13:00:00	AAPL	Stock	3.0025	3.0118	2.9761	2.9882	130333616.0
2007-02-09 14:00:00	AAPL	Stock	2.9882	2.9914	2.9718	2.9811	100096696.0
2007-02-09 15:00:00	AAPL	Stock	2.9807	2.9893	2.9736	2.9736	136112396.0
2007-02-09 16:00:00	AAPL	Stock	2.9739	2.9804	2.9382	2.9714	16332400.0
2007-02-09 17:00:00	AAPL	Stock	2.9718	2.975	2.9714	2.975	305732.0
2007-02-09 18:00:00	AAPL	Stock	2.975	2.9779	2.9732	2.9768	322840.0
2007-02-09 19:00:00	AAPL	Stock	2.9768	2.9779	2.9761	2.9775	304640.0
2007-02-09 07:00:00	MSFT	Stock	29.31	29.31	29.31	29.31	7774.0
2007-02-09 08:00:00	MSFT	Stock	29.31	29.45	29.31	29.35	38892.0
2007-02-09 09:00:00	MSFT	Stock	29.34	29.4	29.25	29.29	8417617.0
2007-02-09 10:00:00	MSFT	Stock	29.28	29.32	29.23	29.25	9373028.0
2007-02-09 11:00:00	MSFT	Stock	29.25	29.31	29.25	29.28	4050723.0
2007-02-09 12:00:00	MSFT	Stock	29.28	29.32	29.22	29.23	10778611.0
2007-02-09 13:00:00	MSFT	Stock	29.23	29.26	29.05	29.092	15014502.0
2007-02-09 14:00:00	MSFT	Stock	29.09	29.35	28.94	29.06	9249593.0
2007-02-09 15:00:00	MSFT	Stock	29.06	29.09	28.93	28.94	10422241.0
2007-02-09 16:00:00	MSFT	Stock	28.93	29.0	28.93	28.95	328779.0
2007-02-09 17:00:00	MSFT	Stock	28.94	29.257	28.94	28.94	17821.0
2007-02-09 18:00:00	MSFT	Stock	28.95	28.95	28.94	28.94	1309.0
2007-02-09 19:00:00	MSFT	Stock	28.94	28.95	28.93	28.93	3303.0
2007-02-09 08:00:00	NVDA	Stock	0.5817	0.5817	0.576	0.576	72000.0
2007-02-09 09:00:00	NVDA	Stock	0.5773	0.5807	0.5743	0.5768	75496200.0
2007-02-09 10:00:00	NVDA	Stock	0.5768	0.58	0.5665	0.5687	126196680.0
2007-02-09 11:00:00	NVDA	Stock	0.5688	0.569	0.5648	0.5667	131223060.0
2007-02-09 12:00:00	NVDA	Stock	0.5666	0.5712	0.555	0.5552	94192980.0
2007-02-09 13:00:00	NVDA	Stock	0.555	0.5573	0.552	0.5533	104920440.0
2007-02-09 14:00:00	NVDA	Stock	0.5533	0.5537	0.5438	0.5447	160264380.0
2007-02-09 15:00:00	NVDA	Stock	0.5447	0.5665	0.542	0.5437	228661320.0
2007-02-09 16:00:00	NVDA	Stock	0.5428	0.5442	0.5425	0.5437	912720.0
2007-02-09 17:00:00	NVDA	Stock	0.5437	0.5445	0.5437	0.5445	55320.0
2007-02-09 18:00:00	NVDA	Stock	0.5445	0.5445	0.5433	0.5433	100920.0
2007-02-09 19:00:00	NVDA	Stock	0.5443	0.5445	0.544	0.5443	107460.0
2007-02-09 08:00:00	AMZN	Stock	1.921	1.9615	1.921	1.9615	18000.0
2007-02-09 09:00:00	AMZN	Stock	1.95	1.9655	1.9485	1.9505	8535760.0
2007-02-09 10:00:00	AMZN	Stock	1.95	1.955	1.9435	1.9496	15012280.0
2007-02-09 11:00:00	AMZN	Stock	1.9495	1.9575	1.941	1.954	21944520.0
2007-02-09 12:00:00	AMZN	Stock	1.954	1.9605	1.944	1.9445	13035080.0
2007-02-09 13:00:00	AMZN	Stock	1.9445	1.9475	1.9385	1.947	15678740.0
2007-02-09 14:00:00	AMZN	Stock	1.9475	1.951	1.933	1.937	18390800.0
2007-02-09 15:00:00	AMZN	Stock	1.937	1.9455	1.934	1.9345	18708560.0
2007-02-09 16:00:00	AMZN	Stock	1.937	1.9375	1.9325	1.935	2712920.0
2007-02-09 17:00:00	AMZN	Stock	1.9355	1.936	1.9355	1.936	2517740.0
2007-02-09 19:00:00	AMZN	Stock	1.932	1.932	1.932	1.932	2000.0

> showing 50 of 30,702 rows — these rows as CSV

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