PREVIEW / stock_1hour / 2007-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-26.parquet
  size:    705 KB
  rows:    32,754
  symbols: 2,614

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
2007-04-26 04:00:00	AAPL	Stock	3.6075	3.6571	3.6075	3.6571	64400.0
2007-04-26 05:00:00	AAPL	Stock	3.6361	3.6368	3.6268	3.6268	24220.0
2007-04-26 06:00:00	AAPL	Stock	3.6286	3.6557	3.6286	3.6475	685496.0
2007-04-26 07:00:00	AAPL	Stock	3.6507	3.7321	3.6507	3.6611	16258312.0
2007-04-26 08:00:00	AAPL	Stock	3.6725	3.6964	3.6268	3.6643	62589716.0
2007-04-26 09:00:00	AAPL	Stock	3.6661	3.6718	3.5489	3.5821	475910288.0
2007-04-26 10:00:00	AAPL	Stock	3.5829	3.63	3.5107	3.5739	376573428.0
2007-04-26 11:00:00	AAPL	Stock	3.5746	3.6121	3.5496	3.5661	165997020.0
2007-04-26 12:00:00	AAPL	Stock	3.5657	3.5832	3.5621	3.5761	110233284.0
2007-04-26 13:00:00	AAPL	Stock	3.5775	3.6279	3.5757	3.605	156333016.0
2007-04-26 14:00:00	AAPL	Stock	3.6046	3.6279	3.5268	3.5911	142796360.0
2007-04-26 15:00:00	AAPL	Stock	3.5907	3.6279	3.5286	3.53	211044484.0
2007-04-26 16:00:00	AAPL	Stock	3.53	3.6246	3.4914	3.5054	11791780.0
2007-04-26 17:00:00	AAPL	Stock	3.5054	3.51	3.5036	3.5068	2359056.0
2007-04-26 18:00:00	AAPL	Stock	3.5068	3.5114	3.5064	3.5089	1150128.0
2007-04-26 19:00:00	AAPL	Stock	3.5071	3.5175	3.5071	3.5143	461412.0
2007-04-26 09:00:00	MSFT	Stock	29.09	29.35	28.91	29.29	8814232.0
2007-04-26 10:00:00	MSFT	Stock	29.29	29.31	29.07	29.11	8163695.0
2007-04-26 11:00:00	MSFT	Stock	29.11	29.24	29.1	29.152	5691597.0
2007-04-26 12:00:00	MSFT	Stock	29.15	29.2	29.1	29.12	4771229.0
2007-04-26 13:00:00	MSFT	Stock	29.12	29.17	29.05	29.13	4340148.0
2007-04-26 14:00:00	MSFT	Stock	29.122	29.22	29.07	29.22	6588668.0
2007-04-26 15:00:00	MSFT	Stock	29.22	29.35	28.17	29.11	15340387.0
2007-04-26 16:00:00	MSFT	Stock	29.1	29.11	29.1	29.1	1084750.0
2007-04-26 08:00:00	NVDA	Stock	0.5555	0.5583	0.5555	0.5567	345000.0
2007-04-26 09:00:00	NVDA	Stock	0.5568	0.5568	0.5477	0.549	46503000.0
2007-04-26 10:00:00	NVDA	Stock	0.549	0.56	0.5468	0.56	121316340.0
2007-04-26 11:00:00	NVDA	Stock	0.56	0.5625	0.558	0.5613	81859860.0
2007-04-26 12:00:00	NVDA	Stock	0.5612	0.5628	0.5583	0.5605	49846440.0
2007-04-26 13:00:00	NVDA	Stock	0.5605	0.562	0.5555	0.5558	54996240.0
2007-04-26 14:00:00	NVDA	Stock	0.556	0.5623	0.5557	0.5602	43666380.0
2007-04-26 15:00:00	NVDA	Stock	0.5602	0.5605	0.5578	0.5585	66109320.0
2007-04-26 16:00:00	NVDA	Stock	0.5585	0.5587	0.5533	0.555	7687380.0
2007-04-26 17:00:00	NVDA	Stock	0.555	0.5587	0.5527	0.5533	7921980.0
2007-04-26 18:00:00	NVDA	Stock	0.555	0.555	0.555	0.555	6000.0
2007-04-26 19:00:00	NVDA	Stock	0.5583	0.5583	0.5548	0.5548	65280.0
2007-04-26 04:00:00	AMZN	Stock	2.847	2.847	2.847	2.847	9860.0
2007-04-26 05:00:00	AMZN	Stock	2.8425	2.8425	2.8425	2.8425	27400.0
2007-04-26 06:00:00	AMZN	Stock	2.8425	2.8425	2.835	2.835	6200.0
2007-04-26 07:00:00	AMZN	Stock	2.8495	2.85	2.841	2.8495	315000.0
2007-04-26 08:00:00	AMZN	Stock	2.849	2.8495	2.82	2.8325	3967760.0
2007-04-26 09:00:00	AMZN	Stock	2.83	2.852	2.8035	2.8315	61326280.0
2007-04-26 10:00:00	AMZN	Stock	2.832	2.9165	2.8315	2.8875	168454180.0
2007-04-26 11:00:00	AMZN	Stock	2.887	2.8965	2.85	2.873	75452980.0
2007-04-26 12:00:00	AMZN	Stock	2.8735	2.9305	2.8625	2.9225	100279500.0
2007-04-26 13:00:00	AMZN	Stock	2.9225	2.9745	2.9065	2.9715	146695180.0
2007-04-26 14:00:00	AMZN	Stock	2.9715	2.9995	2.945	2.988	177436440.0
2007-04-26 15:00:00	AMZN	Stock	2.9875	3.152	2.9865	3.137	478089940.0
2007-04-26 16:00:00	AMZN	Stock	3.1395	3.1475	3.12	3.131	25958360.0
2007-04-26 17:00:00	AMZN	Stock	3.1305	3.143	3.0959	3.14	2170360.0

> showing 50 of 32,754 rows — these rows as CSV

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