PREVIEW / stock_1hour / 2008-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-16.parquet
  size:    818 KB
  rows:    40,713
  symbols: 3,260

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-01-16 04:00:00	AAPL	Stock	5.7893	5.8032	5.7893	5.7936	12600.0
2008-01-16 05:00:00	AAPL	Stock	5.8036	5.8161	5.7914	5.8161	25200.0
2008-01-16 06:00:00	AAPL	Stock	5.815	5.815	5.8018	5.8071	191128.0
2008-01-16 07:00:00	AAPL	Stock	5.8125	5.9071	5.8	5.8889	2146088.0
2008-01-16 08:00:00	AAPL	Stock	5.8793	5.8929	5.8468	5.8786	8712900.0
2008-01-16 09:00:00	AAPL	Stock	5.8757	6.0361	5.8682	5.8843	275997624.0
2008-01-16 10:00:00	AAPL	Stock	5.8836	5.9129	5.5964	5.6679	446585916.0
2008-01-16 11:00:00	AAPL	Stock	5.6682	5.8004	5.6657	5.79	338564996.0
2008-01-16 12:00:00	AAPL	Stock	5.7896	5.8821	5.7411	5.8086	242753672.0
2008-01-16 13:00:00	AAPL	Stock	5.8082	5.8257	5.7218	5.7704	176870904.0
2008-01-16 14:00:00	AAPL	Stock	5.7704	6.0357	5.7336	5.8314	339961944.0
2008-01-16 15:00:00	AAPL	Stock	5.8321	5.9029	5.6896	5.7004	356251644.0
2008-01-16 16:00:00	AAPL	Stock	5.7004	5.9512	5.6929	5.6964	22073996.0
2008-01-16 17:00:00	AAPL	Stock	5.6964	5.7842	5.6661	5.6661	3004960.0
2008-01-16 18:00:00	AAPL	Stock	5.6654	5.6771	5.6321	5.6686	1797208.0
2008-01-16 19:00:00	AAPL	Stock	5.6679	5.7079	5.6679	5.6929	1511888.0
2008-01-16 06:00:00	MSFT	Stock	33.15	33.15	33.15	33.15	500.0
2008-01-16 07:00:00	MSFT	Stock	33.03	33.35	33.03	33.25	28500.0
2008-01-16 08:00:00	MSFT	Stock	33.07	33.27	33.02	33.26	138749.0
2008-01-16 09:00:00	MSFT	Stock	33.27	33.65	33.03	33.21	14033691.0
2008-01-16 10:00:00	MSFT	Stock	33.22	33.26	32.51	32.85	21935594.0
2008-01-16 11:00:00	MSFT	Stock	32.854	33.17	32.71	33.07	12854884.0
2008-01-16 12:00:00	MSFT	Stock	33.08	33.215	33.002	33.06	9465810.0
2008-01-16 13:00:00	MSFT	Stock	33.06	33.12	32.87	32.99	9038745.0
2008-01-16 14:00:00	MSFT	Stock	32.99	33.4	32.87	33.04	14209553.0
2008-01-16 15:00:00	MSFT	Stock	33.04	33.46	33.02	33.21	25688370.0
2008-01-16 16:00:00	MSFT	Stock	33.21	75.0	33.058	33.25	13103795.0
2008-01-16 17:00:00	MSFT	Stock	33.23	33.25	33.2	33.23	3650.0
2008-01-16 18:00:00	MSFT	Stock	33.25	33.25	33.23	33.25	800.0
2008-01-16 19:00:00	MSFT	Stock	33.25	33.34	33.25	33.34	2300.0
2008-01-16 07:00:00	NVDA	Stock	0.6325	0.6325	0.6225	0.6225	12000.0
2008-01-16 08:00:00	NVDA	Stock	0.6315	0.6375	0.6205	0.625	1201320.0
2008-01-16 09:00:00	NVDA	Stock	0.6295	0.6375	0.6118	0.6183	158940400.0
2008-01-16 10:00:00	NVDA	Stock	0.6183	0.6188	0.579	0.5915	263025120.0
2008-01-16 11:00:00	NVDA	Stock	0.5912	0.6053	0.587	0.6035	167741600.0
2008-01-16 12:00:00	NVDA	Stock	0.6035	0.622	0.6033	0.6188	184583680.0
2008-01-16 13:00:00	NVDA	Stock	0.6188	0.619	0.5963	0.5973	140527520.0
2008-01-16 14:00:00	NVDA	Stock	0.5973	0.6075	0.5938	0.5968	194605680.0
2008-01-16 15:00:00	NVDA	Stock	0.5968	0.6043	0.5912	0.5915	300472040.0
2008-01-16 16:00:00	NVDA	Stock	0.5925	0.6268	0.5869	0.5938	49568520.0
2008-01-16 17:00:00	NVDA	Stock	0.595	0.603	0.5938	0.603	5332000.0
2008-01-16 18:00:00	NVDA	Stock	0.5975	0.5975	0.5963	0.5975	119000.0
2008-01-16 19:00:00	NVDA	Stock	0.5985	0.5998	0.5925	0.5925	131640.0
2008-01-16 06:00:00	AMZN	Stock	3.9	3.9	3.9	3.9	6000.0
2008-01-16 07:00:00	AMZN	Stock	3.9	3.9625	3.9	3.9625	34000.0
2008-01-16 08:00:00	AMZN	Stock	3.901	3.95	3.9	3.9495	79100.0
2008-01-16 09:00:00	AMZN	Stock	3.9495	4.1155	3.946	4.044	30629300.0
2008-01-16 10:00:00	AMZN	Stock	4.0445	4.0835	3.922	3.95	48494400.0
2008-01-16 11:00:00	AMZN	Stock	3.9485	4.0645	3.9485	4.0465	30864120.0
2008-01-16 12:00:00	AMZN	Stock	4.0475	4.096	4.0335	4.0696	31010220.0

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

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