PREVIEW / stock_1hour / 2001-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-16.parquet
  size:    363 KB
  rows:    17,322
  symbols: 1,316

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
2001-07-16 08:00:00	AAPL	Stock	0.4402	0.4438	0.4286	0.4425	95200.0
2001-07-16 09:00:00	AAPL	Stock	0.4439	0.4482	0.4341	0.4348	46888800.0
2001-07-16 10:00:00	AAPL	Stock	0.4348	0.4393	0.4329	0.4386	34927200.0
2001-07-16 11:00:00	AAPL	Stock	0.4388	0.4434	0.4366	0.4396	29579200.0
2001-07-16 12:00:00	AAPL	Stock	0.4393	0.4411	0.4304	0.4311	35106400.0
2001-07-16 13:00:00	AAPL	Stock	0.4316	0.4332	0.427	0.4289	21890400.0
2001-07-16 14:00:00	AAPL	Stock	0.4289	0.4355	0.4286	0.4313	22187200.0
2001-07-16 15:00:00	AAPL	Stock	0.4316	0.4329	0.4277	0.4279	45119200.0
2001-07-16 16:00:00	AAPL	Stock	0.4279	0.4348	0.4268	0.4348	28957600.0
2001-07-16 17:00:00	AAPL	Stock	0.4286	0.4286	0.4279	0.4279	28000.0
2001-07-16 18:00:00	AAPL	Stock	0.4286	0.4286	0.4286	0.4286	28000.0
2001-07-16 08:00:00	MSFT	Stock	35.675	35.785	35.675	35.675	12000.0
2001-07-16 09:00:00	MSFT	Stock	35.675	36.08	35.525	35.895	10136600.0
2001-07-16 10:00:00	MSFT	Stock	35.9	36.045	35.82	35.92	10887800.0
2001-07-16 11:00:00	MSFT	Stock	35.92	36.04	35.76	35.8	5778200.0
2001-07-16 12:00:00	MSFT	Stock	35.8	35.815	35.275	35.325	7341800.0
2001-07-16 13:00:00	MSFT	Stock	35.33	35.345	35.075	35.23	4974200.0
2001-07-16 14:00:00	MSFT	Stock	35.23	35.605	35.195	35.455	5506600.0
2001-07-16 15:00:00	MSFT	Stock	35.465	35.67	35.35	35.59	7482000.0
2001-07-16 16:00:00	MSFT	Stock	35.6	35.67	35.37	35.6	1512200.0
2001-07-16 17:00:00	MSFT	Stock	35.62	35.62	35.415	35.415	12600.0
2001-07-16 08:00:00	NVDA	Stock	0.3372	0.3372	0.3354	0.3354	312000.0
2001-07-16 09:00:00	NVDA	Stock	0.3344	0.3375	0.3276	0.3288	102528000.0
2001-07-16 10:00:00	NVDA	Stock	0.3288	0.3327	0.3267	0.3296	115920000.0
2001-07-16 11:00:00	NVDA	Stock	0.3296	0.331	0.323	0.3242	94800000.0
2001-07-16 12:00:00	NVDA	Stock	0.3242	0.3258	0.3151	0.3169	145176000.0
2001-07-16 13:00:00	NVDA	Stock	0.3169	0.3193	0.3153	0.3175	100224000.0
2001-07-16 14:00:00	NVDA	Stock	0.3174	0.3208	0.315	0.3158	123576000.0
2001-07-16 15:00:00	NVDA	Stock	0.3157	0.317	0.3085	0.3102	434952000.0
2001-07-16 16:00:00	NVDA	Stock	0.3102	0.315	0.3083	0.31	22992000.0
2001-07-16 17:00:00	NVDA	Stock	0.3102	0.3102	0.3083	0.3083	336000.0
2001-07-16 18:00:00	NVDA	Stock	0.3079	0.3079	0.3075	0.3075	48000.0
2001-07-16 08:00:00	AMZN	Stock	0.8675	0.87	0.8515	0.8575	334000.0
2001-07-16 09:00:00	AMZN	Stock	0.8575	0.8575	0.8325	0.8335	20770000.0
2001-07-16 10:00:00	AMZN	Stock	0.8325	0.8535	0.827	0.845	21590000.0
2001-07-16 11:00:00	AMZN	Stock	0.8455	0.871	0.845	0.8525	29072000.0
2001-07-16 12:00:00	AMZN	Stock	0.8525	0.8525	0.8115	0.813	15584000.0
2001-07-16 13:00:00	AMZN	Stock	0.8125	0.825	0.812	0.8175	11490000.0
2001-07-16 14:00:00	AMZN	Stock	0.8175	0.826	0.813	0.8195	14394000.0
2001-07-16 15:00:00	AMZN	Stock	0.818	0.8225	0.8005	0.801	22692000.0
2001-07-16 16:00:00	AMZN	Stock	0.801	0.8075	0.8005	0.8075	4594000.0
2001-07-16 17:00:00	AMZN	Stock	0.8005	0.8065	0.7925	0.795	254000.0
2001-07-16 18:00:00	AMZN	Stock	0.795	0.795	0.79	0.79	40000.0
2001-07-16 09:00:00	CL	Stock	27.55	27.79	27.5	27.75	504400.0
2001-07-16 10:00:00	CL	Stock	27.78	28.24	27.75	28.24	739000.0
2001-07-16 11:00:00	CL	Stock	28.24	28.275	28.0	28.125	300000.0
2001-07-16 12:00:00	CL	Stock	28.135	28.35	28.1	28.17	458600.0
2001-07-16 13:00:00	CL	Stock	28.175	28.25	28.125	28.125	296400.0
2001-07-16 14:00:00	CL	Stock	28.125	28.275	28.085	28.11	440200.0
2001-07-16 15:00:00	CL	Stock	28.105	28.14	27.825	27.95	773400.0

> showing 50 of 17,322 rows — these rows as CSV

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