PREVIEW / stock_1hour / 2001-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-24.parquet
  size:    371 KB
  rows:    18,027
  symbols: 1,346

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-09-24 08:00:00	AAPL	Stock	0.2902	0.2925	0.2893	0.2914	431200.0
2001-09-24 09:00:00	AAPL	Stock	0.2902	0.2946	0.2848	0.2914	44816800.0
2001-09-24 10:00:00	AAPL	Stock	0.2915	0.3	0.2911	0.2963	58721600.0
2001-09-24 11:00:00	AAPL	Stock	0.2961	0.3	0.2955	0.2971	28621600.0
2001-09-24 12:00:00	AAPL	Stock	0.2968	0.2991	0.2966	0.2989	15400000.0
2001-09-24 13:00:00	AAPL	Stock	0.2989	0.2998	0.293	0.2964	28347200.0
2001-09-24 14:00:00	AAPL	Stock	0.2964	0.3007	0.295	0.2995	22702400.0
2001-09-24 15:00:00	AAPL	Stock	0.2995	0.3008	0.288	0.2936	74788000.0
2001-09-24 16:00:00	AAPL	Stock	0.2936	0.2948	0.2886	0.2888	6781600.0
2001-09-24 17:00:00	AAPL	Stock	0.2938	0.2938	0.2934	0.2938	3774400.0
2001-09-24 18:00:00	AAPL	Stock	0.2949	0.2949	0.2949	0.2949	392000.0
2001-09-24 08:00:00	MSFT	Stock	25.25	26.0	24.8525	25.5925	409800.0
2001-09-24 09:00:00	MSFT	Stock	25.6	25.895	25.055	25.085	13859000.0
2001-09-24 10:00:00	MSFT	Stock	25.09	25.6	24.935	25.57	17249800.0
2001-09-24 11:00:00	MSFT	Stock	25.575	25.75	25.5	25.7	9366400.0
2001-09-24 12:00:00	MSFT	Stock	25.7	25.985	25.605	25.97	7410000.0
2001-09-24 13:00:00	MSFT	Stock	25.955	25.99	25.755	25.765	6051000.0
2001-09-24 14:00:00	MSFT	Stock	25.77	26.175	25.74	26.14	8966400.0
2001-09-24 15:00:00	MSFT	Stock	26.14	26.225	25.8	26.005	13583600.0
2001-09-24 16:00:00	MSFT	Stock	26.0	26.075	24.57	25.985	3935600.0
2001-09-24 17:00:00	MSFT	Stock	25.9712	26.005	25.94	25.99	533000.0
2001-09-24 18:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	600.0
2001-09-24 08:00:00	NVDA	Stock	0.2322	0.2427	0.2322	0.2417	2388000.0
2001-09-24 09:00:00	NVDA	Stock	0.24	0.2431	0.2318	0.2356	282468000.0
2001-09-24 10:00:00	NVDA	Stock	0.2356	0.2504	0.2333	0.2472	339888000.0
2001-09-24 11:00:00	NVDA	Stock	0.2471	0.2496	0.2458	0.2477	168588000.0
2001-09-24 12:00:00	NVDA	Stock	0.2477	0.25	0.2467	0.2492	104916000.0
2001-09-24 13:00:00	NVDA	Stock	0.2492	0.2496	0.245	0.2453	106656000.0
2001-09-24 14:00:00	NVDA	Stock	0.2453	0.2512	0.245	0.25	105084000.0
2001-09-24 15:00:00	NVDA	Stock	0.25	0.2537	0.249	0.2502	270972000.0
2001-09-24 16:00:00	NVDA	Stock	0.2499	0.2504	0.2426	0.2504	25716000.0
2001-09-24 17:00:00	NVDA	Stock	0.2507	0.251	0.2497	0.251	2796000.0
2001-09-24 18:00:00	NVDA	Stock	0.2512	0.2521	0.2512	0.2521	240000.0
2001-09-24 08:00:00	AMZN	Stock	0.385	0.3855	0.3802	0.385	154000.0
2001-09-24 09:00:00	AMZN	Stock	0.385	0.3975	0.3675	0.3675	14970000.0
2001-09-24 10:00:00	AMZN	Stock	0.368	0.3794	0.367	0.3735	14196000.0
2001-09-24 11:00:00	AMZN	Stock	0.3745	0.3775	0.3733	0.376	9476000.0
2001-09-24 12:00:00	AMZN	Stock	0.3755	0.3775	0.375	0.3755	5554000.0
2001-09-24 13:00:00	AMZN	Stock	0.3755	0.3765	0.371	0.372	10150000.0
2001-09-24 14:00:00	AMZN	Stock	0.3715	0.3775	0.371	0.3765	6238000.0
2001-09-24 15:00:00	AMZN	Stock	0.376	0.377	0.371	0.373	17594000.0
2001-09-24 16:00:00	AMZN	Stock	0.373	0.375	0.3655	0.3655	12826000.0
2001-09-24 17:00:00	AMZN	Stock	0.3795	0.3795	0.3725	0.373	746000.0
2001-09-24 09:00:00	CL	Stock	26.625	26.815	26.625	26.75	479200.0
2001-09-24 10:00:00	CL	Stock	26.825	27.075	26.755	27.06	607000.0
2001-09-24 11:00:00	CL	Stock	27.06	27.315	26.815	27.25	374400.0
2001-09-24 12:00:00	CL	Stock	27.255	27.255	27.03	27.23	292000.0
2001-09-24 13:00:00	CL	Stock	27.225	27.245	27.025	27.245	319200.0
2001-09-24 14:00:00	CL	Stock	27.24	27.265	27.145	27.23	310600.0
2001-09-24 15:00:00	CL	Stock	27.23	27.36	27.135	27.265	666600.0

> showing 50 of 18,027 rows — these rows as CSV

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