PREVIEW / stock_1hour / 2006-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-25.parquet
  size:    626 KB
  rows:    29,988
  symbols: 2,380

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-09-25 07:00:00	AAPL	Stock	2.6239	2.6357	2.6239	2.6339	25200.0
2006-09-25 08:00:00	AAPL	Stock	2.6354	2.6364	2.6264	2.6325	4151560.0
2006-09-25 09:00:00	AAPL	Stock	2.6332	2.6636	2.6304	2.6611	118271888.0
2006-09-25 10:00:00	AAPL	Stock	2.6611	2.6668	2.6357	2.6564	177625616.0
2006-09-25 11:00:00	AAPL	Stock	2.6561	2.6818	2.6543	2.6704	133221228.0
2006-09-25 12:00:00	AAPL	Stock	2.6704	2.6982	2.6679	2.6939	105322924.0
2006-09-25 13:00:00	AAPL	Stock	2.6939	2.7018	2.6846	2.6861	82101096.0
2006-09-25 14:00:00	AAPL	Stock	2.6864	2.6986	2.6857	2.6943	85851640.0
2006-09-25 15:00:00	AAPL	Stock	2.6946	2.7093	2.6929	2.7071	139861288.0
2006-09-25 16:00:00	AAPL	Stock	2.7071	2.7089	2.7036	2.7036	1906772.0
2006-09-25 17:00:00	AAPL	Stock	2.7054	2.7082	2.7054	2.7068	196140.0
2006-09-25 18:00:00	AAPL	Stock	2.7068	2.7143	2.7068	2.7139	333620.0
2006-09-25 19:00:00	AAPL	Stock	2.7139	2.7139	2.7125	2.7139	240688.0
2006-09-25 08:00:00	MSFT	Stock	26.7	26.81	26.7	26.7	5535.0
2006-09-25 09:00:00	MSFT	Stock	26.79	26.97	26.74	26.88	6979700.0
2006-09-25 10:00:00	MSFT	Stock	26.87	26.95	26.79	26.86	8421338.0
2006-09-25 11:00:00	MSFT	Stock	26.85	26.95	26.81	26.85	6900260.0
2006-09-25 12:00:00	MSFT	Stock	26.85	27.02	26.83	27.0	5800652.0
2006-09-25 13:00:00	MSFT	Stock	27.01	27.1	26.99	27.0	5771616.0
2006-09-25 14:00:00	MSFT	Stock	27.0	27.17	27.0	27.09	6606139.0
2006-09-25 15:00:00	MSFT	Stock	27.1	27.19	26.93	26.97	20729072.0
2006-09-25 16:00:00	MSFT	Stock	26.96	26.98	26.92	26.92	392378.0
2006-09-25 17:00:00	MSFT	Stock	26.96	26.97	26.93	26.97	359675.0
2006-09-25 18:00:00	MSFT	Stock	26.96	27.0	26.96	27.0	13502.0
2006-09-25 19:00:00	MSFT	Stock	26.98	26.98	26.97	26.97	3750.0
2006-09-25 07:00:00	NVDA	Stock	0.5027	0.5027	0.5027	0.5027	6000.0
2006-09-25 08:00:00	NVDA	Stock	0.5042	0.5058	0.5028	0.5042	951240.0
2006-09-25 09:00:00	NVDA	Stock	0.5038	0.5075	0.4977	0.4998	68679840.0
2006-09-25 10:00:00	NVDA	Stock	0.4998	0.501	0.4907	0.4957	97488660.0
2006-09-25 11:00:00	NVDA	Stock	0.4957	0.5042	0.4955	0.5025	89360760.0
2006-09-25 12:00:00	NVDA	Stock	0.5023	0.51	0.5017	0.5095	79559760.0
2006-09-25 13:00:00	NVDA	Stock	0.5095	0.5113	0.5053	0.5073	68207400.0
2006-09-25 14:00:00	NVDA	Stock	0.5073	0.5118	0.5067	0.5113	97272360.0
2006-09-25 15:00:00	NVDA	Stock	0.5115	0.5168	0.5112	0.5145	154638840.0
2006-09-25 16:00:00	NVDA	Stock	0.5147	0.517	0.5145	0.5157	3384660.0
2006-09-25 17:00:00	NVDA	Stock	0.5162	0.5163	0.5162	0.5163	105900.0
2006-09-25 18:00:00	NVDA	Stock	0.5163	0.5188	0.515	0.5188	349080.0
2006-09-25 19:00:00	NVDA	Stock	0.5187	0.5192	0.5187	0.5187	168000.0
2006-09-25 08:00:00	AMZN	Stock	1.5475	1.562	1.5475	1.562	31000.0
2006-09-25 09:00:00	AMZN	Stock	1.5625	1.5625	1.537	1.548	13865500.0
2006-09-25 10:00:00	AMZN	Stock	1.548	1.56	1.5375	1.554	24146520.0
2006-09-25 11:00:00	AMZN	Stock	1.5535	1.564	1.5455	1.5495	14525420.0
2006-09-25 12:00:00	AMZN	Stock	1.5495	1.5805	1.545	1.577	15548660.0
2006-09-25 13:00:00	AMZN	Stock	1.5765	1.5815	1.5675	1.568	12072360.0
2006-09-25 14:00:00	AMZN	Stock	1.5685	1.5825	1.5685	1.581	14204260.0
2006-09-25 15:00:00	AMZN	Stock	1.581	1.5985	1.577	1.5885	31828300.0
2006-09-25 16:00:00	AMZN	Stock	1.592	1.592	1.588	1.5915	182960.0
2006-09-25 17:00:00	AMZN	Stock	1.59	1.59	1.59	1.59	20520.0
2006-09-25 09:00:00	CL	Stock	31.05	31.15	30.95	31.075	351200.0
2006-09-25 10:00:00	CL	Stock	31.065	31.095	30.965	30.995	474000.0

> showing 50 of 29,988 rows — these rows as CSV

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