PREVIEW / stock_1hour / 2007-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-13.parquet
  size:    690 KB
  rows:    32,958
  symbols: 2,509

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-13 04:00:00	AAPL	Stock	3.0393	3.0393	3.0393	3.0393	5600.0
2007-02-13 07:00:00	AAPL	Stock	3.0525	3.0543	3.0364	3.0411	313600.0
2007-02-13 08:00:00	AAPL	Stock	3.0429	3.0482	3.0393	3.0439	1932280.0
2007-02-13 09:00:00	AAPL	Stock	3.0414	3.0461	3.0182	3.0289	92533308.0
2007-02-13 10:00:00	AAPL	Stock	3.0289	3.0325	3.0107	3.0193	106163904.0
2007-02-13 11:00:00	AAPL	Stock	3.0193	3.0457	3.0186	3.0361	122136952.0
2007-02-13 12:00:00	AAPL	Stock	3.0357	3.0425	3.0336	3.0354	49949760.0
2007-02-13 13:00:00	AAPL	Stock	3.035	3.0379	3.0189	3.0236	58548644.0
2007-02-13 14:00:00	AAPL	Stock	3.0236	3.0293	3.0143	3.0218	62868372.0
2007-02-13 15:00:00	AAPL	Stock	3.0218	3.0264	3.0125	3.0232	67645144.0
2007-02-13 16:00:00	AAPL	Stock	3.0225	3.0286	3.0221	3.025	2509444.0
2007-02-13 17:00:00	AAPL	Stock	3.025	3.0268	3.0243	3.0268	581308.0
2007-02-13 18:00:00	AAPL	Stock	3.0264	3.0282	3.0225	3.0275	203700.0
2007-02-13 19:00:00	AAPL	Stock	3.0279	3.0286	3.025	3.0286	899108.0
2007-02-13 07:00:00	MSFT	Stock	28.9	28.9	28.85	28.85	7367.0
2007-02-13 08:00:00	MSFT	Stock	28.9	29.0	28.9	28.98	122583.0
2007-02-13 09:00:00	MSFT	Stock	28.98	29.13	28.9	29.09	7787570.0
2007-02-13 10:00:00	MSFT	Stock	29.09	29.1	28.96	28.96	11117196.0
2007-02-13 11:00:00	MSFT	Stock	28.97	29.049	28.96	29.0	4802085.0
2007-02-13 12:00:00	MSFT	Stock	29.0	29.2	28.99	29.03	8146360.0
2007-02-13 13:00:00	MSFT	Stock	29.04	29.1	29.01	29.03	3360315.0
2007-02-13 14:00:00	MSFT	Stock	29.03	29.07	28.99	29.04	5070401.0
2007-02-13 15:00:00	MSFT	Stock	29.03	29.08	28.99	29.04	7098118.0
2007-02-13 16:00:00	MSFT	Stock	29.04	29.05	29.0	29.03	188177.0
2007-02-13 17:00:00	MSFT	Stock	29.03	29.03	29.0	29.01	5078.0
2007-02-13 18:00:00	MSFT	Stock	29.01	29.03	29.01	29.03	2265.0
2007-02-13 19:00:00	MSFT	Stock	29.01	29.01	28.96	29.0	76195.0
2007-02-13 08:00:00	NVDA	Stock	0.5647	0.565	0.563	0.5647	581400.0
2007-02-13 09:00:00	NVDA	Stock	0.5642	0.5673	0.5608	0.5627	72397980.0
2007-02-13 10:00:00	NVDA	Stock	0.5625	0.5655	0.5595	0.562	97541400.0
2007-02-13 11:00:00	NVDA	Stock	0.562	0.5673	0.562	0.5643	87016800.0
2007-02-13 12:00:00	NVDA	Stock	0.5643	0.5712	0.5642	0.5682	101653860.0
2007-02-13 13:00:00	NVDA	Stock	0.5683	0.5683	0.5655	0.5663	55863660.0
2007-02-13 14:00:00	NVDA	Stock	0.5663	0.5683	0.5652	0.5665	132125700.0
2007-02-13 15:00:00	NVDA	Stock	0.5665	0.5683	0.5653	0.5665	148503240.0
2007-02-13 16:00:00	NVDA	Stock	0.5667	0.5833	0.555	0.5782	58945860.0
2007-02-13 17:00:00	NVDA	Stock	0.5782	0.5802	0.5433	0.5623	77722080.0
2007-02-13 18:00:00	NVDA	Stock	0.5625	0.5667	0.5553	0.5625	16853580.0
2007-02-13 19:00:00	NVDA	Stock	0.5633	0.5683	0.5623	0.5682	10348620.0
2007-02-13 09:00:00	AMZN	Stock	1.9425	1.976	1.9425	1.973	14906540.0
2007-02-13 10:00:00	AMZN	Stock	1.9735	1.9805	1.9594	1.9625	13601180.0
2007-02-13 11:00:00	AMZN	Stock	1.9625	1.9725	1.961	1.967	13260780.0
2007-02-13 12:00:00	AMZN	Stock	1.9665	1.969	1.962	1.969	6492280.0
2007-02-13 13:00:00	AMZN	Stock	1.9685	1.9735	1.962	1.9645	8813700.0
2007-02-13 14:00:00	AMZN	Stock	1.964	1.967	1.9565	1.9585	8391060.0
2007-02-13 15:00:00	AMZN	Stock	1.9585	1.968	1.958	1.9645	20377340.0
2007-02-13 16:00:00	AMZN	Stock	1.965	1.9655	1.965	1.9655	70000.0
2007-02-13 17:00:00	AMZN	Stock	1.972	1.9725	1.966	1.966	36000.0
2007-02-13 18:00:00	AMZN	Stock	1.972	1.972	1.972	1.972	2740.0
2007-02-13 19:00:00	AMZN	Stock	1.9725	1.9725	1.9725	1.9725	27440.0

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

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