PREVIEW / stock_1hour / 2009-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-17.parquet
  size:    823 KB
  rows:    40,393
  symbols: 3,330

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
2009-04-17 07:00:00	AAPL	Stock	4.3182	4.3375	4.3182	4.3375	31080.0
2009-04-17 08:00:00	AAPL	Stock	4.3339	4.3511	4.2968	4.3025	916216.0
2009-04-17 09:00:00	AAPL	Stock	4.3025	4.3482	4.2875	4.3476	68436060.0
2009-04-17 10:00:00	AAPL	Stock	4.3479	4.3707	4.3404	4.3539	67903724.0
2009-04-17 11:00:00	AAPL	Stock	4.3546	4.3911	4.3464	4.3775	47133576.0
2009-04-17 12:00:00	AAPL	Stock	4.3779	4.3921	4.3621	4.3896	41325984.0
2009-04-17 13:00:00	AAPL	Stock	4.3893	4.4357	4.3879	4.43	61927096.0
2009-04-17 14:00:00	AAPL	Stock	4.43	4.4343	4.4	4.4061	53011392.0
2009-04-17 15:00:00	AAPL	Stock	4.4068	4.4375	4.4032	4.4071	99590176.0
2009-04-17 16:00:00	AAPL	Stock	4.4064	4.4184	4.3731	4.4146	15775592.0
2009-04-17 17:00:00	AAPL	Stock	4.4161	4.4193	4.4143	4.4193	195272.0
2009-04-17 18:00:00	AAPL	Stock	4.4193	4.4214	4.4179	4.4196	165592.0
2009-04-17 19:00:00	AAPL	Stock	4.4207	4.4211	4.4179	4.4207	156660.0
2009-04-17 07:00:00	MSFT	Stock	19.64	19.64	19.64	19.64	1000.0
2009-04-17 08:00:00	MSFT	Stock	19.66	19.69	19.58	19.58	6286.0
2009-04-17 09:00:00	MSFT	Stock	19.58	19.7	19.0	19.52	5862012.0
2009-04-17 10:00:00	MSFT	Stock	19.52	19.545	19.13	19.15	7554658.0
2009-04-17 11:00:00	MSFT	Stock	19.15	19.28	19.09	19.23	6652902.0
2009-04-17 12:00:00	MSFT	Stock	19.23	19.26	19.1	19.19	3675283.0
2009-04-17 13:00:00	MSFT	Stock	19.188	19.28	19.18	19.26	4012744.0
2009-04-17 14:00:00	MSFT	Stock	19.26	19.4	19.18	19.212	6499252.0
2009-04-17 15:00:00	MSFT	Stock	19.215	19.39	19.15	19.18	13228066.0
2009-04-17 16:00:00	MSFT	Stock	19.2	19.406	19.15	19.27	4159118.0
2009-04-17 17:00:00	MSFT	Stock	19.2	19.26	19.16	19.25	28039.0
2009-04-17 18:00:00	MSFT	Stock	19.25	19.27	19.22	19.22	20386.0
2009-04-17 19:00:00	MSFT	Stock	19.21	19.26	19.17	19.26	17477.0
2009-04-17 08:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	80000.0
2009-04-17 09:00:00	NVDA	Stock	0.2922	0.293	0.285	0.2882	117675120.0
2009-04-17 10:00:00	NVDA	Stock	0.2882	0.2928	0.2875	0.2876	120556360.0
2009-04-17 11:00:00	NVDA	Stock	0.2875	0.2892	0.2862	0.2888	99867640.0
2009-04-17 12:00:00	NVDA	Stock	0.2885	0.2895	0.2865	0.2895	92772520.0
2009-04-17 13:00:00	NVDA	Stock	0.2895	0.2922	0.2884	0.292	52434680.0
2009-04-17 14:00:00	NVDA	Stock	0.2922	0.2935	0.2909	0.2915	47658680.0
2009-04-17 15:00:00	NVDA	Stock	0.2918	0.2968	0.2915	0.2935	146276800.0
2009-04-17 16:00:00	NVDA	Stock	0.2935	0.2945	0.2904	0.2945	13845080.0
2009-04-17 18:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	4000.0
2009-04-17 19:00:00	NVDA	Stock	0.2912	0.2912	0.2912	0.2912	20000.0
2009-04-17 07:00:00	AMZN	Stock	3.8565	3.8565	3.8565	3.8565	2000.0
2009-04-17 08:00:00	AMZN	Stock	3.8505	3.8505	3.83	3.8355	174640.0
2009-04-17 09:00:00	AMZN	Stock	3.82	3.8855	3.794	3.8682	28505920.0
2009-04-17 10:00:00	AMZN	Stock	3.8675	3.8695	3.8015	3.824	21963940.0
2009-04-17 11:00:00	AMZN	Stock	3.8245	3.852	3.815	3.8515	12937060.0
2009-04-17 12:00:00	AMZN	Stock	3.852	3.8925	3.85	3.8925	14575280.0
2009-04-17 13:00:00	AMZN	Stock	3.8925	3.9115	3.8826	3.9095	13778560.0
2009-04-17 14:00:00	AMZN	Stock	3.9095	3.936	3.8945	3.902	16056000.0
2009-04-17 15:00:00	AMZN	Stock	3.9015	3.93	3.8925	3.9	32860660.0
2009-04-17 16:00:00	AMZN	Stock	3.9	3.9087	3.8712	3.9	7169940.0
2009-04-17 17:00:00	AMZN	Stock	3.9025	3.912	3.9025	3.9105	89280.0
2009-04-17 18:00:00	AMZN	Stock	3.92	3.9225	3.92	3.92	8000.0
2009-04-17 19:00:00	AMZN	Stock	3.92	3.92	3.9005	3.9135	47000.0

> showing 50 of 40,393 rows — these rows as CSV

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