PREVIEW / stock_1hour / 2006-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-08.parquet
  size:    633 KB
  rows:    30,495
  symbols: 2,420

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
2006-11-08 07:00:00	AAPL	Stock	2.8764	2.8764	2.8586	2.8586	36400.0
2006-11-08 08:00:00	AAPL	Stock	2.8675	2.8714	2.8543	2.855	1266244.0
2006-11-08 09:00:00	AAPL	Stock	2.855	2.8864	2.8507	2.8818	74773944.0
2006-11-08 10:00:00	AAPL	Stock	2.8818	2.9029	2.8804	2.8979	112570696.0
2006-11-08 11:00:00	AAPL	Stock	2.8975	2.8996	2.8793	2.8882	47685064.0
2006-11-08 12:00:00	AAPL	Stock	2.8882	2.9075	2.8882	2.9039	73039764.0
2006-11-08 13:00:00	AAPL	Stock	2.9036	2.9286	2.9036	2.9264	124237064.0
2006-11-08 14:00:00	AAPL	Stock	2.9264	2.9321	2.9168	2.93	86792804.0
2006-11-08 15:00:00	AAPL	Stock	2.93	2.9532	2.9232	2.9429	139142640.0
2006-11-08 16:00:00	AAPL	Stock	2.945	2.9521	2.9429	2.9446	13932968.0
2006-11-08 17:00:00	AAPL	Stock	2.9464	2.9518	2.9425	2.9457	2702280.0
2006-11-08 18:00:00	AAPL	Stock	2.95	2.9564	2.9482	2.9564	491148.0
2006-11-08 19:00:00	AAPL	Stock	2.9564	2.9607	2.9539	2.9607	182336.0
2006-11-08 07:00:00	MSFT	Stock	28.9	28.9	28.85	28.85	200.0
2006-11-08 08:00:00	MSFT	Stock	28.82	29.24	28.82	28.85	52362.0
2006-11-08 09:00:00	MSFT	Stock	28.87	28.87	28.66	28.82	9661672.0
2006-11-08 10:00:00	MSFT	Stock	28.81	28.89	28.78	28.85	6870807.0
2006-11-08 11:00:00	MSFT	Stock	28.85	28.87	28.77	28.86	4767958.0
2006-11-08 12:00:00	MSFT	Stock	28.86	28.92	28.82	28.86	4526829.0
2006-11-08 13:00:00	MSFT	Stock	28.862	29.03	28.84	29.02	8141262.0
2006-11-08 14:00:00	MSFT	Stock	29.02	29.23	28.95	29.05	26170186.0
2006-11-08 15:00:00	MSFT	Stock	29.05	29.13	28.96	28.99	10270508.0
2006-11-08 16:00:00	MSFT	Stock	28.99	29.16	28.95	29.09	1205775.0
2006-11-08 17:00:00	MSFT	Stock	29.09	29.25	29.09	29.23	118381.0
2006-11-08 18:00:00	MSFT	Stock	29.2	29.2	28.98	29.2	1741067.0
2006-11-08 19:00:00	MSFT	Stock	29.16	29.18	29.14	29.15	8869.0
2006-11-08 08:00:00	NVDA	Stock	0.565	0.5652	0.5625	0.5642	238500.0
2006-11-08 09:00:00	NVDA	Stock	0.5642	0.5733	0.563	0.5727	61707180.0
2006-11-08 10:00:00	NVDA	Stock	0.573	0.58	0.5717	0.5723	117210780.0
2006-11-08 11:00:00	NVDA	Stock	0.5722	0.5742	0.569	0.5693	48891720.0
2006-11-08 12:00:00	NVDA	Stock	0.5693	0.5713	0.566	0.5678	72498060.0
2006-11-08 13:00:00	NVDA	Stock	0.5675	0.578	0.5665	0.5763	60231360.0
2006-11-08 14:00:00	NVDA	Stock	0.5765	0.5832	0.574	0.5827	144031200.0
2006-11-08 15:00:00	NVDA	Stock	0.5828	0.5837	0.5767	0.5767	119503080.0
2006-11-08 16:00:00	NVDA	Stock	0.5768	0.5812	0.5765	0.5812	3838620.0
2006-11-08 17:00:00	NVDA	Stock	0.5812	0.5825	0.5812	0.5825	731040.0
2006-11-08 18:00:00	NVDA	Stock	0.5817	0.583	0.5792	0.583	599340.0
2006-11-08 19:00:00	NVDA	Stock	0.5832	0.5833	0.5817	0.5817	311100.0
2006-11-08 07:00:00	AMZN	Stock	1.93	1.93	1.92	1.925	26000.0
2006-11-08 08:00:00	AMZN	Stock	1.92	1.928	1.92	1.925	182420.0
2006-11-08 09:00:00	AMZN	Stock	1.9295	1.9475	1.923	1.9435	14703160.0
2006-11-08 10:00:00	AMZN	Stock	1.944	1.9565	1.9325	1.9517	27221360.0
2006-11-08 11:00:00	AMZN	Stock	1.9515	1.955	1.932	1.9385	16149960.0
2006-11-08 12:00:00	AMZN	Stock	1.938	1.95	1.9345	1.947	14385840.0
2006-11-08 13:00:00	AMZN	Stock	1.947	1.968	1.9375	1.963	22962320.0
2006-11-08 14:00:00	AMZN	Stock	1.9625	1.969	1.9565	1.968	28679320.0
2006-11-08 15:00:00	AMZN	Stock	1.9675	1.974	1.9645	1.974	35209240.0
2006-11-08 16:00:00	AMZN	Stock	1.973	1.9835	1.9725	1.9755	161340.0
2006-11-08 17:00:00	AMZN	Stock	1.98	1.994	1.98	1.982	112000.0
2006-11-08 18:00:00	AMZN	Stock	1.982	1.982	1.972	1.978	147040.0

> showing 50 of 30,495 rows — these rows as CSV

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