PREVIEW / stock_1hour / 2007-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-23.parquet
  size:    672 KB
  rows:    32,349
  symbols: 2,540

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-23 06:00:00	AAPL	Stock	3.1911	3.1911	3.1911	3.1911	8400.0
2007-02-23 07:00:00	AAPL	Stock	3.1911	3.1911	3.1786	3.1911	33600.0
2007-02-23 08:00:00	AAPL	Stock	3.1911	3.1929	3.1821	3.1929	460404.0
2007-02-23 09:00:00	AAPL	Stock	3.1929	3.2171	3.1732	3.2071	101232124.0
2007-02-23 10:00:00	AAPL	Stock	3.2071	3.2264	3.1786	3.1875	165186252.0
2007-02-23 11:00:00	AAPL	Stock	3.1875	3.2071	3.1818	3.1989	78128400.0
2007-02-23 12:00:00	AAPL	Stock	3.1986	3.2	3.1832	3.1889	49323344.0
2007-02-23 13:00:00	AAPL	Stock	3.1886	3.1943	3.185	3.1904	24990952.0
2007-02-23 14:00:00	AAPL	Stock	3.1904	3.1964	3.1879	3.1932	27532680.0
2007-02-23 15:00:00	AAPL	Stock	3.1929	3.1946	3.1786	3.1804	61221076.0
2007-02-23 16:00:00	AAPL	Stock	3.1804	3.1811	3.1718	3.1718	1992872.0
2007-02-23 17:00:00	AAPL	Stock	3.1718	3.1779	3.1718	3.175	337820.0
2007-02-23 18:00:00	AAPL	Stock	3.1768	3.1782	3.1732	3.175	185752.0
2007-02-23 19:00:00	AAPL	Stock	3.175	3.1768	3.175	3.175	56000.0
2007-02-23 04:00:00	MSFT	Stock	29.12	29.12	29.12	29.12	100.0
2007-02-23 06:00:00	MSFT	Stock	29.09	29.17	29.09	29.17	3500.0
2007-02-23 07:00:00	MSFT	Stock	29.21	29.33	29.21	29.33	15006.0
2007-02-23 08:00:00	MSFT	Stock	29.26	29.28	29.24	29.27	35764.0
2007-02-23 09:00:00	MSFT	Stock	29.25	29.3	29.05	29.05	10222601.0
2007-02-23 10:00:00	MSFT	Stock	29.05	29.14	28.97	29.01	13670181.0
2007-02-23 11:00:00	MSFT	Stock	29.01	29.12	28.951	29.0	10785408.0
2007-02-23 12:00:00	MSFT	Stock	29.0	29.15	28.91	28.94	7443131.0
2007-02-23 13:00:00	MSFT	Stock	28.942	29.25	28.9	28.91	5056815.0
2007-02-23 14:00:00	MSFT	Stock	28.915	28.98	28.89	28.96	5434879.0
2007-02-23 15:00:00	MSFT	Stock	28.95	29.0	28.9	28.9	8312070.0
2007-02-23 16:00:00	MSFT	Stock	28.9	29.035	28.88	28.88	55516.0
2007-02-23 17:00:00	MSFT	Stock	28.88	28.92	28.86	28.92	13629.0
2007-02-23 18:00:00	MSFT	Stock	28.9	28.9	28.88	28.89	1136.0
2007-02-23 19:00:00	MSFT	Stock	28.88	28.88	28.88	28.88	309.0
2007-02-23 08:00:00	NVDA	Stock	0.5517	0.5547	0.5498	0.5498	154140.0
2007-02-23 09:00:00	NVDA	Stock	0.55	0.551	0.545	0.5467	62661720.0
2007-02-23 10:00:00	NVDA	Stock	0.5467	0.55	0.544	0.5458	81718860.0
2007-02-23 11:00:00	NVDA	Stock	0.5457	0.5495	0.545	0.5488	57263040.0
2007-02-23 12:00:00	NVDA	Stock	0.5488	0.5488	0.5442	0.5467	42284700.0
2007-02-23 13:00:00	NVDA	Stock	0.5465	0.5482	0.5452	0.547	37643340.0
2007-02-23 14:00:00	NVDA	Stock	0.5472	0.5487	0.546	0.5475	42386040.0
2007-02-23 15:00:00	NVDA	Stock	0.5473	0.5477	0.544	0.544	66505200.0
2007-02-23 16:00:00	NVDA	Stock	0.5442	0.5457	0.5433	0.5443	1874100.0
2007-02-23 17:00:00	NVDA	Stock	0.545	0.545	0.545	0.545	30000.0
2007-02-23 19:00:00	NVDA	Stock	0.5442	0.5442	0.5442	0.5442	60000.0
2007-02-23 08:00:00	AMZN	Stock	2.05	2.05	2.05	2.05	4000.0
2007-02-23 09:00:00	AMZN	Stock	2.05	2.0545	2.0375	2.0495	9037960.0
2007-02-23 10:00:00	AMZN	Stock	2.0495	2.06	2.0405	2.0485	11440820.0
2007-02-23 11:00:00	AMZN	Stock	2.049	2.059	2.045	2.051	7780620.0
2007-02-23 12:00:00	AMZN	Stock	2.051	2.0515	2.04	2.0445	10870660.0
2007-02-23 13:00:00	AMZN	Stock	2.044	2.05	2.0375	2.0385	17262600.0
2007-02-23 14:00:00	AMZN	Stock	2.039	2.0455	2.037	2.044	17195040.0
2007-02-23 15:00:00	AMZN	Stock	2.044	2.0485	2.039	2.039	31397020.0
2007-02-23 16:00:00	AMZN	Stock	2.039	2.04	2.038	2.038	2730180.0
2007-02-23 18:00:00	AMZN	Stock	2.0445	2.0445	2.0425	2.043	13096000.0

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

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