PREVIEW / stock_1hour / 2008-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-29.parquet
  size:    842 KB
  rows:    40,426
  symbols: 3,293

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-29 07:00:00	AAPL	Stock	6.6886	6.6886	6.6668	6.6668	30800.0
2008-05-29 08:00:00	AAPL	Stock	6.6782	6.6975	6.6429	6.6489	3630172.0
2008-05-29 09:00:00	AAPL	Stock	6.65	6.6811	6.625	6.6511	80746344.0
2008-05-29 10:00:00	AAPL	Stock	6.6526	6.6925	6.6393	6.6686	145148388.0
2008-05-29 11:00:00	AAPL	Stock	6.6686	6.6911	6.64	6.6761	95695964.0
2008-05-29 12:00:00	AAPL	Stock	6.6761	6.7179	6.6636	6.7029	77883736.0
2008-05-29 13:00:00	AAPL	Stock	6.7036	6.7175	6.6786	6.6939	61843712.0
2008-05-29 14:00:00	AAPL	Stock	6.6954	6.7214	6.6725	6.6854	85365532.0
2008-05-29 15:00:00	AAPL	Stock	6.6854	6.6946	6.6611	6.6664	81729592.0
2008-05-29 16:00:00	AAPL	Stock	6.6816	6.6857	6.6654	6.6821	10568264.0
2008-05-29 17:00:00	AAPL	Stock	6.6818	6.6882	6.6789	6.6821	857920.0
2008-05-29 18:00:00	AAPL	Stock	6.685	6.6871	6.6768	6.6786	290220.0
2008-05-29 19:00:00	AAPL	Stock	6.6786	6.6807	6.675	6.675	128436.0
2008-05-29 08:00:00	MSFT	Stock	28.23	28.29	28.22	28.24	17838.0
2008-05-29 09:00:00	MSFT	Stock	28.24	28.49	28.14	28.49	3972125.0
2008-05-29 10:00:00	MSFT	Stock	28.49	28.54	28.31	28.47	8228581.0
2008-05-29 11:00:00	MSFT	Stock	28.48	28.56	28.37	28.49	5274970.0
2008-05-29 12:00:00	MSFT	Stock	28.49	28.67	28.46	28.64	4507750.0
2008-05-29 13:00:00	MSFT	Stock	28.64	28.68	28.51	28.55	4813425.0
2008-05-29 14:00:00	MSFT	Stock	28.55	28.61	28.36	28.412	6686006.0
2008-05-29 15:00:00	MSFT	Stock	28.41	28.43	28.25	28.26	11681012.0
2008-05-29 16:00:00	MSFT	Stock	28.27	28.48	28.26	28.43	1663151.0
2008-05-29 17:00:00	MSFT	Stock	28.45	28.5	28.4	28.5	67335.0
2008-05-29 18:00:00	MSFT	Stock	28.49	28.5	28.45	28.45	9219.0
2008-05-29 19:00:00	MSFT	Stock	28.45	28.48	28.4	28.42	9365.0
2008-05-29 20:00:00	MSFT	Stock	28.31	28.31	28.31	28.31	3700.0
2008-05-29 08:00:00	NVDA	Stock	0.5908	0.5938	0.588	0.588	115960.0
2008-05-29 09:00:00	NVDA	Stock	0.59	0.5908	0.5802	0.5805	43445760.0
2008-05-29 10:00:00	NVDA	Stock	0.5805	0.5845	0.5772	0.5802	122809760.0
2008-05-29 11:00:00	NVDA	Stock	0.5805	0.582	0.5772	0.5798	86508600.0
2008-05-29 12:00:00	NVDA	Stock	0.58	0.5832	0.5782	0.5825	65047440.0
2008-05-29 13:00:00	NVDA	Stock	0.5825	0.5853	0.5818	0.5828	69215240.0
2008-05-29 14:00:00	NVDA	Stock	0.5828	0.59	0.5828	0.5843	155286600.0
2008-05-29 15:00:00	NVDA	Stock	0.5843	0.5885	0.5832	0.5875	121844640.0
2008-05-29 16:00:00	NVDA	Stock	0.588	0.6058	0.5833	0.5978	9800840.0
2008-05-29 17:00:00	NVDA	Stock	0.5975	0.6	0.5975	0.5975	2740080.0
2008-05-29 18:00:00	NVDA	Stock	0.5965	0.597	0.5963	0.5963	69200.0
2008-05-29 19:00:00	NVDA	Stock	0.596	0.5963	0.5952	0.5952	96000.0
2008-05-29 20:00:00	NVDA	Stock	0.588	0.588	0.588	0.588	2220000.0
2008-05-29 09:00:00	AMZN	Stock	3.995	4.098	3.995	4.093	27252020.0
2008-05-29 10:00:00	AMZN	Stock	4.093	4.0955	4.015	4.0245	34421060.0
2008-05-29 11:00:00	AMZN	Stock	4.0245	4.058	4.016	4.0465	14014900.0
2008-05-29 12:00:00	AMZN	Stock	4.048	4.055	4.0425	4.0495	10623620.0
2008-05-29 13:00:00	AMZN	Stock	4.0493	4.0605	4.0245	4.0245	15283180.0
2008-05-29 14:00:00	AMZN	Stock	4.0245	4.058	4.0235	4.0315	12056180.0
2008-05-29 15:00:00	AMZN	Stock	4.0305	4.0375	4.0085	4.0175	16347380.0
2008-05-29 16:00:00	AMZN	Stock	4.0195	4.0492	4.004	4.0165	2599100.0
2008-05-29 17:00:00	AMZN	Stock	4.034	4.034	4.034	4.034	300000.0
2008-05-29 18:00:00	AMZN	Stock	4.025	4.025	4.025	4.025	9000.0
2008-05-29 08:00:00	TLT	Stock	90.3	90.3	89.85	89.85	1200.0

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

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