PREVIEW / stock_1hour / 2008-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-24.parquet
  size:    823 KB
  rows:    40,020
  symbols: 3,330

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
2008-07-24 06:00:00	AAPL	Stock	5.945	5.945	5.945	5.945	2800.0
2008-07-24 07:00:00	AAPL	Stock	5.9346	5.9375	5.9018	5.9018	209020.0
2008-07-24 08:00:00	AAPL	Stock	5.9211	5.9379	5.8786	5.8839	5652668.0
2008-07-24 09:00:00	AAPL	Stock	5.8839	5.9021	5.8071	5.8621	104177500.0
2008-07-24 10:00:00	AAPL	Stock	5.8621	5.8625	5.7332	5.7464	172082344.0
2008-07-24 11:00:00	AAPL	Stock	5.7468	5.7514	5.6743	5.7196	146296416.0
2008-07-24 12:00:00	AAPL	Stock	5.7198	5.7729	5.7104	5.7464	74122944.0
2008-07-24 13:00:00	AAPL	Stock	5.7464	5.8029	5.7171	5.7932	87852184.0
2008-07-24 14:00:00	AAPL	Stock	5.7932	5.7964	5.7068	5.7287	89298356.0
2008-07-24 15:00:00	AAPL	Stock	5.7289	5.7589	5.6589	5.6814	128354324.0
2008-07-24 16:00:00	AAPL	Stock	5.6818	5.7562	5.6754	5.6814	19639676.0
2008-07-24 17:00:00	AAPL	Stock	5.6786	5.6821	5.665	5.6714	550984.0
2008-07-24 18:00:00	AAPL	Stock	5.67	5.6796	5.65	5.6679	1272124.0
2008-07-24 19:00:00	AAPL	Stock	5.6654	5.6736	5.6643	5.6736	161812.0
2008-07-24 04:00:00	MSFT	Stock	26.43	26.43	26.43	26.43	200.0
2008-07-24 07:00:00	MSFT	Stock	26.06	26.35	26.06	26.16	11900.0
2008-07-24 08:00:00	MSFT	Stock	26.24	26.71	26.24	26.3	946839.0
2008-07-24 09:00:00	MSFT	Stock	26.3	26.3	25.75	25.83	6900840.0
2008-07-24 10:00:00	MSFT	Stock	25.83	25.83	25.5	25.59	16620209.0
2008-07-24 11:00:00	MSFT	Stock	25.59	25.635	25.44	25.592	10473327.0
2008-07-24 12:00:00	MSFT	Stock	25.6	25.652	25.53	25.61	5714592.0
2008-07-24 13:00:00	MSFT	Stock	25.61	25.76	25.53	25.59	7689930.0
2008-07-24 14:00:00	MSFT	Stock	25.59	25.61	25.52	25.58	7026071.0
2008-07-24 15:00:00	MSFT	Stock	25.58	25.65	25.44	25.44	19140614.0
2008-07-24 16:00:00	MSFT	Stock	25.45	25.61	25.41	25.5	3507523.0
2008-07-24 17:00:00	MSFT	Stock	25.5	25.53	25.46	25.53	122237.0
2008-07-24 18:00:00	MSFT	Stock	25.55	25.55	25.44	25.53	62938.0
2008-07-24 19:00:00	MSFT	Stock	25.53	25.53	25.5	25.5	3900.0
2008-07-24 07:00:00	NVDA	Stock	0.296	0.296	0.296	0.296	32000.0
2008-07-24 08:00:00	NVDA	Stock	0.2975	0.2975	0.2905	0.2905	498880.0
2008-07-24 09:00:00	NVDA	Stock	0.2905	0.2965	0.2842	0.2843	64098480.0
2008-07-24 10:00:00	NVDA	Stock	0.2845	0.2848	0.2803	0.2805	144275440.0
2008-07-24 11:00:00	NVDA	Stock	0.2805	0.281	0.278	0.2795	74653440.0
2008-07-24 12:00:00	NVDA	Stock	0.2798	0.2812	0.2778	0.28	61263000.0
2008-07-24 13:00:00	NVDA	Stock	0.28	0.2803	0.2772	0.278	109174520.0
2008-07-24 14:00:00	NVDA	Stock	0.278	0.2792	0.2765	0.2778	67551520.0
2008-07-24 15:00:00	NVDA	Stock	0.2778	0.279	0.275	0.2755	153516840.0
2008-07-24 16:00:00	NVDA	Stock	0.2758	0.2796	0.275	0.2763	23230720.0
2008-07-24 17:00:00	NVDA	Stock	0.2752	0.2758	0.274	0.274	455960.0
2008-07-24 18:00:00	NVDA	Stock	0.274	0.2758	0.274	0.2758	202440.0
2008-07-24 19:00:00	NVDA	Stock	0.2758	0.2758	0.2758	0.2758	104000.0
2008-07-24 06:00:00	AMZN	Stock	3.7505	3.85	3.7505	3.85	186000.0
2008-07-24 07:00:00	AMZN	Stock	3.85	3.85	3.749	3.815	1915140.0
2008-07-24 08:00:00	AMZN	Stock	3.85	3.875	3.7975	3.822	9388500.0
2008-07-24 09:00:00	AMZN	Stock	3.8215	4.0185	3.7815	3.971	137275020.0
2008-07-24 10:00:00	AMZN	Stock	3.971	4.1	3.9245	4.0895	142368420.0
2008-07-24 11:00:00	AMZN	Stock	4.0895	4.105	4.033	4.0785	72829860.0
2008-07-24 12:00:00	AMZN	Stock	4.0775	4.119	4.0455	4.064	45836100.0
2008-07-24 13:00:00	AMZN	Stock	4.061	4.0815	4.0465	4.074	35486900.0
2008-07-24 14:00:00	AMZN	Stock	4.074	4.0925	4.02	4.0555	58773840.0

> showing 50 of 40,020 rows — these rows as CSV

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