PREVIEW / stock_1hour / 2001-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-15.parquet
  size:    354 KB
  rows:    17,090
  symbols: 1,319

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-15 08:00:00	AAPL	Stock	0.3357	0.3357	0.3348	0.3348	162400.0
2001-08-15 09:00:00	AAPL	Stock	0.3355	0.3382	0.3323	0.3336	22226400.0
2001-08-15 10:00:00	AAPL	Stock	0.3336	0.3371	0.3295	0.3334	48154400.0
2001-08-15 11:00:00	AAPL	Stock	0.3334	0.3334	0.3298	0.3314	20367200.0
2001-08-15 12:00:00	AAPL	Stock	0.3318	0.3329	0.33	0.3311	12448800.0
2001-08-15 13:00:00	AAPL	Stock	0.3314	0.3321	0.3304	0.3305	16122400.0
2001-08-15 14:00:00	AAPL	Stock	0.3307	0.3316	0.325	0.3277	23783200.0
2001-08-15 15:00:00	AAPL	Stock	0.3275	0.3313	0.3261	0.3289	95620000.0
2001-08-15 16:00:00	AAPL	Stock	0.3289	0.332	0.327	0.3293	42520800.0
2001-08-15 18:00:00	AAPL	Stock	0.3293	0.3293	0.3293	0.3293	5600.0
2001-08-15 08:00:00	MSFT	Stock	32.47	32.47	32.345	32.345	3000.0
2001-08-15 09:00:00	MSFT	Stock	32.34	32.525	32.14	32.19	4292000.0
2001-08-15 10:00:00	MSFT	Stock	32.185	32.305	31.925	32.055	6549600.0
2001-08-15 11:00:00	MSFT	Stock	32.06	32.1	31.74	31.825	5564800.0
2001-08-15 12:00:00	MSFT	Stock	31.82	31.98	31.75	31.935	4089800.0
2001-08-15 13:00:00	MSFT	Stock	31.9	32.1	31.87	31.99	3628600.0
2001-08-15 14:00:00	MSFT	Stock	31.99	32.045	31.725	31.84	5176600.0
2001-08-15 15:00:00	MSFT	Stock	31.835	32.01	31.6	31.6	6666200.0
2001-08-15 16:00:00	MSFT	Stock	31.63	31.72	31.25	31.6	1972000.0
2001-08-15 17:00:00	MSFT	Stock	31.6	31.715	31.6	31.65	30000.0
2001-08-15 18:00:00	MSFT	Stock	31.65	31.715	31.65	31.715	1200.0
2001-08-15 08:00:00	NVDA	Stock	0.3667	0.3693	0.3651	0.3658	26928000.0
2001-08-15 09:00:00	NVDA	Stock	0.3658	0.37	0.355	0.3575	449256000.0
2001-08-15 10:00:00	NVDA	Stock	0.3581	0.3633	0.3575	0.3625	359952000.0
2001-08-15 11:00:00	NVDA	Stock	0.3625	0.3643	0.3616	0.3637	209976000.0
2001-08-15 12:00:00	NVDA	Stock	0.3637	0.3669	0.3629	0.3663	171720000.0
2001-08-15 13:00:00	NVDA	Stock	0.3663	0.3676	0.3633	0.3635	112800000.0
2001-08-15 14:00:00	NVDA	Stock	0.3637	0.3652	0.3592	0.3607	113640000.0
2001-08-15 15:00:00	NVDA	Stock	0.3607	0.3621	0.3569	0.358	248808000.0
2001-08-15 16:00:00	NVDA	Stock	0.3581	0.3679	0.3571	0.3581	51000000.0
2001-08-15 17:00:00	NVDA	Stock	0.3581	0.3588	0.3579	0.3579	720000.0
2001-08-15 18:00:00	NVDA	Stock	0.3579	0.3579	0.3577	0.3577	336000.0
2001-08-15 08:00:00	AMZN	Stock	0.5275	0.5275	0.526	0.527	110000.0
2001-08-15 09:00:00	AMZN	Stock	0.5295	0.5415	0.526	0.5315	8402000.0
2001-08-15 10:00:00	AMZN	Stock	0.532	0.535	0.511	0.514	18750000.0
2001-08-15 11:00:00	AMZN	Stock	0.5135	0.516	0.5	0.5035	13286000.0
2001-08-15 12:00:00	AMZN	Stock	0.5035	0.513	0.503	0.5125	4666000.0
2001-08-15 13:00:00	AMZN	Stock	0.5125	0.5125	0.503	0.504	6358000.0
2001-08-15 14:00:00	AMZN	Stock	0.504	0.511	0.5025	0.5065	3558000.0
2001-08-15 15:00:00	AMZN	Stock	0.5065	0.511	0.5025	0.504	6624000.0
2001-08-15 16:00:00	AMZN	Stock	0.5045	0.509	0.503	0.504	1530000.0
2001-08-15 17:00:00	AMZN	Stock	0.5035	0.5075	0.5035	0.5045	38000.0
2001-08-15 18:00:00	AMZN	Stock	0.505	0.505	0.505	0.505	2000.0
2001-08-15 09:00:00	CL	Stock	27.305	27.4	27.305	27.325	222000.0
2001-08-15 10:00:00	CL	Stock	27.305	27.325	27.14	27.22	408600.0
2001-08-15 11:00:00	CL	Stock	27.21	27.325	27.15	27.225	194200.0
2001-08-15 12:00:00	CL	Stock	27.24	27.325	27.23	27.26	238200.0
2001-08-15 13:00:00	CL	Stock	27.26	27.37	27.225	27.325	173200.0
2001-08-15 14:00:00	CL	Stock	27.345	27.45	27.25	27.275	503600.0
2001-08-15 15:00:00	CL	Stock	27.29	27.325	27.15	27.195	424600.0

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

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