PREVIEW / stock_1hour / 2008-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-21.parquet
  size:    813 KB
  rows:    39,753
  symbols: 3,286

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-21 04:00:00	AAPL	Stock	5.7693	5.7693	5.7618	5.7618	5600.0
2008-04-21 05:00:00	AAPL	Stock	5.7889	5.7921	5.7889	5.7921	11172.0
2008-04-21 06:00:00	AAPL	Stock	5.7793	5.7793	5.7711	5.775	54600.0
2008-04-21 07:00:00	AAPL	Stock	5.775	5.8036	5.7571	5.7857	606452.0
2008-04-21 08:00:00	AAPL	Stock	5.7929	5.8214	5.7821	5.79	8205792.0
2008-04-21 09:00:00	AAPL	Stock	5.7875	5.8732	5.7771	5.8604	150746960.0
2008-04-21 10:00:00	AAPL	Stock	5.8607	5.8636	5.8071	5.8164	151467624.0
2008-04-21 11:00:00	AAPL	Stock	5.8164	5.8468	5.8143	5.8407	83145216.0
2008-04-21 12:00:00	AAPL	Stock	5.8407	5.8821	5.8361	5.8775	104839560.0
2008-04-21 13:00:00	AAPL	Stock	5.8771	5.8921	5.8664	5.8782	86703848.0
2008-04-21 14:00:00	AAPL	Stock	5.8789	5.9425	5.8646	5.9375	143274796.0
2008-04-21 15:00:00	AAPL	Stock	5.9371	6.0179	5.9345	6.0057	276044104.0
2008-04-21 16:00:00	AAPL	Stock	6.0037	6.0058	5.8919	5.9786	13955396.0
2008-04-21 17:00:00	AAPL	Stock	5.9821	5.9943	5.8734	5.9882	1351476.0
2008-04-21 18:00:00	AAPL	Stock	5.9857	5.9875	5.9786	5.9789	393400.0
2008-04-21 19:00:00	AAPL	Stock	5.9846	5.985	5.9764	5.9768	314580.0
2008-04-21 07:00:00	MSFT	Stock	30.03	30.1	30.0	30.1	4710.0
2008-04-21 08:00:00	MSFT	Stock	30.15	30.5	30.0	30.31	295792.0
2008-04-21 09:00:00	MSFT	Stock	30.32	30.43	30.12	30.4	7630033.0
2008-04-21 10:00:00	MSFT	Stock	30.4	30.47	30.22	30.42	10382594.0
2008-04-21 11:00:00	MSFT	Stock	30.42	30.6	30.4	30.43	8621128.0
2008-04-21 12:00:00	MSFT	Stock	30.43	30.48	30.35	30.44	4543266.0
2008-04-21 13:00:00	MSFT	Stock	30.441	30.49	30.3	30.32	5699711.0
2008-04-21 14:00:00	MSFT	Stock	30.31	30.465	30.28	30.34	4703938.0
2008-04-21 15:00:00	MSFT	Stock	30.34	30.52	30.3	30.41	9748820.0
2008-04-21 16:00:00	MSFT	Stock	30.42	30.46	30.35	30.43	1620812.0
2008-04-21 17:00:00	MSFT	Stock	30.43	30.6	30.38	30.55	156565.0
2008-04-21 18:00:00	MSFT	Stock	30.55	30.59	30.55	30.57	31318.0
2008-04-21 19:00:00	MSFT	Stock	30.57	30.59	30.55	30.58	12681.0
2008-04-21 08:00:00	NVDA	Stock	0.4755	0.4758	0.4748	0.4748	41800.0
2008-04-21 09:00:00	NVDA	Stock	0.475	0.4835	0.4685	0.4815	40361080.0
2008-04-21 10:00:00	NVDA	Stock	0.4815	0.4875	0.4808	0.485	107860720.0
2008-04-21 11:00:00	NVDA	Stock	0.485	0.491	0.4848	0.4908	101306760.0
2008-04-21 12:00:00	NVDA	Stock	0.4906	0.4912	0.4892	0.4902	77387120.0
2008-04-21 13:00:00	NVDA	Stock	0.4902	0.4958	0.49	0.4931	73843440.0
2008-04-21 14:00:00	NVDA	Stock	0.4931	0.4988	0.4926	0.4982	91599480.0
2008-04-21 15:00:00	NVDA	Stock	0.4982	0.5	0.4965	0.4975	162442240.0
2008-04-21 16:00:00	NVDA	Stock	0.4978	0.4988	0.4914	0.4952	8042760.0
2008-04-21 17:00:00	NVDA	Stock	0.494	0.4955	0.4914	0.4955	2224480.0
2008-04-21 18:00:00	NVDA	Stock	0.494	0.494	0.494	0.494	4680.0
2008-04-21 19:00:00	NVDA	Stock	0.4955	0.4955	0.4955	0.4955	26000.0
2008-04-21 08:00:00	AMZN	Stock	4.0	4.0625	3.9775	4.0325	228420.0
2008-04-21 09:00:00	AMZN	Stock	4.0325	4.067	3.965	4.0495	33650400.0
2008-04-21 10:00:00	AMZN	Stock	4.0495	4.0495	3.9605	3.963	35036120.0
2008-04-21 11:00:00	AMZN	Stock	3.9625	4.0075	3.953	3.9945	19313320.0
2008-04-21 12:00:00	AMZN	Stock	3.9955	4.016	3.9775	3.9845	16534380.0
2008-04-21 13:00:00	AMZN	Stock	3.984	4.028	3.98	3.992	18781660.0
2008-04-21 14:00:00	AMZN	Stock	3.992	3.9975	3.9625	3.9855	21922440.0
2008-04-21 15:00:00	AMZN	Stock	3.986	4.0245	3.9815	4.008	37653700.0
2008-04-21 16:00:00	AMZN	Stock	4.009	4.015	3.997	3.997	2635080.0

> showing 50 of 39,753 rows — these rows as CSV

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