PREVIEW / stock_1hour / 2006-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-20.parquet
  size:    593 KB
  rows:    27,931
  symbols: 2,241

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-04-20 04:00:00	AAPL	Stock	2.4482	2.4482	2.37	2.37	16800.0
2006-04-20 05:00:00	AAPL	Stock	2.4464	2.4464	2.4464	2.4464	2800.0
2006-04-20 06:00:00	AAPL	Stock	2.4625	2.4643	2.4468	2.4468	137200.0
2006-04-20 07:00:00	AAPL	Stock	2.4518	2.4643	2.4246	2.4518	828212.0
2006-04-20 08:00:00	AAPL	Stock	2.4504	2.4929	2.4482	2.4811	40278672.0
2006-04-20 09:00:00	AAPL	Stock	2.4804	2.5	2.4554	2.4736	324123128.0
2006-04-20 10:00:00	AAPL	Stock	2.4736	2.4843	2.4204	2.4346	361913440.0
2006-04-20 11:00:00	AAPL	Stock	2.4346	2.4479	2.4161	2.4232	159565252.0
2006-04-20 12:00:00	AAPL	Stock	2.4232	2.4821	2.4193	2.4296	95986240.0
2006-04-20 13:00:00	AAPL	Stock	2.4296	2.4755	2.3954	2.3975	121265788.0
2006-04-20 14:00:00	AAPL	Stock	2.3975	2.4157	2.3643	2.4043	288886752.0
2006-04-20 15:00:00	AAPL	Stock	2.4043	2.4557	2.4014	2.4154	202628888.0
2006-04-20 16:00:00	AAPL	Stock	2.4132	2.4264	2.4086	2.4143	23057020.0
2006-04-20 17:00:00	AAPL	Stock	2.4143	2.4193	2.4129	2.4182	1392916.0
2006-04-20 18:00:00	AAPL	Stock	2.4179	2.4214	2.4171	2.4211	391804.0
2006-04-20 06:00:00	MSFT	Stock	27.08	27.08	26.99	26.99	1000.0
2006-04-20 07:00:00	MSFT	Stock	27.03	27.03	27.03	27.03	150.0
2006-04-20 08:00:00	MSFT	Stock	27.06	27.1	27.06	27.1	15420.0
2006-04-20 09:00:00	MSFT	Stock	27.08	27.08	26.7	26.96	3940919.0
2006-04-20 10:00:00	MSFT	Stock	26.96	27.19	26.94	27.09	12215598.0
2006-04-20 11:00:00	MSFT	Stock	27.09	27.11	26.97	27.03	6458027.0
2006-04-20 12:00:00	MSFT	Stock	27.03	27.055	26.94	27.05	6552019.0
2006-04-20 13:00:00	MSFT	Stock	27.05	27.09	27.03	27.08	3603972.0
2006-04-20 14:00:00	MSFT	Stock	27.078	27.11	27.04	27.06	3353792.0
2006-04-20 15:00:00	MSFT	Stock	27.061	27.08	27.0	27.07	6075471.0
2006-04-20 16:00:00	MSFT	Stock	27.04	27.05	27.01	27.02	1784828.0
2006-04-20 17:00:00	MSFT	Stock	27.03	27.05	27.02	27.02	305503.0
2006-04-20 18:00:00	MSFT	Stock	27.01	27.03	27.01	27.02	20196.0
2006-04-20 08:00:00	NVDA	Stock	0.4827	0.4827	0.4792	0.4792	213000.0
2006-04-20 09:00:00	NVDA	Stock	0.4808	0.4825	0.4737	0.478	105093660.0
2006-04-20 10:00:00	NVDA	Stock	0.478	0.494	0.478	0.4847	128347320.0
2006-04-20 11:00:00	NVDA	Stock	0.4847	0.486	0.4795	0.4822	61267320.0
2006-04-20 12:00:00	NVDA	Stock	0.4823	0.4858	0.4808	0.4858	44646660.0
2006-04-20 13:00:00	NVDA	Stock	0.486	0.4867	0.4833	0.4853	36295200.0
2006-04-20 14:00:00	NVDA	Stock	0.4853	0.4885	0.4842	0.4872	49795140.0
2006-04-20 15:00:00	NVDA	Stock	0.4872	0.4875	0.4847	0.4853	96508140.0
2006-04-20 16:00:00	NVDA	Stock	0.485	0.4868	0.4828	0.4852	403500.0
2006-04-20 17:00:00	NVDA	Stock	0.4872	0.4883	0.4872	0.4883	286800.0
2006-04-20 18:00:00	NVDA	Stock	0.4883	0.4883	0.4883	0.4883	13200.0
2006-04-20 08:00:00	AMZN	Stock	1.839	1.839	1.839	1.839	2000.0
2006-04-20 09:00:00	AMZN	Stock	1.8355	1.84	1.816	1.8275	11370340.0
2006-04-20 10:00:00	AMZN	Stock	1.827	1.86	1.8255	1.831	21821360.0
2006-04-20 11:00:00	AMZN	Stock	1.831	1.8362	1.82	1.835	12047680.0
2006-04-20 12:00:00	AMZN	Stock	1.835	1.8355	1.827	1.835	4813420.0
2006-04-20 13:00:00	AMZN	Stock	1.835	1.8485	1.835	1.8405	6733080.0
2006-04-20 14:00:00	AMZN	Stock	1.84	1.84	1.831	1.834	18576420.0
2006-04-20 15:00:00	AMZN	Stock	1.8345	1.8345	1.8115	1.817	29069580.0
2006-04-20 16:00:00	AMZN	Stock	1.8185	1.8395	1.8125	1.8375	399720.0
2006-04-20 17:00:00	AMZN	Stock	1.8365	1.8375	1.8365	1.8375	62000.0
2006-04-20 08:00:00	CL	Stock	28.305	28.465	28.305	28.465	507800.0

> showing 50 of 27,931 rows — these rows as CSV

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