PREVIEW / stock_1hour / 2000-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-31.parquet
  size:    321 KB
  rows:    16,303
  symbols: 1,242

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
2000-10-31 08:00:00	AAPL	Stock	0.3527	0.3566	0.3449	0.3504	548800.0
2000-10-31 09:00:00	AAPL	Stock	0.3504	0.356	0.3348	0.356	75717600.0
2000-10-31 10:00:00	AAPL	Stock	0.3549	0.3605	0.3516	0.3538	150740800.0
2000-10-31 11:00:00	AAPL	Stock	0.3527	0.3616	0.3482	0.3538	80948000.0
2000-10-31 12:00:00	AAPL	Stock	0.3538	0.3571	0.3493	0.3527	79111200.0
2000-10-31 13:00:00	AAPL	Stock	0.3527	0.3538	0.3493	0.3527	57136800.0
2000-10-31 14:00:00	AAPL	Stock	0.3527	0.3538	0.3471	0.3471	105324800.0
2000-10-31 15:00:00	AAPL	Stock	0.3471	0.3504	0.3438	0.3488	195098400.0
2000-10-31 16:00:00	AAPL	Stock	0.3482	0.3504	0.3471	0.3504	49470400.0
2000-10-31 17:00:00	AAPL	Stock	0.3504	0.3516	0.3493	0.3516	2581600.0
2000-10-31 18:00:00	AAPL	Stock	0.3516	0.3516	0.3516	0.3516	44800.0
2000-10-31 08:00:00	MSFT	Stock	34.5312	35.0	34.5312	34.7188	345200.0
2000-10-31 09:00:00	MSFT	Stock	34.6875	34.8125	34.1562	34.3281	11015600.0
2000-10-31 10:00:00	MSFT	Stock	34.3438	34.375	34.0	34.3125	16201000.0
2000-10-31 11:00:00	MSFT	Stock	34.3438	34.5312	34.1562	34.25	15462600.0
2000-10-31 12:00:00	MSFT	Stock	34.25	34.75	34.2188	34.625	11568800.0
2000-10-31 13:00:00	MSFT	Stock	34.625	34.6562	34.4375	34.5	13732200.0
2000-10-31 14:00:00	MSFT	Stock	34.5	34.5938	34.0938	34.2812	11933200.0
2000-10-31 15:00:00	MSFT	Stock	34.25	34.5625	34.0625	34.4688	12225200.0
2000-10-31 16:00:00	MSFT	Stock	34.4375	34.5312	34.25	34.375	4697600.0
2000-10-31 17:00:00	MSFT	Stock	34.4219	34.5	34.3125	34.4375	54200.0
2000-10-31 18:00:00	MSFT	Stock	34.4375	34.4688	34.4375	34.4375	4000.0
2000-10-31 08:00:00	NVDA	Stock	0.2417	0.25	0.2417	0.2417	192000.0
2000-10-31 09:00:00	NVDA	Stock	0.2385	0.2474	0.2385	0.2451	18384000.0
2000-10-31 10:00:00	NVDA	Stock	0.2432	0.2531	0.2432	0.2484	38904000.0
2000-10-31 11:00:00	NVDA	Stock	0.2484	0.2542	0.2464	0.2534	36792000.0
2000-10-31 12:00:00	NVDA	Stock	0.2521	0.263	0.2516	0.2599	51240000.0
2000-10-31 13:00:00	NVDA	Stock	0.2625	0.2625	0.2547	0.2591	30096000.0
2000-10-31 14:00:00	NVDA	Stock	0.2594	0.2612	0.2563	0.2582	52872000.0
2000-10-31 15:00:00	NVDA	Stock	0.257	0.2625	0.2565	0.2589	35976000.0
2000-10-31 16:00:00	NVDA	Stock	0.2583	0.2599	0.2578	0.2578	4608000.0
2000-10-31 08:00:00	AMZN	Stock	1.65	1.6625	1.65	1.65	144000.0
2000-10-31 09:00:00	AMZN	Stock	1.65	1.6625	1.6063	1.6219	16754000.0
2000-10-31 10:00:00	AMZN	Stock	1.625	1.675	1.6125	1.6562	21926000.0
2000-10-31 11:00:00	AMZN	Stock	1.6562	1.6781	1.6531	1.6719	13274000.0
2000-10-31 12:00:00	AMZN	Stock	1.6719	1.7188	1.6719	1.7156	17360000.0
2000-10-31 13:00:00	AMZN	Stock	1.7156	1.7531	1.7125	1.7344	22168000.0
2000-10-31 14:00:00	AMZN	Stock	1.7375	1.7719	1.7312	1.7469	20926000.0
2000-10-31 15:00:00	AMZN	Stock	1.75	1.8438	1.7469	1.8312	49126000.0
2000-10-31 16:00:00	AMZN	Stock	1.8375	1.8625	1.8188	1.8312	12584000.0
2000-10-31 17:00:00	AMZN	Stock	1.8344	1.8344	1.8031	1.8219	114000.0
2000-10-31 18:00:00	AMZN	Stock	1.8031	1.8219	1.8031	1.8094	24000.0
2000-10-31 09:00:00	CL	Stock	29.0	29.005	28.375	28.38	1102000.0
2000-10-31 10:00:00	CL	Stock	28.425	28.575	28.15	28.475	1214800.0
2000-10-31 11:00:00	CL	Stock	28.475	28.5	28.225	28.265	537000.0
2000-10-31 12:00:00	CL	Stock	28.25	28.675	28.225	28.64	550200.0
2000-10-31 13:00:00	CL	Stock	28.625	28.63	28.385	28.385	246400.0
2000-10-31 14:00:00	CL	Stock	28.4	29.125	28.4	29.11	697200.0
2000-10-31 15:00:00	CL	Stock	29.11	29.475	29.07	29.425	977800.0
2000-10-31 16:00:00	CL	Stock	29.375	29.38	29.365	29.365	167000.0

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

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