PREVIEW / stock_1hour / 2009-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-15.parquet
  size:    926 KB
  rows:    44,432
  symbols: 3,432

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-12-15 04:00:00	AAPL	Stock	6.9989	6.9989	6.9989	6.9989	2800.0
2009-12-15 07:00:00	AAPL	Stock	7.0018	7.0018	6.9989	7.0004	18200.0
2009-12-15 08:00:00	AAPL	Stock	7.0179	7.0179	6.9821	7.0064	1761844.0
2009-12-15 09:00:00	AAPL	Stock	7.0064	7.0075	6.9507	6.9689	55506668.0
2009-12-15 10:00:00	AAPL	Stock	6.9682	7.0539	6.9614	7.0343	82393612.0
2009-12-15 11:00:00	AAPL	Stock	7.035	7.0386	6.9914	7.0032	51327528.0
2009-12-15 12:00:00	AAPL	Stock	7.0027	7.0139	6.9907	7.0	21644476.0
2009-12-15 13:00:00	AAPL	Stock	6.9993	7.0046	6.9725	6.9761	35685804.0
2009-12-15 14:00:00	AAPL	Stock	6.9761	6.9893	6.9557	6.9582	37507512.0
2009-12-15 15:00:00	AAPL	Stock	6.9589	6.9696	6.9025	6.9346	88521076.0
2009-12-15 16:00:00	AAPL	Stock	6.935	6.9819	6.9278	6.9375	6306832.0
2009-12-15 17:00:00	AAPL	Stock	6.9393	7.035	6.9343	6.9432	614180.0
2009-12-15 18:00:00	AAPL	Stock	6.9396	6.9496	6.9346	6.9421	577976.0
2009-12-15 19:00:00	AAPL	Stock	6.9429	6.9446	6.9339	6.9393	99680.0
2009-12-15 07:00:00	MSFT	Stock	29.95	29.95	29.95	29.95	1500.0
2009-12-15 08:00:00	MSFT	Stock	30.11	30.11	29.92	29.93	19461.0
2009-12-15 09:00:00	MSFT	Stock	29.93	30.01	29.88	30.0	3654477.0
2009-12-15 10:00:00	MSFT	Stock	30.01	30.2	30.0	30.183	7615787.0
2009-12-15 11:00:00	MSFT	Stock	30.19	30.21	30.17	30.2	3744698.0
2009-12-15 12:00:00	MSFT	Stock	30.195	30.2	30.07	30.09	5118451.0
2009-12-15 13:00:00	MSFT	Stock	30.09	30.18	30.07	30.082	3373145.0
2009-12-15 14:00:00	MSFT	Stock	30.08	30.15	30.062	30.15	4529521.0
2009-12-15 15:00:00	MSFT	Stock	30.14	30.16	29.98	30.01	13885144.0
2009-12-15 16:00:00	MSFT	Stock	30.01	30.159	29.889	30.01	1542492.0
2009-12-15 17:00:00	MSFT	Stock	30.02	30.11	30.01	30.07	532700.0
2009-12-15 18:00:00	MSFT	Stock	30.07	30.07	30.01	30.01	4404.0
2009-12-15 20:00:00	MSFT	Stock	30.21	30.21	30.08	30.08	26249.0
2009-12-15 08:00:00	NVDA	Stock	0.3925	0.3925	0.3713	0.3875	69000.0
2009-12-15 09:00:00	NVDA	Stock	0.3878	0.396	0.3878	0.394	52799000.0
2009-12-15 10:00:00	NVDA	Stock	0.394	0.3955	0.3905	0.3955	72339880.0
2009-12-15 11:00:00	NVDA	Stock	0.3955	0.397	0.3942	0.3965	63135120.0
2009-12-15 12:00:00	NVDA	Stock	0.3965	0.3973	0.3959	0.397	44774520.0
2009-12-15 13:00:00	NVDA	Stock	0.397	0.3978	0.3945	0.3948	38970720.0
2009-12-15 14:00:00	NVDA	Stock	0.3949	0.396	0.394	0.395	46616440.0
2009-12-15 15:00:00	NVDA	Stock	0.395	0.3953	0.3902	0.3913	106689640.0
2009-12-15 16:00:00	NVDA	Stock	0.3913	0.3942	0.3912	0.3913	16414440.0
2009-12-15 17:00:00	NVDA	Stock	0.3918	0.3922	0.3913	0.3922	446040.0
2009-12-15 07:00:00	AMZN	Stock	6.58	6.58	6.55	6.575	45000.0
2009-12-15 08:00:00	AMZN	Stock	6.5545	6.555	6.5325	6.5375	395580.0
2009-12-15 09:00:00	AMZN	Stock	6.5375	6.6085	6.4796	6.5015	29277200.0
2009-12-15 10:00:00	AMZN	Stock	6.501	6.623	6.4875	6.6225	35170080.0
2009-12-15 11:00:00	AMZN	Stock	6.622	6.623	6.5515	6.5805	18512820.0
2009-12-15 12:00:00	AMZN	Stock	6.581	6.5985	6.575	6.589	7382140.0
2009-12-15 13:00:00	AMZN	Stock	6.5875	6.5958	6.5555	6.5625	7602860.0
2009-12-15 14:00:00	AMZN	Stock	6.5625	6.5645	6.5305	6.551	13575120.0
2009-12-15 15:00:00	AMZN	Stock	6.551	6.559	6.488	6.5095	24485280.0
2009-12-15 16:00:00	AMZN	Stock	6.5065	6.6156	6.5	6.505	770660.0
2009-12-15 17:00:00	AMZN	Stock	6.569	6.569	6.5095	6.514	216080.0
2009-12-15 18:00:00	AMZN	Stock	6.5035	6.5145	6.5035	6.5145	46500.0
2009-12-15 19:00:00	AMZN	Stock	6.51	6.52	6.51	6.5165	60600.0

> showing 50 of 44,432 rows — these rows as CSV

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