PREVIEW / stock_1hour / 2002-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-23.parquet
  size:    412 KB
  rows:    19,250
  symbols: 1,407

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-04-23 08:00:00	AAPL	Stock	0.4381	0.4381	0.4375	0.4375	1136800.0
2002-04-23 09:00:00	AAPL	Stock	0.4361	0.4402	0.432	0.4395	21134400.0
2002-04-23 10:00:00	AAPL	Stock	0.4393	0.4395	0.4355	0.438	43484000.0
2002-04-23 11:00:00	AAPL	Stock	0.438	0.4411	0.437	0.4393	37391200.0
2002-04-23 12:00:00	AAPL	Stock	0.4395	0.4418	0.4375	0.4388	29601600.0
2002-04-23 13:00:00	AAPL	Stock	0.4393	0.4425	0.4386	0.4405	23525600.0
2002-04-23 14:00:00	AAPL	Stock	0.4407	0.4414	0.4386	0.4393	20059200.0
2002-04-23 15:00:00	AAPL	Stock	0.4395	0.4396	0.4302	0.4325	42845600.0
2002-04-23 16:00:00	AAPL	Stock	0.4325	0.4381	0.4321	0.433	5952800.0
2002-04-23 17:00:00	AAPL	Stock	0.433	0.433	0.433	0.433	61600.0
2002-04-23 18:00:00	AAPL	Stock	0.433	0.433	0.433	0.433	1086400.0
2002-04-23 08:00:00	MSFT	Stock	28.1	28.125	27.85	27.89	84200.0
2002-04-23 09:00:00	MSFT	Stock	27.88	27.995	27.63	27.75	7990800.0
2002-04-23 10:00:00	MSFT	Stock	27.755	27.79	27.325	27.47	12588400.0
2002-04-23 11:00:00	MSFT	Stock	27.48	27.595	27.375	27.395	5973400.0
2002-04-23 12:00:00	MSFT	Stock	27.4	27.425	26.97	27.085	9346600.0
2002-04-23 13:00:00	MSFT	Stock	27.095	27.22	26.98	27.0	6095200.0
2002-04-23 14:00:00	MSFT	Stock	27.0	27.225	26.82	27.047	7134200.0
2002-04-23 15:00:00	MSFT	Stock	27.04	27.08	26.65	26.995	12531800.0
2002-04-23 16:00:00	MSFT	Stock	26.995	27.2734	26.7	26.81	3034400.0
2002-04-23 17:00:00	MSFT	Stock	26.81	27.3078	26.81	26.915	688400.0
2002-04-23 18:00:00	MSFT	Stock	26.915	26.995	26.9	26.945	188800.0
2002-04-23 08:00:00	NVDA	Stock	0.3093	0.3166	0.3058	0.3102	1032000.0
2002-04-23 09:00:00	NVDA	Stock	0.3097	0.3152	0.3096	0.3136	111312000.0
2002-04-23 10:00:00	NVDA	Stock	0.3134	0.3152	0.3075	0.3093	136620000.0
2002-04-23 11:00:00	NVDA	Stock	0.3093	0.3104	0.3062	0.3067	45468000.0
2002-04-23 12:00:00	NVDA	Stock	0.3068	0.3084	0.3012	0.3024	81204000.0
2002-04-23 13:00:00	NVDA	Stock	0.3025	0.307	0.3005	0.3031	61692000.0
2002-04-23 14:00:00	NVDA	Stock	0.3039	0.3039	0.3	0.3004	92508000.0
2002-04-23 15:00:00	NVDA	Stock	0.3005	0.3011	0.2939	0.2971	196812000.0
2002-04-23 16:00:00	NVDA	Stock	0.2971	0.3045	0.295	0.2983	11232000.0
2002-04-23 17:00:00	NVDA	Stock	0.2983	0.3049	0.2967	0.2983	1104000.0
2002-04-23 18:00:00	NVDA	Stock	0.2975	0.2987	0.2967	0.2982	888000.0
2002-04-23 08:00:00	AMZN	Stock	0.717	0.722	0.715	0.7155	112000.0
2002-04-23 09:00:00	AMZN	Stock	0.715	0.7375	0.6675	0.7315	19934000.0
2002-04-23 10:00:00	AMZN	Stock	0.7315	0.7365	0.718	0.7215	21920000.0
2002-04-23 11:00:00	AMZN	Stock	0.7215	0.723	0.7035	0.705	17264000.0
2002-04-23 12:00:00	AMZN	Stock	0.705	0.707	0.6975	0.7035	14630000.0
2002-04-23 13:00:00	AMZN	Stock	0.706	0.709	0.701	0.707	11286000.0
2002-04-23 14:00:00	AMZN	Stock	0.707	0.7145	0.7055	0.7125	13268000.0
2002-04-23 15:00:00	AMZN	Stock	0.7125	0.7145	0.694	0.7065	24704000.0
2002-04-23 16:00:00	AMZN	Stock	0.7065	0.755	0.695	0.748	26898000.0
2002-04-23 17:00:00	AMZN	Stock	0.7495	0.7615	0.7495	0.7565	2656000.0
2002-04-23 18:00:00	AMZN	Stock	0.7565	0.7595	0.703	0.757	664000.0
2002-04-23 09:00:00	CL	Stock	27.36	27.4	27.23	27.4	342400.0
2002-04-23 10:00:00	CL	Stock	27.4	27.62	27.375	27.515	847600.0
2002-04-23 11:00:00	CL	Stock	27.525	27.605	27.5	27.51	468600.0
2002-04-23 12:00:00	CL	Stock	27.51	27.675	27.505	27.675	471800.0
2002-04-23 13:00:00	CL	Stock	27.67	27.765	27.64	27.655	391800.0
2002-04-23 14:00:00	CL	Stock	27.655	27.695	27.51	27.585	470400.0

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

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