PREVIEW / stock_1hour / 2002-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-20.parquet
  size:    410 KB
  rows:    18,856
  symbols: 1,419

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-20 08:00:00	AAPL	Stock	0.4461	0.4461	0.4379	0.445	112000.0
2002-05-20 09:00:00	AAPL	Stock	0.4438	0.4448	0.438	0.4411	61258400.0
2002-05-20 10:00:00	AAPL	Stock	0.4411	0.4438	0.4391	0.4407	54947200.0
2002-05-20 11:00:00	AAPL	Stock	0.4411	0.4413	0.4388	0.44	39552800.0
2002-05-20 12:00:00	AAPL	Stock	0.4402	0.4405	0.4384	0.4402	19913600.0
2002-05-20 13:00:00	AAPL	Stock	0.44	0.4452	0.4398	0.4423	36584800.0
2002-05-20 14:00:00	AAPL	Stock	0.4423	0.445	0.4411	0.4421	15932000.0
2002-05-20 15:00:00	AAPL	Stock	0.4421	0.4427	0.4388	0.4416	34462400.0
2002-05-20 16:00:00	AAPL	Stock	0.4418	0.443	0.4409	0.4427	3365600.0
2002-05-20 17:00:00	AAPL	Stock	0.4418	0.4418	0.4418	0.4418	145600.0
2002-05-20 08:00:00	MSFT	Stock	27.83	27.97	27.56	27.795	34200.0
2002-05-20 09:00:00	MSFT	Stock	27.775	27.97	27.455	27.515	8595400.0
2002-05-20 10:00:00	MSFT	Stock	27.52	27.52	27.079	27.11	9955400.0
2002-05-20 11:00:00	MSFT	Stock	27.105	27.215	26.955	27.055	6007800.0
2002-05-20 12:00:00	MSFT	Stock	27.05	27.075	26.89	26.935	4879800.0
2002-05-20 13:00:00	MSFT	Stock	26.93	27.175	26.93	27.08	5518000.0
2002-05-20 14:00:00	MSFT	Stock	27.075	27.085	26.9015	26.905	5497000.0
2002-05-20 15:00:00	MSFT	Stock	26.92	27.085	26.75	27.01	9617400.0
2002-05-20 16:00:00	MSFT	Stock	27.01	27.1473	26.9656	27.0	1181400.0
2002-05-20 17:00:00	MSFT	Stock	27.005	27.025	27.0	27.0	83600.0
2002-05-20 18:00:00	MSFT	Stock	27.01	27.015	27.01	27.015	2800.0
2002-05-20 08:00:00	NVDA	Stock	0.3242	0.3262	0.3214	0.3225	972000.0
2002-05-20 09:00:00	NVDA	Stock	0.3226	0.33	0.3208	0.3293	167592000.0
2002-05-20 10:00:00	NVDA	Stock	0.3295	0.3295	0.3227	0.3246	156276000.0
2002-05-20 11:00:00	NVDA	Stock	0.3245	0.3274	0.3238	0.3265	83076000.0
2002-05-20 12:00:00	NVDA	Stock	0.326	0.3275	0.3251	0.3272	72120000.0
2002-05-20 13:00:00	NVDA	Stock	0.3272	0.3321	0.3271	0.3303	153696000.0
2002-05-20 14:00:00	NVDA	Stock	0.3306	0.3312	0.3283	0.3296	108324000.0
2002-05-20 15:00:00	NVDA	Stock	0.3294	0.3308	0.3254	0.3302	178704000.0
2002-05-20 16:00:00	NVDA	Stock	0.3299	0.3317	0.3277	0.3302	21864000.0
2002-05-20 17:00:00	NVDA	Stock	0.3302	0.3304	0.3292	0.3299	1392000.0
2002-05-20 18:00:00	NVDA	Stock	0.3292	0.3292	0.3292	0.3292	144000.0
2002-05-20 08:00:00	AMZN	Stock	0.95	0.95	0.9299	0.94	446000.0
2002-05-20 09:00:00	AMZN	Stock	0.945	0.9575	0.938	0.9515	29698000.0
2002-05-20 10:00:00	AMZN	Stock	0.952	0.972	0.95	0.9645	42400000.0
2002-05-20 11:00:00	AMZN	Stock	0.9645	0.974	0.956	0.957	23450000.0
2002-05-20 12:00:00	AMZN	Stock	0.957	0.964	0.9525	0.9635	12912000.0
2002-05-20 13:00:00	AMZN	Stock	0.963	0.9715	0.958	0.9635	13444000.0
2002-05-20 14:00:00	AMZN	Stock	0.964	0.9675	0.9555	0.9565	15594000.0
2002-05-20 15:00:00	AMZN	Stock	0.9565	0.971	0.952	0.9695	20578000.0
2002-05-20 16:00:00	AMZN	Stock	0.969	0.97	0.9635	0.966	1726000.0
2002-05-20 17:00:00	AMZN	Stock	0.967	0.9695	0.967	0.9675	18000.0
2002-05-20 18:00:00	AMZN	Stock	0.9675	0.968	0.9675	0.968	20000.0
2002-05-20 09:00:00	CL	Stock	27.4	27.49	27.38	27.41	170400.0
2002-05-20 10:00:00	CL	Stock	27.41	27.5	27.33	27.485	324800.0
2002-05-20 11:00:00	CL	Stock	27.54	27.65	27.45	27.52	417000.0
2002-05-20 12:00:00	CL	Stock	27.52	27.54	27.455	27.5	97200.0
2002-05-20 13:00:00	CL	Stock	27.5	27.535	27.475	27.48	111400.0
2002-05-20 14:00:00	CL	Stock	27.485	27.54	27.41	27.46	322800.0
2002-05-20 15:00:00	CL	Stock	27.45	27.55	27.4	27.405	410800.0

> showing 50 of 18,856 rows — these rows as CSV

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