PREVIEW / stock_1hour / 2001-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-10-31.parquet
  size:    370 KB
  rows:    17,761
  symbols: 1,354

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-10-31 08:00:00	AAPL	Stock	0.3143	0.3188	0.3143	0.317	974400.0
2001-10-31 09:00:00	AAPL	Stock	0.3188	0.3245	0.3157	0.3236	35403200.0
2001-10-31 10:00:00	AAPL	Stock	0.3236	0.3286	0.3193	0.3197	43528800.0
2001-10-31 11:00:00	AAPL	Stock	0.3198	0.3229	0.3196	0.3201	31707200.0
2001-10-31 12:00:00	AAPL	Stock	0.32	0.3205	0.3114	0.3124	35537600.0
2001-10-31 13:00:00	AAPL	Stock	0.3123	0.3213	0.3116	0.3186	23324000.0
2001-10-31 14:00:00	AAPL	Stock	0.3186	0.3268	0.3186	0.3213	38376800.0
2001-10-31 15:00:00	AAPL	Stock	0.3214	0.3233	0.3116	0.3136	48888000.0
2001-10-31 16:00:00	AAPL	Stock	0.3138	0.3159	0.3123	0.3136	12930400.0
2001-10-31 17:00:00	AAPL	Stock	0.3127	0.32	0.3116	0.3136	1092000.0
2001-10-31 18:00:00	AAPL	Stock	0.3136	0.3136	0.3136	0.3136	156800.0
2001-10-31 08:00:00	MSFT	Stock	29.78	29.8	29.39	29.7	199800.0
2001-10-31 09:00:00	MSFT	Stock	29.7	29.95	29.6435	29.9	7541000.0
2001-10-31 10:00:00	MSFT	Stock	29.895	30.365	29.775	29.95	13616600.0
2001-10-31 11:00:00	MSFT	Stock	29.93	29.95	29.7245	29.78	8191600.0
2001-10-31 12:00:00	MSFT	Stock	29.78	29.8	29.225	29.305	6705800.0
2001-10-31 13:00:00	MSFT	Stock	29.305	29.6	29.25	29.495	4069600.0
2001-10-31 14:00:00	MSFT	Stock	29.47	29.905	29.45	29.865	7071600.0
2001-10-31 15:00:00	MSFT	Stock	29.875	29.906	29.05	29.075	12554600.0
2001-10-31 16:00:00	MSFT	Stock	29.07	29.7382	29.0	29.015	3483800.0
2001-10-31 17:00:00	MSFT	Stock	29.015	29.075	29.0	29.0	104200.0
2001-10-31 18:00:00	MSFT	Stock	29.075	29.075	29.005	29.05	14000.0
2001-10-31 08:00:00	NVDA	Stock	0.3542	0.3654	0.3537	0.3623	2928000.0
2001-10-31 09:00:00	NVDA	Stock	0.3625	0.3687	0.3597	0.3685	154860000.0
2001-10-31 10:00:00	NVDA	Stock	0.3683	0.3729	0.3632	0.3642	178752000.0
2001-10-31 11:00:00	NVDA	Stock	0.3642	0.3675	0.361	0.3622	135648000.0
2001-10-31 12:00:00	NVDA	Stock	0.3622	0.3649	0.3521	0.3558	144996000.0
2001-10-31 13:00:00	NVDA	Stock	0.3558	0.3647	0.3547	0.3601	90168000.0
2001-10-31 14:00:00	NVDA	Stock	0.3602	0.3671	0.3587	0.3665	107880000.0
2001-10-31 15:00:00	NVDA	Stock	0.3666	0.3669	0.3557	0.3572	148308000.0
2001-10-31 16:00:00	NVDA	Stock	0.3573	0.3583	0.3555	0.3579	16764000.0
2001-10-31 17:00:00	NVDA	Stock	0.3576	0.3576	0.3562	0.3562	852000.0
2001-10-31 18:00:00	NVDA	Stock	0.3562	0.3572	0.3562	0.3572	144000.0
2001-10-31 08:00:00	AMZN	Stock	0.325	0.34	0.321	0.34	562000.0
2001-10-31 09:00:00	AMZN	Stock	0.3415	0.35	0.3275	0.3345	22102000.0
2001-10-31 10:00:00	AMZN	Stock	0.335	0.3435	0.3335	0.3355	26580000.0
2001-10-31 11:00:00	AMZN	Stock	0.3355	0.3435	0.3325	0.34	26568000.0
2001-10-31 12:00:00	AMZN	Stock	0.34	0.344	0.334	0.335	16192000.0
2001-10-31 13:00:00	AMZN	Stock	0.335	0.3375	0.3325	0.335	12018000.0
2001-10-31 14:00:00	AMZN	Stock	0.336	0.342	0.335	0.339	10304000.0
2001-10-31 15:00:00	AMZN	Stock	0.338	0.351	0.3375	0.349	24414000.0
2001-10-31 16:00:00	AMZN	Stock	0.3485	0.35	0.338	0.349	5868000.0
2001-10-31 17:00:00	AMZN	Stock	0.3485	0.349	0.348	0.348	172000.0
2001-10-31 18:00:00	AMZN	Stock	0.349	0.349	0.345	0.345	54000.0
2001-10-31 09:00:00	CL	Stock	28.8	28.8	28.605	28.715	360000.0
2001-10-31 10:00:00	CL	Stock	28.715	28.9	28.62	28.775	289000.0
2001-10-31 11:00:00	CL	Stock	28.775	28.795	28.61	28.615	373600.0
2001-10-31 12:00:00	CL	Stock	28.645	28.75	28.545	28.6	308200.0
2001-10-31 13:00:00	CL	Stock	28.605	28.77	28.605	28.635	249400.0
2001-10-31 14:00:00	CL	Stock	28.675	28.75	28.585	28.75	367400.0

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

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