PREVIEW / stock_1hour / 2005-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-12.parquet
  size:    587 KB
  rows:    27,696
  symbols: 2,142

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
2005-12-12 05:00:00	AAPL	Stock	2.6679	2.67	2.6679	2.67	19600.0
2005-12-12 06:00:00	AAPL	Stock	2.6818	2.6818	2.6818	2.6818	2800.0
2005-12-12 07:00:00	AAPL	Stock	2.6829	2.6829	2.6768	2.6786	266000.0
2005-12-12 08:00:00	AAPL	Stock	2.6786	2.6839	2.6696	2.6786	3497340.0
2005-12-12 09:00:00	AAPL	Stock	2.6786	2.6875	2.6704	2.6779	122187828.0
2005-12-12 10:00:00	AAPL	Stock	2.6779	2.6857	2.6629	2.6829	104197268.0
2005-12-12 11:00:00	AAPL	Stock	2.6825	2.6911	2.68	2.6857	65424492.0
2005-12-12 12:00:00	AAPL	Stock	2.6868	2.6889	2.6679	2.6764	62470604.0
2005-12-12 13:00:00	AAPL	Stock	2.6764	2.6796	2.67	2.6754	36293068.0
2005-12-12 14:00:00	AAPL	Stock	2.6754	2.6839	2.6732	2.6736	48433084.0
2005-12-12 15:00:00	AAPL	Stock	2.6736	2.6786	2.6711	2.6754	65398844.0
2005-12-12 16:00:00	AAPL	Stock	2.6757	2.6804	2.6746	2.6754	3812872.0
2005-12-12 17:00:00	AAPL	Stock	2.6775	2.6786	2.6754	2.6757	212996.0
2005-12-12 18:00:00	AAPL	Stock	2.6757	2.6768	2.6754	2.6768	353612.0
2005-12-12 05:00:00	MSFT	Stock	27.71	27.75	27.71	27.75	2000.0
2005-12-12 06:00:00	MSFT	Stock	27.75	27.75	27.75	27.75	100.0
2005-12-12 08:00:00	MSFT	Stock	27.75	27.8	27.74	27.75	9850.0
2005-12-12 09:00:00	MSFT	Stock	27.77	27.77	27.45	27.51	9092738.0
2005-12-12 10:00:00	MSFT	Stock	27.511	27.592	27.47	27.55	6645007.0
2005-12-12 11:00:00	MSFT	Stock	27.55	27.68	27.51	27.52	4688621.0
2005-12-12 12:00:00	MSFT	Stock	27.52	27.54	27.47	27.492	8930584.0
2005-12-12 13:00:00	MSFT	Stock	27.49	27.5	27.46	27.49	5838684.0
2005-12-12 14:00:00	MSFT	Stock	27.488	27.5	27.4	27.42	12725196.0
2005-12-12 15:00:00	MSFT	Stock	27.42	27.46	27.33	27.44	13582540.0
2005-12-12 16:00:00	MSFT	Stock	27.44	27.485	27.41	27.41	599136.0
2005-12-12 17:00:00	MSFT	Stock	27.45	27.45	27.41	27.41	122500.0
2005-12-12 18:00:00	MSFT	Stock	27.41	27.44	27.41	27.44	350.0
2005-12-12 05:00:00	NVDA	Stock	0.307	0.3083	0.3062	0.3062	228000.0
2005-12-12 07:00:00	NVDA	Stock	0.3083	0.3083	0.3083	0.3083	108000.0
2005-12-12 08:00:00	NVDA	Stock	0.3066	0.3075	0.3057	0.3065	402000.0
2005-12-12 09:00:00	NVDA	Stock	0.306	0.306	0.3032	0.3045	29915520.0
2005-12-12 10:00:00	NVDA	Stock	0.3047	0.3069	0.3037	0.3061	49917720.0
2005-12-12 11:00:00	NVDA	Stock	0.3062	0.3067	0.3052	0.3055	25053720.0
2005-12-12 12:00:00	NVDA	Stock	0.3055	0.3061	0.3049	0.3057	20313000.0
2005-12-12 13:00:00	NVDA	Stock	0.3058	0.3058	0.304	0.3049	15567720.0
2005-12-12 14:00:00	NVDA	Stock	0.3051	0.3079	0.3049	0.3073	36699480.0
2005-12-12 15:00:00	NVDA	Stock	0.3073	0.3079	0.3067	0.307	66055440.0
2005-12-12 16:00:00	NVDA	Stock	0.3072	0.3072	0.3064	0.3072	6981240.0
2005-12-12 17:00:00	NVDA	Stock	0.3072	0.3072	0.3072	0.3072	12000.0
2005-12-12 08:00:00	AMZN	Stock	2.4695	2.4695	2.437	2.4595	70960.0
2005-12-12 09:00:00	AMZN	Stock	2.4585	2.465	2.453	2.453	10902080.0
2005-12-12 10:00:00	AMZN	Stock	2.453	2.4595	2.4375	2.44	16359700.0
2005-12-12 11:00:00	AMZN	Stock	2.44	2.4485	2.435	2.44	8875800.0
2005-12-12 12:00:00	AMZN	Stock	2.44	2.442	2.4355	2.4385	6213700.0
2005-12-12 13:00:00	AMZN	Stock	2.4385	2.4485	2.432	2.448	5060360.0
2005-12-12 14:00:00	AMZN	Stock	2.4485	2.4525	2.438	2.451	6097980.0
2005-12-12 15:00:00	AMZN	Stock	2.45	2.4575	2.4485	2.4515	13197160.0
2005-12-12 16:00:00	AMZN	Stock	2.453	2.4565	2.4525	2.455	153260.0
2005-12-12 17:00:00	AMZN	Stock	2.455	2.455	2.4525	2.4525	16000.0
2005-12-12 08:00:00	CL	Stock	27.52	27.52	27.52	27.52	1400.0

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

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