PREVIEW / stock_1hour / 2002-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-21.parquet
  size:    408 KB
  rows:    19,041
  symbols: 1,422

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
2002-05-21 08:00:00	AAPL	Stock	0.445	0.445	0.4425	0.4438	28000.0
2002-05-21 09:00:00	AAPL	Stock	0.4439	0.4464	0.4421	0.4439	22999200.0
2002-05-21 10:00:00	AAPL	Stock	0.4438	0.4438	0.433	0.4332	35453600.0
2002-05-21 11:00:00	AAPL	Stock	0.4331	0.4334	0.4257	0.4305	30464000.0
2002-05-21 12:00:00	AAPL	Stock	0.4305	0.4322	0.4246	0.4268	32866400.0
2002-05-21 13:00:00	AAPL	Stock	0.4268	0.4286	0.4252	0.4266	17348800.0
2002-05-21 14:00:00	AAPL	Stock	0.4266	0.4273	0.4196	0.42	32838400.0
2002-05-21 15:00:00	AAPL	Stock	0.4198	0.4214	0.4179	0.4186	74547200.0
2002-05-21 16:00:00	AAPL	Stock	0.4186	0.4195	0.4179	0.4189	13636000.0
2002-05-21 17:00:00	AAPL	Stock	0.4189	0.4193	0.4189	0.4193	16800.0
2002-05-21 08:00:00	MSFT	Stock	27.2	27.225	27.0	27.09	509800.0
2002-05-21 09:00:00	MSFT	Stock	27.08	27.3	26.875	26.965	8638000.0
2002-05-21 10:00:00	MSFT	Stock	26.963	27.02	26.715	26.725	8936600.0
2002-05-21 11:00:00	MSFT	Stock	26.725	26.76	26.35	26.47	9797000.0
2002-05-21 12:00:00	MSFT	Stock	26.47	26.502	26.105	26.2	7214200.0
2002-05-21 13:00:00	MSFT	Stock	26.195	26.39	26.165	26.355	6026000.0
2002-05-21 14:00:00	MSFT	Stock	26.355	26.375	26.07	26.105	6721400.0
2002-05-21 15:00:00	MSFT	Stock	26.105	26.25	26.065	26.095	9697000.0
2002-05-21 16:00:00	MSFT	Stock	26.1	26.5081	26.05	26.075	4043800.0
2002-05-21 17:00:00	MSFT	Stock	26.075	26.12	26.075	26.11	5400.0
2002-05-21 18:00:00	MSFT	Stock	26.125	26.15	26.085	26.085	8200.0
2002-05-21 08:00:00	NVDA	Stock	0.3308	0.3356	0.3292	0.3333	4020000.0
2002-05-21 09:00:00	NVDA	Stock	0.3337	0.3387	0.3326	0.3334	217140000.0
2002-05-21 10:00:00	NVDA	Stock	0.3335	0.3337	0.315	0.3153	338436000.0
2002-05-21 11:00:00	NVDA	Stock	0.3154	0.317	0.3105	0.3128	238896000.0
2002-05-21 12:00:00	NVDA	Stock	0.3127	0.3151	0.3108	0.3125	109896000.0
2002-05-21 13:00:00	NVDA	Stock	0.3126	0.3146	0.311	0.3119	110292000.0
2002-05-21 14:00:00	NVDA	Stock	0.3117	0.3133	0.306	0.3068	145200000.0
2002-05-21 15:00:00	NVDA	Stock	0.3069	0.3075	0.3044	0.3047	186456000.0
2002-05-21 16:00:00	NVDA	Stock	0.3047	0.3187	0.3037	0.3037	26472000.0
2002-05-21 17:00:00	NVDA	Stock	0.3037	0.305	0.3035	0.304	1080000.0
2002-05-21 18:00:00	NVDA	Stock	0.3038	0.3043	0.3036	0.3043	852000.0
2002-05-21 08:00:00	AMZN	Stock	0.968	0.9805	0.968	0.9805	486000.0
2002-05-21 09:00:00	AMZN	Stock	0.98	0.99	0.9705	0.9766	22166000.0
2002-05-21 10:00:00	AMZN	Stock	0.9775	0.984	0.9655	0.966	27592000.0
2002-05-21 11:00:00	AMZN	Stock	0.966	0.977	0.9625	0.9715	19804000.0
2002-05-21 12:00:00	AMZN	Stock	0.9715	0.9745	0.94	0.9445	21970000.0
2002-05-21 13:00:00	AMZN	Stock	0.944	0.9545	0.9425	0.9465	17216000.0
2002-05-21 14:00:00	AMZN	Stock	0.946	0.9465	0.9275	0.932	14838000.0
2002-05-21 15:00:00	AMZN	Stock	0.9305	0.9435	0.9295	0.9375	18972000.0
2002-05-21 16:00:00	AMZN	Stock	0.9375	0.9604	0.931	0.935	10594000.0
2002-05-21 17:00:00	AMZN	Stock	0.9345	0.938	0.934	0.938	86000.0
2002-05-21 18:00:00	AMZN	Stock	0.9305	0.931	0.9305	0.931	12000.0
2002-05-21 09:00:00	CL	Stock	27.525	27.575	27.25	27.25	300200.0
2002-05-21 10:00:00	CL	Stock	27.25	27.35	27.175	27.18	386200.0
2002-05-21 11:00:00	CL	Stock	27.175	27.2	27.08	27.175	286800.0
2002-05-21 12:00:00	CL	Stock	27.17	27.225	27.15	27.2	251000.0
2002-05-21 13:00:00	CL	Stock	27.2	27.22	27.12	27.125	303000.0
2002-05-21 14:00:00	CL	Stock	27.14	27.145	27.015	27.045	451200.0
2002-05-21 15:00:00	CL	Stock	27.03	27.085	27.0	27.03	433800.0

> showing 50 of 19,041 rows — these rows as CSV

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