PREVIEW / stock_1hour / 2005-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-12.parquet
  size:    542 KB
  rows:    25,477
  symbols: 1,968

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-05-12 08:00:00	AAPL	Stock	1.2714	1.2761	1.2643	1.2718	4800208.0
2005-05-12 09:00:00	AAPL	Stock	1.2718	1.275	1.2507	1.2575	103352172.0
2005-05-12 10:00:00	AAPL	Stock	1.2575	1.2607	1.2196	1.2264	245477232.0
2005-05-12 11:00:00	AAPL	Stock	1.2268	1.2461	1.2232	1.2443	151127844.0
2005-05-12 12:00:00	AAPL	Stock	1.2443	1.2479	1.2321	1.2357	70429184.0
2005-05-12 13:00:00	AAPL	Stock	1.2354	1.2361	1.2232	1.2293	100330496.0
2005-05-12 14:00:00	AAPL	Stock	1.2296	1.235	1.2193	1.2254	129668560.0
2005-05-12 15:00:00	AAPL	Stock	1.2254	1.2268	1.2143	1.22	133978964.0
2005-05-12 16:00:00	AAPL	Stock	1.2221	1.225	1.2186	1.2214	3175928.0
2005-05-12 17:00:00	AAPL	Stock	1.2218	1.2268	1.2214	1.2221	1112664.0
2005-05-12 18:00:00	AAPL	Stock	1.2264	1.2271	1.2236	1.225	70000.0
2005-05-12 08:00:00	MSFT	Stock	24.88	24.88	24.87	24.87	600.0
2005-05-12 09:00:00	MSFT	Stock	24.89	24.97	24.76	24.86	5649231.0
2005-05-12 10:00:00	MSFT	Stock	24.86	25.03	24.85	24.97	12665086.0
2005-05-12 11:00:00	MSFT	Stock	24.97	25.1	24.93	25.08	10636637.0
2005-05-12 12:00:00	MSFT	Stock	25.08	25.11	24.93	25.01	8154927.0
2005-05-12 13:00:00	MSFT	Stock	25.01	25.06	24.94	25.01	5226557.0
2005-05-12 14:00:00	MSFT	Stock	25.01	25.05	24.92	25.02	11461730.0
2005-05-12 15:00:00	MSFT	Stock	25.02	25.09	24.94	25.0	14941968.0
2005-05-12 16:00:00	MSFT	Stock	25.01	25.08	24.96	25.08	263205.0
2005-05-12 17:00:00	MSFT	Stock	25.06	25.08	25.01	25.01	35198.0
2005-05-12 18:00:00	MSFT	Stock	25.07	25.07	25.07	25.07	200.0
2005-05-12 08:00:00	NVDA	Stock	0.1867	0.1868	0.1867	0.1868	696000.0
2005-05-12 09:00:00	NVDA	Stock	0.187	0.1902	0.1855	0.1887	101495520.0
2005-05-12 10:00:00	NVDA	Stock	0.1887	0.1898	0.1882	0.1887	102117720.0
2005-05-12 11:00:00	NVDA	Stock	0.1886	0.1897	0.1882	0.1895	85546200.0
2005-05-12 12:00:00	NVDA	Stock	0.1895	0.1917	0.1889	0.1916	97793760.0
2005-05-12 13:00:00	NVDA	Stock	0.1916	0.1924	0.1905	0.1912	99041160.0
2005-05-12 14:00:00	NVDA	Stock	0.1913	0.1917	0.189	0.1911	75996720.0
2005-05-12 15:00:00	NVDA	Stock	0.1912	0.1913	0.1892	0.1899	156806640.0
2005-05-12 16:00:00	NVDA	Stock	0.1897	0.2018	0.1883	0.2012	108315240.0
2005-05-12 17:00:00	NVDA	Stock	0.2012	0.2072	0.2007	0.2066	79231200.0
2005-05-12 18:00:00	NVDA	Stock	0.2065	0.2067	0.2053	0.2066	6998400.0
2005-05-12 09:00:00	AMZN	Stock	1.693	1.6975	1.6815	1.6875	11553560.0
2005-05-12 10:00:00	AMZN	Stock	1.6875	1.706	1.683	1.698	31109860.0
2005-05-12 11:00:00	AMZN	Stock	1.698	1.703	1.691	1.7025	14673560.0
2005-05-12 12:00:00	AMZN	Stock	1.7025	1.705	1.7	1.7035	12560960.0
2005-05-12 13:00:00	AMZN	Stock	1.703	1.7038	1.696	1.6985	7640700.0
2005-05-12 14:00:00	AMZN	Stock	1.698	1.6995	1.6835	1.6845	17822880.0
2005-05-12 15:00:00	AMZN	Stock	1.684	1.6985	1.6775	1.6925	23297680.0
2005-05-12 16:00:00	AMZN	Stock	1.6915	1.6925	1.6875	1.6925	347560.0
2005-05-12 17:00:00	AMZN	Stock	1.6925	1.694	1.6925	1.6925	124000.0
2005-05-12 09:00:00	CL	Stock	24.645	24.745	24.585	24.62	448000.0
2005-05-12 10:00:00	CL	Stock	24.625	24.71	24.555	24.64	599600.0
2005-05-12 11:00:00	CL	Stock	24.645	24.74	24.6	24.705	554600.0
2005-05-12 12:00:00	CL	Stock	24.7	24.765	24.635	24.75	400400.0
2005-05-12 13:00:00	CL	Stock	24.75	24.8	24.675	24.71	531400.0
2005-05-12 14:00:00	CL	Stock	24.71	24.725	24.6	24.61	575000.0
2005-05-12 15:00:00	CL	Stock	24.605	24.645	24.575	24.615	774000.0

> showing 49 of 25,477 rows — these rows as CSV

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