PREVIEW / stock_1hour / 2005-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-12.parquet
  size:    586 KB
  rows:    28,244
  symbols: 2,094

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-10-12 05:00:00	AAPL	Stock	1.6682	1.6889	1.6682	1.6889	58800.0
2005-10-12 06:00:00	AAPL	Stock	1.6875	1.6921	1.6789	1.6821	81200.0
2005-10-12 07:00:00	AAPL	Stock	1.6839	1.6946	1.6768	1.6886	2182320.0
2005-10-12 08:00:00	AAPL	Stock	1.6907	1.7268	1.6793	1.7186	90815368.0
2005-10-12 09:00:00	AAPL	Stock	1.7182	1.7743	1.7096	1.7675	635659136.0
2005-10-12 10:00:00	AAPL	Stock	1.7675	1.7929	1.7554	1.7707	511142968.0
2005-10-12 11:00:00	AAPL	Stock	1.7714	1.7964	1.7643	1.7646	259698600.0
2005-10-12 12:00:00	AAPL	Stock	1.7643	1.7868	1.7625	1.7814	183777300.0
2005-10-12 13:00:00	AAPL	Stock	1.7814	1.7936	1.7418	1.7711	470441160.0
2005-10-12 14:00:00	AAPL	Stock	1.7714	1.7714	1.735	1.7436	271416096.0
2005-10-12 15:00:00	AAPL	Stock	1.7443	1.7825	1.7346	1.7589	245616840.0
2005-10-12 16:00:00	AAPL	Stock	1.7589	1.7639	1.7529	1.7568	3836224.0
2005-10-12 17:00:00	AAPL	Stock	1.7586	1.7605	1.7554	1.7593	2055200.0
2005-10-12 18:00:00	AAPL	Stock	1.7593	1.7593	1.7582	1.7582	1018500.0
2005-10-12 08:00:00	MSFT	Stock	24.38	24.41	24.31	24.36	44790.0
2005-10-12 09:00:00	MSFT	Stock	24.36	24.7	24.35	24.67	7636185.0
2005-10-12 10:00:00	MSFT	Stock	24.672	24.7	24.45	24.53	10469922.0
2005-10-12 11:00:00	MSFT	Stock	24.53	24.54	24.41	24.43	8770972.0
2005-10-12 12:00:00	MSFT	Stock	24.43	24.48	24.3	24.35	9600891.0
2005-10-12 13:00:00	MSFT	Stock	24.342	24.41	24.27	24.37	7827473.0
2005-10-12 14:00:00	MSFT	Stock	24.36	24.45	24.31	24.35	9648334.0
2005-10-12 15:00:00	MSFT	Stock	24.36	24.43	24.3	24.3	15100020.0
2005-10-12 16:00:00	MSFT	Stock	24.31	24.63	24.29	24.32	1237293.0
2005-10-12 17:00:00	MSFT	Stock	24.33	24.35	24.31	24.33	72332.0
2005-10-12 18:00:00	MSFT	Stock	24.35	24.35	24.31	24.35	100936.0
2005-10-12 09:00:00	NVDA	Stock	0.2648	0.2691	0.2641	0.2691	87822360.0
2005-10-12 10:00:00	NVDA	Stock	0.269	0.2702	0.2656	0.2701	103404120.0
2005-10-12 11:00:00	NVDA	Stock	0.2701	0.2721	0.2679	0.2681	114304800.0
2005-10-12 12:00:00	NVDA	Stock	0.268	0.2703	0.2673	0.2693	59778960.0
2005-10-12 13:00:00	NVDA	Stock	0.2696	0.2724	0.2663	0.2674	91188600.0
2005-10-12 14:00:00	NVDA	Stock	0.2673	0.2683	0.2656	0.2673	69892200.0
2005-10-12 15:00:00	NVDA	Stock	0.2672	0.2694	0.2663	0.2684	125253360.0
2005-10-12 16:00:00	NVDA	Stock	0.2683	0.27	0.2677	0.2679	1834680.0
2005-10-12 17:00:00	NVDA	Stock	0.2679	0.2683	0.2679	0.268	370320.0
2005-10-12 18:00:00	NVDA	Stock	0.2678	0.2678	0.2678	0.2678	60000.0
2005-10-12 08:00:00	AMZN	Stock	2.1625	2.1625	2.1505	2.1505	10520.0
2005-10-12 09:00:00	AMZN	Stock	2.1605	2.184	2.1425	2.1605	13923300.0
2005-10-12 10:00:00	AMZN	Stock	2.1615	2.164	2.1305	2.136	20327580.0
2005-10-12 11:00:00	AMZN	Stock	2.137	2.153	2.13	2.133	13147100.0
2005-10-12 12:00:00	AMZN	Stock	2.1325	2.1415	2.1285	2.1415	12687640.0
2005-10-12 13:00:00	AMZN	Stock	2.141	2.1615	2.14	2.15	9194660.0
2005-10-12 14:00:00	AMZN	Stock	2.1495	2.151	2.1375	2.1395	11346200.0
2005-10-12 15:00:00	AMZN	Stock	2.1395	2.14	2.122	2.1285	29177140.0
2005-10-12 16:00:00	AMZN	Stock	2.1275	2.132	2.125	2.132	568140.0
2005-10-12 17:00:00	AMZN	Stock	2.1275	2.1296	2.1275	2.1275	1696760.0
2005-10-12 18:00:00	AMZN	Stock	2.1275	2.1275	2.1275	2.1275	105520.0
2005-10-12 09:00:00	CL	Stock	25.85	26.03	25.85	26.03	392400.0
2005-10-12 10:00:00	CL	Stock	26.03	26.06	25.925	25.975	499800.0
2005-10-12 11:00:00	CL	Stock	25.975	25.99	25.865	25.885	486600.0
2005-10-12 12:00:00	CL	Stock	25.89	26.0	25.825	25.955	334200.0

> showing 50 of 28,244 rows — these rows as CSV

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