PREVIEW / stock_1hour / 2008-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-26.parquet
  size:    799 KB
  rows:    40,029
  symbols: 3,289

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-26 05:00:00	AAPL	Stock	5.02	5.0357	5.02	5.0357	5600.0
2008-03-26 06:00:00	AAPL	Stock	5.0493	5.0493	5.0493	5.0493	2800.0
2008-03-26 07:00:00	AAPL	Stock	5.0407	5.0464	5.0093	5.0146	212800.0
2008-03-26 08:00:00	AAPL	Stock	5.0146	5.035	4.9993	5.0046	10143728.0
2008-03-26 09:00:00	AAPL	Stock	5.0011	5.1122	5.0	5.0764	149580844.0
2008-03-26 10:00:00	AAPL	Stock	5.0757	5.1596	5.0646	5.1593	234845268.0
2008-03-26 11:00:00	AAPL	Stock	5.1582	5.1836	5.1357	5.1618	154548716.0
2008-03-26 12:00:00	AAPL	Stock	5.1607	5.1864	5.1436	5.1839	109195520.0
2008-03-26 13:00:00	AAPL	Stock	5.1839	5.2043	5.1457	5.1564	129979724.0
2008-03-26 14:00:00	AAPL	Stock	5.1561	5.1961	5.1261	5.1946	141455748.0
2008-03-26 15:00:00	AAPL	Stock	5.195	5.205	5.1425	5.1843	197932112.0
2008-03-26 16:00:00	AAPL	Stock	5.1807	5.1964	5.035	5.1321	26213992.0
2008-03-26 17:00:00	AAPL	Stock	5.1321	5.1807	5.1196	5.125	11943484.0
2008-03-26 18:00:00	AAPL	Stock	5.125	5.1782	5.1179	5.1189	620088.0
2008-03-26 19:00:00	AAPL	Stock	5.1182	5.1321	5.1182	5.1321	170716.0
2008-03-26 07:00:00	MSFT	Stock	29.07	29.07	29.06	29.06	1700.0
2008-03-26 08:00:00	MSFT	Stock	29.04	29.14	28.99	29.08	690941.0
2008-03-26 09:00:00	MSFT	Stock	29.1	29.15	28.81	28.86	3231713.0
2008-03-26 10:00:00	MSFT	Stock	28.86	28.9	28.51	28.6	9470373.0
2008-03-26 11:00:00	MSFT	Stock	28.6	28.6	28.38	28.42	6497070.0
2008-03-26 12:00:00	MSFT	Stock	28.43	28.51	28.42	28.442	3036016.0
2008-03-26 13:00:00	MSFT	Stock	28.45	28.47	28.39	28.44	4263171.0
2008-03-26 14:00:00	MSFT	Stock	28.448	28.67	28.42	28.67	4942217.0
2008-03-26 15:00:00	MSFT	Stock	28.67	28.69	28.42	28.56	9666568.0
2008-03-26 16:00:00	MSFT	Stock	28.58	28.701	28.06	28.3	2032413.0
2008-03-26 17:00:00	MSFT	Stock	28.29	28.57	28.27	28.3	1100729.0
2008-03-26 18:00:00	MSFT	Stock	28.487	28.487	28.27	28.3	9887.0
2008-03-26 19:00:00	MSFT	Stock	28.3	28.31	28.27	28.27	3552.0
2008-03-26 06:00:00	NVDA	Stock	0.508	0.508	0.508	0.508	4000.0
2008-03-26 08:00:00	NVDA	Stock	0.5072	0.5072	0.5	0.5	4714200.0
2008-03-26 09:00:00	NVDA	Stock	0.5013	0.5048	0.4862	0.4932	88536120.0
2008-03-26 10:00:00	NVDA	Stock	0.4935	0.4965	0.4875	0.491	135126000.0
2008-03-26 11:00:00	NVDA	Stock	0.491	0.4967	0.49	0.4945	100576040.0
2008-03-26 12:00:00	NVDA	Stock	0.4948	0.4952	0.4915	0.4942	60407600.0
2008-03-26 13:00:00	NVDA	Stock	0.4944	0.4945	0.4905	0.4905	91995840.0
2008-03-26 14:00:00	NVDA	Stock	0.4905	0.494	0.4892	0.494	91683800.0
2008-03-26 15:00:00	NVDA	Stock	0.494	0.495	0.49	0.4915	132043680.0
2008-03-26 16:00:00	NVDA	Stock	0.4915	0.4938	0.485	0.4862	14638960.0
2008-03-26 17:00:00	NVDA	Stock	0.4862	0.4927	0.4862	0.4883	227640.0
2008-03-26 18:00:00	NVDA	Stock	0.4898	0.4925	0.4875	0.4912	163560.0
2008-03-26 19:00:00	NVDA	Stock	0.4912	0.4935	0.4912	0.4935	82520.0
2008-03-26 08:00:00	AMZN	Stock	3.7585	3.7585	3.7495	3.7575	1198500.0
2008-03-26 09:00:00	AMZN	Stock	3.749	3.756	3.6915	3.7105	16322180.0
2008-03-26 10:00:00	AMZN	Stock	3.71	3.732	3.6785	3.7045	14260220.0
2008-03-26 11:00:00	AMZN	Stock	3.704	3.7145	3.6635	3.6715	12477320.0
2008-03-26 12:00:00	AMZN	Stock	3.6715	3.68	3.662	3.673	8978760.0
2008-03-26 13:00:00	AMZN	Stock	3.673	3.6855	3.6625	3.6745	8567500.0
2008-03-26 14:00:00	AMZN	Stock	3.675	3.7115	3.6625	3.7115	15882860.0
2008-03-26 15:00:00	AMZN	Stock	3.7115	3.7185	3.664	3.6945	28121840.0
2008-03-26 16:00:00	AMZN	Stock	3.6945	3.7585	3.67	3.6935	15341640.0

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

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