PREVIEW / stock_1hour / 2008-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-21.parquet
  size:    847 KB
  rows:    40,487
  symbols: 3,309

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-05-21 05:00:00	AAPL	Stock	6.64	6.64	6.64	6.64	2800.0
2008-05-21 06:00:00	AAPL	Stock	6.6393	6.6393	6.6393	6.6393	2800.0
2008-05-21 07:00:00	AAPL	Stock	6.6182	6.6182	6.5929	6.6071	99120.0
2008-05-21 08:00:00	AAPL	Stock	6.6193	6.6318	6.6071	6.6239	1698228.0
2008-05-21 09:00:00	AAPL	Stock	6.6236	6.7125	6.6214	6.6854	102276188.0
2008-05-21 10:00:00	AAPL	Stock	6.6861	6.7107	6.5714	6.5918	162036840.0
2008-05-21 11:00:00	AAPL	Stock	6.5914	6.6107	6.5446	6.5725	111488748.0
2008-05-21 12:00:00	AAPL	Stock	6.5721	6.6021	6.5393	6.5982	75249916.0
2008-05-21 13:00:00	AAPL	Stock	6.5986	6.6057	6.5036	6.5079	97140736.0
2008-05-21 14:00:00	AAPL	Stock	6.5082	6.5089	6.3289	6.415	323998780.0
2008-05-21 15:00:00	AAPL	Stock	6.4161	6.7143	6.2946	6.3671	250694892.0
2008-05-21 16:00:00	AAPL	Stock	6.3639	6.6393	6.3639	6.3768	18813032.0
2008-05-21 17:00:00	AAPL	Stock	6.3771	6.3782	6.3686	6.3686	501508.0
2008-05-21 18:00:00	AAPL	Stock	6.3696	6.3746	6.3639	6.3714	337680.0
2008-05-21 19:00:00	AAPL	Stock	6.37	6.3807	6.3679	6.3757	379176.0
2008-05-21 05:00:00	MSFT	Stock	29.01	29.01	29.01	29.01	1000.0
2008-05-21 07:00:00	MSFT	Stock	29.07	29.07	28.9	28.9	5760.0
2008-05-21 08:00:00	MSFT	Stock	28.85	28.96	28.76	28.9	847191.0
2008-05-21 09:00:00	MSFT	Stock	28.95	29.05	28.65	28.78	5842412.0
2008-05-21 10:00:00	MSFT	Stock	28.77	28.9	28.67	28.78	8064936.0
2008-05-21 11:00:00	MSFT	Stock	28.78	28.88	28.71	28.78	3941069.0
2008-05-21 12:00:00	MSFT	Stock	28.775	28.95	28.76	28.94	3725421.0
2008-05-21 13:00:00	MSFT	Stock	28.948	28.95	28.62	28.68	7491885.0
2008-05-21 14:00:00	MSFT	Stock	28.68	28.68	28.27	28.38	12744851.0
2008-05-21 15:00:00	MSFT	Stock	28.39	28.44	28.19	28.23	13449633.0
2008-05-21 16:00:00	MSFT	Stock	28.26	28.76	28.24	28.39	2746970.0
2008-05-21 17:00:00	MSFT	Stock	28.37	28.39	28.31	28.38	14625.0
2008-05-21 18:00:00	MSFT	Stock	28.38	28.38	28.25	28.28	23670.0
2008-05-21 19:00:00	MSFT	Stock	28.33	28.34	28.27	28.32	5130.0
2008-05-21 08:00:00	NVDA	Stock	0.5822	0.585	0.582	0.5848	720000.0
2008-05-21 09:00:00	NVDA	Stock	0.5838	0.5958	0.5815	0.586	92931600.0
2008-05-21 10:00:00	NVDA	Stock	0.5858	0.589	0.5762	0.581	129975080.0
2008-05-21 11:00:00	NVDA	Stock	0.5812	0.606	0.5788	0.5963	242832120.0
2008-05-21 12:00:00	NVDA	Stock	0.596	0.598	0.5915	0.5948	128924480.0
2008-05-21 13:00:00	NVDA	Stock	0.595	0.5952	0.5863	0.5863	84505000.0
2008-05-21 14:00:00	NVDA	Stock	0.5865	0.5888	0.5775	0.5805	137980200.0
2008-05-21 15:00:00	NVDA	Stock	0.5805	0.5848	0.576	0.5772	195671880.0
2008-05-21 16:00:00	NVDA	Stock	0.5775	0.5876	0.5756	0.5762	3461840.0
2008-05-21 17:00:00	NVDA	Stock	0.5762	0.5772	0.5762	0.577	178800.0
2008-05-21 18:00:00	NVDA	Stock	0.5772	0.5772	0.5772	0.5772	10000.0
2008-05-21 19:00:00	NVDA	Stock	0.5762	0.5762	0.576	0.576	62000.0
2008-05-21 05:00:00	AMZN	Stock	4.05	4.05	4.05	4.05	4000.0
2008-05-21 07:00:00	AMZN	Stock	4.015	4.0175	4.015	4.0175	10000.0
2008-05-21 08:00:00	AMZN	Stock	4.053	4.053	4.03	4.046	33400.0
2008-05-21 09:00:00	AMZN	Stock	4.046	4.0575	4.0	4.005	13896880.0
2008-05-21 10:00:00	AMZN	Stock	4.0038	4.033	3.9875	3.994	24400080.0
2008-05-21 11:00:00	AMZN	Stock	3.9945	3.9945	3.951	3.978	16932340.0
2008-05-21 12:00:00	AMZN	Stock	3.9772	4.0	3.963	3.9912	8933360.0
2008-05-21 13:00:00	AMZN	Stock	3.9915	4.004	3.9615	3.962	14306800.0
2008-05-21 14:00:00	AMZN	Stock	3.9625	3.9625	3.875	3.9105	32209120.0

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

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