PREVIEW / stock_1hour / 2008-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-25.parquet
  size:    817 KB
  rows:    40,847
  symbols: 3,262

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-03-25 07:00:00	AAPL	Stock	4.9961	5.0036	4.9893	4.9989	323316.0
2008-03-25 08:00:00	AAPL	Stock	4.9964	5.0121	4.9814	4.9814	3507140.0
2008-03-25 09:00:00	AAPL	Stock	4.9821	5.0061	4.9368	4.9464	126252560.0
2008-03-25 10:00:00	AAPL	Stock	4.9471	4.9932	4.9046	4.975	189859544.0
2008-03-25 11:00:00	AAPL	Stock	4.9746	5.0193	4.9696	4.995	127635760.0
2008-03-25 12:00:00	AAPL	Stock	4.9946	5.015	4.9857	4.9982	76606292.0
2008-03-25 13:00:00	AAPL	Stock	4.9984	5.0821	4.9939	5.0732	147622720.0
2008-03-25 14:00:00	AAPL	Stock	5.0736	5.0918	5.0507	5.0875	142508940.0
2008-03-25 15:00:00	AAPL	Stock	5.0857	5.1107	5.0271	5.0325	193972436.0
2008-03-25 16:00:00	AAPL	Stock	5.0346	5.0725	4.9625	5.0286	14176484.0
2008-03-25 17:00:00	AAPL	Stock	5.0246	5.0293	5.0218	5.0275	374724.0
2008-03-25 18:00:00	AAPL	Stock	5.0221	5.0268	5.0179	5.0179	159628.0
2008-03-25 19:00:00	AAPL	Stock	5.0179	5.0268	5.0161	5.0161	156632.0
2008-03-25 07:00:00	MSFT	Stock	29.27	29.27	29.27	29.27	400.0
2008-03-25 08:00:00	MSFT	Stock	29.27	29.38	29.25	29.25	30799.0
2008-03-25 09:00:00	MSFT	Stock	29.22	29.37	29.0	29.02	5903052.0
2008-03-25 10:00:00	MSFT	Stock	29.01	29.2	28.94	29.13	8665992.0
2008-03-25 11:00:00	MSFT	Stock	29.12	29.22	29.05	29.07	4769337.0
2008-03-25 12:00:00	MSFT	Stock	29.07	29.27	29.03	29.2	4420874.0
2008-03-25 13:00:00	MSFT	Stock	29.19	29.23	29.11	29.21	4226091.0
2008-03-25 14:00:00	MSFT	Stock	29.2	29.21	29.04	29.135	4245722.0
2008-03-25 15:00:00	MSFT	Stock	29.14	29.25	29.02	29.14	11174797.0
2008-03-25 16:00:00	MSFT	Stock	29.141	29.2	28.98	29.08	4065356.0
2008-03-25 17:00:00	MSFT	Stock	29.003	29.163	29.003	29.05	22219.0
2008-03-25 18:00:00	MSFT	Stock	29.05	29.08	29.05	29.07	24000.0
2008-03-25 19:00:00	MSFT	Stock	29.07	29.14	29.05	29.05	78125.0
2008-03-25 08:00:00	NVDA	Stock	0.5075	0.5078	0.503	0.5072	568120.0
2008-03-25 09:00:00	NVDA	Stock	0.5072	0.5175	0.5008	0.5102	92612520.0
2008-03-25 10:00:00	NVDA	Stock	0.5102	0.5105	0.4982	0.501	141843120.0
2008-03-25 11:00:00	NVDA	Stock	0.5008	0.5055	0.5003	0.505	88195280.0
2008-03-25 12:00:00	NVDA	Stock	0.5053	0.51	0.5043	0.505	122617680.0
2008-03-25 13:00:00	NVDA	Stock	0.5053	0.5093	0.503	0.5078	69832080.0
2008-03-25 14:00:00	NVDA	Stock	0.5078	0.509	0.5025	0.509	77532120.0
2008-03-25 15:00:00	NVDA	Stock	0.509	0.5112	0.5058	0.508	116930880.0
2008-03-25 16:00:00	NVDA	Stock	0.5075	0.5138	0.5065	0.508	15202480.0
2008-03-25 17:00:00	NVDA	Stock	0.507	0.507	0.5062	0.5062	72000.0
2008-03-25 18:00:00	NVDA	Stock	0.5058	0.5058	0.5058	0.5058	8000.0
2008-03-25 19:00:00	NVDA	Stock	0.506	0.5068	0.506	0.5068	56000.0
2008-03-25 08:00:00	AMZN	Stock	3.79	3.79	3.79	3.79	4000.0
2008-03-25 09:00:00	AMZN	Stock	3.789	3.8145	3.734	3.737	22780200.0
2008-03-25 10:00:00	AMZN	Stock	3.737	3.775	3.7025	3.743	26122800.0
2008-03-25 11:00:00	AMZN	Stock	3.7415	3.771	3.7365	3.7415	11341200.0
2008-03-25 12:00:00	AMZN	Stock	3.7415	3.7625	3.731	3.743	10771480.0
2008-03-25 13:00:00	AMZN	Stock	3.7428	3.781	3.7385	3.7805	12126960.0
2008-03-25 14:00:00	AMZN	Stock	3.7805	3.7805	3.7465	3.7675	13703160.0
2008-03-25 15:00:00	AMZN	Stock	3.769	3.7865	3.753	3.758	25568380.0
2008-03-25 16:00:00	AMZN	Stock	3.758	3.7604	3.755	3.7585	3513480.0
2008-03-25 17:00:00	AMZN	Stock	3.7872	3.7872	3.775	3.775	114000.0
2008-03-25 19:00:00	AMZN	Stock	3.755	3.7585	3.755	3.7585	503500.0
2008-03-25 08:00:00	TLT	Stock	95.4	95.4	95.29	95.39	15200.0

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

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