PREVIEW / stock_1hour / 2001-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-01.parquet
  size:    367 KB
  rows:    17,452
  symbols: 1,324

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-01 09:00:00	AAPL	Stock	0.3379	0.3446	0.3377	0.3446	36506400.0
2001-08-01 10:00:00	AAPL	Stock	0.3446	0.3479	0.3421	0.345	46597600.0
2001-08-01 11:00:00	AAPL	Stock	0.345	0.3491	0.3448	0.3464	30301600.0
2001-08-01 12:00:00	AAPL	Stock	0.3464	0.3532	0.3463	0.3525	40499200.0
2001-08-01 13:00:00	AAPL	Stock	0.3521	0.3532	0.3473	0.3493	23088800.0
2001-08-01 14:00:00	AAPL	Stock	0.3493	0.3496	0.34	0.3405	46104800.0
2001-08-01 15:00:00	AAPL	Stock	0.34	0.3425	0.3384	0.3404	58604000.0
2001-08-01 16:00:00	AAPL	Stock	0.3402	0.3498	0.3389	0.3404	12017600.0
2001-08-01 17:00:00	AAPL	Stock	0.3404	0.3404	0.3404	0.3404	509600.0
2001-08-01 08:00:00	MSFT	Stock	33.25	33.45	33.2	33.45	84000.0
2001-08-01 09:00:00	MSFT	Stock	33.47	33.5	32.97	33.2	6158400.0
2001-08-01 10:00:00	MSFT	Stock	33.2	33.38	32.975	32.995	11646600.0
2001-08-01 11:00:00	MSFT	Stock	33.0	33.07	32.88	32.935	7644200.0
2001-08-01 12:00:00	MSFT	Stock	32.925	33.245	32.92	33.205	6071000.0
2001-08-01 13:00:00	MSFT	Stock	33.205	33.325	33.125	33.27	5982400.0
2001-08-01 14:00:00	MSFT	Stock	33.27	33.29	33.06	33.095	5139000.0
2001-08-01 15:00:00	MSFT	Stock	33.095	33.25	33.035	33.225	7982200.0
2001-08-01 16:00:00	MSFT	Stock	33.23	33.375	33.125	33.325	2437800.0
2001-08-01 17:00:00	MSFT	Stock	33.235	33.325	33.235	33.32	79600.0
2001-08-01 08:00:00	NVDA	Stock	0.3417	0.3436	0.3315	0.3417	5760000.0
2001-08-01 09:00:00	NVDA	Stock	0.3417	0.3503	0.3408	0.347	277272000.0
2001-08-01 10:00:00	NVDA	Stock	0.3468	0.3538	0.3463	0.352	250608000.0
2001-08-01 11:00:00	NVDA	Stock	0.352	0.3539	0.3493	0.3508	79920000.0
2001-08-01 12:00:00	NVDA	Stock	0.351	0.3594	0.3509	0.3583	192144000.0
2001-08-01 13:00:00	NVDA	Stock	0.3579	0.3583	0.3538	0.3548	84360000.0
2001-08-01 14:00:00	NVDA	Stock	0.3546	0.3571	0.3523	0.353	93912000.0
2001-08-01 15:00:00	NVDA	Stock	0.3527	0.3579	0.3525	0.3576	153624000.0
2001-08-01 16:00:00	NVDA	Stock	0.3577	0.3585	0.3551	0.3577	31032000.0
2001-08-01 17:00:00	NVDA	Stock	0.3577	0.3583	0.3577	0.3583	384000.0
2001-08-01 18:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	48000.0
2001-08-01 08:00:00	AMZN	Stock	0.63	0.6375	0.6205	0.635	284000.0
2001-08-01 09:00:00	AMZN	Stock	0.635	0.643	0.6255	0.6275	9210000.0
2001-08-01 10:00:00	AMZN	Stock	0.6265	0.6275	0.617	0.6185	24500000.0
2001-08-01 11:00:00	AMZN	Stock	0.619	0.627	0.617	0.621	9212000.0
2001-08-01 12:00:00	AMZN	Stock	0.6215	0.625	0.6175	0.6205	7682000.0
2001-08-01 13:00:00	AMZN	Stock	0.6215	0.6225	0.614	0.617	8902000.0
2001-08-01 14:00:00	AMZN	Stock	0.62	0.62	0.6115	0.612	10408000.0
2001-08-01 15:00:00	AMZN	Stock	0.612	0.625	0.6085	0.625	17562000.0
2001-08-01 16:00:00	AMZN	Stock	0.625	0.63	0.623	0.625	15206000.0
2001-08-01 17:00:00	AMZN	Stock	0.625	0.625	0.625	0.625	102000.0
2001-08-01 18:00:00	AMZN	Stock	0.625	0.625	0.624	0.624	8000.0
2001-08-01 09:00:00	CL	Stock	27.175	27.2	27.08	27.2	341400.0
2001-08-01 10:00:00	CL	Stock	27.2	27.2	26.955	26.975	563400.0
2001-08-01 11:00:00	CL	Stock	26.975	27.06	26.95	27.03	198000.0
2001-08-01 12:00:00	CL	Stock	27.04	27.045	26.96	27.005	215800.0
2001-08-01 13:00:00	CL	Stock	27.02	27.035	26.925	26.97	133600.0
2001-08-01 14:00:00	CL	Stock	26.965	26.97	26.575	26.615	770600.0
2001-08-01 15:00:00	CL	Stock	26.625	26.675	26.35	26.475	1070000.0
2001-08-01 16:00:00	CL	Stock	26.475	27.025	26.47	27.025	154800.0
2001-08-01 17:00:00	CL	Stock	26.475	26.475	26.475	26.475	4000.0

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

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