PREVIEW / stock_1hour / 2001-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-18.parquet
  size:    358 KB
  rows:    17,511
  symbols: 1,339

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-18 08:00:00	AAPL	Stock	0.3053	0.3571	0.3018	0.303	1394400.0
2001-09-18 09:00:00	AAPL	Stock	0.3034	0.3054	0.2968	0.3038	27703200.0
2001-09-18 10:00:00	AAPL	Stock	0.3038	0.3164	0.3021	0.3109	46228000.0
2001-09-18 11:00:00	AAPL	Stock	0.31	0.3114	0.2964	0.3009	30609600.0
2001-09-18 12:00:00	AAPL	Stock	0.3009	0.3027	0.2986	0.3007	37200800.0
2001-09-18 13:00:00	AAPL	Stock	0.3004	0.3018	0.2964	0.2979	27759200.0
2001-09-18 14:00:00	AAPL	Stock	0.298	0.2982	0.2932	0.2954	47555200.0
2001-09-18 15:00:00	AAPL	Stock	0.2952	0.2957	0.2888	0.2907	70968800.0
2001-09-18 16:00:00	AAPL	Stock	0.2905	0.2994	0.2902	0.2907	7744800.0
2001-09-18 17:00:00	AAPL	Stock	0.2902	0.2907	0.2902	0.2907	498400.0
2001-09-18 08:00:00	MSFT	Stock	26.4575	26.6895	26.43	26.65	334600.0
2001-09-18 09:00:00	MSFT	Stock	26.65	26.915	26.455	26.915	11340800.0
2001-09-18 10:00:00	MSFT	Stock	26.915	27.29	26.85	27.055	16076800.0
2001-09-18 11:00:00	MSFT	Stock	27.06	27.175	26.99	27.065	9452400.0
2001-09-18 12:00:00	MSFT	Stock	27.055	27.335	27.03	27.305	5357400.0
2001-09-18 13:00:00	MSFT	Stock	27.305	27.5	27.25	27.37	7692400.0
2001-09-18 14:00:00	MSFT	Stock	27.37	27.38	27.09	27.24	9777000.0
2001-09-18 15:00:00	MSFT	Stock	27.226	27.24	26.9	27.16	15036400.0
2001-09-18 16:00:00	MSFT	Stock	27.165	27.275	27.0691	27.16	3031200.0
2001-09-18 17:00:00	MSFT	Stock	27.19	27.275	27.155	27.16	74000.0
2001-09-18 08:00:00	NVDA	Stock	0.2833	0.2875	0.2828	0.2834	3084000.0
2001-09-18 09:00:00	NVDA	Stock	0.2857	0.2896	0.2687	0.2867	111384000.0
2001-09-18 10:00:00	NVDA	Stock	0.2863	0.2908	0.2836	0.2875	203976000.0
2001-09-18 11:00:00	NVDA	Stock	0.2875	0.2875	0.274	0.2741	82320000.0
2001-09-18 12:00:00	NVDA	Stock	0.2742	0.2812	0.2714	0.2778	57084000.0
2001-09-18 13:00:00	NVDA	Stock	0.2772	0.2824	0.2755	0.2767	73992000.0
2001-09-18 14:00:00	NVDA	Stock	0.2767	0.2771	0.2608	0.2632	90816000.0
2001-09-18 15:00:00	NVDA	Stock	0.2632	0.2666	0.2597	0.2661	192132000.0
2001-09-18 16:00:00	NVDA	Stock	0.2661	0.2663	0.2624	0.2662	15564000.0
2001-09-18 17:00:00	NVDA	Stock	0.2661	0.2664	0.2661	0.2662	420000.0
2001-09-18 08:00:00	AMZN	Stock	0.373	0.375	0.3725	0.373	278000.0
2001-09-18 09:00:00	AMZN	Stock	0.373	0.387	0.368	0.3765	11544000.0
2001-09-18 10:00:00	AMZN	Stock	0.3765	0.3875	0.3705	0.385	31354000.0
2001-09-18 11:00:00	AMZN	Stock	0.385	0.3865	0.375	0.3755	8148000.0
2001-09-18 12:00:00	AMZN	Stock	0.3755	0.376	0.3715	0.373	6392000.0
2001-09-18 13:00:00	AMZN	Stock	0.3735	0.379	0.37	0.3715	9570000.0
2001-09-18 14:00:00	AMZN	Stock	0.3715	0.3725	0.3625	0.365	12144000.0
2001-09-18 15:00:00	AMZN	Stock	0.365	0.3675	0.3625	0.3635	18294000.0
2001-09-18 16:00:00	AMZN	Stock	0.3635	0.3782	0.325	0.3645	14010000.0
2001-09-18 17:00:00	AMZN	Stock	0.3645	0.3645	0.3645	0.3645	86000.0
2001-09-18 09:00:00	CL	Stock	29.15	29.25	28.825	28.885	655600.0
2001-09-18 10:00:00	CL	Stock	28.89	28.98	28.775	28.935	777200.0
2001-09-18 11:00:00	CL	Stock	28.905	28.935	28.675	28.735	879800.0
2001-09-18 12:00:00	CL	Stock	28.735	28.805	28.625	28.795	1002800.0
2001-09-18 13:00:00	CL	Stock	28.795	28.875	28.795	28.82	626800.0
2001-09-18 14:00:00	CL	Stock	28.81	28.975	28.8	28.925	477000.0
2001-09-18 15:00:00	CL	Stock	28.93	29.03	28.885	28.98	756400.0
2001-09-18 16:00:00	CL	Stock	28.98	29.005	28.98	29.0	113400.0

> showing 48 of 17,511 rows — these rows as CSV

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