PREVIEW / stock_1hour / 2006-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-17.parquet
  size:    604 KB
  rows:    28,294
  symbols: 2,204

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-03-17 07:00:00	AAPL	Stock	2.3196	2.3196	2.3125	2.3125	98000.0
2006-03-17 08:00:00	AAPL	Stock	2.3143	2.3179	2.3121	2.3125	2653140.0
2006-03-17 09:00:00	AAPL	Stock	2.3129	2.3175	2.2896	2.3064	224816928.0
2006-03-17 10:00:00	AAPL	Stock	2.3061	2.3207	2.2975	2.3018	132129200.0
2006-03-17 11:00:00	AAPL	Stock	2.3018	2.3139	2.2975	2.3036	89306364.0
2006-03-17 12:00:00	AAPL	Stock	2.3036	2.3139	2.3032	2.3111	67355372.0
2006-03-17 13:00:00	AAPL	Stock	2.3114	2.3171	2.2986	2.3036	67446820.0
2006-03-17 14:00:00	AAPL	Stock	2.3036	2.3164	2.3035	2.3089	54209764.0
2006-03-17 15:00:00	AAPL	Stock	2.3089	2.3407	2.2982	2.3079	115308088.0
2006-03-17 16:00:00	AAPL	Stock	2.3079	2.3093	2.2968	2.3086	12654712.0
2006-03-17 17:00:00	AAPL	Stock	2.3075	2.3093	2.3071	2.3089	448420.0
2006-03-17 18:00:00	AAPL	Stock	2.3071	2.3107	2.3071	2.3107	360948.0
2006-03-17 04:00:00	MSFT	Stock	27.5	27.5	27.5	27.5	800.0
2006-03-17 07:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	950.0
2006-03-17 08:00:00	MSFT	Stock	27.25	27.28	27.25	27.28	1820.0
2006-03-17 09:00:00	MSFT	Stock	27.25	27.43	27.25	27.4	21937455.0
2006-03-17 10:00:00	MSFT	Stock	27.4	27.53	27.39	27.42	15343079.0
2006-03-17 11:00:00	MSFT	Stock	27.42	27.55	27.4	27.55	6924210.0
2006-03-17 12:00:00	MSFT	Stock	27.55	27.66	27.5	27.6	7731192.0
2006-03-17 13:00:00	MSFT	Stock	27.6	27.63	27.5	27.54	6471194.0
2006-03-17 14:00:00	MSFT	Stock	27.54	27.55	27.43	27.45	8734785.0
2006-03-17 15:00:00	MSFT	Stock	27.45	27.51	27.35	27.46	19627049.0
2006-03-17 16:00:00	MSFT	Stock	27.5	27.61	27.27	27.55	5326667.0
2006-03-17 17:00:00	MSFT	Stock	27.52	27.56	27.5	27.51	15300.0
2006-03-17 18:00:00	MSFT	Stock	27.5	27.54	27.48	27.54	1841.0
2006-03-17 07:00:00	NVDA	Stock	0.4017	0.4017	0.4017	0.4017	12000.0
2006-03-17 08:00:00	NVDA	Stock	0.4017	0.4023	0.4017	0.4021	172800.0
2006-03-17 09:00:00	NVDA	Stock	0.4015	0.4019	0.3952	0.3962	147663840.0
2006-03-17 10:00:00	NVDA	Stock	0.3962	0.4008	0.3953	0.396	94701840.0
2006-03-17 11:00:00	NVDA	Stock	0.396	0.4048	0.3957	0.4044	73723320.0
2006-03-17 12:00:00	NVDA	Stock	0.4047	0.4075	0.4039	0.4061	69104880.0
2006-03-17 13:00:00	NVDA	Stock	0.406	0.4072	0.4032	0.4043	55028040.0
2006-03-17 14:00:00	NVDA	Stock	0.4043	0.4057	0.4032	0.4048	67925760.0
2006-03-17 15:00:00	NVDA	Stock	0.4048	0.4069	0.4044	0.4067	75447960.0
2006-03-17 16:00:00	NVDA	Stock	0.4064	0.407	0.4032	0.407	2022240.0
2006-03-17 17:00:00	NVDA	Stock	0.4074	0.4082	0.4074	0.4077	845040.0
2006-03-17 09:00:00	AMZN	Stock	1.8425	1.849	1.818	1.825	25688120.0
2006-03-17 10:00:00	AMZN	Stock	1.825	1.831	1.815	1.826	15566020.0
2006-03-17 11:00:00	AMZN	Stock	1.825	1.833	1.825	1.8325	8090680.0
2006-03-17 12:00:00	AMZN	Stock	1.8325	1.834	1.822	1.8225	11245840.0
2006-03-17 13:00:00	AMZN	Stock	1.822	1.826	1.815	1.8155	11771500.0
2006-03-17 14:00:00	AMZN	Stock	1.8155	1.819	1.8035	1.809	19869180.0
2006-03-17 15:00:00	AMZN	Stock	1.809	1.8125	1.7925	1.8	37417540.0
2006-03-17 16:00:00	AMZN	Stock	1.799	1.8385	1.798	1.8	1152520.0
2006-03-17 17:00:00	AMZN	Stock	1.8	1.8005	1.8	1.8005	42060.0
2006-03-17 18:00:00	AMZN	Stock	1.8	1.8	1.7995	1.7995	29600.0
2006-03-17 08:00:00	CL	Stock	28.325	28.325	28.325	28.325	38400.0
2006-03-17 09:00:00	CL	Stock	28.335	28.445	28.28	28.305	1183400.0
2006-03-17 10:00:00	CL	Stock	28.305	28.355	28.195	28.2	358200.0
2006-03-17 11:00:00	CL	Stock	28.205	28.295	28.185	28.275	437200.0

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

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