PREVIEW / stock_1hour / 2010-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-02.parquet
  size:    915 KB
  rows:    43,416
  symbols: 3,483

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
2010-03-02 04:00:00	AAPL	Stock	7.445	7.445	7.4446	7.4446	7224.0
2010-03-02 06:00:00	AAPL	Stock	7.4643	7.4643	7.4643	7.4643	2800.0
2010-03-02 07:00:00	AAPL	Stock	7.4857	7.5086	7.4679	7.4854	431452.0
2010-03-02 08:00:00	AAPL	Stock	7.4893	7.5221	7.4786	7.5161	3653776.0
2010-03-02 09:00:00	AAPL	Stock	7.5157	7.5296	7.4864	7.5053	95504108.0
2010-03-02 10:00:00	AAPL	Stock	7.5057	7.5107	7.4607	7.4721	98284200.0
2010-03-02 11:00:00	AAPL	Stock	7.4725	7.5157	7.4711	7.5039	54656728.0
2010-03-02 12:00:00	AAPL	Stock	7.5032	7.5064	7.4896	7.4929	28632744.0
2010-03-02 13:00:00	AAPL	Stock	7.4939	7.5036	7.4825	7.5011	26261424.0
2010-03-02 14:00:00	AAPL	Stock	7.5009	7.5068	7.4264	7.4296	70391692.0
2010-03-02 15:00:00	AAPL	Stock	7.4296	7.4582	7.4193	7.4571	98010528.0
2010-03-02 16:00:00	AAPL	Stock	7.4571	7.4941	7.4514	7.4529	11051824.0
2010-03-02 17:00:00	AAPL	Stock	7.4546	7.4586	7.4529	7.4539	254996.0
2010-03-02 18:00:00	AAPL	Stock	7.4539	7.4589	7.4493	7.4507	277340.0
2010-03-02 19:00:00	AAPL	Stock	7.4514	7.4579	7.4464	7.4468	150752.0
2010-03-02 07:00:00	MSFT	Stock	29.01	29.08	29.01	29.08	415.0
2010-03-02 08:00:00	MSFT	Stock	29.1	29.19	29.1	29.15	12087.0
2010-03-02 09:00:00	MSFT	Stock	29.15	29.3	29.02	29.109	6927615.0
2010-03-02 10:00:00	MSFT	Stock	29.105	29.14	28.94	29.05	10747963.0
2010-03-02 11:00:00	MSFT	Stock	29.04	29.06	28.63	28.88	23419771.0
2010-03-02 12:00:00	MSFT	Stock	28.88	28.89	28.54	28.69	8712272.0
2010-03-02 13:00:00	MSFT	Stock	28.691	28.82	28.66	28.808	4353833.0
2010-03-02 14:00:00	MSFT	Stock	28.81	28.84	28.56	28.56	5537606.0
2010-03-02 15:00:00	MSFT	Stock	28.56	28.58	28.24	28.45	26547252.0
2010-03-02 16:00:00	MSFT	Stock	28.45	29.205	28.355	28.49	4754351.0
2010-03-02 17:00:00	MSFT	Stock	28.48	28.48	28.45	28.45	600.0
2010-03-02 18:00:00	MSFT	Stock	28.46	28.48	28.45	28.47	5980.0
2010-03-02 19:00:00	MSFT	Stock	28.47	28.47	28.46	28.46	1220.0
2010-03-02 08:00:00	NVDA	Stock	0.425	0.4295	0.425	0.4295	167200.0
2010-03-02 09:00:00	NVDA	Stock	0.4275	0.4302	0.424	0.4275	61044200.0
2010-03-02 10:00:00	NVDA	Stock	0.4275	0.4285	0.4218	0.4218	83778000.0
2010-03-02 11:00:00	NVDA	Stock	0.4218	0.426	0.4218	0.4253	46406320.0
2010-03-02 12:00:00	NVDA	Stock	0.4254	0.4255	0.4225	0.4253	32908080.0
2010-03-02 13:00:00	NVDA	Stock	0.4253	0.427	0.4242	0.4269	27756200.0
2010-03-02 14:00:00	NVDA	Stock	0.427	0.4274	0.4205	0.421	39830080.0
2010-03-02 15:00:00	NVDA	Stock	0.4208	0.4225	0.418	0.4208	110371760.0
2010-03-02 16:00:00	NVDA	Stock	0.4208	0.424	0.4205	0.421	76994760.0
2010-03-02 17:00:00	NVDA	Stock	0.42	0.4242	0.42	0.4242	600000.0
2010-03-02 18:00:00	NVDA	Stock	0.4175	0.4175	0.4175	0.4175	23480.0
2010-03-02 19:00:00	NVDA	Stock	0.4205	0.4205	0.4205	0.4205	36520.0
2010-03-02 06:00:00	AMZN	Stock	6.25	6.27	6.25	6.27	8000.0
2010-03-02 07:00:00	AMZN	Stock	6.23	6.2685	6.23	6.2685	23300.0
2010-03-02 08:00:00	AMZN	Stock	6.25	6.275	6.25	6.2625	546160.0
2010-03-02 09:00:00	AMZN	Stock	6.26	6.3675	6.24	6.356	61585880.0
2010-03-02 10:00:00	AMZN	Stock	6.356	6.359	6.3185	6.328	46819300.0
2010-03-02 11:00:00	AMZN	Stock	6.329	6.3675	6.3195	6.353	27697440.0
2010-03-02 12:00:00	AMZN	Stock	6.3525	6.359	6.29	6.3015	21555540.0
2010-03-02 13:00:00	AMZN	Stock	6.3015	6.324	6.281	6.3175	18077940.0
2010-03-02 14:00:00	AMZN	Stock	6.316	6.324	6.2685	6.2692	17370420.0
2010-03-02 15:00:00	AMZN	Stock	6.269	6.2925	6.256	6.276	34284440.0

> showing 50 of 43,416 rows — these rows as CSV

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