PREVIEW / stock_1hour / 2001-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-02.parquet
  size:    363 KB
  rows:    17,170
  symbols: 1,325

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-08-02 08:00:00	AAPL	Stock	0.3402	0.3438	0.3402	0.3438	1752800.0
2001-08-02 09:00:00	AAPL	Stock	0.3446	0.3529	0.3445	0.3511	51032800.0
2001-08-02 10:00:00	AAPL	Stock	0.3518	0.3545	0.3439	0.3502	48148800.0
2001-08-02 11:00:00	AAPL	Stock	0.3495	0.3518	0.3461	0.3495	25698400.0
2001-08-02 12:00:00	AAPL	Stock	0.3495	0.3546	0.3495	0.3521	22024800.0
2001-08-02 13:00:00	AAPL	Stock	0.3527	0.3543	0.3484	0.352	21145600.0
2001-08-02 14:00:00	AAPL	Stock	0.3511	0.3536	0.35	0.3518	20434400.0
2001-08-02 15:00:00	AAPL	Stock	0.3521	0.3548	0.3477	0.3538	45522400.0
2001-08-02 16:00:00	AAPL	Stock	0.3538	0.3571	0.3536	0.357	5723200.0
2001-08-02 17:00:00	AAPL	Stock	0.3527	0.3527	0.3527	0.3527	5600.0
2001-08-02 08:00:00	MSFT	Stock	33.55	33.815	33.5	33.725	108400.0
2001-08-02 09:00:00	MSFT	Stock	33.725	33.77	33.505	33.66	6572200.0
2001-08-02 10:00:00	MSFT	Stock	33.67	33.695	33.155	33.435	13651400.0
2001-08-02 11:00:00	MSFT	Stock	33.415	33.515	33.3	33.385	4040400.0
2001-08-02 12:00:00	MSFT	Stock	33.395	33.45	33.315	33.32	3218600.0
2001-08-02 13:00:00	MSFT	Stock	33.315	33.375	33.155	33.19	4959400.0
2001-08-02 14:00:00	MSFT	Stock	33.175	33.54	33.13	33.485	5800600.0
2001-08-02 15:00:00	MSFT	Stock	33.485	33.76	33.39	33.715	8978800.0
2001-08-02 16:00:00	MSFT	Stock	33.705	33.875	33.41	33.8	4010800.0
2001-08-02 17:00:00	MSFT	Stock	33.825	33.975	33.81	33.83	22200.0
2001-08-02 18:00:00	MSFT	Stock	33.835	33.85	33.825	33.825	800.0
2001-08-02 08:00:00	NVDA	Stock	0.3583	0.3667	0.3583	0.3605	1752000.0
2001-08-02 09:00:00	NVDA	Stock	0.3608	0.3634	0.3548	0.3564	138216000.0
2001-08-02 10:00:00	NVDA	Stock	0.3566	0.3566	0.3507	0.3513	228432000.0
2001-08-02 11:00:00	NVDA	Stock	0.3509	0.356	0.35	0.3543	162960000.0
2001-08-02 12:00:00	NVDA	Stock	0.3543	0.3579	0.3528	0.3554	75504000.0
2001-08-02 13:00:00	NVDA	Stock	0.355	0.3556	0.3506	0.3524	89448000.0
2001-08-02 14:00:00	NVDA	Stock	0.3525	0.3562	0.3517	0.3561	81456000.0
2001-08-02 15:00:00	NVDA	Stock	0.3562	0.3675	0.3543	0.3662	258840000.0
2001-08-02 16:00:00	NVDA	Stock	0.3662	0.3667	0.3622	0.3656	28104000.0
2001-08-02 17:00:00	NVDA	Stock	0.366	0.366	0.366	0.366	24000.0
2001-08-02 18:00:00	NVDA	Stock	0.3658	0.3658	0.3656	0.3656	96000.0
2001-08-02 08:00:00	AMZN	Stock	0.6325	0.6325	0.625	0.63	26000.0
2001-08-02 09:00:00	AMZN	Stock	0.6325	0.6325	0.615	0.616	6768000.0
2001-08-02 10:00:00	AMZN	Stock	0.6165	0.6165	0.605	0.608	18200000.0
2001-08-02 11:00:00	AMZN	Stock	0.608	0.611	0.605	0.609	9994000.0
2001-08-02 12:00:00	AMZN	Stock	0.609	0.616	0.6075	0.6135	7188000.0
2001-08-02 13:00:00	AMZN	Stock	0.614	0.6155	0.61	0.6155	7594000.0
2001-08-02 14:00:00	AMZN	Stock	0.6155	0.6175	0.612	0.613	6160000.0
2001-08-02 15:00:00	AMZN	Stock	0.613	0.617	0.6085	0.6095	14502000.0
2001-08-02 16:00:00	AMZN	Stock	0.6095	0.6125	0.609	0.6105	1456000.0
2001-08-02 17:00:00	AMZN	Stock	0.6105	0.6105	0.6105	0.6105	2000.0
2001-08-02 09:00:00	CL	Stock	26.6	26.785	26.6	26.74	341400.0
2001-08-02 10:00:00	CL	Stock	26.74	26.825	26.605	26.7	576600.0
2001-08-02 11:00:00	CL	Stock	26.7	26.725	26.61	26.68	642600.0
2001-08-02 12:00:00	CL	Stock	26.68	26.68	26.525	26.61	376800.0
2001-08-02 13:00:00	CL	Stock	26.575	26.575	26.48	26.49	458600.0
2001-08-02 14:00:00	CL	Stock	26.49	26.59	26.475	26.59	345200.0
2001-08-02 15:00:00	CL	Stock	26.59	26.59	26.425	26.47	663200.0
2001-08-02 16:00:00	CL	Stock	26.47	26.55	26.465	26.47	68400.0

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

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