PREVIEW / stock_1hour / 2006-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-24.parquet
  size:    604 KB
  rows:    28,613
  symbols: 2,272

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-05-24 06:00:00	AAPL	Stock	2.25	2.25	2.25	2.25	56000.0
2006-05-24 07:00:00	AAPL	Stock	2.25	2.25	2.2464	2.2464	14000.0
2006-05-24 08:00:00	AAPL	Stock	2.2504	2.2657	2.2504	2.2643	1872276.0
2006-05-24 09:00:00	AAPL	Stock	2.2636	2.2643	2.2143	2.2611	145295500.0
2006-05-24 10:00:00	AAPL	Stock	2.2607	2.2732	2.2504	2.2596	132160616.0
2006-05-24 11:00:00	AAPL	Stock	2.2593	2.2596	2.2375	2.2524	97754328.0
2006-05-24 12:00:00	AAPL	Stock	2.2521	2.2564	2.2243	2.2289	79298716.0
2006-05-24 13:00:00	AAPL	Stock	2.2289	2.2329	2.1986	2.2269	131081048.0
2006-05-24 14:00:00	AAPL	Stock	2.2268	2.2464	2.2143	2.2432	146462400.0
2006-05-24 15:00:00	AAPL	Stock	2.2432	2.2679	2.2246	2.2605	152552176.0
2006-05-24 16:00:00	AAPL	Stock	2.2593	2.2704	2.2582	2.2661	4502652.0
2006-05-24 17:00:00	AAPL	Stock	2.2664	2.2689	2.2664	2.2679	153020.0
2006-05-24 18:00:00	AAPL	Stock	2.2679	2.2704	2.2661	2.2689	219212.0
2006-05-24 07:00:00	MSFT	Stock	22.67	22.67	22.64	22.67	3400.0
2006-05-24 08:00:00	MSFT	Stock	22.83	22.99	22.79	22.89	258680.0
2006-05-24 09:00:00	MSFT	Stock	22.94	23.38	22.9	23.33	16944853.0
2006-05-24 10:00:00	MSFT	Stock	23.33	23.48	23.31	23.35	21210468.0
2006-05-24 11:00:00	MSFT	Stock	23.35	23.41	23.19	23.29	12348968.0
2006-05-24 12:00:00	MSFT	Stock	23.29	23.405	23.26	23.31	9051414.0
2006-05-24 13:00:00	MSFT	Stock	23.31	23.4	23.23	23.37	9387143.0
2006-05-24 14:00:00	MSFT	Stock	23.38	23.51	23.3	23.43	14019638.0
2006-05-24 15:00:00	MSFT	Stock	23.43	23.54	23.33	23.5	20699781.0
2006-05-24 16:00:00	MSFT	Stock	23.49	23.53	23.34	23.49	689845.0
2006-05-24 17:00:00	MSFT	Stock	23.5	23.53	23.49	23.51	20479.0
2006-05-24 18:00:00	MSFT	Stock	23.52	23.55	23.51	23.55	19880.0
2006-05-24 06:00:00	NVDA	Stock	0.3955	0.3955	0.3955	0.3955	6000.0
2006-05-24 08:00:00	NVDA	Stock	0.3968	0.3992	0.3958	0.3962	184500.0
2006-05-24 09:00:00	NVDA	Stock	0.397	0.41	0.3967	0.4087	92547780.0
2006-05-24 10:00:00	NVDA	Stock	0.4087	0.4127	0.3973	0.3977	107227260.0
2006-05-24 11:00:00	NVDA	Stock	0.3977	0.4072	0.3948	0.4007	67227360.0
2006-05-24 12:00:00	NVDA	Stock	0.4005	0.4018	0.3943	0.3952	45072900.0
2006-05-24 13:00:00	NVDA	Stock	0.3952	0.3977	0.3902	0.3949	78351360.0
2006-05-24 14:00:00	NVDA	Stock	0.395	0.4025	0.3945	0.4012	72866160.0
2006-05-24 15:00:00	NVDA	Stock	0.4012	0.4037	0.397	0.4008	100003860.0
2006-05-24 16:00:00	NVDA	Stock	0.4002	0.4008	0.4002	0.4008	113100.0
2006-05-24 17:00:00	NVDA	Stock	0.4	0.4017	0.4	0.4005	174240.0
2006-05-24 18:00:00	NVDA	Stock	0.4	0.4023	0.4	0.4023	177120.0
2006-05-24 08:00:00	AMZN	Stock	1.675	1.6755	1.6625	1.67	431000.0
2006-05-24 09:00:00	AMZN	Stock	1.666	1.7255	1.663	1.715	24095960.0
2006-05-24 10:00:00	AMZN	Stock	1.715	1.746	1.709	1.7155	31155880.0
2006-05-24 11:00:00	AMZN	Stock	1.7145	1.726	1.697	1.726	15347820.0
2006-05-24 12:00:00	AMZN	Stock	1.726	1.732	1.695	1.7045	14951840.0
2006-05-24 13:00:00	AMZN	Stock	1.7045	1.7235	1.694	1.714	19662460.0
2006-05-24 14:00:00	AMZN	Stock	1.714	1.7455	1.71	1.737	33091200.0
2006-05-24 15:00:00	AMZN	Stock	1.7365	1.7615	1.7285	1.759	41784380.0
2006-05-24 16:00:00	AMZN	Stock	1.758	1.758	1.75	1.75	110400.0
2006-05-24 17:00:00	AMZN	Stock	1.7595	1.7595	1.7585	1.759	52360.0
2006-05-24 18:00:00	AMZN	Stock	1.759	1.759	1.759	1.759	18220.0
2006-05-24 09:00:00	CL	Stock	29.76	29.83	29.595	29.775	698800.0
2006-05-24 10:00:00	CL	Stock	29.78	29.825	29.675	29.775	1098000.0

> showing 50 of 28,613 rows — these rows as CSV

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