PREVIEW / stock_1hour / 2007-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-16.parquet
  size:    646 KB
  rows:    30,801
  symbols: 2,508

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-16 07:00:00	AAPL	Stock	3.045	3.045	3.0357	3.0375	16800.0
2007-02-16 08:00:00	AAPL	Stock	3.0379	3.0421	3.0357	3.0371	820540.0
2007-02-16 09:00:00	AAPL	Stock	3.0371	3.0504	3.0236	3.035	92713656.0
2007-02-16 10:00:00	AAPL	Stock	3.035	3.0386	3.0304	3.0329	54231828.0
2007-02-16 11:00:00	AAPL	Stock	3.0329	3.0357	3.0286	3.0311	35130816.0
2007-02-16 12:00:00	AAPL	Stock	3.0311	3.0332	3.0246	3.0296	33821424.0
2007-02-16 13:00:00	AAPL	Stock	3.0296	3.0346	3.0279	3.0329	35842408.0
2007-02-16 14:00:00	AAPL	Stock	3.0332	3.0354	3.0321	3.0329	34275248.0
2007-02-16 15:00:00	AAPL	Stock	3.0329	3.0364	3.0271	3.0271	75816272.0
2007-02-16 16:00:00	AAPL	Stock	3.0296	3.0354	3.0289	3.0304	6144516.0
2007-02-16 17:00:00	AAPL	Stock	3.0296	3.0318	3.0293	3.0296	19172216.0
2007-02-16 18:00:00	AAPL	Stock	3.0314	3.0321	3.03	3.0304	137004.0
2007-02-16 19:00:00	AAPL	Stock	3.0304	3.0318	3.0304	3.0304	63140.0
2007-02-16 06:00:00	MSFT	Stock	28.81	28.84	28.81	28.84	4500.0
2007-02-16 07:00:00	MSFT	Stock	28.85	29.09	28.85	29.0	142290.0
2007-02-16 08:00:00	MSFT	Stock	29.0	29.07	28.98	29.0	844549.0
2007-02-16 09:00:00	MSFT	Stock	28.99	29.01	28.75	28.78	30217265.0
2007-02-16 10:00:00	MSFT	Stock	28.78	28.8	28.65	28.78	24861383.0
2007-02-16 11:00:00	MSFT	Stock	28.78	28.91	28.75	28.773	12528356.0
2007-02-16 12:00:00	MSFT	Stock	28.77	28.83	28.75	28.77	6019654.0
2007-02-16 13:00:00	MSFT	Stock	28.78	28.88	28.67	28.8	7788987.0
2007-02-16 14:00:00	MSFT	Stock	28.8	28.82	28.76	28.77	6604314.0
2007-02-16 15:00:00	MSFT	Stock	28.763	28.8	28.71	28.71	13668391.0
2007-02-16 16:00:00	MSFT	Stock	28.72	28.75	28.72	28.72	264712.0
2007-02-16 17:00:00	MSFT	Stock	28.74	28.74	28.71	28.74	3276870.0
2007-02-16 18:00:00	MSFT	Stock	28.74	28.74	28.71	28.73	18318.0
2007-02-16 19:00:00	MSFT	Stock	28.74	28.74	28.71	28.74	8932.0
2007-02-16 09:00:00	NVDA	Stock	0.56	0.5608	0.5535	0.5545	131801340.0
2007-02-16 10:00:00	NVDA	Stock	0.5547	0.559	0.5485	0.5513	186931260.0
2007-02-16 11:00:00	NVDA	Stock	0.5515	0.5592	0.5437	0.5466	206058060.0
2007-02-16 12:00:00	NVDA	Stock	0.5467	0.5508	0.546	0.5483	78944280.0
2007-02-16 13:00:00	NVDA	Stock	0.5483	0.5485	0.5457	0.5467	71844600.0
2007-02-16 14:00:00	NVDA	Stock	0.5467	0.5473	0.5447	0.5457	82980660.0
2007-02-16 15:00:00	NVDA	Stock	0.5455	0.5533	0.5447	0.5447	119319000.0
2007-02-16 16:00:00	NVDA	Stock	0.5452	0.5457	0.5442	0.5457	880440.0
2007-02-16 17:00:00	NVDA	Stock	0.5448	0.5453	0.5448	0.5453	172980.0
2007-02-16 18:00:00	NVDA	Stock	0.5455	0.5455	0.5455	0.5455	30000.0
2007-02-16 19:00:00	NVDA	Stock	0.5455	0.5457	0.5442	0.5442	72000.0
2007-02-16 09:00:00	AMZN	Stock	1.9975	2.005	1.994	1.999	13062840.0
2007-02-16 10:00:00	AMZN	Stock	1.999	2.0115	1.9935	2.01	13666000.0
2007-02-16 11:00:00	AMZN	Stock	2.0105	2.0115	2.0	2.004	8820420.0
2007-02-16 12:00:00	AMZN	Stock	2.0035	2.006	2.0	2.0005	9086080.0
2007-02-16 13:00:00	AMZN	Stock	2.001	2.0065	2.001	2.0045	4945080.0
2007-02-16 14:00:00	AMZN	Stock	2.0045	2.016	2.004	2.0075	18587440.0
2007-02-16 15:00:00	AMZN	Stock	2.007	2.022	2.0065	2.0165	22035000.0
2007-02-16 16:00:00	AMZN	Stock	2.019	2.02	2.017	2.017	207500.0
2007-02-16 17:00:00	AMZN	Stock	2.0225	2.0245	2.0165	2.02	59400.0
2007-02-16 18:00:00	AMZN	Stock	2.02	2.024	2.02	2.024	8000.0
2007-02-16 07:00:00	CL	Stock	34.3	34.3	34.295	34.295	1800.0
2007-02-16 09:00:00	CL	Stock	34.335	34.435	34.075	34.35	1025000.0

> showing 50 of 30,801 rows — these rows as CSV

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