PREVIEW / stock_1hour / 2007-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-12.parquet
  size:    811 KB
  rows:    40,154
  symbols: 3,175

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
2007-11-12 04:00:00	AAPL	Stock	5.9282	5.9282	5.9282	5.9282	16800.0
2007-11-12 05:00:00	AAPL	Stock	5.9329	5.9332	5.9329	5.9332	14840.0
2007-11-12 06:00:00	AAPL	Stock	5.9464	5.9464	5.9107	5.9279	142044.0
2007-11-12 07:00:00	AAPL	Stock	5.9279	5.9429	5.8982	5.9089	783552.0
2007-11-12 08:00:00	AAPL	Stock	5.9089	5.9789	5.8318	5.9682	12534116.0
2007-11-12 09:00:00	AAPL	Stock	5.9707	5.9893	5.7704	5.9007	223609176.0
2007-11-12 10:00:00	AAPL	Stock	5.8989	5.9107	5.7396	5.8679	242226824.0
2007-11-12 11:00:00	AAPL	Stock	5.87	5.9114	5.8429	5.8564	163806860.0
2007-11-12 12:00:00	AAPL	Stock	5.8554	5.8761	5.7575	5.7696	118654228.0
2007-11-12 13:00:00	AAPL	Stock	5.7714	5.8005	5.5889	5.6143	251355496.0
2007-11-12 14:00:00	AAPL	Stock	5.615	5.6818	5.5079	5.635	322556892.0
2007-11-12 15:00:00	AAPL	Stock	5.6357	5.6464	5.3796	5.4875	394898392.0
2007-11-12 16:00:00	AAPL	Stock	5.4875	5.9625	5.4714	5.48	33295780.0
2007-11-12 17:00:00	AAPL	Stock	5.6634	5.7106	5.425	5.4393	2287348.0
2007-11-12 18:00:00	AAPL	Stock	5.45	5.4536	5.3929	5.4004	1572732.0
2007-11-12 19:00:00	AAPL	Stock	5.4018	5.4457	5.3929	5.4411	1338792.0
2007-11-12 05:00:00	MSFT	Stock	33.73	33.73	33.73	33.73	100.0
2007-11-12 06:00:00	MSFT	Stock	33.73	34.0	33.73	34.0	200.0
2007-11-12 07:00:00	MSFT	Stock	33.8	33.8	33.35	33.4	126481.0
2007-11-12 08:00:00	MSFT	Stock	33.4	33.73	33.31	33.55	1787338.0
2007-11-12 09:00:00	MSFT	Stock	33.54	33.55	33.02	33.43	11769585.0
2007-11-12 10:00:00	MSFT	Stock	33.43	33.55	33.23	33.519	10851724.0
2007-11-12 11:00:00	MSFT	Stock	33.511	33.71	33.42	33.49	8872423.0
2007-11-12 12:00:00	MSFT	Stock	33.48	33.67	33.38	33.41	7951819.0
2007-11-12 13:00:00	MSFT	Stock	33.4	33.55	33.36	33.39	10164374.0
2007-11-12 14:00:00	MSFT	Stock	33.39	33.7	33.35	33.63	10578347.0
2007-11-12 15:00:00	MSFT	Stock	33.63	33.67	33.35	33.38	18911298.0
2007-11-12 16:00:00	MSFT	Stock	33.38	33.492	33.163	33.29	3706853.0
2007-11-12 17:00:00	MSFT	Stock	33.506	33.506	33.27	33.3	13700.0
2007-11-12 18:00:00	MSFT	Stock	33.32	33.4	33.27	33.31	129497.0
2007-11-12 19:00:00	MSFT	Stock	33.31	33.38	33.3	33.3	7166.0
2007-11-12 08:00:00	NVDA	Stock	0.8388	0.84	0.834	0.8363	684000.0
2007-11-12 09:00:00	NVDA	Stock	0.8363	0.8398	0.8205	0.8302	48206960.0
2007-11-12 10:00:00	NVDA	Stock	0.8298	0.83	0.8028	0.8045	99793440.0
2007-11-12 11:00:00	NVDA	Stock	0.8043	0.807	0.7755	0.7828	116477560.0
2007-11-12 12:00:00	NVDA	Stock	0.7825	0.788	0.7772	0.7825	75563600.0
2007-11-12 13:00:00	NVDA	Stock	0.7828	0.789	0.778	0.78	68715280.0
2007-11-12 14:00:00	NVDA	Stock	0.78	0.7825	0.7702	0.7755	94956600.0
2007-11-12 15:00:00	NVDA	Stock	0.7755	0.7755	0.7508	0.751	165701560.0
2007-11-12 16:00:00	NVDA	Stock	0.751	0.7862	0.7508	0.756	43773840.0
2007-11-12 17:00:00	NVDA	Stock	0.7777	0.7862	0.7508	0.7525	1511440.0
2007-11-12 18:00:00	NVDA	Stock	0.7593	0.7593	0.7515	0.7515	36000.0
2007-11-12 19:00:00	NVDA	Stock	0.755	0.7575	0.75	0.7503	308800.0
2007-11-12 08:00:00	AMZN	Stock	3.9125	3.9445	3.9125	3.9365	148600.0
2007-11-12 09:00:00	AMZN	Stock	3.9275	3.9975	3.863	3.945	26361240.0
2007-11-12 10:00:00	AMZN	Stock	3.945	3.988	3.885	3.9555	25913880.0
2007-11-12 11:00:00	AMZN	Stock	3.9555	3.9995	3.9433	3.9695	15339200.0
2007-11-12 12:00:00	AMZN	Stock	3.97	4.0045	3.9465	3.953	14550360.0
2007-11-12 13:00:00	AMZN	Stock	3.9535	3.966	3.8925	3.905	23658080.0
2007-11-12 14:00:00	AMZN	Stock	3.905	3.9105	3.8495	3.9025	26857880.0

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

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