PREVIEW / stock_1hour / 2008-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-03.parquet
  size:    808 KB
  rows:    40,327
  symbols: 3,250

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-04-03 06:00:00	AAPL	Stock	5.3071	5.3071	5.2996	5.2996	30800.0
2008-04-03 07:00:00	AAPL	Stock	5.3	5.3175	5.2857	5.3125	205492.0
2008-04-03 08:00:00	AAPL	Stock	5.3093	5.3125	5.235	5.2496	4253200.0
2008-04-03 09:00:00	AAPL	Stock	5.2493	5.3332	5.2232	5.3311	170087092.0
2008-04-03 10:00:00	AAPL	Stock	5.3307	5.3629	5.3164	5.3282	174111616.0
2008-04-03 11:00:00	AAPL	Stock	5.3275	5.3821	5.3221	5.3813	117698000.0
2008-04-03 12:00:00	AAPL	Stock	5.3796	5.4561	5.3682	5.448	129139248.0
2008-04-03 13:00:00	AAPL	Stock	5.4468	5.4868	5.4211	5.4289	155849428.0
2008-04-03 14:00:00	AAPL	Stock	5.4289	5.465	5.3964	5.4639	111970964.0
2008-04-03 15:00:00	AAPL	Stock	5.4639	5.4739	5.3843	5.4143	163181256.0
2008-04-03 16:00:00	AAPL	Stock	5.4143	5.4201	5.3836	5.4201	10267376.0
2008-04-03 17:00:00	AAPL	Stock	5.4114	5.4239	5.4107	5.4196	423024.0
2008-04-03 18:00:00	AAPL	Stock	5.4214	5.425	5.4214	5.4214	212632.0
2008-04-03 19:00:00	AAPL	Stock	5.4229	5.4239	5.4196	5.4214	143892.0
2008-04-03 07:00:00	MSFT	Stock	29.16	29.16	29.1	29.1	200.0
2008-04-03 08:00:00	MSFT	Stock	29.16	29.29	28.96	28.99	345360.0
2008-04-03 09:00:00	MSFT	Stock	29.0	29.15	28.88	28.99	3222692.0
2008-04-03 10:00:00	MSFT	Stock	28.99	29.1	28.8	28.86	6288536.0
2008-04-03 11:00:00	MSFT	Stock	28.852	29.1	28.85	29.06	4788885.0
2008-04-03 12:00:00	MSFT	Stock	29.06	29.27	29.06	29.24	4534669.0
2008-04-03 13:00:00	MSFT	Stock	29.23	29.32	29.04	29.04	4221581.0
2008-04-03 14:00:00	MSFT	Stock	29.042	29.25	29.03	29.24	3689839.0
2008-04-03 15:00:00	MSFT	Stock	29.23	29.25	28.94	29.0	9560591.0
2008-04-03 16:00:00	MSFT	Stock	28.98	29.14	28.98	29.0	1762593.0
2008-04-03 17:00:00	MSFT	Stock	29.04	29.09	29.04	29.08	13785.0
2008-04-03 18:00:00	MSFT	Stock	29.07	29.09	29.07	29.07	44336.0
2008-04-03 19:00:00	MSFT	Stock	29.06	29.07	29.06	29.06	2875.0
2008-04-03 05:00:00	NVDA	Stock	0.4998	0.4998	0.4998	0.4998	4000.0
2008-04-03 08:00:00	NVDA	Stock	0.5125	0.5128	0.5013	0.5038	250120.0
2008-04-03 09:00:00	NVDA	Stock	0.5018	0.5055	0.4883	0.4963	102535400.0
2008-04-03 10:00:00	NVDA	Stock	0.496	0.4988	0.4852	0.4865	154056320.0
2008-04-03 11:00:00	NVDA	Stock	0.4862	0.4988	0.4848	0.498	132943320.0
2008-04-03 12:00:00	NVDA	Stock	0.498	0.502	0.4948	0.5	123325120.0
2008-04-03 13:00:00	NVDA	Stock	0.4998	0.5038	0.4963	0.4968	93604600.0
2008-04-03 14:00:00	NVDA	Stock	0.4968	0.5038	0.4952	0.5035	76114680.0
2008-04-03 15:00:00	NVDA	Stock	0.5038	0.5045	0.4978	0.5005	126804360.0
2008-04-03 16:00:00	NVDA	Stock	0.4998	0.5013	0.4905	0.4995	22458160.0
2008-04-03 17:00:00	NVDA	Stock	0.5015	0.5015	0.5	0.5013	100000.0
2008-04-03 18:00:00	NVDA	Stock	0.5013	0.5013	0.4995	0.4995	140160.0
2008-04-03 07:00:00	AMZN	Stock	3.825	3.825	3.825	3.825	10000.0
2008-04-03 08:00:00	AMZN	Stock	3.845	3.8685	3.7525	3.765	1020880.0
2008-04-03 09:00:00	AMZN	Stock	3.77	3.775	3.725	3.75	27219420.0
2008-04-03 10:00:00	AMZN	Stock	3.75	3.778	3.72	3.7315	36367160.0
2008-04-03 11:00:00	AMZN	Stock	3.7295	3.76	3.6905	3.7575	23825020.0
2008-04-03 12:00:00	AMZN	Stock	3.7575	3.8005	3.734	3.7735	17120000.0
2008-04-03 13:00:00	AMZN	Stock	3.7735	3.799	3.744	3.749	13796480.0
2008-04-03 14:00:00	AMZN	Stock	3.75	3.775	3.7395	3.763	13466400.0
2008-04-03 15:00:00	AMZN	Stock	3.763	3.767	3.7275	3.751	26612440.0
2008-04-03 16:00:00	AMZN	Stock	3.757	3.757	3.747	3.75	1415540.0
2008-04-03 17:00:00	AMZN	Stock	3.747	3.747	3.747	3.747	4680.0

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

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