PREVIEW / stock_1hour / 2001-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-27.parquet
  size:    349 KB
  rows:    16,633
  symbols: 1,287

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-04-27 08:00:00	AAPL	Stock	0.4446	0.4554	0.4446	0.45	319200.0
2001-04-27 09:00:00	AAPL	Stock	0.45	0.4575	0.4446	0.4536	48658400.0
2001-04-27 10:00:00	AAPL	Stock	0.4536	0.458	0.4502	0.4514	65520000.0
2001-04-27 11:00:00	AAPL	Stock	0.4518	0.4527	0.442	0.452	48423200.0
2001-04-27 12:00:00	AAPL	Stock	0.452	0.4543	0.445	0.452	30469600.0
2001-04-27 13:00:00	AAPL	Stock	0.4525	0.4571	0.4496	0.4564	24096800.0
2001-04-27 14:00:00	AAPL	Stock	0.4566	0.4588	0.4516	0.4586	29859200.0
2001-04-27 15:00:00	AAPL	Stock	0.4586	0.4695	0.4563	0.4679	101360000.0
2001-04-27 16:00:00	AAPL	Stock	0.468	0.4696	0.4552	0.4689	28896000.0
2001-04-27 17:00:00	AAPL	Stock	0.4679	0.4689	0.4679	0.4689	67200.0
2001-04-27 18:00:00	AAPL	Stock	0.47	0.47	0.4688	0.4689	134400.0
2001-04-27 08:00:00	MSFT	Stock	34.56	35.1	34.55	34.985	263200.0
2001-04-27 09:00:00	MSFT	Stock	35.0	35.0	34.33	34.525	10527200.0
2001-04-27 10:00:00	MSFT	Stock	34.525	34.77	34.0	34.08	12631000.0
2001-04-27 11:00:00	MSFT	Stock	34.085	34.24	33.88	33.95	10133000.0
2001-04-27 12:00:00	MSFT	Stock	33.955	34.005	33.5	33.61	18696800.0
2001-04-27 13:00:00	MSFT	Stock	33.61	33.78	33.575	33.59	10200600.0
2001-04-27 14:00:00	MSFT	Stock	33.59	33.625	33.11	33.25	22446000.0
2001-04-27 15:00:00	MSFT	Stock	33.25	33.825	33.11	33.56	26240800.0
2001-04-27 16:00:00	MSFT	Stock	33.565	34.725	33.375	33.7	4778000.0
2001-04-27 17:00:00	MSFT	Stock	33.725	33.825	33.56	33.675	53000.0
2001-04-27 18:00:00	MSFT	Stock	33.675	33.7	33.635	33.67	8000.0
2001-04-27 08:00:00	NVDA	Stock	0.3146	0.3208	0.3125	0.3167	3600000.0
2001-04-27 09:00:00	NVDA	Stock	0.3198	0.3255	0.3073	0.321	187296000.0
2001-04-27 10:00:00	NVDA	Stock	0.3216	0.3271	0.3171	0.3184	173904000.0
2001-04-27 11:00:00	NVDA	Stock	0.3179	0.3244	0.3167	0.3203	84984000.0
2001-04-27 12:00:00	NVDA	Stock	0.32	0.3213	0.313	0.3205	93720000.0
2001-04-27 13:00:00	NVDA	Stock	0.3205	0.3269	0.3198	0.324	80904000.0
2001-04-27 14:00:00	NVDA	Stock	0.324	0.3259	0.3173	0.3183	104064000.0
2001-04-27 15:00:00	NVDA	Stock	0.3183	0.3305	0.316	0.3292	121728000.0
2001-04-27 16:00:00	NVDA	Stock	0.3291	0.333	0.329	0.3319	9336000.0
2001-04-27 17:00:00	NVDA	Stock	0.3308	0.3333	0.3144	0.3333	408000.0
2001-04-27 18:00:00	NVDA	Stock	0.3333	0.3333	0.3325	0.3333	336000.0
2001-04-27 08:00:00	AMZN	Stock	0.785	0.7925	0.785	0.79	58000.0
2001-04-27 09:00:00	AMZN	Stock	0.79	0.8	0.751	0.7545	17798000.0
2001-04-27 10:00:00	AMZN	Stock	0.7545	0.775	0.751	0.7565	22376000.0
2001-04-27 11:00:00	AMZN	Stock	0.7565	0.766	0.7525	0.7585	9028000.0
2001-04-27 12:00:00	AMZN	Stock	0.7585	0.762	0.755	0.756	4748000.0
2001-04-27 13:00:00	AMZN	Stock	0.756	0.7675	0.7555	0.7595	10722000.0
2001-04-27 14:00:00	AMZN	Stock	0.7595	0.7625	0.756	0.7585	6724000.0
2001-04-27 15:00:00	AMZN	Stock	0.7585	0.765	0.7565	0.763	12318000.0
2001-04-27 16:00:00	AMZN	Stock	0.7635	0.7635	0.7535	0.7635	1180000.0
2001-04-27 17:00:00	AMZN	Stock	0.7605	0.7625	0.76	0.762	38000.0
2001-04-27 18:00:00	AMZN	Stock	0.7605	0.7625	0.7605	0.7605	16000.0
2001-04-27 09:00:00	CL	Stock	27.25	27.275	27.125	27.2	170000.0
2001-04-27 10:00:00	CL	Stock	27.2	27.425	27.135	27.335	220600.0
2001-04-27 11:00:00	CL	Stock	27.3	27.65	27.3	27.475	577600.0
2001-04-27 12:00:00	CL	Stock	27.495	27.745	27.435	27.65	492200.0
2001-04-27 13:00:00	CL	Stock	27.65	27.83	27.625	27.76	324000.0
2001-04-27 14:00:00	CL	Stock	27.765	27.8	27.6	27.725	299600.0

> showing 50 of 16,633 rows — these rows as CSV

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