PREVIEW / stock_1hour / 2007-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-12.parquet
  size:    685 KB
  rows:    32,425
  symbols: 2,527

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-12 07:00:00	AAPL	Stock	2.9804	3.0307	2.9804	3.0161	1676360.0
2007-02-12 08:00:00	AAPL	Stock	3.0179	3.025	3.0086	3.0136	6331164.0
2007-02-12 09:00:00	AAPL	Stock	3.0143	3.0189	2.9868	3.013	141255408.0
2007-02-12 10:00:00	AAPL	Stock	3.0135	3.0286	2.9929	3.0136	145459244.0
2007-02-12 11:00:00	AAPL	Stock	3.0136	3.0211	3.0093	3.0118	82046888.0
2007-02-12 12:00:00	AAPL	Stock	3.0118	3.03	3.0114	3.0254	65779616.0
2007-02-12 13:00:00	AAPL	Stock	3.0254	3.035	3.0189	3.0236	90213844.0
2007-02-12 14:00:00	AAPL	Stock	3.0232	3.0336	3.0161	3.0332	64529836.0
2007-02-12 15:00:00	AAPL	Stock	3.0321	3.0421	3.0271	3.0333	118459516.0
2007-02-12 16:00:00	AAPL	Stock	3.0339	3.0411	3.0314	3.0357	1773072.0
2007-02-12 17:00:00	AAPL	Stock	3.0368	3.0368	3.0339	3.0354	179256.0
2007-02-12 18:00:00	AAPL	Stock	3.0354	3.0354	3.0329	3.035	215152.0
2007-02-12 19:00:00	AAPL	Stock	3.0354	3.0354	3.0332	3.0354	163940.0
2007-02-12 07:00:00	MSFT	Stock	28.89	28.94	28.89	28.92	4860.0
2007-02-12 08:00:00	MSFT	Stock	28.9	28.97	28.86	28.9	25773.0
2007-02-12 09:00:00	MSFT	Stock	28.91	28.95	28.83	28.92	7756368.0
2007-02-12 10:00:00	MSFT	Stock	28.92	29.09	28.84	28.96	12616555.0
2007-02-12 11:00:00	MSFT	Stock	28.96	29.0	28.92	28.93	4494988.0
2007-02-12 12:00:00	MSFT	Stock	28.94	29.0	28.92	29.0	3518092.0
2007-02-12 13:00:00	MSFT	Stock	29.0	29.0	28.89	28.9	3912127.0
2007-02-12 14:00:00	MSFT	Stock	28.9	28.95	28.86	28.91	5881851.0
2007-02-12 15:00:00	MSFT	Stock	28.9	28.96	28.88	28.94	7982973.0
2007-02-12 16:00:00	MSFT	Stock	28.95	28.99	28.92	28.96	1972217.0
2007-02-12 17:00:00	MSFT	Stock	28.94	28.95	28.93	28.94	1139200.0
2007-02-12 18:00:00	MSFT	Stock	28.93	28.97	28.93	28.97	21503.0
2007-02-12 19:00:00	MSFT	Stock	28.97	29.02	28.97	28.98	16895.0
2007-02-12 07:00:00	NVDA	Stock	0.5427	0.5477	0.5427	0.5477	150000.0
2007-02-12 08:00:00	NVDA	Stock	0.5467	0.5467	0.5402	0.5418	1367340.0
2007-02-12 09:00:00	NVDA	Stock	0.5415	0.555	0.5415	0.5517	111303900.0
2007-02-12 10:00:00	NVDA	Stock	0.5517	0.5643	0.5493	0.5638	224832660.0
2007-02-12 11:00:00	NVDA	Stock	0.5637	0.568	0.5567	0.5607	109715940.0
2007-02-12 12:00:00	NVDA	Stock	0.5607	0.5648	0.5587	0.5625	66953940.0
2007-02-12 13:00:00	NVDA	Stock	0.5623	0.5627	0.5592	0.5598	77275020.0
2007-02-12 14:00:00	NVDA	Stock	0.5598	0.5612	0.5572	0.5587	68696940.0
2007-02-12 15:00:00	NVDA	Stock	0.5587	0.5595	0.5555	0.5573	88363500.0
2007-02-12 16:00:00	NVDA	Stock	0.5575	0.5592	0.5552	0.5592	1313760.0
2007-02-12 17:00:00	NVDA	Stock	0.5575	0.5592	0.5563	0.5575	454200.0
2007-02-12 18:00:00	NVDA	Stock	0.5592	0.5607	0.5583	0.5583	60000.0
2007-02-12 08:00:00	AMZN	Stock	1.9445	1.9445	1.9445	1.9445	3520.0
2007-02-12 09:00:00	AMZN	Stock	1.9305	1.942	1.918	1.9225	11534700.0
2007-02-12 10:00:00	AMZN	Stock	1.923	1.945	1.921	1.9415	15454300.0
2007-02-12 11:00:00	AMZN	Stock	1.9415	1.9455	1.933	1.938	9170660.0
2007-02-12 12:00:00	AMZN	Stock	1.9375	1.944	1.9365	1.941	5219200.0
2007-02-12 13:00:00	AMZN	Stock	1.941	1.943	1.934	1.934	6742800.0
2007-02-12 14:00:00	AMZN	Stock	1.934	1.942	1.932	1.941	8887160.0
2007-02-12 15:00:00	AMZN	Stock	1.941	1.9495	1.938	1.943	17305020.0
2007-02-12 16:00:00	AMZN	Stock	1.943	1.945	1.9425	1.945	104340.0
2007-02-12 17:00:00	AMZN	Stock	1.9425	1.9425	1.9425	1.9425	30000.0
2007-02-12 18:00:00	AMZN	Stock	1.943	1.943	1.943	1.943	6460.0
2007-02-12 08:00:00	CL	Stock	33.46	33.46	33.46	33.46	68600.0

> showing 50 of 32,425 rows — these rows as CSV

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