PREVIEW / stock_1hour / 2008-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-09.parquet
  size:    788 KB
  rows:    39,380
  symbols: 3,289

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-04-09 04:00:00	AAPL	Stock	5.4518	5.4518	5.4332	5.4332	6748.0
2008-04-09 06:00:00	AAPL	Stock	5.4536	5.4686	5.4536	5.4686	5600.0
2008-04-09 07:00:00	AAPL	Stock	5.4696	5.4929	5.4664	5.4664	82712.0
2008-04-09 08:00:00	AAPL	Stock	5.4675	5.4893	5.4611	5.4868	2403772.0
2008-04-09 09:00:00	AAPL	Stock	5.4875	5.4961	5.4004	5.4304	139336120.0
2008-04-09 10:00:00	AAPL	Stock	5.4296	5.4821	5.4064	5.4554	160579356.0
2008-04-09 11:00:00	AAPL	Stock	5.4564	5.4564	5.375	5.3836	112411460.0
2008-04-09 12:00:00	AAPL	Stock	5.3839	5.3996	5.3736	5.3875	89619852.0
2008-04-09 13:00:00	AAPL	Stock	5.3868	5.4393	5.3825	5.4271	112220836.0
2008-04-09 14:00:00	AAPL	Stock	5.4282	5.4361	5.3832	5.3875	105160188.0
2008-04-09 15:00:00	AAPL	Stock	5.3879	5.4207	5.3746	5.4086	129443272.0
2008-04-09 16:00:00	AAPL	Stock	5.4089	5.43	5.4057	5.4211	7693112.0
2008-04-09 17:00:00	AAPL	Stock	5.4189	5.4196	5.4136	5.4164	439684.0
2008-04-09 18:00:00	AAPL	Stock	5.4189	5.4229	5.4139	5.4139	152124.0
2008-04-09 19:00:00	AAPL	Stock	5.4146	5.4211	5.4146	5.42	299012.0
2008-04-09 07:00:00	MSFT	Stock	28.9	28.9	28.8	28.8	1100.0
2008-04-09 08:00:00	MSFT	Stock	28.78	28.85	28.78	28.8	13818.0
2008-04-09 09:00:00	MSFT	Stock	28.8	28.87	28.67	28.76	3679720.0
2008-04-09 10:00:00	MSFT	Stock	28.76	28.945	28.69	28.788	6320771.0
2008-04-09 11:00:00	MSFT	Stock	28.79	28.9	28.61	28.632	4842677.0
2008-04-09 12:00:00	MSFT	Stock	28.635	28.8	28.6	28.61	3669126.0
2008-04-09 13:00:00	MSFT	Stock	28.61	28.76	28.6	28.69	2490841.0
2008-04-09 14:00:00	MSFT	Stock	28.68	28.72	28.54	28.563	5247108.0
2008-04-09 15:00:00	MSFT	Stock	28.57	29.04	28.55	28.92	12277808.0
2008-04-09 16:00:00	MSFT	Stock	28.92	28.95	28.706	28.91	6882271.0
2008-04-09 17:00:00	MSFT	Stock	28.93	28.95	28.91	28.92	14115.0
2008-04-09 18:00:00	MSFT	Stock	28.92	28.93	28.91	28.91	6599.0
2008-04-09 19:00:00	MSFT	Stock	28.93	28.93	28.91	28.91	4870.0
2008-04-09 20:00:00	MSFT	Stock	28.71	28.71	28.71	28.71	3000.0
2008-04-09 08:00:00	NVDA	Stock	0.4805	0.4825	0.4805	0.482	159840.0
2008-04-09 09:00:00	NVDA	Stock	0.482	0.4915	0.4798	0.487	102295880.0
2008-04-09 10:00:00	NVDA	Stock	0.4868	0.4925	0.484	0.4852	119937280.0
2008-04-09 11:00:00	NVDA	Stock	0.4855	0.4865	0.479	0.4838	105871600.0
2008-04-09 12:00:00	NVDA	Stock	0.4838	0.4852	0.4812	0.4812	70309640.0
2008-04-09 13:00:00	NVDA	Stock	0.4812	0.4902	0.4808	0.4898	66647040.0
2008-04-09 14:00:00	NVDA	Stock	0.4898	0.4908	0.4828	0.485	70703480.0
2008-04-09 15:00:00	NVDA	Stock	0.485	0.49	0.4838	0.4875	118631080.0
2008-04-09 16:00:00	NVDA	Stock	0.4875	0.4892	0.4855	0.4872	4544480.0
2008-04-09 17:00:00	NVDA	Stock	0.4885	0.4885	0.4875	0.4875	53120.0
2008-04-09 18:00:00	NVDA	Stock	0.4883	0.4883	0.4868	0.4868	148000.0
2008-04-09 19:00:00	NVDA	Stock	0.4868	0.4885	0.4868	0.4885	18000.0
2008-04-09 07:00:00	AMZN	Stock	3.854	3.854	3.8535	3.8535	20000.0
2008-04-09 08:00:00	AMZN	Stock	3.85	3.85	3.8185	3.835	56000.0
2008-04-09 09:00:00	AMZN	Stock	3.835	3.835	3.7655	3.7815	17567500.0
2008-04-09 10:00:00	AMZN	Stock	3.7805	3.782	3.7	3.74	30085680.0
2008-04-09 11:00:00	AMZN	Stock	3.7393	3.7445	3.683	3.6895	18696040.0
2008-04-09 12:00:00	AMZN	Stock	3.6885	3.7115	3.685	3.6925	8870060.0
2008-04-09 13:00:00	AMZN	Stock	3.693	3.7245	3.6885	3.7245	10674560.0
2008-04-09 14:00:00	AMZN	Stock	3.7245	3.729	3.7	3.704	15505080.0
2008-04-09 15:00:00	AMZN	Stock	3.7042	3.74	3.6925	3.7195	27909620.0

> showing 50 of 39,380 rows — these rows as CSV

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