PREVIEW / stock_1hour / 2005-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-26.parquet
  size:    540 KB
  rows:    25,420
  symbols: 1,962

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
2005-04-26 06:00:00	AAPL	Stock	1.3025	1.3025	1.3025	1.3025	56000.0
2005-04-26 07:00:00	AAPL	Stock	1.3018	1.3071	1.295	1.3071	218568.0
2005-04-26 08:00:00	AAPL	Stock	1.3125	1.3125	1.2939	1.3068	5278616.0
2005-04-26 09:00:00	AAPL	Stock	1.3046	1.3157	1.2986	1.3064	99069432.0
2005-04-26 10:00:00	AAPL	Stock	1.3064	1.3396	1.3043	1.3346	195879432.0
2005-04-26 11:00:00	AAPL	Stock	1.3343	1.3364	1.3264	1.33	87596572.0
2005-04-26 12:00:00	AAPL	Stock	1.3304	1.3307	1.325	1.3296	51426732.0
2005-04-26 13:00:00	AAPL	Stock	1.3296	1.33	1.3129	1.3175	82699260.0
2005-04-26 14:00:00	AAPL	Stock	1.3175	1.3175	1.29	1.2925	132071268.0
2005-04-26 15:00:00	AAPL	Stock	1.2921	1.3057	1.2911	1.2925	138387956.0
2005-04-26 16:00:00	AAPL	Stock	1.2932	1.2971	1.2918	1.2936	3257688.0
2005-04-26 17:00:00	AAPL	Stock	1.2925	1.2946	1.2918	1.2918	1049440.0
2005-04-26 18:00:00	AAPL	Stock	1.2911	1.2911	1.2857	1.2896	1018220.0
2005-04-26 08:00:00	MSFT	Stock	24.89	24.98	24.86	24.87	2507470.0
2005-04-26 09:00:00	MSFT	Stock	24.88	25.25	24.88	25.12	8116544.0
2005-04-26 10:00:00	MSFT	Stock	25.12	25.19	24.93	25.17	11837383.0
2005-04-26 11:00:00	MSFT	Stock	25.172	25.18	25.07	25.09	4162461.0
2005-04-26 12:00:00	MSFT	Stock	25.08	25.1	24.98	25.03	3945907.0
2005-04-26 13:00:00	MSFT	Stock	25.03	25.05	24.91	24.99	7543412.0
2005-04-26 14:00:00	MSFT	Stock	24.99	24.99	24.82	24.84	7894889.0
2005-04-26 15:00:00	MSFT	Stock	24.842	24.98	24.75	24.76	12214106.0
2005-04-26 16:00:00	MSFT	Stock	24.75	24.78	24.69	24.71	821795.0
2005-04-26 17:00:00	MSFT	Stock	24.74	24.75	24.7	24.75	75969.0
2005-04-26 18:00:00	MSFT	Stock	24.75	24.75	24.75	24.75	195.0
2005-04-26 08:00:00	NVDA	Stock	0.1879	0.1882	0.1879	0.1879	540000.0
2005-04-26 09:00:00	NVDA	Stock	0.1875	0.1892	0.1836	0.1856	40133160.0
2005-04-26 10:00:00	NVDA	Stock	0.1855	0.1922	0.1851	0.1913	105949440.0
2005-04-26 11:00:00	NVDA	Stock	0.1913	0.1914	0.1896	0.1903	47945160.0
2005-04-26 12:00:00	NVDA	Stock	0.1903	0.1904	0.1892	0.1898	17935440.0
2005-04-26 13:00:00	NVDA	Stock	0.1899	0.1899	0.189	0.1896	30211560.0
2005-04-26 14:00:00	NVDA	Stock	0.1896	0.1897	0.1875	0.1876	49558440.0
2005-04-26 15:00:00	NVDA	Stock	0.1876	0.1884	0.1866	0.1872	52008840.0
2005-04-26 16:00:00	NVDA	Stock	0.1872	0.1874	0.1872	0.1874	219480.0
2005-04-26 17:00:00	NVDA	Stock	0.1874	0.1874	0.1874	0.1874	132000.0
2005-04-26 18:00:00	NVDA	Stock	0.1871	0.1871	0.1871	0.1871	12000.0
2005-04-26 08:00:00	AMZN	Stock	1.665	1.6685	1.665	1.6685	34000.0
2005-04-26 09:00:00	AMZN	Stock	1.6685	1.699	1.664	1.6905	20164100.0
2005-04-26 10:00:00	AMZN	Stock	1.6905	1.6925	1.667	1.6845	34163820.0
2005-04-26 11:00:00	AMZN	Stock	1.6845	1.6885	1.67	1.6755	13080780.0
2005-04-26 12:00:00	AMZN	Stock	1.6755	1.6805	1.6665	1.6685	14232860.0
2005-04-26 13:00:00	AMZN	Stock	1.6685	1.68	1.6435	1.65	23936820.0
2005-04-26 14:00:00	AMZN	Stock	1.65	1.68	1.6365	1.639	29944260.0
2005-04-26 15:00:00	AMZN	Stock	1.639	1.65	1.629	1.6315	66644160.0
2005-04-26 16:00:00	AMZN	Stock	1.6325	1.68	1.5325	1.56	86293640.0
2005-04-26 17:00:00	AMZN	Stock	1.561	1.6355	1.546	1.565	12336140.0
2005-04-26 18:00:00	AMZN	Stock	1.5655	1.5805	1.561	1.5785	3934220.0
2005-04-26 09:00:00	CL	Stock	25.85	25.85	25.56	25.595	234800.0
2005-04-26 10:00:00	CL	Stock	25.595	25.805	25.47	25.765	590200.0
2005-04-26 11:00:00	CL	Stock	25.755	25.87	25.705	25.75	525200.0
2005-04-26 12:00:00	CL	Stock	25.75	25.78	25.7	25.735	359600.0

> showing 50 of 25,420 rows — these rows as CSV

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